ONSITE EDUCATION

Your Team,
Your Location,
Our Instructors

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

Duration: Two Day Course

Prerequisite: This course assumes basic understanding of data warehousing fundamentals.

Preview Course Materials Course Outline

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.

You Will Learn

  • Differences in modeling techniques for business transactions, business events, and business metrics
  • Different types of data and their implications
  • 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 data warehouse analysis and design
  • The roles of generalization 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

Contact Us to Get Started Today

REQUEST INFORMATION

Yvonne Baho

Yvonne M. Baho Director, Enterprise Learning
Phone: 978.582.7105
E-mail: ybaho@tdwi.org

PRINTABLE PDF

Check out the Onsite Brochure

Download Now

TESTIMONIALS

“Very good overall view of DW concepts and provided valuable insight for such a varied audience.”

Jerry Bundt
Nestle Purina

“This was the best training class I’ve had in my 20 year career.”

Tim Grieb
Seattle Children’s Hospital

“The instructor did an excellent job and demonstrated an understanding of real world applications.”

Sean Dewulf
Con-way Freight

Discover the impact Onsite Education has had on real Fortune 500 clients through practical in-depth training.

  • Banking
  • Healthcare
  • Manufacturing
TDWI has provided education to 95% of the Fortune 100 companies.
Our expert instructors will help your company surge ahead of the competition.