Скачать или смотреть LESSON 10040 | DEVELOPING SQL SCRIPTS IN SSMS FOR POWER BI DASHBOARD

In this video, I guide you through developing SQL scripts using SQL Server Management Studio (SSMS) to prepare the necessary data for a Power BI dashboard using the ContosoRetailDW database. I explain how to identify and retrieve key fields from fact and dimension tables such as FactSales, DimStore, DimSalesTerritory, DimEmployee, and DimProduct, focusing on essential elements like sales amount, sales quantity, region, store manager, and product name. You'll learn how to build SQL queries that define relationships between these tables using keys like StoreKey, GeographyKey, ProductKey, and EmployeeKey.

📈 Get the data packs for our courses: https://immalytics.com/packs?utm_sour...

🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  
🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  

💻 For all playlists, visit our website: https://immalytics.com

Chapters
00:00 Introduction and video objectives
01:10 Reviewing the FactSales table for metrics
03:10 Identifying necessary columns for the bar chart
04:45 Exploring DimStore table for region information
06:00 Linking geography data via DimSalesTerritory
07:25 Finalizing required fields from related tables
08:30 Preparing for manager data with DimEmployee
09:55 Creating full name for sales managers
11:00 Pulling product data from DimProduct
12:15 Verifying all keys are ready for table relationships
13:00 Prepping scripts for Power Query import
13:45 Wrap-up and next steps

#powerqueryeditor #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver