top of page

Data Warehouse Training Modules

Register to any of our training modules! 

There's much to see here so, take your time, look around and take a moment to drop us a line &

we will get back to you for further scheduling, customization or preferred method.

Data Warehouse (DWH) Introduction

Mo - Sat 

8:00 AM - 16:00 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • DWH history 

  • DWH appliance & benefits 

  • DWH structure basics 

Data

Marts 

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Data mart introduction 

  • Data mart definition 

  • Difference between DWH and data marts 

  • Data mart benefits & advantages

  • Data mart mistakes & misconceptions

DWH

Metadata

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Metadata introduction 

  • Metadata definition 

  • Metadata benefits 

  • Metadata types

  • Standard projects on metadata 

  • Metadata setup & best practices

Entity Relational

Data Model 

Mo - Sat 

8:00 AM - 16:30 PM

8 hrs ​/Virtual or Classroom

70 Eur/ Participant

​

  • Data modeling definition & usage 

  • Data modeling techniques

  • ER data model 

  • ER entity definition

  • Entity types

  • Attribute definition 

  • Attribute types

  • Entity sets & keys 

  • Identifier

  • Relationships (links)

  • Data model notation

  • Logical data model (LDM)

  • Transition from LDM to physical data model (PDM)

  • Differences between CDM, LDM, PDM 

  • ER data model disadvantages

Dimensional

Model 

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Dimension definition 

  • Dimensional model definition 

  • Dimensional modeling benefits 

  • Fact definition 

  • Primary key definition & uses (PK)

  • Foreign key definition & uses (FK)

  • Surrogate & business key definition & uses

The Star

Schema 

Mo - Sat 

8:00 AM - 16:00 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Star schema vs. Snowflake schema 

  • Dimension (conformed, junk & degenerate)

  • Changing dimensions (type 1, 2 & 3)

  • Case study & setup of dimensional model

  • ER model vs. dimensional model 

DWH

Indexes

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • DWH index definition 

  • Bitmap index 

  • B-tree index

  • Bitmap index vs. B-tree index

ETL vs. ELT

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • ETL introduction 

  • ETL definition 

  • Data integration definition 

  • ETL usage & benefits 

  • ELT introduction 

  • ELT definition 

  • ETL vs. ELT 

  • Extraction methods 

Typical Roles in

DWH projects 

Mo - Sat 

8:00 AM - 16:30 PM

8 hrs ​/Virtual or Classroom

70 Eur/ Participant

​

  • Project Sponsor

  • Functional Account Manager (FAM)

  • Project Manager

  • Release Manager

  • Business Analyst 

  • Subject Matter Expert (SME)

  • DWH BI Architect 

  • Data Modeler/ Designer

ETL Phase

Mo - Sat 

8:00 AM - 16:30 PM

4 hrs ​/Virtual or Classroom

50 Eur/ Participant

​

  • Data access phase & types

  • Data selection 

  • Data drilling down 

  • Data exceptional reporting 

  • Data calculations 

  • Data graphics & visualization 

  • Data entry options 

  • Data customizations 

  • Data web-based reporting 

  • Data broadcasting

bottom of page