Curriculum
- What is ETL (3:54)
- What is Power Query (4:07)
- Load from Excel Demo (26:58)
- Load from Folder Demo (9:51)
- Datasets vs Reports (2:43)
- Connection Types (8:51)
- |Challenge| Test my knowledge
- Advanced Power Query (7:51)
- Data Quality (4:05)
- Profiling Data Demo (14:24)
- Merging in Power Query Demo (17:08)
- |Task| Load Data
- STAR Schema (6:34)
- Facts and Dimensions (19:00)
- Linking Tables with Keys (4:39)
- Designing a STAR Schema (5:43)
- Types of Dimensions (12:39)
- Types of fact (3:36)
- Fact Grain (7:24)
- Making a STAR Schema (5:02)
- Create a STAR Schema Demo (15:34)
- Relationships in Power BI (12:19)
- Making Relationships Demo (7:36)
- Tidying Data Models Demo (11:10)
- |Task| Transform Data
- What is DAX (11:22)
- Writing DAX Demo (16:49)
- The CALCULATE Statement (6:21)
- Introduction to Expanded Tables (3:43)
- What is Filter Context (8:05)
- What is Row Context (4:33)
- Iterators (9:22)
- Putting Context Together (5:10)
- Visual Level Filters (12:36)
- Remove Filters (4:58)
- Refresh Process (3:57)
- Many to Many relationships (3:28)
- Snowflake Schema (9:12)
- Calculate Revisited (5:49)
- Context Transition (12:50)
- Implicit vs Explicit DAX
- CALCULATE Demo (11:37)
- Aggregation Functions (15:50)
- SELECTEDVALUE (3:55)
- Informational functions (16:26)
- Logical functions (24:40)
- Time intelligence Functions (22:29)
- Advanced Calculate (15:13)
- Multiple FACTs (11:37)
- Role Playing Dimensions (15:20)
- |Challenge| DAX Quiz
- |Task| DAX Table
- |Task| DAX Measures
- Checking the Version (1:03)
- Preview Features (2:52)
- Adding Visuals (11:12)
- Formatting Visuals (18:59)
- Further Analysis on Visuals (4:29)
- Adding Filters (16:56)
- Format a Page (9:48)
- Layout a Page (14:51)
- Conditional Formatting (13:03)
- Hierarchies (17:29)
- Create a Date Heirarchy (5:58)
- Drillthroughs (11:14)
- Tooltips (7:03)
- Panes (8:42)
- Bookmarks (14:23)
- Bookmark tips
- Buttons (8:08)
- Button Navigators (9:09)
- Custom visuals (9:58)
- Mobile View (3:20)
What prerequisite knowledge do I need?
To optimize your chances of success, we recommend that you understand the basics of Power BI. If you have never used Power BI before, you can take the free on-demand course “Up and running with Power BI”.
Why should I enroll?
In Power BI, the need for skilled professionals is growing across industries. Our classes emphasize hands-on learning with focus on both underlying theory as well as technical skills. This approach ensures that you not only grasp the theoretical concepts but also gain confidence in applying them to real-world scenarios.
The course will provide you with a solid grounding in data visualization principles, data modeling concepts, and best practices.
Who is the instructor?
This course has been designed by Steve Campbell. Steve is the owner of Sunny BI, a consulting firm specializing in data modernization and consulting services. He is a sought-after speaker who presents and trains students all over the world.
After previously running global Power BI consulting teams, he noticed a gap in skills of developers. Students focused too much on the technical aspect, ignoring theoretical, domain, and best practices.
That’s why Power BI Masterclass was developed – a hands on, end to end class that sets up students for Power BI success.