Section 01: Introduction to Power BI
Section 02: Power Query Editor | Data Preparation | Automate Data Cleaning
-
Practice Files
-
Power Query Introduction (1:06)
-
Power Query Editor Interface: Import Data from Excel (7:59)
-
Data Transformation Part 2 : Basic Column Transformations (6:01)
-
Data Transformation Part 3: Remove Blank Row, Fill Down (9:53)
-
Data Transformation Part 4 : Tricks to Avoid Manual Work (6:20)
-
Data Transformation Part 5 : Transform a Report view to Raw Data (8:42)
-
Append Queries with Similar Data Structure (4:26)
-
Append: Combine Similar Excel Files from a Folder (6:51)
-
Merge Queries : An Alternate to Vlookup (9:26)
-
Date Master Query
Section 03: Power BI Relationships
Section 04: Data Model : Introduction to DAX Formulas
-
Creating New Columns in Table (5:00)
-
Create Groups based on Existing Text and Numeric Fields (6:37)
-
Measures: Creating Basic Calculations (6:27)
-
New Column vs New Measure, Measure Group Tables (5:26)
-
Formatting of Measures or Columns (5:15)
-
DISTINCTCOUNT : Count Unique Values (4:24)
-
CALCULATE : Function you can not live without (4:32)
-
SUMX and RELATED Function (5:01)
-
Time Intelligence Function (62:15)
Section 5: Charts & Visualizations
-
Practice Files
-
Visual Elements in Power BI: Adding Text , Images, Themes (9:33)
-
Insert and Formatting a Chart (7:37)
-
Column & Bar Charts (8:14)
-
Tooltips (5:36)
-
Drill Down & Hierarchy (7:01)
-
Tiles, Card Visuals and Multi Row Card (4:54)
-
Tables & Matrix (5:59)
-
Conditional Formatting (7:49)
-
Line and Area Charts (4:18)
-
Pie , Donut (3:42)
-
Map Visuals (6:19)
-
Waterfall Chart (11:56)
-
Scatter Chart (9:26)
-
Funnel Chart (3:57)
-
Custom Visual Store (6:29)
-
Gauge Chart / Speedometer (2:48)
Section 6: Interactivity in Power BI
Bonus : Advance Visualisations
Power BI Service - Publish & Share
