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 BI programs
- How principles and best practices have changed
- Modern data architectures that leverage new technologies, including NoSQL and virtualization
- The impact of big data on dimensional models
- How dimensional solutions integrate with new BI services
- The influence of agile development on the dimensional model
- Refactoring techniques for production dimensional solutions.
- A streamlined process for generating requirements through collaboration and iteration
- 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