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 stored in relational or columnar databases, or OLAP cubes. This course provides the fundamental techniques to designing the data warehouse, data marts or cubes that enable business intelligence reporting and analytics.

This online 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