Data Modeling

£395.00

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

Category:

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.

INSTRUCTOR

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

WHAT TO KNOW BEFORE THE CLASS

Basic knowledge of working with data and database structures.


Duration: 6:35:05
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 providing analytical value through business intelligence.
Data Modeling - What do you need to get started
Module 01 - Course Introduction
09:52
Module 02A - Modeling Methodologies (Transactional Model)
14:25
Module 02B - Modeling Methodologies (Dimensional Model)
18:57
Module 03 - Transactional Model Design
17:55
Module 04 - Dimensional Model Design
15:55
Module 05A - Defining the Business Process (Planning a Project)
25:16
Module 05B - Defining the Business Process (Declaring the Grain)
23:34
Module 06A - Dimension Design (Dimension Types)
35:31
Module 06B - Dimension Design (Conformed Dimensions)
14:19
Module 06C - Dimension Design (Junk Dimensions)
08:54
Module 06D - Dimension Design (Degenerate Dimensions)
07:26
Module 06E - Dimension Design (Role Playing Dimensions)
09:22
Module 06F - Dimension Design (Creating Dimensions)
12:29
Module 06G - Dimension Design (Creating a Customer Dimension)
20:44
Module 07A - Fact Design (Transaction Facts)
20:27
Module 07B - Fact Design (Periodic Snapshot)
13:41
Module 07C - Fact Design (Accumulating Snapshot)
07:28
Module 08A - Relationships (Overview)
23:43
Module 08B - Relationships (Many to Many - Double Counting)
13:46
Module 08C - Relationships (Hierarchy and Parent-Child)
09:13
Module 09A - Advanced Data Modeling Techniques (Overview)
21:15
Module 09B - Advanced Data Modeling Techniques (Allocated Facts)
11:55
Module 09C - Advanced Data Modeling Techniques (Other Dimensions)
14:26
Module 10A - Designing for Business Intelligence (ETL Considerations)
17:21
Module 10B - Designing for Business Intelligence (SSAS Consideration)
07:11
Class Survey

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