Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Dimensional Modeling: Getting Started with Excel Power Pivot
Course Content
Expand All
Platform Introduction
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Course Examples
Course Introduction
Who is Ken Puls?
Extend Your Access
Introduction to Power Pivot
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Where PivotTables Fail
Enter the Data Model
Relating the Tables
Aggregating Data with DAX
Filtering, Ordering and Sorting
Architecting Business Intelligence Solutions
9 Lessons
Expand
Module Content
0% Complete
0/9 Steps
Steps to Successful Business Intelligence
Identifying the Business Process
Wireframing Report Requirements
Determining the Model Grain
Structuring Data for Self Service BI
Exercise: Designing Tables From Wireframes
Solution: Designing Tables From Wireframes
Determining Unique Columns Required
Collecting and Normalizing Model Data
Dimensional Modeling Terminology and Techniques
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Facts and Dimensions
Preparing For Dimensional Modeling
Designing Dimension Tables
Designing Fact Tables
Creating Facts (Measures)
Relating Tables
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Relationship Types
Relationship Schemas
Effect of Relationship Issues
Preventing Filtering Issues
Dimensional Modeling Recipes
11 Lessons
Expand
Module Content
0% Complete
0/11 Steps
Composite Key Joins
Bridge Tables
Flattening Snowflaked Dimensions
Creating Calendar Dimensions
Creating Calendar Boundaries
Creating Calendars from StartDate to EndDate
Fiscal Periods for 12-Month Dec 31 Year Ends
Modifications for 12-Month Non-Std Year Ends
Fiscal Periods for 12-Month Non-Std Year Ends
Modifications for 364 Day Calendars
Fiscal Periods for 364 Day Calendars
Slowly Changing Dimensions
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Slowly Changing Dimensions
Filling Blanks with Dates
Option 1: Surrogate Keys Without Meaning
Option 2: Surrogate Keys With Meaning
Creating the Bridge Query
Replacing the Fact Table’s Foreign Key
Development Tips
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Model Performance and Stability
How the Vertipaq Engine Works
Help Resources
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Free Help Forums
Free Articles and Blogs
Master Your Data
Power Query Recipes
Power Query Academy
Free Newsletters