Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fast Track to Power BI
Section 1: Introduction (a look around the dojo)
What is Power BI (4:23)
⚙️How to Use the Platform for Best Learning Experience
Pre-assessment Quiz (track your progress)
Quick Tour of Power BI (8:51)
📖 What's What in the Power BI Universe
🔻 Download Files & Important Course Info (1:43)
📖 Access without Work or School Account
📖 Power BI vs Excel
🔍 Looking for a Specific Topic? Use the Transporter!
🆕 Summary of Power BI Updates
--------⏩ FAST TRACK ⏩--------
First Power BI Project Overview (Sales Analyst at OfficePlus) (3:46)
Section 2A: Tour of Power BI as you Build Your Report
Loading Data for Analysis (8:19)
Creating a Data Model (6:36)
Exploring Visuals in Power BI (14:18)
Filters and Slicers (6:59)
Creating Quick Measures (10:32)
🤔 Quiz
📝 Key Takeaways
Section 2B: Design Your First Dashboard
Designing Report Layout (Theme & Draft) (3:17)
Getting Started on our Dashboard (8:21)
Sync Slicers & Edit Interactions between Visuals (8:56)
Drill Down & Line Charts (9:48)
Custom Hierarchies for Drill down (7:26)
Adding Custom Visuals like Word Cloud (5:20)
Artificial Intelligence (AI) Visuals - Smart Narrative (4:43)
Q&A - Create Visuals by Typing a Normal Sentence (8:41)
Top N Filter & Conditional Formatting (6:26)
Dynamic Card Titles with Conditional Formatting (6:49)
Customize Tooltips & Analyze Data (8:54)
Analytics Pane to add More Analysis to Visuals (5:15)
Adding Page Navigation and Back Buttons (9:33)
💪 Challenge & Final Touches
🤔 Quiz
📝 Key Takeaways
Section 2C: Publish Your First Dashboard
Publishing and Exploring Report in Power BI Service (12:04)
Create a Dashboard from your Report (9:58)
Mobile Dashboard (8:31)
Refreshing the Dataset in Power BI Desktop (7:04)
Connect to a Published Dataset (6:48)
🤔 Quiz
📝 Key Takeaways
🚩 Congratulations for Completing the Fast Lane (1:06)
🆕 Enjoying the Course so far? Refer a friend and get 30% off your next XelPlus purchase!
-------- 🔎 EXPERT LANE 🔍 --------
New Project Background and Scope (4:33)
Section 3A: Power Query - Combining, Transforming and Cleaning Data
Section Overview & Importing Data Options (6:01)
Getting Data & Important Tips (8:38)
Useful Transformations (14:19)
Real Life vs Training (SharePoint, OneDrive connections) (5:20)
Importing All Files from a Folder (9:38)
Avoiding Date Errors when Importing Data from Different Regions (Changing Locale) (12:03)
Appending Data before Loading to Model (8:11)
Importing Budget - Unpivot Data & Convert Month Names to Dates (6:40)
📖 Optimizing Query & Dealing with Errors
🤔 Quiz
💪 Challenge - Get Data from Web
📝 Key Takeaways - Power Query (getting & transforming data) (0:37)
Section 3B: Data Model - Deep Dive
Data Model: Section Overview (0:46)
Relationships: Terminology & Logic (9:23)
Manage Relationships - How to Spot Problems (7:58)
Many-to-Many Relationships (Multiple Data Table Pitfalls) (9:14)
Create a Dynamic Calendar table (Disable Auto Date/Time) (9:51)
Multiple Data Tables & ONE Calendar (Sorting Tips for Calendar Columns) (5:57)
Star Schema Vs. Snowflake - Which is Better? (4:12)
Merge Tables in Power Query (4:59)
Why Not One Big Table? Optimizing Performance (5:37)
Data Model Best Practices (8:50)
💪 Challenge - Find the Mistake
🤔 Quiz
📝 Key Takeaways - Data Model
Section 3C: DAX
What is DAX & Where is it Used? (2:17)
Writing Measures & Filter Context (9:46)
Calculating Total Sales by Iterating Over Table Rows (SUMX and Row Context) (9:15)
RELATED & SUMX for Cost Calculation (5:19)
DIVIDE Function - Better Way of Calculating Percentages (2:08)
Create a Dedicated Measures Table (Plus Many More Pro Tips) (5:31)
Introduction to CALCULATE Function (6:11)
Common Time Intelligence Functions (YTD, PY) (9:25)
USERELATIONSHIP to Activate Inactive Relationships (4:32)
CALCULATE Modifiers (ALL, REMOVEFILTERS, KEEPFILTERS) (12:30)
Calculating Sales Current Year (7:40)
💪 Challenge
🤔 Quiz
📝 Key Takeaways - DAX (2:55)
Section 3D: Storytelling with Power BI
Principles of Data Visualization (4:50)
🎨 Create a Custom Theme (5:47)
Section 3E: Stores
📖 Our Goal
Set up Slicers & Treemap (8:01)
Decomposition Tree - Find Insights You Might Have Missed (8:41)
Creating Drill Through Pages - View Details with Minimal Effort (9:36)
Convert a Field to a Clickable Link (for Table & Matrix Visual) (1:43)
Different Map Charts (7:48)
Discover the Magic of Bookmarks (Capture Views & Swap Visuals) (9:01)
Add Buttons to Switch Between Bookmarks (8:25)
💪 Challenge - Set up the Dashboard Until Now
Section 3F: Budget
📖 Our Goal
Flag Slicer & Conditional Formatting with Thresholds (10:05)
Gauge Chart (8:29)
Combo Chart (6:43)
Last Reported Month (3:24)
KPI Card & Tooltip Challenge (10:19)
💪 Challenge - Set up the Dashboard Until Now
Section 3G: Overview
📖 Our Goal
Multi-row Card as a Better Option to Multiple Cards (5:12)
Last 12 Months Automatic Filter & Conditional Formatting Challenge (13:06)
Sales to New Customers (Drill-through to Details) (10:24)
Waterfall Chart - Current Period to PY (Dynamic Date Ranges) (8:06)
Field Parameters - Toggle between Categories & Measures (8:14)
Continuous vs Categorical Axis for Line Charts (10:46)
Slicer Panel to Show & Hide Slicers from View (8:12)
Display Slicer Selection on a Card (SELECTEDVALUE) (5:02)
💪 Challenge - Set up the Dashboard Until Now
Section 3H: Finalizing & Performance Check
Add a Customized Page Navigation with Icons (5:13)
Tips to Optimize Performance - Performance Analyzer (10:26)
🤔 Quiz
📝 Key Takeaways: Storytelling and Design (1:43)
Section 3I: Power BI Service
Row Level Security - Restrict Data Access (5:52)
Workspaces and License Types in Power BI Service (5:50)
Publish & Share Reports and Datasets (6:25)
Schedule Refresh in Power BI Service (Gateway vs Cloud) (5:47)
💪Challenge Solution & Tips
💡Add Last Refreshed Date to Report
📖 Incremental Refresh
🤔 Quiz
📝 Key Takeaways
Section 3J: Power BI & Excel
Analyze in Excel - Create Excel Pivot Tables from Power BI Data (3:14)
🆕📺 Exploring Power BI Datasets in Excel - All Methods
Import Your Data Model from Excel to Power BI (3:41)
📺Organizational Data Types
📝 Key Takeaways - Excel with Power BI
🎁 EXTRA Bonus - Fiscal Calendar Report 🗓️
🔻DOWNLOAD Fiscal Version of the HQ Final Report
🎁 BONUS 1️⃣ - Complete Course eBook
🔻DOWNLOAD Your Complete eBook
🎁BONUS 2️⃣ - DAX Recipes
🔻DOWNLOAD DAX Recipes
🎁 BONUS 3️⃣ - Mini Course Power Automate & Power BI
Introduction to Power Automate (4:02)
Send Dashboard Email Alert to Multiple People (11:03)
Formatting Email Content & Links in Power Automate (4:07)
Power Automate Visual in Power BI - Send Emails from Report (9:14)
Filtering and Editing a Flow in Power BI (5:33)
Conditions in Power Automate - Send Different Emails Based on Performance (9:46)
📖 Add a Button to Refresh the Dataset
📖 Other Power BI Actions in Power Automate
📰 Power BI Updates
Q4 2022: Quick Measure Suggestions, Optimize Ribbon, Slicer Types
Q1 2023: Conditional Formatting, Page Navigator & RLS Enhancements; Apply All & Clear All Slicers
Mar 2023: On-Object (New Way to Create and Format Visuals; incl. subsequent updates)
Q2 2023: Azure Maps, Measure-Driven Labels, Edit Model in Service
Jun 2023: New 💪Enhanced Card Visual
Q3 2023: Line & Area Charts Enhancements, Datasets in Mobile; Bubble Range Scaling, Layout Switcher
Section 4: Wrap up
🎆 What You've Accomplished (1:38)
Post-Assessment Quiz (check how far you've come)
✍️Leave a Review
What to Learn Next
Financial Modelling in Power BI eBook
⚙️ My Favorite Resources
Access to Bonus Items
🏅 Share Your Digital Certificate (0:40)
Mar 2023: On-Object (New Way to Create and Format Visuals; incl. subsequent updates)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock