Business Intelligence (BI) Data Modeling

A clear overview and fundamental techniques for designing dimensional data models for your BI project.

Athena Solutions

$525.00

A well designed data model is the cornerstone to building business intelligence and data warehouse applications that provide significant business value.  Effective data modeling results in transforming data into an enterprise information asset that is consistent, comprehensive and current. Data is transformed from operational or source systems into a data warehouse and often data marts or OLAP cubes for analysis. This course provides the fundamental techniques to designing the data warehouse, data marts or cubes that enable business intelligence reporting and analytics.

This course covers:

  • Overview and purpose of dimensional modeling
  • Introduction to facts, dimensions and schemas
  • ER versus dimensional modeling
  • Fact tables
  • How to achieve consistency
  • Hierarchies
  • Advanced dimension topics:
    • Slowly-changing dimensions
    • Rapidly-changing dimensions
    • Causal dimensions
    • Multi-valued dimensions
    • Junk dimensions
  • Value band reporting
  • Heterogeneous products
  • Hot-swappable dimensions

This course will benefit:

  • Data modelers
  • Business analysts and architects
  • Database administrators and analysts
  • Information technology managers and project managers
  • Application development project team members
  • People involved in design and maintenance of data warehousing and business intelligence applications
  • People involved in data quality or data governance processes

Instructor
Rick Sherman