Global Inventory Dashboard

*Real project, hence sensitive data is blurred

Global Inventory Dashboard Power BI report


  • <– One main dashboard with 20+ sub reports 
  • Click to navigate to associated report
  • ‘Actions Comment’ block when KPI is red
  • Definition on KPI 

Back-end Data Processing

PBIX dataset –> Connected to Power BI DataFlow (Cloud) –> Single DataFlow that append all SQL tables –> Multiple SQL Server database –> SQL querys that return unified result
Why Power BI Dataflow?
Because of the global inventory data size has exceeded pbix dataset size restriction (2.0 GB).
Data Reusability: other colleagues are able to use same data structure that have been already built. 

Leave a Comment

Your email address will not be published. Required fields are marked *