Advanced Database design techniques for Business Intelligence and Data Warehousing Systems

Brochure Image

by Michael Schmitz download a PDF brochure Download Event Brochure


This seminar addresses issues involved in designing database schemas to support Enterprise-Wide Business Intelligence. Real-time and near real-time requirements are dramatically changing requirements and this seminar focuses on the paradigm shift you will have to make. This seminar also introduces a new data architecture, Dimensional Normal Form. Dimensional Normal Form combines the strengths of both the normalized and the dimensional design methodologies to provide usable, flexible, scalable, and high performing designs for Enterprise-Wide Business Intelligence. Seminar participants will learn the new data architecture and study BI database design techniques. Participants work in teams as they develop solutions for difficult design problems. Their solutions are then analyzed and simulated for both usability and performance, providing important feedback to the students on their design choices. Attendees will leave with an understanding of the new data architecture and appreciation of how different design choices affect both the usability and performance of both their database and ETL design. This seminar is taught by an experienced BI database designer.

What you will learn

  • How to architect to accommodate Real-Time and Near Real-Time Requirements
  • A new data architecture – Dimensional Normal Form
  • Database Design Techniques for Business Intelligence
  • Tracking history without affecting usability or performance
  • Physical design issues

Main Topics

  • Data Modeling Review
  • The Dimensional Normal Form Approach
  • Dimensional Normal Form Basics
  • Planning BI Database Design
  • Business Dimensions in Depth
  • Designing for Extensibility
  • Enterprise BI Modeling Example
  • Tracking Dimension Attribute History
  • Additional Design Issues
  • Real-Time BI
  • Multi-National Support
  • Summary Strategies and Implementation
  • Physical Design and Performance Tuning