(PWRBI-EXCEL.AP1) / ISBN : 978-1-64459-388-2
This course includes
Lessons
TestPrep
Hands-On Labs
AI Tutor (Add-on)
141 Review
Get A Free Trial

Get the support you need. Enroll in our Instructor-Led Course.

Lessons

13+ Lessons | 87+ Exercises | 50+ Quizzes | 43+ Flashcards | 43+ Glossary of terms

TestPrep

37+ Pre Assessment Questions | 38+ Post Assessment Questions |

Hands-On Labs

21+ LiveLab | 21+ Video tutorials | 01:48+ Hours

1

Introduction

  • Who this course is for?
  • Organization of this course
  • Conventions
2

Introduction to data modeling

  • Working with a single table
  • Introducing the data model
  • Introducing star schemas
  • Understanding the importance of naming objects
  • Conclusions
3

Using header/detail tables

  • Introducing header/detail
  • Aggregating values from the header
  • Flattening header/detail
  • Conclusions
4

Using multiple fact tables

  • Using denormalized fact tables
  • Filtering across dimensions
  • Understanding model ambiguity
  • Using orders and invoices
  • Conclusions
5

Working with date and time

  • 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
6

Tracking historical attributes

  • Introducing slowly changing dimensions
  • Using slowly changing dimensions
  • Loading slowly changing dimensions
  • Rapidly changing dimensions
  • Choosing the right modeling technique
  • Conclusions
7

Using snapshots

  • Using data that you cannot aggregate over time
  • Aggregating snapshots
  • Understanding derived snapshots
  • Understanding the transition matrix
  • Conclusions
8

Analyzing date and time intervals

  • Introduction to temporal data
  • Aggregating with simple intervals
  • Intervals crossing dates
  • Modeling working shifts and time shifting
  • Analyzing active events
  • Mixing different durations
  • Conclusions
9

Many-to-many relationships

  • 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

  • Introduction to granularity
  • Relationships at different granularity
  • Conclusions
11

Segmentation data models

  • Computing multiple-column relationships
  • Computing static segmentation
  • Using dynamic segmentation
  • Understanding the power of calculated columns: ABC analysis
  • Conclusions
12

Working with multiple currencies

  • Understanding different scenarios
  • Multiple source currencies, single reporting currency
  • Single source currency, multiple reporting currencies
  • Multiple source currencies, multiple reporting currencies
  • Conclusions

Appendix A. Data modeling 101

  • Tables
  • Data types
  • Relationships
  • Filtering and cross-filtering
  • Different types of models
  • Measures and additivity

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 Course
scroll to top