Provision an Azure SQL Database with Private Endpoint | DP-300 Lab 02 | Virtual Network | SSMS

Welcome to Lab 02 of the PL-300 Microsoft Power BI Data Analyst Certification series! In this hands-on lab, you'll use Power Query Editor to apply real-world data cleansing and transformation techniques across multiple queries — then load them into your semantic model as clean, structured tables. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 WHAT YOU'LL LEARN IN THIS VIDEO ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ✅ Rename, filter, and remove columns in Power Query Editor ✅ Merge columns (FirstName + LastName → Salesperson) ✅ Expand related table columns (DimProductSubcategory, DimGeography) ✅ Fix data quality issues (replace "Ware House" → "Warehouse") ✅ Unpivot month columns to reshape the Targets table ✅ Create a custom column using an IF formula to fix missing cost values ✅ Use "Column From Examples" to auto-generate a date column ✅ Merge queries from different data sources (SQL Server + CSV) ✅ Disable query load for helper queries (ColorFormats) ✅ Set correct data types (Whole Number, Fixed Decimal, Date) ✅ Load all 7 final tables into the Power BI semantic model ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ QUERIES CONFIGURED IN THIS LAB ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🔹 Salesperson – 5 columns, 18 rows 🔹 SalespersonRegion – 2 columns, 39 rows 🔹 Product – 8 columns, 397 rows (merged with ColorFormats) 🔹 Reseller – 6 columns, 701 rows 🔹 Region – 4 columns, 10 rows 🔹 Sales – 10 columns, 999+ rows 🔹 Targets – 3 columns, 809 rows 🔹 ColorFormats – 3 columns, 10 rows (load disabled) Chapters: 00:00 Overview 07:48 Hands-on Lab ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🔗 IMPORTANT LINKS ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 📌 Playlist :    • PL-300 Power BI Data Analyst Certification...   📖 Microsoft Learn : https://microsoftlearning.github.io/P... 💻 GitHub Link: https://github.com/MicrosoftLearning/... ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 📌 EXAM TIPS FOR PL-300 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 💡 Know the difference between Left Outer, Inner, and Full Outer joins when merging queries — this is a common exam topic. 💡 Understand why Fixed Decimal Number is preferred over Decimal for financial values like Sales, Cost, and Unit Price. 💡 Remember that disabling "Enable Load To Report" on a query prevents it from appearing as a table in the data model, but it can still be used in merges. 💡 Unpivoting columns is a key transformation skill tested in the PL-300 — practice it well! ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🔔 DON'T FORGET ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 👍 Like this video if it helped you 🔔 Subscribe & hit the bell so you don't miss the next lab 💬 Got questions? Drop them in the comments — I reply to every one! ⏮️ PREVIOUS VIDEO → Lab 01: Get Data in Power BI ▶️ NEXT VIDEO → Lab 03: Configure a Semantic Model in Power BI #PowerBI #PL300 #PowerQuery #DataTransformation #MicrosoftCertification #PowerBIDesktop #DataCleaning #SemanticModel #DataAnalyst #PL300Lab #MicrosoftLearn #PowerBICertification #BusinessIntelligence #DataAnalytics #ExamPrep2026