Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis using Power BI
Orientation
Celebrate Power BI Mastery: Your Journey Begins Here!
Section 01: Introduction to Power BI
What is Power BI? (3:30)
Power BI Software and Licenses (4:53)
Power Bi Desktop Interface (4:39)
Workshop Content (120:05)
First Power BI Report (4:59)
Datasets for Practice
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)
Data Master Query
Section 03: Power BI Relationships
Practice Files
Understanding Automatic vs Manual Relationships (13:35)
Relationships best practices : 1 to Many vs Many to Many (6:34)
Relating Tables with multiple common fields (5:04)
Custom Sorting: Sorting Month in Chronological Order (3:54)
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
Customize Interaction between Visuals (8:46)
Dates Slicers (5:51)
Numeric Slicers (3:19)
Text Slicers (8:14)
Slicer with Multiple Fields (1:35)
Sync Slicers (4:11)
Filters : Visual , Page and Report Level Filters (5:57)
Slicers vs Filters: Which one to Use (2:33)
Bonus : Advance Visualisations
Advance Visualisations
Power BI Service - Publish & Share
Share Report as PDF or Publish to a Workspace (7:23)
Share the report with Others on Power BI Service (4:31)
Interactive Power BI Report in Power Point (3:38)
Using Power BI Dataset in Excel : Analyze in Excel (3:43)
Teach online with
Create Groups based on Existing Text and Numeric Fields
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock