NEED HELP? TALK TO AN EXPERT (904) 638-5743

Data Modeling

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

Outline

 

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

Instructor

MITCHELL PEARSON

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.

REVIEWS

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.

Anonymous

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