x

Topics

Earn a Certificate

By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

TDWI Transform 2025

Las Vegas | Feb. 23–28

Course Description

Data Management and Governance, Onsite, TDWI Foundations

S1 TDWI Data Modeling: Data Analysis and Design for BI and Analytics Solutions

February 23, 2025

9:00 am - 5:00 pm

Duration: Full Day

Level: Beginner to Intermediate

Prerequisite: This course assumes basic understanding of data warehousing fundamentals. It also assumes some basic understanding of entity-relationship modeling.

Rich Fox

Analytics Consultant and Educator

Course Outline

This data modeling techniques course explores different situations facing data modeling practitioners and provides information and techniques to help them develop the appropriate data models.

BI and analytics systems challenge the proven data modeling techniques of the past. The expanding scope of data management technologies, consumption demands, and data science processes require updated modeling skills. The data modeler’s toolbox must address relational data, NoSQL data, dimensional data, and master data. Modeling processes must include both top-down requirements-driven and bottom-up discovery methods. For those with data modeling experience, this course extends their skills to meet today’s modeling challenges. Those new to data modeling are introduced to the broad range of modeling skills needed for BI and data warehousing systems. Those who need to understand data models, but not necessarily to develop them, will learn about the various forms of models and what they are intended to communicate.

You Will Learn

  • Differences in modeling techniques for business transactions, business events, and business metrics
  • Different types of data and their implications
  • How modeling processes differ based on analytics objectives and data management technology
  • Application of business context to modeling activities
  • The role of business requirements in BI data modeling
  • The role of source data analysis in data modeling
  • Use of normalized modeling techniques for data warehouse analysis and design
  • Use of dimensional modeling techniques for BI and data mart analysis and design
  • The roles of generalization and abstraction in data warehouse design
  • The roles of identity and hierarchy management in data model design
  • How time-variant data is represented in data models
  • Implementation and optimization considerations for data stores

Geared To

  • Data architects
  • Data modelers
  • BI program and project managers
  • BI and data warehousing systems developers

Register Online

Rest easy—online registrations for this conference are secure. Our secured server environment keeps your information private.

TDWI Transform West — Las Vegas

Planet Hollywood Las Vegas Resort & Casino
3667 Las Vegas Blvd South
Las Vegas, NV 89109
February 23–28