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

Dimensional Modeling Deep Dive

A TDWI Certificate Track

Virtual Classroom
October 11–13, 2022
9:00am – 5:00pm CT

Chris Adamson

Chris Adamson

Director of Education, TDWI

The scope of BI and analytics programs has expanded over the last decade, and technologies and methodologies have evolved. Dimensional modeling skills remain essential to success but must adapt to the modern data management environment. This intensive seminar provides comprehensive treatment of this crucial discipline. Learn everything you need to know to deliver success, from the basics of dimensional modeling for requirements and design to advanced techniques for complex scenarios and adaptations required in the era of big data and agile delivery.

Attend all three days and earn a certificate.

  • Tuesday, October 11

    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.

  • Wednesday, October 12

    In the era of big data, dimensional models serve a wide range of functions—from traditional OLAP consumption to resource provisioning for analytics to information distribution for self-service. This intensive course immerses you in the principles, processes, and deliverables of dimensional modeling.

    You will learn must-have skills—from the design of multi-star solutions to bridge tables to advanced slow change processing. You will understand how these techniques apply to three worlds: data mart development, production data sets for the data science community, and tabular views for the self-service community.

  • Thursday, October 13

    Traditional dimensional modeling techniques are destined to fail in modern BI and analytics programs. The best practices of dimensional modeling were established in the 1990s, before the advent of analytics, self-service, nonrelational data, agile methods, and data governance. The instructor will demonstrate how these expanded interests conflict with classic dimensional approaches and provide you with new techniques for scoping, requirements, design, and refactoring. Nothing is sacred, not even conformed dimensions!

Pricing Select Courses, View Pricing

3-Day Certificate Unlocked

Discounts

  • Early Bird Discounts

    Receive a 20% discount if you register by Aug. 12.
    Receive a 10% discount if you register by Sep. 09.

  • Member Discount

    Receive a 10% discount on your registration. Membership status will be validated when your registration is processed.

  • Team Discounts

    Teams of 3–9 people save 10% by using code TEAM. Groups of 10 or more will save 20% with code TEAM20.

REFUND AND CANCELLATION: You may substitute one person in your place by contacting registration@tdwi.org at least five business days prior to the event. If you must cancel all or part of your registration, your refund request must be sent to registration@tdwi.org no later than 10 business days prior. Your fee will be returned, less a 20% cancellation fee. No refunds will be issued within 10 days of the event.

Reserve your spot at the seminar today!

seminars

Subscribe to receive seminar updates via email