BI & Data Warehousing Fundamentals

Two-day practical training with a clear overview of core BI and data warehousing concepts, design principles and strategic choices. Learn how modern data warehouse solutions are built.

2 days
Certificate on completion
business-intelligence data-architectuur data-modelling

The two-day BI & Data Warehousing Fundamentals training gives you a clear and applicable overview of the most important concepts, design principles and strategic choices within Business Intelligence and data warehousing. You learn how modern data warehouse solutions are built, how they connect to (Big) Data and cloud technologies, and how to shape a robust and future-proof BI architecture within your organisation.

What can you expect?

This training is strongly practice-oriented and covers the core of BI and DWH architecture in an accessible way. You work on realistic cases and learn how to align technical choices with organisational goals. We cover different architectural styles (such as Kimball, Inmon, Data Vault), cloud models, and the role of data integration, governance and analytics.

What will you learn?

After this training you can:

  • Name the most important concepts, components and layers of a data warehouse architecture;

  • Recognise and weigh different design approaches (Kimball, Inmon, Data Vault);

  • Explain the relationship between traditional data warehouses and new concepts such as Data Lakes and Lakehouses;

  • Make strategic choices in design and architecture form;

  • Guide BI projects with attention to preconditions such as data quality, metadata and governance;

  • Apply architectural principles to your own practice or organisational question.

Training setup

The training combines theory with concrete real-world examples and group assignments. You learn from experienced trainers with hands-on experience in both classical and modern BI landscapes.

Why take part?

A well-considered data warehouse architecture is essential for reliable insights, scalability and future-proofing. With this training you get the overview and depth you need to steer strategically on data.

Want to get a grip on BI architecture and run data-driven projects more successfully?

Sign up today and lay a solid foundation in Data Warehouse Architecture.

Day 1: Fundamentals of BI & Data Warehousing

  • Introduction to Business Intelligence: goals, applications and success factors

  • What is a Data Warehouse? Concepts, functions and positioning

  • Architecture variants: from classical to modern (including Big Data)

  • BI components: from ETL to dashboards

  • Organisation and governance: the Business Intelligence Competence Center (BICC)

  • Preconditions for a robust BI architecture

Day 2: Architecture in practice

  • Topologies of data warehouses: hub-and-spoke, data lakehouse, etc.

  • Data Management: data quality, metadata and master data

  • Modelling facts and dimensions: from registration to analysis

  • Information presentation: reports, dashboards and self-service BI

  • Trends and developments: cloud, real-time BI, AI in BI

  • Practical cases and interactive discussions

After completing this training, you receive a Professional Development certificate as proof of the knowledge and skills you have gained.

Audience

  • IT managers and project leaders
  • Data and information architects
  • Business and information analysts
  • Data engineers and BI consultants
  • Professionals looking for basic knowledge of data warehouse architecture

Prior knowledge

No technical prior knowledge required; affinity with data, BI or IT projects is helpful.

business-intelligence data-architectuur data-modelling
Voorjaar 2026
Culemborg Available
Tuesday 12 May 2026 09:00 – 17:00
Wednesday 13 May 2026 09:00 – 17:00
Register until 1 May 2026