Prerequisite: This course assumes a basic understanding of dimensional models (including concepts such as facts, dimensions, grain, and the basics of slowly-changing dimensions).
The dimensional model is a product of a simpler age—one where BI was all about the data warehouse and a terabyte of data was unimaginable.
How has this aging discipline been impacted by advances in technologies, the advent of agile methods, and the expansion of BI programs to include analytics, performance management, and data governance?
Join Chris Adamson, the world’s leading expert on the dimensional model, for a tour of what has (and has not) changed in the era of big data and analytics.
You Will Learn
- A refresher on dimensional modeling techniques (including the types of fact tables, dimensional intricacy, bridge design, and change handling)
- How principles and best practices have changed (Spoiler: principles have not changed, but best practices have)
- Agile dimensional techniques for requirements, scope, and design (including business dimensional modeling techniques and a rethinking of design best practices)
- How to integrate with analytics and other BI services (including techniques for analytics-friendly warehouse design, multidirectional data integration, and KPI management)
- How to incorporate nonrelational data sources (including techniques for incorporating unstructured data in dimensional designs and for extending the warehouse to include both dimensional and nonrelational data)
- Modern data architectures that support multiple BI services and leverage new technologies including NoSQL and virtualization
- How to make sure “modeling” is not a dirty word by shifting the modeler’s role away from gatekeeping and toward consensus building
- Templates for capturing business needs, collaborative design, and KPI definition
This course is intended for anyone who contributes to data mart requirements and development, including:
- Business analysts and requirements analysts
- Data modelers and architects
- Reporting and ETL developers and architects
- BI program and project managers
- Database administrators
- "Power users" and business subject matter experts