Ora Hanttu

Tuoteryhmäpäällikkö, ICT

040 582 6008 Lähetä viesti

Kesto: 3 dagar
Veroton hinta (+ alv 24 %): 2 290 €
Voit maksaa:

Haluatko koulutuksen asiakaskohtaisena? Jätä yhteystietosi, niin palaamme asiaan. 


Lataa pdf-muodossa

Affecto Agile Data Warehouse Design Masterclass

In partnership with the Decision One Company, Affecto presente an Agile Data Warehouse Design 3-day masterclass from international data warehousing expert and author Lawrence Corr covering the latest agile techniques for systematically designing effective data warehouses and Business Intelligence systems.


The course is aimed at business and IT professionals who want to develop better data warehouses and BI solutions faster. Business analysts, scrum masters, product owners, 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 knowledge with the latest ideas on agile data modeling, data warehouse design patterns and business model innovation.

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 the design of the earliest needed and most important working software for DW/BI: database schemas.

Instructor Lawrence Corr

Lawrence Corr is a leading data warehouse designer 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 Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema and has contributed to Ralph Kimball articles and design tips.

He is the author of 'Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema'.


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, in detail, how agile dimensional modeling overcomes these limitations by modelstorming (modeling + brainstorming) requirements directly with fully-engaged BI stakeholders.


Agile Dimensional Modeling Fundamentals

  • BI/DW design requirements, challenges and opportunities: the need for agility
  • Modeling with BI stakeholders: the case for collaborative data modeling
  • Modeling for measurement: the case for dimensional modeling, star schemas, facts and dimensions
  • Thinking dimensional: using 7Ws (who, what, when, where, how many, why and how) to describe data
  • Business Event Analysis and Modeling (BEAM*): an agile approach to dimensional modeling

Dimensional Modelstorming Tools

  • Data stories, themes and BEAM* tables: modeling BI data requirements by example
  • Timelines: modeling time and process measurement
  • Hierarchy charts: modeling dimensional drill-downs and rollups
  • Change stories: capturing historical reporting requirements (slowly changing dimension business rules)
  • Storyboarding the data warehouse design: matrix planning and estimating for agile BI development
  • The Business Model Canvas: aligning DW/BI design with business model innovation
  • The BI Model Canvas: a systematic approach to star schema design

Star Schema Design

  • Test-driven design: using agile/lean data profiling to validate and improve requirements models
  • Data warehouse reuse: identifying, defining and developing conformed dimensions and facts
  • Balancing ‘just enough design up front’ (JEDUF) and ‘just in time’ (JIT) data modeling
  • Designing flexible, high performance star schemas: maximising the benefits of surrogate keys
  • Refactoring star schemas: responding to change, dealing with data debt
  • Lean (minimum viable) DW documentation: enhanced star schemas, BEAM* short codes, DW matrix

Dimensional Design Patterns using the 7Ws:

  • Who and What: Customers, employees, products and services
  • Large populations with rapidly changing dimensional attributes: mini-dimensions and customer facts
  • Customer segmentation: business to business (B2B), business to consumer (B2C) dimensions
  • Recursive customer relationships and organisation structures: variable-depth hierarchy maps
  • Current and historical reporting perspectives: hybrid slowly changing dimensions
  • Mixed business models: heterogeneous products and services, diverse attribution, ragged hierarchies
  • Product and service decomposition: component (bill of materials) and product unbundling analysis

When and Where: dates, times and locations

  • Flexible date handling, ad-hoc date ranges and year-to-date analysis
  • Modeling time as dimensions and facts
  • Multinational BI: national languages reporting, multiple currencies, time zones and national calendars
  • Understanding journeys and trajectories: modeling events with multiple geographies

How Many: facts, measures and KPIs

  • Fact types: transactions, periodic snapshots, accumulating snapshots
  • Fact additivity: additive, semi-additive and non-additive measures
  • Fact performance and usability: indexing, partitioning, aggregating and consolidating facts

Why and How: cause and effect

  • Causal factors: trigging events, referrals, promotions, weather and exception reason dimensions
  • Fact specific dimensions: transaction and event status descriptions
  • Multi-valued dimensions: bridge tables, weighting factors, impact and 'correctly weighted' analysis
  • Behaviour Tagging: modeling causation and outcome, dimensional overloading, step dimensions

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.

For further information, please contact

Mira Marno
Training Manager

or visit http://www.affecto.fi/AgileDW

Cancellation and Payment terms - Agile Workshop
Refund and Cancellation Terms for Agile Workshop
Cancellation of registration must be made in writing to academy.finland(at)affecto.com no later than 21 business days before course begins. Late cancellations (or no-show) will be invoiced. You may substitute another person in your place by emailing to academy.finland(at)affecto.com. Cancellations due to illness can be refundable upon presentation of a medical certificate.
Payment term: 14 days net (Finland)
Affecto reserves the right to change course schedules, content and prices.