x

Topics

Earn a Certificate

TDWI San Diego 2022 has ended, sorry you missed it!

Join us at TDWI Orlando, November 6–11, for the next data and analytics conference plus Executive Summit on Data Management, Nov. 7-8.

If you have any questions, please contact registration@tdwi.org.

By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

Course Description

Modern Data Management, Onsite, CBIP Certification, TDWI Foundations

T1 TDWI Dimensional Data Modeling Primer: From Requirements to Business Analysis

August 9, 2022

8:00 am - 5:30 pm

Duration: Full Day Course

Level: Beginner to Intermediate

Prerequisite: None

Krish Krishnan

Founder

Sixth Sense Advisors Inc.

Course Outline

Dimensional data is a core component of modern business intelligence and data warehouse implementations. Dimensionally organized data offers a more effective and adaptable solution to business analytics needs than can be achieved with relational data structures. Virtually anyone involved in business intelligence and data warehousing projects needs to have fundamental knowledge of the pathway from business questions to business analytics. This course traces that pathway.

The course begins with a comparison of relational and dimensional data organization and provides an example of business questions not readily answered using more traditional data structures of relational modeling. It then illustrates the steps to design analytics solutions, starting from business questions and concluding by demonstrating an OLAP solution. These steps encompass techniques to capture business questions, represent them as a business solution, translate them into a technology solution, and deliver them to those who need information.

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
  • Requirements-gathering techniques for business metrics and dimensional data
  • How to build a logical dimensional model
  • How to translate a logical dimensional model to a star schema design
  • How dimensional data is used to deliver business analytics and OLAP capabilities

Geared To

  • Data architects
  • Data mart developers
  • Business analysts
  • Business intelligence and data warehouse program and project managers

The clock is ticking.

Register Now

Register Online

Rest easy—online registrations for this conference are secure. Our secured server environment keeps your information private.