Training Dates - please open the booking form by clicking the listed date.

training duration icon Business Intelligence - OLAP and Data Warehousing

Duration: 2 Days
Delivery Type: Classroom
Target Audience: Business Intelligence Developer
Course Number: 2020335
Method: Lecture and discussion
  • Topics
  • Summary
  • Trainer
  • Download
  • Conditions

Tab 1


A. Business Intelligence, OLAP, and Data Warehousing

[Duration: 0.25 Days] Goals of a Data Warehouse - Components of a Data Warehouse: Operational Source Systems, Data Staging Area, Data Presentation, Data Access Tools - Dimensional Modeling: Fact Tables, Dimension Tables

B. The Data Warehouse and Design

[Duration: 0.5 Days] Operational Data - The Data Warehouse and Data Models: The Data Warehouse Data Model, The Midlevel Data Model, The Physical Data Model - Normalization and Denormalization - Metadata - Technical and Physical Architecture - Deploying and Supporting the DW/BI System

C. The Relational and the Multidimensional Models

[Duration: 0.25 Days] The Relational Model - The Multidimensional Model - Snowflake Structures - Differences between the Models - Independent Data Marts - OLAP and Aggregations - OLAP Operations

D. ETL - Loading the Data Warehouse

[Duration: 0.25 Days] ETL (Extract, Transformation, and Load) - Designing the Staging Area - Data Structures in the ETL System - Data Flow: Extracting, Cleaning and Conforming - Loading Fact Tables - Integrating OLAP Processing into the ETL System - Development Options of ETL - Data Latency - Data Quality

E. Dimension Tables

[Duration: 0.25 Days] The Basic Structure of a Dimension - The Grain of a Dimension - Flat Dimensions and Snowflaked Dimensions - Date and Time Dimensions - Big and Small Dimensions - Dimensional Roles - Degenerate Dimensions - Slowly Changing Dimensions - Ragged Hierarchies and Bridge Tables

F. OLAP and Data Mining

[Duration: 0.5 Days] Business Intelligence Applications: Direct Access Query and Reporting Tools, Standard Reports, Analytic Applications, Dashboards and Scorecards - Data Mining: Data Mining Overview, Data Mining in the Applications Architecture

Tab 3

Tab 4

Tab 5

Tab 6

For trainings with hands-on labs you are kindly requested to bring your own laptop with the required software. Alternatively, you can use our virtual machines (VMWare) for the MS Windows OS.
These course dates don´t fit in your calendar?
We also offer individual appointments or on-site trainings for your team and charge a per-day fee depending on the size of the group.
In order to enroll for a training or for general inquiries regarding our training and consulting services please use the contact form, send us an email or phone. Kontaktformular oder die folgenden Möglichkeiten:
  • Phone : +1.305.395.7962
  • Fax : +1.305.395.7964