Model-based Business Intelligence (BI) and Data Warehouse (DWH) Modeling

Course description

There is no one method or technology used in BI/DWH. It is a concept for preparing and allocating (BI) company-relevant data (DWH), transformed from various sources and historicized in corporate data systems; this data system is then used to extract and prepare data depending on the relevant application or department.

This seminar will teach you which various aspects to consider when mapping a model-based and manufacturer-independent Business Intelligence and Data Warehouse and the advantages of using a model-technical mapping. You will learn the necessary basic elements for BPMN 2 and the various ERM (Entity Relationship Modeling) notations and learn how to use them for model-based depiction of your BI.

At the end of the course you will be able to recognize various aspects of a BI and be able to differentiate between BI modeling elements and apply them correctly.

Course contents/Methodology/Target group

  • BI aspects
  • BI layered architecture
  • Define and display data modeling and process modeling
  • Data modeling notations
  • Types of data modeling (3NF vs. DataVault)
  • BI – Create glossary
  • Introduction into process modeling
  • Modeling ETLs with BPMN elements
  • Discussing
    • Measures
    • Hierarchies
    • Dimensions
    • Cubes

Target group:
BI modelers, analysts, technical users, system architects and software architects


Basic knowledge of data modeling; basic knowledge of software development and BI/DWH would be advantageous.

Advanced courses

BI / Data Vault 2 Modeling in Innovator for Information Architects

In dieser Schulung lernen Sie gleichermaßen als Einsteiger bzw. auch als Personen mit Vorerfahrungen das „why/what/how” der Data Vault 2.0- Modellierung eines BI/DWH-Projekts.

BI- and DWH-Modeling in Innovator for Information Architects

Do you already have experience with BI/DWH architectures and want to use this knowledge in models using standardized notations irrelevant of the manufacturer? Then you need a suitable modeling tool for this. The Innovator for Information Architects is a tried and tested tool that can be used for displaying BI and DWH architectures in models.


Group discounts

  1. Participant 1
    € 660.00
  2. Participant 2
    € 660.00  - 10% = € 594.00
  3. Participant 3
    € 660.00  - 20% = € 528.00
  4. Participant 4
    € 660.00  - 20% = € 528.00

For groups bigger than five persons please request an individual offer

At the moment there are no events scheduled for this course. You can contact us if you are interested.

Price (per person)

Regular € 660.00

€ 785.40 incl. tax

Companies Like Yours Trust in Our Expertise

Need More Information?

Please do not hesitate to contact us with any questions about (in-house) training or individual packages you may have.



Dr. Katja Eisentraut

Head of Academy