Power BI Course Syllabus 5hrs 30min
Session 1: Quick Start Power BI Service0:31:40
1.01 | Get Power BI Tools | 0:03:08 |
1.02 | Introduction to Tools and Terminology | 0:04:19 |
1.03 | Dashboard in Minutes | 0:09:51 |
1.04 | Refreshing Power BI Service Data | 0:02:59 |
1.05 | Interacting with your Dashboards | 0:07:22 |
1.06 | Sharing Dashboards and Reports | 0:04:01 |
Session 2: Getting and Transforming Data with Power BI Desktop0:23:21
2.01 | Introduction to Power BI Desktop | 0:08:16 |
2.02 | Getting Data: Excel vs Power BI Desktop & Service | 0:05:14 |
2.03 | Naming for Q&A | 0:03:46 |
2.04 | DirectQuery vs Import Data | 0:03:44 |
2.05 | Recap and What's Next | 0:02:21 |
Session 3: Modeling with Power BI0:42:34
3.01 | Introduction to Modeling | 0:01:17 |
3.02 | Setup and Manage Relationships | 0:06:15 |
3.03 | Cardinality and Cross Filtering | 0:10:04 |
3.04 | Default Summarization & Sort by | 0:06:04 |
3.05 | Creating Calculated Columns | 0:03:13 |
3.06 | Creating Measures & Quick Measures | 0:13:39 |
3.07 | Recap and What's Next | 0:02:02 |
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:22:54
5.01 | Introduction to the Power BI Service | 0:04:24 |
5.02 | Standalone Tiles | 0:04:32 |
5.03 | Data Driven Alerts (Power BI Pro/Premium) | 0:05:11 |
5.04 | Quick and Related Insights | 0:04:06 |
5.05 | Custom Q&A | 0:04:41 |
Session 6: Publishing and Sharing0:47:44
6.01 | Sharing Options Overview | 0:04:16 |
6.02 | Publish from Power BI Desktop | 0:03:53 |
6.03 | Publish Reports to Web | 0:05:26 |
6.04 | Sharing Reports & Dashboards (Power BI Pro/Premium) | 0:04:01 |
6.05 | Workspaces (Power BI Pro/Premium) | 0:03:56 |
6.06 | Apps (Power BI Pro/Premium) | 0:06:39 |
6.07 | Printing, PDFs and Exporting to PowerPoint | 0:04:20 |
6.08 | Row Level Security (Power BI Pro) | 0:05:17 |
6.09 | Export Data from a Visualisation | 0:03:38 |
6.10 | Publishing for Mobile Apps | 0:03:04 |
6.z | Sharing Options Summary | 0:03:14 |
Session 7: Refreshing Datasets0:15:48
7.01 | Understanding Data Refresh | 0:04:18 |
7.02 | Personal Gateway (Power BI Pro and 64-bit Windows) | 0:07:08 |
7.03 | Replacing a Dataset | 0:01:57 |
7.04 | Troubleshooting Refreshing | 0:02:25 |
Session 8: Power BI and Excel Together0:18:01
8.01 | Options for Publishing from Excel | 0:02:34 |
8.02 | Import Excel Power Query & Power Pivot Models | 0:04:08 |
8.03 | Analyze in Excel (Power BI Pro or Premium) | 0:03:44 |
8.04 | Excel Publish: Upload and Export to Power BI | 0:05:05 |
8.05 | Sharing Published Excel Dashboards (Power BI Pro or Premium) | 0:02:30 |