Agile techniques emphasise the early and frequent delivery of working software, stakeholder collaboration, responsiveness to change and waste elimination. They have revolutionised application development and are increasingly being adopted by DW/BI teams. This course provides practical tools and techniques for applying agility to the design of DW/BI database schemas – the earliest needed and most important working software for BI.
The course contrasts agile and non-agile DW/BI development and highlights the inherent failings of traditional BI requirements analysis and data modeling. Via class room sessions and team exercises attendees will discover how modelstorming (modeling + brainstorming) data requirements directly with BI stakeholders overcomes these limitations.
You will learn how to:
Who Should Attend
You receive a free copy of the book Agile Data Warehouse Design by Lawrence Corr.
Agile Dimensional Modeling Fundamentals
Dimensional Modelstorming Tools
Star Schema Design
How Much/How Many: Designing facts, measures and KPIs (Key Performance Indicators)
Who & What dimension patterns: customers, employees, products and services
When & Where dimension patterns: dates, times and locations
Why & How dimension patterns: cause and effect