Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)
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
Watch video Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1) online without registration, duration hours minute second in high quality. This video was added by user ViSIT 25 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 275 once and liked it 11 people.