YoVDO

Case Study: Supply Chain Analytics in Power BI

Offered By: DataCamp

Tags

Supply Chain Analytics Courses Data Visualization Courses Cost Calculations Courses

Course Description

Overview

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.

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.


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.

Syllabus

  • 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.
  • 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.
  • 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.

Taught by

Nicholas Switzer

Related Courses

Einführung in das Rechnungswesen
RWTH Aachen University via iversity
Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique
Gestión de inventario y portafolio
Logyca via edX
Business Boot Camp: A Crash Course in Fundamentals
Udemy
Business Management: Fundamentals of Management Accounting
The Open University via FutureLearn