BI and DW – Data Modeling

The foundation to a structurally sound business intelligence and data warehousing solution that delivers value is a well-designed data model.

data-modeling

An effective data model transforms data into an asset that is current, comprehensive and consistent. How does this transformation occur? Data must be transferred from source systems into a destination for analysis: data warehouse, data mart or OLAP cubes.

In this course, we present techniques fundamental to designing these data warehouses, data marts or cubes to enable effective reporting and analysis of business intelligence.

We cover two logical data modeling approaches:

  • Entity-Relationship (ER) Modeling
  • Dimensional Modeling

ER Modeling helps establish the baseline data model while Dimensional Modeling creates the cornerstone to the DW/BI application. With the continual evolution and creation of data modeling best practices, these two modeling techniques have matured to meet the demands of enterprises of all sizes in various industries. Use of these techniques:

  • Reduces application development time
  • Enhances project productivity
  • Increases the business value of data

Our course incorporates concepts, applications and practical examples, to deliver instruction in the most effective way.

We instruct on:

  • Entity-Relationship (ER) and dimensional modeling fundamentals
  • Dimensional Data Modeling benefits and applicability
  • Dimensional Data Model creation for BI and DW applications
  • Learning more about Data Modeling in general

This course is designed for:

  • Beginner Data Modelers
  • Business Analysts and Architects
  • Database Administrators and Analysts
  • Information Technology Managers, Project Managers
  • Application Development Project Team Members
  • Peopleworking on design and maintenance of Data Warehousing and Business Intelligence applications
  • People supporting data quality or data governance processes