.jpg){kind=logo}
PWRBI-EXCEL.AP1.E0T
Analyzing Data with Power BI and Power Pivot for Excel Course
Intermediate Self-paced · 1 year access
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
13 Interactive Lessons · 69 topics01 Introduction 3 topics +
- Who this course is for?
- Organization of this course
- Conventions
02 Introduction to data modeling 5 topics +
- Working with a single table
- Introducing the data model
- Introducing star schemas
- Understanding the importance of naming objects
- Conclusions
03 Using header/detail tables 4 topics +
- Introducing header/detail
- Aggregating values from the header
- Flattening header/detail
- Conclusions
04 Using multiple fact tables 5 topics +
- Using denormalized fact tables
- Filtering across dimensions
- Understanding model ambiguity
- Using orders and invoices
- Conclusions
05 Working with date and time 10 topics +
- Creating a date dimension
- Understanding automatic time dimensions
- Using multiple date dimensions
- Handling date and time
- Time-intelligence calculations
- Handling fiscal calendars
- Computing with working days
- Handling special periods of the year
- Working with weekly calendars
- Conclusions
06 Tracking historical attributes 6 topics +
- Introducing slowly changing dimensions
- Using slowly changing dimensions
- Loading slowly changing dimensions
- Rapidly changing dimensions
- Choosing the right modeling technique
- Conclusions
07 Using snapshots 5 topics +
- Using data that you cannot aggregate over time
- Aggregating snapshots
- Understanding derived snapshots
- Understanding the transition matrix
- Conclusions
08 Analyzing date and time intervals 7 topics +
- Introduction to temporal data
- Aggregating with simple intervals
- Intervals crossing dates
- Modeling working shifts and time shifting
- Analyzing active events
- Mixing different durations
- Conclusions
09 Many-to-many relationships 5 topics +
- Introducing many-to-many relationships
- Cascading many-to-many
- Temporal many-to-many
- Using the fact tables as a bridge
- Conclusions
10 Working with different granularity 3 topics +
- Introduction to granularity
- Relationships at different granularity
- Conclusions
11 Segmentation data models 5 topics +
- Computing multiple-column relationships
- Computing static segmentation
- Using dynamic segmentation
- Understanding the power of calculated columns: ABC analysis
- Conclusions
12 Working with multiple currencies 5 topics +
- Understanding different scenarios
- Multiple source currencies, single reporting currency
- Single source currency, multiple reporting currencies
- Multiple source currencies, multiple reporting currencies
- Conclusions
13 Appendix A. Data modeling 101 6 topics +
- Tables
- Data types
- Relationships
- Filtering and cross-filtering
- Different types of models
- Measures and additivity
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for Analyzing Data with Power BI and Power Pivot for Excel Course
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.