Lisbon BI Course

 

The Lisbon BI Course is the first training in Portugal in Agile Data Warehouse Design and ETL with renowned experts in the field, Lawrence Corr and Joe Caserta.
Caserta Concepts, LLC will provide a four-day course, consisting of two days of Agile DW Design, followed by two days of ETL – advanced techniques.
Lawrence and Joe usually teach these courses all over the world, including in TDWI events. This constitutes a unique opportunity to learn and exchange ideas in a friendly but intense environment.
The Lisbon BI Course will take place at ISCTE – University Institute of Lisbon (ISCTE-IUL), located in the centre of Lisbon, in the University City Campus. This is a joint effort promoted by ISCTE-IUL, particularly its Master in Integrated Systems for Decision Support, Novabase, SAS Institute Portugal, and Passio.

 

About the Instructors:

Lawrence Corr is the author of Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema. He is a leading data warehouse design specialist and highly experienced educator who has worked in Europe, USA, the Middle East and South Africa developing and reviewing data warehouses for healthcare, telecommunications, engineering, broadcasting, financial services and retail clients.

 

Joe Caserta is the author of the best-selling book The Data Warehouse ETL Toolkit, the de facto standard for building dimensional data warehouses. Joe offers more than 25 years of IT experience and over 15 years of delivering dimensional data warehouse solutions including experience in Higher Education. Joe delivers his published best practices in a way that encourages participants to immediately apply his techniques in real-life situations.

 

Course Agenda:

The training sessions start at 9h and will end at 18h.


The topics covered in the course are:

Days 1 & 2: Agile BI/DW Analysis and Design
(Instructor: Lawrence Corr)

Agile BI Analysis

·       BI/DW design requirements, challenges and opportunities: the case for agility

·       Modeling for measurement: the case for dimensional modeling

·       Modelstorming: the case for agile modeling directly with BI stakeholders

·       BEAM* (Business Event Analysis and Modeling): agile dimensional modeling techniques

·       Using the 7Ws (who, what, when, where, how many, why and how) to discover and document dimensional BI requirements

·       BEAM* Tables, Data stories and Data Themes: modeling by example

·       Timelines: modeling events sequences and end-to-end business processes

·       Hierarchy Charts: discovering valuable dimensional attributes

·       Change Stories: capturing history requirements and slowly changing dimensions rules

·       Event Matrix and Business Model Canvas: storyboarding the data warehouse design. Planning and estimating incremental BI development. Providing lean BI requirements documentation.

Agile Star Schema Design

·       Test-driven design: data profiling to validate requirements models

·       Data warehouse reuse: conformed dimensions (and facts), multi-role dimensions

·       Designing high performance star schemas using surrogate keys

·       BI Model Canvas and BEAM* Short Codes: producing enhanced star schemas

·       Refactoring star schemas: responding to change

·       Recognizing and applying dimensional design patterns

·       Handling large populations with rapidly changing dimensional attributes

·       Customer relationships and organisation structures: resolving recursive relationships and reporting on variable-depth hierarchies

·       Current and historical reporting perspectives: hybrid slowly changing dimensions

·       Mixed business models: business to business (B2B), business to consumer (B2C). Heterogeneous products/services: diverse dimensional attributes and ragged hierarchies

·       Decomposing products and services: components, bill of materials, product bundling analysis

·       Flexible date handling and year-to-date analysis

·       Understanding journeys and trajectories: modeling events with multiple geographies

·       Multinational BI: national language reporting, multiple currencies, time zones and local calendars

·       Multi-valued dimensions: bridge tables, weighting factors, impact /'correctly weighted' analysis

·       Modeling sequential behavior, causation and effect

 

Days 3 & 4: ETL
(Instructor: Joe Caserta)

High Level ETL Design

·       Planning and designing your ETL system

·       Choosing the appropriate architecture

·       Managing the implementation

·       Managing the day to day operations

·       Building the development/test/production suite of ETL processes

·       Building a data cleaning subsystem

·       Understanding the tradeoffs of various staging data structures, including flat files, normalized schemas, XML, and dimensional schemas

·       Analyzing and extracting source data

·       Creating the logical data mapping

Advanced ETL Techniques

·       Structuring the data into dimensional schemas for the most effective delivery to end users

·       Conforming heterogeneous data from multiple sources into standardized dimension tables and fact tables

·       Building ETL modules for handling the three distinct types of slowly changing dimensions (SCDs)

·       Building ETL modules for multi-valued dimensions and hierarchical dimensions

·       Running high-performance surrogate key pipelines

·       Loading the three fundamental fact table grains – transaction, periodic snapshot and accumulating snapshot

·       Handling late arriving dimensions and facts

·       Optimizing ETL processes to fit into highly constrained load windows

·       Structuring and presenting metadata

·       Converting batch and file-oriented processes into continuously streaming real-time ETL systems

 

Registration:

Fee:
1590€ + IVA (Agile BI and ETL Training - four days of training)


or

940€ + IVA (Agile BI - two days of training)


750€ + IVA (ETL Training - two days of training)



These values include course materials, a copy of the books by Lawrence Corr and Joe Caserta, lunches, coffee-breaks, and a social event scheduled for April 9th.

 

Location

Auditório Afonso de Barros


ISCTE - Instituto Universitário de Lisboa



Av. das Forças Armadas
Edifício ALA AUTÓNOMA
Piso 1


1649-026 Lisboa

 

Contacts/Info:

Any questions please feel free to contact us.
Elsa Cardoso 
elsa.cardoso@iscte.pt

 

Promoted by:

 

 


Last update: 20-03-2013