Agile Data Warehouse Design covers step-by-step techniques for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders.
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 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.
The course teaches BEAM (Business Event Analysis & Modeling), an agile approach to dimensional modeling, for improving communication between data designers, BI stakeholders and the whole DW/BI development team. BEAM provides tools and techniques that will encourage designers and developers to set aside their keyboards and entity relationship based tools and model interactively with their business stakeholders and colleagues. The result is everyone thinks dimensionally from the initial high level data requirements right down to detailed datasets. Developers understand how to efficiently implement dimensional modeling solutions. Business stakeholders feel ownership of the models they co-create and can already imagine how they will use them to answer their business questions.
BEAM helps close the gap between the business users’ data requirements and database design. It allows groups of business and IT professionals to model data collaboratively to not only gather and prioritize data requirements but create a shared understanding of data analytics opportunities and design more flexible BI solutions.
Join Lawrence Corr, author of the DW/BI bestseller Agile Data Warehouse Design for a lively three-day collaborative dimensional modeling course covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems.
You will learn how to:
You receive a free copy of the book Agile Data Warehouse Design by Lawrence Corr.
Van der Valk Hotel Utrecht
3526 KV Utrecht
Telefoon 030 8000 800
The hotel is very well accessible by public transport. From busstop ‘Kanaleneiland Zuid’ it is only a three-minute walk. You can also take the tram line 60 or 61 from trainstation Utrecht Centraal and get off at stop ‘Kanaleneiland’. Please consult www.9292.nl (door-to-door journey planner, also available in English) or call 0900-9292 (travel advice by phone, € 0.70 p/m).
Van der Valk Hotel Utrecht is also located next to the highway A12, exit 17 (Utrecht / Jaarbeurs / Kanaleneiland).
Although the hotel has a large parking garage, we cannot guarantee parking spots. We therefore advise you to go by public transport.
For those who would like to arrive the day before, there is the possibility of staying at the Van der Valk Hotel Utrecht. However, the hotel does not provide special discounts for attendees of events. Therefore, when interested in an overnight stay, please consult Van der Valk directly to make a reservation.
More information about the hotel and the location can be found on their website www.vandervalkhotelutrecht.nl.
“Lawrence Corr is a really enjoyable and knowledgeable lecturer. The workshop has a nice variety of team exercises and theory.”
“Relevant for anyone interested in gathering BI-requirements, with a lot of practical models.”
“Great course for people in BI who are looking for a quality set of basic knowledge in DWH design. Combine this with excellent methods to do this with non-technical colleagues.”
“Great course from the business perspective, will make me change my approach to modeling with the business.”
“Very refreshing approach to Data Warehouse Modelling. Speaking the stakeholder language is a big plus.”
“Very complete DWH and DTM training, including Agile Business Communication tips.”
“Great workshop, very inspiring.”
Practically all of our seminars and workshops can be offered as an In-house course for your company exclusively. We can tailor with extra focus on specific topics that apply to your organization. Also available in online format or in face-to-face format with live video stream.