Data Modeling


What Will You Learn?

  • Modeling methodologies and advanced data modeling techniques
  • Transactional and dimensional model design
  • How to define the business process


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.



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.

Curriculum For This Course

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

You may also like…