Watch Video

Agile Datawarehouse Design

[Due to corona restrictions we only have a limited number of seats available. Please register early! To provide the live video stream in the hybrid format, we require a minimum of three online attendees.]

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.

Learning objectives

You will learn how to:

  • Understand the requirements and challenges of DW/BI design in a “Big Data” world
  • Explain the impact of agile practices on DW/BI design
  • Agile dimensional modeling using Business Event Analysis & Modeling (BEAM)
  • Run modelstorming sessions: do data modeling that is quicker, more inclusive, more productive, and quite frankly more fun!
  • Model BI requirements with stakeholders using business-friendly tools and techniques
  • Model data requirements collaboratively using visual thinking and storytelling
  • Tell dimensional data stories using the 7Ws (who, what, when, where, how many, why and how)
  • Use narrative, visual thinking, 7Ws and lots of Post-it ™ notes to get everyone thinking more clearly about data requirements and creating better data models
  • Help business stakeholders develop powerful mental maps for exploring their data with modern BI tools
  • Model by example not abstraction; using data story themes, not crow’s feet, to describe detail
  • Storyboard the data warehouse to discover conformed dimensions and plan iterative development
  • Rapidly translate BI data requirements into efficient, flexible data warehouse and data mart designs
  • Plan, design and develop BI solutions incrementally
  • Solve common BI performance and usability problems with proven dimensional design patterns.

Who Should Attend

  • Business and IT professionals who want to jointly develop better analytical data solutions sooner
  • Business analysts, scrum masters, data modelers/architects, DBAs and application developers new to DW/BI, will benefit from the solid grounding in dimensional modeling.
  • Data scientists and engineers will learn valuable techniques for designing feature rich datasets.
  • Experienced DW/BI professionals will find the course updates their hard-earned industry knowledge with fresh ideas on agile modeling, dimensional design patterns and business model alignment.
  • Data Vault practitioners will appreciate BEAM’s systematic approach for designing query-friendly dimensional data marts and unlocking business value.

You receive a free copy of the book Agile Data Warehouse Design by Lawrence Corr.

Lawrence Corr

Chief Data Modelstormer
DecisionOne Consulting
Lawrence Corr is a leading international BI consultant and former Ralph Kimball Associate. He has worked on data warehousing projects in the US, Europe, the Middle East and Africa within healthcare, telecoms, broadcasting, higher education, financial services and retail, helping organizations benefit from simpler, more inclusive requirements modeling techniques.

Read more

The virtual seminars and workshops will be offered through an online meeting platform, usually Webex or Zoom, from our video studio. The virtual classroom is equipped with multiple professional cameras and microphones and we have a two person crew available so that we can offer a similar experience to that of the traditional classroom and, more important, still offer adequate interaction with the speaker.

The presenter / trainer will still use his Powerpoint, combined with flipchart and paper, virtual whiteboard and physical whiteboard and will be accompanied by a operator / moderator at the scene. The presenter does not have to worry about technical issues such as switching, splitting, microphone settings and such but can fully focus on the course material and on engaging with the online attendees.

  • When using the flipchart, the moderator will take care of switching scenes and camera perspective and of switching to attendees to ask questions.
  • When switching to flipchart you will have full view of the presenter and of the flipchart with all text and diagrams crystal clear.
  • And since the presenter / trainer is equipped with a wireless lapel microphone and the questions of the participants enter the course room clearly understandable (amplified), he can answer those questions from anywhere in the classroom and from any camera angle.
  • Asking questions and the speaker answering them can therefore be done just like you are used to in a regular classroom.
  • Because the course room is equipped with at least four monitors, the speaker/trainer also has a view of the online participants during the meeting.
  • For some (international) speakers we may use their own virtual course room with similar facilities but we will send the invite ourselves and the meeting will run on the Adept Events online meeting platform.

All of the above is to ensure that it does not become an impersonal one-way webinar but an interactive virtual classroom setting.

Those attending an online event or a hybrid event with the online meeting platform will be sent an invitiation with the meeting hyperlink and instructions a few days before, so well in advance of the course.

testimonials

Maarten Sitvast BI Team-lead, Ymere

“Lawrence is a fantastic, enthusiastic speaker. Definitely an 'icon' in the world of BI. I enjoyed following his workshop BEAM Agile Data Warehouse Design.”

Erwin de Vries Data Engineer, Devhouse Spindle

“Lawrence Corr is a really enjoyable and knowledgeable lecturer. The workshop has a nice variety of team exercises and theory.”

Sanne van der Veer BI analist, Ymere

“Very intersting, fun, broad. Covers a lot and manages to keep it simple. Inspiring days, lots of new ideas!”

Najma Mustafa Product Owner, NEOM

“I can see why Lawrence is an expert in the Agile DW & Dimensional Modelling field. His teaching & knowledge is thorough, engaging and thoughtful.”

Bram Nijenhuis BI-specialist, VisionBI B.V.

“Relevant for anyone interested in gathering BI-requirements, with a lot of practical models.”

Petter Derhaag BI Developer, PGGM

“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.”

Paul Gale Data Architect, Paga BV

“Great course from the business perspective, will make me change my approach to modeling with the business.”

Erik van Dongen Data Engineer, Gemeente Oosterhout

“Very refreshing approach to Data Warehouse Modelling. Speaking the stakeholder language is a big plus.”

Francoise Grandjean BI Expert, Keyrus nv

“Very complete DWH and DTM training, including Agile Business Communication tips.”

Norbert Lourijsen BI Consultant, Rabobank

“Great workshop, very inspiring.”

Peter Hamersma Data analist, Agentschap Telecom/EZK

“Lawrence is an excellent trainer and has a lot of experience he shares with us.”

In-house Info

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.

MORE INFO