.jpg){kind=logo}
PWRBI-EXCEL.AP1.0L0
Analyzing Data with Power BI and Power Pivot for Excel Labs
Intermediate Self-paced · 1 year access
21 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
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 · 1 LiveLab +
- Working with a single table
- Introducing the data model
- Introducing star schemas
- Understanding the importance of naming objects
- Conclusions
1 LiveLab in this lesson — see the labs panel →
03 Using header/detail tables 4 topics · 1 LiveLab +
- Introducing header/detail
- Aggregating values from the header
- Flattening header/detail
- Conclusions
1 LiveLab in this lesson — see the labs panel →
04 Using multiple fact tables 5 topics · 2 LiveLab +
- Using denormalized fact tables
- Filtering across dimensions
- Understanding model ambiguity
- Using orders and invoices
- Conclusions
2 LiveLab in this lesson — see the labs panel →
05 Working with date and time 10 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
06 Tracking historical attributes 6 topics · 1 LiveLab +
- Introducing slowly changing dimensions
- Using slowly changing dimensions
- Loading slowly changing dimensions
- Rapidly changing dimensions
- Choosing the right modeling technique
- Conclusions
1 LiveLab in this lesson — see the labs panel →
07 Using snapshots 5 topics · 3 LiveLab +
- Using data that you cannot aggregate over time
- Aggregating snapshots
- Understanding derived snapshots
- Understanding the transition matrix
- Conclusions
3 LiveLab in this lesson — see the labs panel →
08 Analyzing date and time intervals 7 topics · 4 LiveLab +
- Introduction to temporal data
- Aggregating with simple intervals
- Intervals crossing dates
- Modeling working shifts and time shifting
- Analyzing active events
- Mixing different durations
- Conclusions
4 LiveLab in this lesson — see the labs panel →
09 Many-to-many relationships 5 topics · 2 LiveLab +
- Introducing many-to-many relationships
- Cascading many-to-many
- Temporal many-to-many
- Using the fact tables as a bridge
- Conclusions
2 LiveLab in this lesson — see the labs panel →
10 Working with different granularity 3 topics · 1 LiveLab +
- Introduction to granularity
- Relationships at different granularity
- Conclusions
1 LiveLab in this lesson — see the labs panel →
11 Segmentation data models 5 topics · 3 LiveLab +
- Computing multiple-column relationships
- Computing static segmentation
- Using dynamic segmentation
- Understanding the power of calculated columns: ABC analysis
- Conclusions
3 LiveLab in this lesson — see the labs panel →
12 Working with multiple currencies 5 topics · 2 LiveLab +
- Understanding different scenarios
- Multiple source currencies, single reporting currency
- Single source currency, multiple reporting currencies
- Multiple source currencies, multiple reporting currencies
- Conclusions
2 LiveLab in this lesson — see the labs panel →
13 Appendix A. Data modeling 101 6 topics +
- Tables
- Data types
- Relationships
- Filtering and cross-filtering
- Different types of models
- Measures and additivity
Hands-On Labs Our edge
21 LiveLabs- Exploring a Dataset
- Aggregating Values from the Header Table
- Analyzing Denormalized Fact Tables
- Understanding Model Ambiguity
- Creating a Date Dimension
- Analyzing Slowly Changing Dimensions
- Analyzing Snapshots
- Analyzing Derived Snapshots
- Understanding the Transition Matrix
- Understanding Temporal Data
- Analyzing Events that Cross Dates
- Analyzing Active Events
- Mixing Different Durations
- Exploring Many-to-Many Relationships
- Exploring a Temporal Many-to-Many Relationship
- Analyzing Relationships at Different Granularity
- Analyzing Calculated Physical Relationships
- Analyzing Dynamic Segmentation
- Understanding ABC Analysis
- Producing a Report Containing Information With a Single Type of Currency
- Producing a Report in Multiple Currencies
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for Analyzing Data with Power BI and Power Pivot for Excel Labs
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 21 LiveLab included
- Certificate of completion
No credit card required