Global Inventory Dashboard

Leave a Comment / By jiangyanqing90@gmail.com / October 12, 2021

*Real project, hence sensitive data is blurred

Global Inventory Dashboard Power BI report

Features:

<– 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 Cancel Reply