Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Power BI - Professional Course
1.Introduction
1. What is Power BI (12:27)
2.Course Outline (6:25)
3.Power BI Installation (3:36)
4.Quick Overview of Power BI-1 of 3 (8:33)
5.Quick Overview of Power BI-2 of 3_Working in the Query Editor (7:57)
6.Quick Overview of Power BI-3 of 3_The Data View and Create our First Visual (6:56)
7.How to get the most out of this course (6:30)
Knowledge Check
2.Getting started with Power BI Desktop
1.Module Overview (3:00)
2.How to use the attached project files (6:20)
3.Understanding PowerBI Workflow (3:57)
4.Exploring the interface of the Data Model (7:58)
5.Understanding the Query Editor Interface (5:44)
6.Important Creating the Project file and Recommended Settings (5:00)
3.Working in the Query Editor
1.Module Overview (1:41)
2.Linking to Source Files (7:26)
3.Keeping and Removing Rows (15:05)
4.Working with Filters (4:01)
5.Removing Empty Rows (5:06)
6.Saving the Project Draft (3:22)
7.Appending Queries (6:06)
8.Working with Columns (5:04)
9.Replacing Values (6:54)
10.Formatting Data and Handling Format errors (9:38)
11.Pivoting and Unpivoting Data (8:12)
12.Splitting Columns (6:52)
13.Creating Groups and Cleaning Up our project (3:25)
4.Case Study-1
1.Import Data from CSV file (8:08)
2.Basic Data Modeling in Power Query (7:19)
3.Building Second Report in a quick way (9:39)
4.Measures (19:03)
5.Filter to extract more details (13:45)
6.Slicers (8:00)
7.Exploring our second BI report (6:32)
5.Assessment-1
Assessment-1
6.Case Study-2_Sport Analytics
1.Data Cleaning in Query Editor (26:22)
2.Data Modeling Merge Queries and Column Profiling (21:47)
3.Cleaning blank rows for Data integrity (5:25)
4.Additional Explanation about JOIN and Enable Load (5:07)
13.Creating Groups and Cleaning Up our project
Download
Complete and Continue