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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Analyzing Data with Power BI and Power Pivot for Excel Labs

$139.99

Buy Now

Related Courses

All Courses