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

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