uCertify

Analyzing Data with Power BI and Power Pivot for Excel Labs

(PWRBI-EXCEL.AP1.0L0)
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to data modeling

  • Exploring a Dataset
2

Using header/detail tables

  • Aggregating Values from the Header Table
3

Using multiple fact tables

  • Analyzing Denormalized Fact Tables
  • Understanding Model Ambiguity
4

Working with date and time

  • Creating a Date Dimension
5

Tracking historical attributes

  • Analyzing Slowly Changing Dimensions
6

Using snapshots

  • Analyzing Snapshots
  • Analyzing Derived Snapshots
  • Understanding the Transition Matrix
7

Analyzing date and time intervals

  • Understanding Temporal Data
  • Analyzing Events that Cross Dates
  • Analyzing Active Events
  • Mixing Different Durations
8

Many-to-many relationships

  • Exploring Many-to-Many Relationships
  • Exploring a Temporal Many-to-Many Relationship
9

Working with different granularity

  • Analyzing Relationships at Different Granularity
10

Segmentation data models

  • Analyzing Calculated Physical Relationships
  • Analyzing Dynamic Segmentation
  • Understanding ABC Analysis
11

Working with multiple currencies

  • Producing a Report Containing Information With a Single Type of Currency
  • Producing a Report in Multiple Currencies

Related Courses

All Courses