Skip to main content

Course

Case Study: Supply Chain Analytics in Power BI

Basic4 hr

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.

Python4 hr5 videos20 Exercises1,750 XP5,275Statement of accomplishment

Create Your Free Account

Continue with Google
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training a Team?

Try for Business

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.

Prerequisites

Curriculum

Course outline

1

The Buy Option

In 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.
Start Chapter
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.
Start Chapter
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.
Start Chapter

Case Study: Supply Chain Analytics in Power BI

Course
Complete

Earn Statement of Accomplishment

Enroll Now

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.

Case Study: Supply Chain Analytics in Power BI | DataCamp