Skip Main Navigation
Eventbrite
Browse Events
Organise
Help
Log InSign Up
Menu
Page Content
This event has ended.
Agile Data Warehouse Design with Lawrence Corr - Bern, Switzerland 7-9 February 2018 (Euro Pricing)

Actions Panel

Feb 07

Agile Data Warehouse Design with Lawrence Corr - Bern, Switzerland 7-9 February 2018 (Euro Pricing)

By DecisionOne Consulting

When and where

Date and time

Wed, 7 Feb 2018, 09:00 – Fri, 9 Feb 2018, 16:30 CET

Location

IT-Logix AG Schwarzenburgstrasse 11 3007 Bern Switzerland

Map and directions

How to get there

Refund Policy

Refunds up to 30 days before event

Description

Collaborative BI Requirements Analysis & Dimensional Modeling Training

Join Lawrence Corr, author of the DW/BI bestseller "Agile Data Warehouse Design" for a three-day BEAM✲ workshop and data modelstorming masterclass covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems.

Discover how modelstorming (modeling + brainstorming) directly with business stakeholders overcomes the limitations of traditional BI requirements analysis and data modeling to create a shared data language across business and IT.

Over three days of engaging class room sessions, quizzes, games and team exercises, Lawrence will build on Kimball method, industry-standard dimensional modeling and go beyond the books to provide you with practical tools and techniques for BI data design.

Agile Data Warehouse Design Book CoverWho Should Attend

Business and IT professionals who want to jointly develop better BI solutions faster.

Business analysts, scrum masters, data modelers/architects, DBAs and application developers new to DW/BI, will benefit from the solid grounding in dimensional modeling.

Experienced DW/BI practitioners will find the course updates their hard-earned industry knowledge with fresh ideas on agile modeling, data warehouse design patterns and business model alignment.


You will learn how to:

  • Model BI requirements with stakeholders using business-friendly tools and techniques

  • Rapidly translate BI data requirements into efficient, flexible data warehouse designs

  • Identify and solve common BI problems using dimensional design patterns

  • Plan, design and develop BI solutions incrementally with agility


Day 1: Modelstorming – Agile BI Requirements Gathering


Agile Dimensional Modeling Fundamentals

  • BI/DW design requirements, challenges and opportunities: the need for agility

  • Modeling for measurement: the case for dimensional modeling, star schemas, facts & dimensions

  • Modelstorming with BI stakeholders: the case for collaborative data modeling

  • Thinking dimensional using the 7Ws (who, what, when, where, how many, why & how)

  • Business Event Analysis and Modeling (BEAM✲): an agile approach to dimensional modeling

Dimensional Modelstorming Tools

  • Data Stories, Themes and BEAM✲ Tables: modeling detailed BI data requirements by example

  • Timelines: modeling process sequence measurement

  • Hierarchy Charts: modeling dimensional drill-downs and rollups

  • Change Stories: capturing historical data requirements (slowly changing dimension rules)

  • BEAM✲ Matrix: Storyboarding multiple business events planning and estimating for agile BI development

  • Business Model Canvas: aligning DW/BI design with business model definition, measurement and innovation

  • BEAM✲ (BI Model) Canvas: a systematic approach to BI & star schema design


Day 2: Agile Star Schema Design


  • Test-driven design: agile data profiling for validating and improving 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 DW documentation: enhanced star schemas, Data Warehouse matrix

  • How Many: Designing facts, measures and KPIs

  • Fact table types: transactions, periodic snapshots, accumulating snapshots

  • Fact additivity: additive, semi-additive and non-additive measures


Day 3: Dimensional Design Patterns


Who & What patterns for modeling customers, employees, products and services

  • Large populations with rapidly changing dimensional attributes: mini-dimensions & 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/services, diverse attribution, ragged hierarchies

  • Product and service decomposition: component (bill of materials) and product unbundling analysis

When & Where patterns for modeling dates, times and locations

  • Flexible date handling, ad-hoc date ranges and year-to-date analysis

  • Modeling time quantitatively and qualitively as dimensions and facts

  • Multinational BI: national languages reporting, multiple currencies, time zones & national calendars

  • Understanding journeys and trajectories: modeling event sequences with multiple geographies

Why & How patterns for modeling 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


Material

Attendees receive a course workbook, BEAM✲ agile dimensional modeling reference card, downloadable modelstorming templates plus paperback and ebook copies of Agile Data Warehouse Design (DecisionOne Press, 2011) by Lawrence Corr and Jim Stagnitto.

Lunch, teas and coffees will be provided each day


Booking AND Payment

Register above to pay online via credit card.

If you are a Swiss resident/business and wish to pay online in Swiss Francs please visit our CHF Eventbrite page.

To book and pay via bank transfer or company PO contact training@decisionone.co.uk or call +44 (0)7971 964794

Tags

  • Switzerland Events
  • Bern Events
  • Things to do in Berne
  • Berne Classes
  • Berne Business Classes
Event ended

Agile Data Warehouse Design with Lawrence Corr - Bern, Switzerland 7-9 February 2018 (Euro Pricing)


Follow this organiser to stay informed on future events

DecisionOne Consulting

Event creator

Events you might like

  • Exos Performance Mentorship Phase 1 & 2 - Bern, Switzerland

    Exos Performance Mentorship Phase 1 & 2 - Bern, Switzerland
    Exos Performance Mentorship Phase 1 & 2 - Bern, Switzerland

    Thu, Jun 8, 08:15
    savo.ch • Bern
    US$2,379 - US$5,038
  • XLCubed Administrator - Schulung in Bern

    XLCubed Administrator - Schulung in Bern
    XLCubed Administrator - Schulung in Bern

    Fri, Feb 10, 09:00
    Business Center Welle 7 • Bern
    €1,131.08
  • BLUF United Dinner Bern

    BLUF United Dinner Bern
    BLUF United Dinner Bern

    Fri, Feb 17, 19:00
    Anker • Bern
    Free
  • Jedox Basis - Schulung in Bern

    Jedox Basis - Schulung in Bern
    Jedox Basis - Schulung in Bern

    Thu, Feb 16, 09:00
    Business Center Welle 7 • Bern
    €1,131.08
  • XLCubed Basis - Schulung in Bern

    XLCubed Basis - Schulung in Bern
    XLCubed Basis - Schulung in Bern

    Tue, Mar 14, 09:00
    Business Center Welle 7 • Bern
    €2,260.99
  • Data Vault Basis - Schulung in Bern

    Data Vault Basis - Schulung in Bern
    Data Vault Basis - Schulung in Bern

    Tue, Apr 4, 09:00
    Business Center Welle 7 • Bern
    €1,131.08
  • XLCubed Professional - Schulung in Bern

    XLCubed Professional - Schulung in Bern
    XLCubed Professional - Schulung in Bern

    Tue, Apr 4, 09:00
    Business Center Welle 7 • Bern
    €2,260.99
  • Cubeware Importer - Schulung in Bern

    Cubeware Importer - Schulung in Bern
    Cubeware Importer - Schulung in Bern

    Tomorrow at 09:00
    Business Center Welle 7 • Bern
    €3,390.89
  • Cubeware Cockpit Basis - Schulung in Bern

    Cubeware Cockpit Basis - Schulung in Bern
    Cubeware Cockpit Basis - Schulung in Bern

    Mon, May 8, 09:00
    Business Center Welle 7 • Bern
    €2,260.99
  • Cubeware Cockpit Maps - Schulung in Bern

    Cubeware Cockpit Maps - Schulung in Bern
    Cubeware Cockpit Maps - Schulung in Bern

    Fri, Feb 10, 09:00
    Business Center Welle 7 • Bern
    €1,131.08

Site Navigation

Use Eventbrite

  • Create Events
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse Bern Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Centre
  • Terms
  • Privacy
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite