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
November 4–6, 2024
9:00am – 5:00pm CT

Mark Peco

Mark Peco

Analytics Consultant and Instructor

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.

Register today for our dimensional modeling deep dive certificate course. Attend all three days and earn a certificate.

  • Monday, November 4

    TDWI Dimensional Data Modeling Primer: From Requirements to Business Analysis

    View Full Course Abstract

    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.

  • Tuesday, November 5

    Advanced Dimensional Modeling: Complete Tour of Modern Best Practices

    View Full Course Abstract

    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.

  • Wednesday, November 6

    The Dimensional Model Refactored: New Techniques for the 21st Century

    View Full Course Abstract

    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

  3-Day Training 2-Day Training 1-Day Training
Super Early Bird Discount Save 20% by Sep 13 $1,840 $1,465 $835
Early Bird Discount Save 10% by Oct 4
 $2,070 $1,650 $935
Regular Registration Oct 5 - Nov 1 $2,300 $1,830 $1,040

Discounts

  • Early Bird Discounts

    Receive a 20% discount if you register by Sep 13.
    Receive a 10% discount if you register by Oct 4.

  • 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 [email protected] 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 [email protected] no later than October 18, 2024. Your fee will be returned, less a 20% cancellation fee. No refunds will be issued after October 18, 2024.

Reserve your spot at the seminar today!

virtual seminars

Subscribe to receive seminar updates via email

Dimensional Modeling Deep Dive

November 4–6, 2024