$525 – $1,395

Agile Data Warehousing, ETL, and Big Data Workshops

Event Information

Share this event

Date and Time

Location

Location

American Management Association

1601 Broadway

Room 808

New York, NY 10019

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

CasertaLogo

Join us this fall for a three-day intensive course on all the latest developments and best practices in Agile Data Warehousing, Dimensional Modeling, and ETL. The class will be broken down into three daylong lessons. Attendees may purchase one-day passes for the lesson(s) of their choice, or a full-access pass to attend the workshop in its entirety. Taught by Joe Caserta, author of The Data Warehouse ETL Toolkit, the class will be held in midtown Manhattan.

Lunch will be provided.

What you’ll learn:

Day 1: Agile Data Warehouse Design & Dimensional Modeling

  • BEAM (Business Event Analysis & Modeling)
    • A systematic approach to BI & star schema design
    • Agile approach: Data Stories, themes, and collaborative modeling
    • Modeling BI data requirements by example
  • Modelstorming (collaborative data modeling + brainstorming)
    • Storyboarding the data warehouse design
    • The Business Model Canvas
    • Rapidly translate BI requirements into efficient, flexible data warehouse designs
  • Database schemas (working design patterns for DW/BI)
    • Defining and developing conformed dimensions and facts
    • Designing flexible, high performance star schemas
    • Current and historical reporting perspectives

Lunch demonstration by:


Day 2: ETL Architecture & Design

  • Planning, Managing and Designing ETL
    • Techniques for analyzing source systems/data profiling
    • Gathering requirements/creating the logical data mapping
    • Standardizing data coming from multiple sources
    • Designing the Architecture for effective ETL processing
    • Managing development and the day-to- day ETL program
  • Implementation and Operations
    • Loading the three fundamental fact table grains – transaction, periodic snapshot and accumulating snapshot
    • Building ETL modules for handling the three distinct types of slowly changing dimensions (SCDs)
    • Loading Hierarchies, Bridge Tables and Junk Dimensions
    • Handling late arriving dimensions and facts

Lunch demonstration by:


Day 3: Big Data For Data Warehousing Practictioners

  • Advanced ETL Techniques
    • Real-Time and Optimizing ETL for highly constrained load windows
    • Building a Data Quality sub-system
    • Handling Big Data/Unstructured Data
    • ETL on Big Data

Lunch demonstration by:


Share with friends

Date and Time

Location

American Management Association

1601 Broadway

Room 808

New York, NY 10019

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved