Delve into metrics to understand the factors that contribute to reported results.
This course describes the role of dimensional modeling as a powerful approach for meeting business information needs and then describes the steps needed to develop conceptual, logical, and physical structures needed to deliver the information in a consumable form. Dimensional models provide a powerful way to enable business analysts, manager, and executives to view performance metrics and to delve into those metrics to understand the factors that contribute to the reported results.
You Will Learn
- Concepts of dimensional data modeling
- The relationship between business metrics and dimensional data
- Similarities and differences between relational and dimensional data models
- How to build a logical dimensional model
- Understand different types of dimensions and where to use each
- How to translate a logical dimensional model to a star schema design
- Testing and validating the dimensional model
- How to dimensional data is used to deliver business analytics and OLAP capabilities
- Business analysts, managers, executives to view performance metrics and to delve into those metrics to understand the factors that contribute to the reported results.
- Business professionals wanting to build and transform logical and physical structures that can deliver information to business people without a technical background.
Continuing Professional Education Credits: 5
Apply these credits toward your CBIP recertification. Not certified? Learn more about CBIP and how to get certified https://tdwi.org/pages/education/cbip-certification/cbip-home.aspx here.
Geiger Intl, Inc.
Jonathan Geiger, CBIP, is an experienced consultant with management and hands-on experience in business intelligence, data governance, quality management, CRM, and related areas in many industries, having gained his initial experience as a program manager at an electric utility company and subsequently as a consultant. He presents frequently at national and international conferences, has written over sixty articles, and coauthored three books.