September 29, 2020
8:00 am - 3:30 pm
Duration: Full Day Course
Founder and BI Specialist
Oakton Software LLC
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.
Students learn to match these techniques to real-world business complexity and explore their impacts on BI, analytics, and data integration tools. The course exposes the reasons behind best practices and teaches you to make pragmatic choices on design options. You will also learn how to fit dimensional modeling into varied development frameworks (including agile) and will receive templates for capturing requirements and designs.
This course assumes basic understanding of dimensional models (facts, dimensions, and basic slow change techniques). It is intended for anyone who contributes to data mart development, including: