Skip Main Navigation
Eventbrite
Browse Events
Organise
Help
Log InSign Up
Menu
Page Content
This event has ended.
BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec

Dec

07

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec

by DecisionOne Consulting

Actions and Detail Panel

Sales Ended

Date and time

Tue, 7 Dec 2021, 09:00 –

Thu, 9 Dec 2021, 16:30 GMT

Location

Online event

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Learn BEAM✲, modelstorming and visual collaboration for Analytical Data Requirements Gathering and Dimensional Modeling

About this event

Join Lawrence Corr, author of the DW/BI bestseller "Agile Data Warehouse Design" live online for a three-day BEAM✲ masterclass and data modelstorming workskshop covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective analytical databases and datasets in person and at distance.

Discover how modelstorming (modeling + brainstorming) with business stakeholders overcomes the limitations of traditionally separate requirements analysis and data modeling to create a shared data language for business and IT.

Over three days of engaging virtual classroom 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.

The class will be live and interactive on Whereby (like Zoom but nicer). Every attendee will be able to practice BEAM modestorming techniques in teams with 2 or 3 other attendees using Whereby Breakout Rooms and Miro visual collaboration boards instead of physical whiteboards and Post-its. The class size will be limited to 16 attendees.

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec image

Who 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 to:

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

  • Rapidly translate BI data requirements into efficient, flexible analytical database designs

  • Identify and solve common BI problems using dimensional design patterns

  • Plan, design and develop BI solutions incrementally with agility

  • Use BEAM with cloud visual collaboration tools for distributed modelstorming

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec image

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

Data 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

  • Visual Collaboration platforms: modelstorming tools for distributed organisations and remote workers

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec image

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. Supporting Slowly Changing Dimensions.

  • 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

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec image

Material

Attendees receive a course eWorkbook, 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.

Prerequisites

Attendees will need free Whereby and miro.com accounts plus a webcam and microphone to follow and take part in the classroom discussions and team exercises. We also recommend attendees use two monitors and/or an additional large tablet if possible so they can view the virtual classroom and training material simultaneously and work on visual collaboration boards during the team exercises. A laptop and separate large tablet will work too.

Booking AND Payment

Register above to pay online via credit card.

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

Tags

  • Online Events
  • Online Classes
  • Online Business Classes
  • #agile
  • #beam
  • #modelstorming
  • #business_intelligence
  • #data_warehousing
  • #data_modeling
  • #dimensional_modeling
  • #star_schema
  • #data_mart_design
Event ended

BEAM Agile Data Warehouse Design with Lawrence Corr - Live Online 7-9 Dec


Follow this organiser to stay informed on future events

DecisionOne Consulting

Event creator

Events you might like

  • Learn Public Speaking @ Warehouse  Toastmasters Oakland

    Learn Public Speaking @ Warehouse Toastmasters Oakland
    Learn Public Speaking @ Warehouse Toastmasters Oakland

    Tue, Aug 23, 2022 7:00 AM PDT (-07:00)
    Free
  • Amazon warehouse jobs Military information session- Central Florida

    Amazon warehouse jobs Military information session- Central Florida
    Amazon warehouse jobs Military information session- Central Florida

    Thu, Aug 25, 2022 12:00 PM EDT (-04:00)
    Free
  • Amazon Workforce Staffing Virtual Info Session - NJ Warehouse Jobs

    Amazon Workforce Staffing Virtual Info Session - NJ Warehouse Jobs
    Amazon Workforce Staffing Virtual Info Session - NJ Warehouse Jobs

    Thu, Aug 25, 2022 12:00 PM EDT (-04:00)
    Free
  • New Orleans CBD & Warehouse District

    New Orleans CBD & Warehouse District
    New Orleans CBD & Warehouse District

    Fri, Aug 19, 2022 4:00 PM BST (+01:00)
    Free
  • Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Lean Six Sigma Green Belt Online Training in Lawrence, KS
    Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Fri, Aug 26, 2022 9:00 AM IST (+05:30)
    US$999
  • Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Lean Six Sigma Green Belt Online Training in Lawrence, KS
    Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Tue, Aug 23, 2022 9:00 AM IST (+05:30)
    US$999
  • Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Lean Six Sigma Green Belt Online Training in Lawrence, KS
    Lean Six Sigma Green Belt Online Training in Lawrence, KS

    Tue, Aug 23, 2022 9:00 AM IST (+05:30)
    US$999
  • Amazon is hiring! Virtual Info Session - MA/NH Warehouse Jobs - Thu @ 12:30

    Amazon is hiring! Virtual Info Session - MA/NH Warehouse Jobs - Thu @ 12:30
    Amazon is hiring! Virtual Info Session - MA/NH Warehouse Jobs - Thu @ 12:30

    Thu, Sep 1, 2022 12:30 PM EDT (-04:00)
    Free
  • Create automated  Power BI solution on Azure with a data warehouse approach

    Create automated Power BI solution on Azure with a data warehouse approach
    Create automated Power BI solution on Azure with a data warehouse approach

    Fri, Sep 9, 2022 9:30 AM CEST (+02:00)
    Free
  • CSM Certification Training in Lake Lawrence, KS

    CSM Certification Training in Lake Lawrence, KS
    CSM Certification Training in Lake Lawrence, KS

    Thu, Aug 25, 2022 9:00 AM PDT (-07:00)
    US$799

Site Navigation

Use Eventbrite

  • How it Works
  • Pricing
  • Event Blog
  • Event Planner Forum

Plan events

  • Online Registration
  • Sell Event Tickets
  • Event Management Software

Find events

  • Browse Online Events
  • Get the Eventbrite App

Connect with us

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

© 2022 Eventbrite