Case Study: Supply Chain Analytics in Power BI
Learn how to use Power BI for supply chain analytics in this case study. Create a make vs. buy analysis tool, calculate costs, and analyze production volumes.
Start Course for Free3 Hours5 Videos20 Exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
Course Description
Master Supply Chain Analytics with Power BI
Looking to enhance your supply chain analytics skills? This course focuses on creating a powerful make versus buy analysis tool using Power BI.Create a Make versus Buy Analysis Tool
Through this case study, you will develop a quote analysis tool, calculate costs for various production volumes, and integrate internal manufacturing cost data for in-depth analysis.Discover the Advantages of Power BI
The course highlights the advantages of Power BI over traditional spreadsheets, offering a valuable model that can be extended to include additional cost considerations and supply chain aspects.Extend the Model to Include More Supply Chain Aspects
Take your supply chain analytics to the next level by extending the model to include additional cost considerations and supply chain aspects.By the end of this course, you'll have a strong understanding of supply chain analytics with Power BI, allowing you to create valuable tools for your organization.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more- 1
The Buy Option
FreeIn this first chapter, you will learn about the make and buy options in a supply chain. Then you will become acquainted with the concepts of extended cost and full cost. You will learn how to calculate these with a basic quote dataset.
- 2
Creating a Volume Parameter and Scenario Analysis
In this chapter, you will explore building a scenario analysis tool to examine how your cost calculations change as volumes change. You will create visualizations of how the full cost changes across the different potential production volumes.
- 3
The Make Option
You will learn how to assess internal costs manufacturing costs - the "Make" option in the Make versus Buy. You will also learn how to communicate your results.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreCollaborators
Nicholas Switzer
See More
Analytics Solutions Lead at Stryker
Nick Switzer is an Analytics Solutions Lead at Stryker, a leading global provider of medical technologies. He earned a BS in electrical engineering at the Rose Hulman Institute of Technology. He spent a decade in engineering and supply chain roles before transitioning to analytics. During his time in supply chain, he drove sourcing and make versus buy decisions on multiple new product development platforms. At Stryker, Nick uses Power BI, Azure, R, and Python to develop and implement data-driven solutions that improve the company's operations. He is passionate about using data to solve real-world problems and improve people's lives. Nick enjoys playing basketball, riding his bike, and spending time with his family outside of work.
What do other learners have to say?
Join over 13 million learners and start Case Study: Supply Chain Analytics in Power BI today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.