Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Dimensional Modeling for the Excel Pro
Course Content
Expand All
Course Introduction
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Getting Started
What is This Course All About?
Overview of the Data Model
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 for the Model
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
Extracting Facts with Measures
Relating Tables
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Relationship Types
Relationship Schemas
Relationship Issues
Preventing Filtering Issues
Methodology for Creating a Data Model
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Designing a Data Model – Model-Driven Approach
Assess Datasets
Categorize and Discover & Analyze
Sketch and Prototype in Excel
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 Standard Year Ends
Adjustments for 12-Month Non-Standard Year Ends
Fiscal Periods for Non-Standard 12-Month Year Ends
Adjustments for 364-Day Calendars
Fiscal Periods for 364-Day Calendars
Slowly Changing Dimensions
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
The Slowly Changing Dimension Issue
Filling Blank Cells with Dates
Option 1: Surrogate Keys Without Meaning
Option 2: Surrogate Keys With Meaning
Creating the Merging Bridge Table
Replacing the Fact Table’s Primary Key
Storing Dimensions on Fact Tables
Many to Many Joins
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Many to Many Patterns
Many to Many with 1:Many in Excel
Many to Many Physical Relationships
Many to Many Virtual Relationships in Excel
Solving Specific Business Issues
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Header Detail Tables (Excel)
Stock on Hand Count Reporting (Excel)
Status Reporting (Excel)
Custom Time Intelligence
Performance and Optimization
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Model Performance and Stability
How the Vertipaq Engine Works
6 Tips for Data Model Optimization
Power Query Optimization
Tools for Testing Model Performance
Rate the Course
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Course Feedback