Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)

Опубликовано: 11 Октябрь 2024
на канале: ViSIT
275
11

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