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 the dimensional model and its purpose in BIprograms.
- How principles and best practices have changed. Spoiler: principles have not changed, but best practices have.
- Modern data architectures that leverage new technologies, including NoSQL and virtualization, and the importance of the dimensional model in this expanding ecosystem.
- The impact of big data on dimensional models—including techniques for augmenting dimensional designs with unstructured data and for extending data marts to include both dimensional and non-relational data.
- How dimensional solutions integrate with new BI services—including the incorporation of analytics insights into dimensional data marts, design techniques for analytics-friendly dimensional models, and KPI definition for performance management integration.
- The influence of agile development on the dimensional model—including scope management, design practices, and tools for assessing technical debt.
- Refactoring techniques for production dimensional solutions.
- A streamlined process for generating requirements through collaboration and iteration—including business requirements (information needs) and functional requirements(top-level design).
- Templates for capturing business and functional requirements that are validated and actionable.
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 data pipeline developers and architects
- BI program and project managers
- Database administrators
- “Power users” and business subject matter experts