Wrap-up

Case Study: Supply Chain Analytics in Power BI

Nick Switzer

Analytics Lead

Summary

  • Chapter 1: Buy Option Full Cost at fixed volumes
  • Chapter 2: Buy Option Full Cost at variable volumes
  • Chapter 3: Make Option Full Cost at variable volumes and Cost Avoidance

A screenshot of the Chapter 1 final solution

A screenshot of the Chapter 2 final solution

A screenshot of the Chapter 3 final solution

Case Study: Supply Chain Analytics in Power BI

A baseline data model

Time Money and Quality in one triangle

  • More cost considerations
    • Salaried employees
    • Extra Facilities
    • Variable overheads
    • Freight Costs
  • Time considerations
  • Quality metrics
Case Study: Supply Chain Analytics in Power BI

Power BI or spreadsheets

An elephant sitting in a chair with a coffee in a waiting room

Case Study: Supply Chain Analytics in Power BI

Consistency and control

Consistency across analyses
Rubber duckies all in a row

  • More quotes can be added
  • Same logic
  • Avoids new spreadsheets

Control A lock on a file

  • Data security
  • Avoids flawed data
Case Study: Supply Chain Analytics in Power BI

Simple, powerful Sharing

A woman presenting around a conference room with dashboards on a screen

  • Online dashboards and interactive reports
  • Easy and immediate access
  • Beautiful visualizations built-in
Case Study: Supply Chain Analytics in Power BI

Congratulations!

Case Study: Supply Chain Analytics in Power BI

Preparing Video For Download...