Power BI Course Syllabus


Power BI Course Syllabus 5hrs 2mins


Session 1: Quick Start Power BI Service0:29:53

1.01 Get Power BI Tools 0:03:10
1.02 Introduction to Tools and Terminology 0:03:15
1.03 Dashboard in Minutes 0:13:16
1.04 Refreshing Power BI Service Data 0:01:56
1.05 Interacting with Reports 0:05:26
1.06 Sharing Dashboards and Reports 0:03:29

Session 2: Getting and Transforming Data with Power BI Desktop0:16:17

2.01 Introduction to Power BI Desktop 0:09:01
2.02 Getting Data: Excel vs Power BI Desktop & Service 0:05:14
2.03 Naming for Q&A 0:03:15
2.04 DirectQuery vs Import Data 0:02:34
2.05 Key Takeaways and What's Next 0:01:27

Session 3: Modeling with Power BI Desktop0:40:45

3.01 Introduction to Modeling 0:01:58
3.02 Setup and Manage Relationships 0:06:45
3.03 Cardinality and Cross Filtering 0:10:15
3.04 Default Summarization & Sort by 0:05:50
3.05 Creating Calculated Columns 0:02:41
3.06 Creating Measures & Quick Measures 0:11:56
3.z Recap and What's Next 0:01:20

Session 4: Power BI Desktop Visualisations2:06:16

4.01 Creating Visualisations 0:05:55
4.02 Color & Conditional Formatting 0:07:39
4.03 Setting Sort Order 0:03:57
4.04 Scatter & Bubble Charts & Play Axis 0:04:03
4.05 Slicers 0:12:08
4.06 Tooltips 0:03:47
4.07 Cross Filtering and Highlighting 0:03:32
4.08 Visual, Page and Report Level Filters 0:08:10
4.09 Drill Down/Up 0:06:16
4.10 Hierarchies 0:02:48
4.11 Constant Lines 0:05:14
4.12 Tables, Matrices & Table Conditional Formatting 0:10:30
4.13 KPI's, Cards & Gauges 0:08:57
4.14 Map Visualisations 0:05:44
4.15 Custom Visuals 0:03:13
4.16 Managing and Arranging 0:04:06
4.17 Drillthrough 0:04:47
4.18 Custom Report Themes 0:08:29
4.19 Grouping and Binning 0:03:49
4.20 Bookmarks & Buttons 0:08:54
4.21 Decomposition Tree 0:07:16
4.z Recap and What's Next 0:02:57

Session 5: Power BI Service Visualisation Tools0:19:40

5.01 Introduction to the Power BI Service 0:04:13
5.02 Standalone Tiles 0:04:18
5.03 Data Driven Alerts (Power BI Pro/Premium) 0:04:07
5.04 Quick and Related Insights 0:02:47
5.05 Custom Q&A 0:04:15

Session 6: Publishing and Sharing0:40:21

6.01 Sharing Options and Publishing 0:04:41
6.02 Row Level Security 0:06:13
6.03 Publish Reports to Web 0:05:39
6.04 Sharing Reports & Dashboards (Power BI Pro/Premium) 0:03:37
6.05 Creating Workspaces (Power BI Pro/Premium) 0:02:29
6.06 Apps (Power BI Pro/Premium) 0:05:12
6.07 Printing and PDFs 0:01:43
6.08 Embed in PowerPoint 0:03:34
6.09 Embed in Teams (Power BI Pro) 0:01:55
6.10 Embed in SharePoint Online 0:02:23
6.11 Publishing for Mobile Apps 0:02:55

Session 7: Refreshing Datasets0:16:58

7.01 Understanding Data Refresh 0:06:49
7.02 Personal Gateway (Power BI Pro and 64-bit Windows) 0:06:43
7.03 Replacing a Dataset 0:01:39
7.04 Lineage View 0:01:47

Session 8: Power BI and Excel Together0:10:57

8.01 Options for Publishing from Excel 0:01:46
8.02 Import Excel Power Query & Power Pivot Models 0:03:29
8.03 Work with Power BI Data in Excel (Power BI Pro or Premium) 0:05:42