Indigeno Technologies - Part 1 - Complex Data Modeling & Relationships, & Creating Tables using DAX

[admin]

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.

#PowerBI #datavisualization #datamodeling #sankeychart #DAX #tutorial #businessintelligence #dashboard #orders #reporting #howto