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. 

Make versus Buy introduction

Options

Make

Make and Buy options

Exploring the Quotes

Exploring suppliers

Extended Cost and Full Cost

Calculating Full Cost

Visualizing lowest cost supplier

The Buy Option

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. 

Scenario Analysis - volume changes

Adding a volume parameter

Displaying non-recurring expenses

Analyzing volumes outside the quoted range

Recommending an order volume

Adding row-level security

Creating a Volume Parameter and Scenario Analysis

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. 

Assessing the Make option

Incremental or sunk cost

Required unit capacity

Full Cost with capital investment

Assessing Make vs. Buy

Cost of Quality

Wrap-up

The Make Option

Metadata sheet

DataCamp vs. Local Experience

Exercises and Datasets

This course focuses on creating a powerful make versus buy analysis tool using Power BI. 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. 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. Take your supply chain analytics to the next level by extending the model to include additional cost considerations and supply chain aspects.
<br><br>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.


<h2>Master Supply Chain Analytics with Power BI</h2> Looking to enhance your supply chain analytics skills? This course focuses on creating a powerful make versus buy analysis tool using Power BI. <br><br> <h2>Create a Make versus Buy Analysis Tool</h2> 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. <br><br> <h2>Discover the Advantages of Power BI</h2> 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. <br><br> <h2>Extend the Model to Include More Supply Chain Aspects</h2> Take your supply chain analytics to the next level by extending the model to include additional cost considerations and supply chain aspects. <br><br> 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.


Introduction to Power BI

DAX Functions in Power BI

Data Connections 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.

Case Study: Supply Chain Analytics in Power BI

Manufacturing your own finished goods at your factory

Forming and polishing forks in your own facilities

Sending your component design to the manufacturing team at your own company to make 40 prototype pieces

Sourcing a pre-existing product such as a machine screw

Outsourcing the manufacturing of a finished good

Sending your component design to a company that 3D-prints 30 copies for you	

Make and Buy options

Case Study: Supply Chain Analytics in Power BI

Exercice interactif pratique