TDWI Data Modeling: Data Analysis and Design for BI and Data Warehousing Systems

A session at TDWI 2011 Europe Amsterdam

  • Jonathan G. Geiger

Monday 14th November, 2011

9:30am to 4:30pm (AMT)

Business intelligence and data warehousing systems challenge the proven data modeling techniques of the past. From requirements to implementation, new roles, uses, and kinds of data demand updated modeling skills. The data modeler's toolbox must address relational data, dimensional data, unstructured data, and master data. 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/DW systems. Those who need to understand data models, but not necessarily develop them, will learn about the various forms of models and what they are intended to communicate.

Prerequisite: This course assumes knowledge of data warehousing concepts and business intelligence fundamentals.

You Will Learn

The role of business requirements in BI data modeling
Differences in modeling techniques for business transactions, business events, and business metrics
The role of source data analysis in data modeling
Use of relational modeling techniques for data warehouse analysis and design
Use of dimensional modeling techniques for data warehouse analysis and design
Implications of unstructured data
The roles of normalization and abstraction in data warehouse design
The roles of identity and hierarchy management in data warehouse design
How time-variant data is represented in data models
Implementation and optimization considerations for warehousing data stores

Geared To

Data architects; data modelers; BI program and project managers; BI/DW system developers

About the speaker

This person is speaking at this event.
Jonathan G. Geiger

Sign in to add slides, notes or videos to this session

Tell your friends!

View the schedule



See something wrong?

Report an issue with this session