Data Modeling

Part Of The On-Demand Courses


  • Modeling methodologies and advanced data modeling techniques
  • Transactional and dimensional model design
  • How to define the business process
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

The Pragmatic Works Data Modeling course is designed to teach the foundation of creating effective data models. This course covers two separate modeling techniques: transactional systems and dimensional modeling. A well-designed data model is the foundation for supporting the day-to-day operational activities of an organization and provides analytical value through business intelligence.


Click here for a downloadable PDF



Module 01 | Course Introduction
09m 51s total


Module 01A | Course Introduction
09m 51s


Module 02 | Modeling Methodologies
33m 20s total


Module 02A | Transactional Model
14m 24s


Module 02B | Dimensional Model
18m 56s


Module 03 | Transactional Model Design
17m 54s total


Module 03A | Transactional Model Design
17m 54s


Module 04 | Dimensional Model Design
15m 55s total


Module 04A | Dimensional Model Design
15m 55s


Module 05 | Defining the Business Process
48m 49s total


Module 05A | Planning a Project
25m 15s


Module 05B | Declaring the Grain
23m 34s


Module 06 | Dimension Design
108m 39s total


Module 06A | Dimension Types
35m 30s


Module 06B | Conformed Dimensions
14m 18s


Module 06C | Junk Dimensions
8m 54s


Module 06D | Degenerate Dimensions
7m 25s


Module 06E | Role Playing Dimensions
9m 21s


Module 06F | Creating Dimensions
12m 28s


Module 06G | Creating a Customer Dimension
20m 43s


Module 07 | Fact Design
41m 35s total


Module 07A | Transaction Facts
20m 27s


Module 07B | Periodic Snapshot
13m 40s


Module 07C | Accumulating Snapshot
7m 28s


Module 08 | Relationships
46m 41s total


Module 08A | Relationships Overview
23m 43s


Module 08B | Many to Many – Double Counting
13m 46s


Module 08C | Hierarchy and Parent-Child
9m 12s


Module 09 | Advanced Data Modeling Techniques
47m 34s total


Module 09A | Advanced Data Modeling Techniques Overview
21m 14s


Module 09B | Allocated Facts
11m 55s


Module 09C | Other Dimensions
14m 25s


Module 10 | Designing for Business Intelligence
24m 30s total


Module 10A | ETL Considerations
17m 20s


Module 10B | SSAS Consideration
7m 10s



Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Windows 7, Windows 8 or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • **Optional** SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014/2016 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Management Studio
  • **Optional** Microsoft Excel

What to Know Before Class

Basic knowledge of working with data and database structures.


Overall a FANTASTIC tutorial on dimensional modelling.

Roger F.

Great job on the course; the clarity, the thoroughness, the precise language and explaining terminology in simple, easy to digest ideas, have been second to none. Kudos!!!

Cosmin I.

Great job thanks Mitchell. I particularly like the way you minimize the length of each video to less than 20 minutes. Helps a lot as I often pause the video to make notes or try things out, so this is the ideal maximum time per video to make concentration easier. Also, the whiteboarding demos were excellent.


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required