LESSON 10050 | CREATING A COMPLETE DATA MODEL WITH POWER BI & SQL SERVER | Dashboard Creation Course
📊 Dive deep into Power Query with our comprehensive course!
Stay ahead of the curve with regularly updated lessons designed to elevate your data skills.
💻 Ready to practice?
All study materials and datasets used in the lessons are available for download on our website — so you can follow along step by step and boost your learning through hands-on experience. 👉🏻https://www.immalytics.com
📺 Watch the Power Query Complete Course 👉🏻 • POWER QUERY COMPLETE FREE COURSE
Chapters
00:00 Importing Data from Contoso DB into Power BI
01:12 Using SQL Server connection in Power BI
02:50 Explaining Import vs Direct Query modes
05:20 Executing SQL script to import FactSales table
07:00 Formatting data types in Power Query
08:10 Duplicating query to import DimStore table
09:25 Editing permissions and renaming table
10:20 Importing DRegion, DEmployees, and DProducts via SQL scripts
12:30 Organizing tables and switching to Model View
13:30 Removing automatic relationships in Power BI
14:20 Manually creating one-to-many relationships
15:40 Final table setup and relationship validation
#powerqueryeditor #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver
