This tutorial creates a data model and visualizes a flow of orders in Power BI.
Here’s a summary:
– We start with 11 excel tables related to orders.
– We import them into Power BI and create relationships between tables based on matching columns (e.g., product ID).
– We use DAX queries to create new tables containing order flow information (e.g., flow from broker to supplier).
– We create a single table “Flow All” combining all flow information using the UNION function.
– We use a Sankey chart (imported custom visual) to visualize the flow of orders from brokers to buyers.
– We add slicers to filter by year and quarter.
– We format the visuals with borders and rounded corners.
Link to the Dataset and Power BI File:
https://drive.google.com/file/d/1N53ah5gBN6K8v3_Udka6Big1bm6g5Imc/view?usp=sharing
#PowerBI #datavisualization #datamodeling #sankeychart #DAX #tutorial #businessintelligence #dashboard #orders #reporting #howto