Agile Data Warehouse Design
A 3-day workshop presented by international data warehousing expert and author Lawrence Corr covering the latest agile techniques for systematically designing effective data warehouses and Business Intelligence systems.
Agile and lean practices that emphasise the early and frequent delivery of working software, stakeholder collaboration, responsiveness to change and waste elimination have revolutionised application development and are increasingly being adopted by data warehousing and business intelligence (DW/BI) teams. This course provides practical tools and techniques for applying agility to BI requirements gathering and the design of the earliest needed and most important working software for DW/BI: database schemas.
The course begins by contrasting agile and non-agile DW/BI development and highlighting the inherent failings of traditional BI requirements analysis and data modeling. It then describes, via class room sessions and team exercises, how agile dimensional modeling overcomes these limitations by modelstorming (modeling + brainstorming) requirements directly with BI stakeholders.
You Will Learn To:
✲ Model BI requirements with BI stakeholders using inclusive tools and visual thinking techniques
✲ Rapidly translate BI requirements into efficient, flexible data warehouse designs
✲ Identify and solve common BI problems – before they occur – using dimensional design patterns
✲ Incrementally plan, design and develop BI solutions with agility
Who Should Attend
The course is aimed at business and IT professionals who want to develop better data warehouses and BI solutions faster. Business analysts, scrum masters, data modelers/architects, DBA’s and application developers, new to DW/BI, will benefit from the solid grounding in dimensional modeling provided. Experienced DW/BI practitioners will find the course updates their hard-earned industry knowledge with the latest ideas on agile modeling, data warehouse design patterns and business model innovation.
About the Instructor
Lawrence Corr is a leading data warehouse designer, author and highly experienced educator who has worked in Europe, North America, the Middle East and South Africa developing and reviewing BI solutions for healthcare, telecoms, engineering, broadcasting, financial services and retail sectors. He specialises in helping organisations benefit from simpler, more inclusive DW/BI design techniques.
He is the author of the bestselling Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema (an amazon.com #1 bestseller in data warehousing) and a past contributor to Ralph Kimball articles and design tips.
Attendees receive a course workbook, BEAM✲ agile dimensional modeling reference card and a copy of ‘Agile Data Warehouse Design’ (DecisionOne Press, 2011) by Lawrence Corr and Jim Stagnitto
2013 - 2014Order or take a peek >