Data Warehousing and
Data Modeling

Data Engineering
Data Modeling
data warehousing

Build a solid foundation of data warehousing and modeling with this training. Learn the different modeling approaches like Kimball, Inmon and Data Vault, and how to work with data warehouse architectures, formal data modeling, performance tuning and more. You’ll put theory into practice with hands-on exercises in SQL, and create an entire data warehouse in a mainstream data warehouse of your choice. 

Looking to upskill your team(s) or organization?

Rozaliia will gladly help you further with custom training solutions.

Get in touch

What will you learn?

After the training, you will be able to:

Design a data warehouse that is tailored to business requirements.

Tackle common performance issues in modern data warehouses to ensure optimal functionality and efficiency.

Evaluate mainstream data modeling techniques to choose the best approach for effective data representation.

Discuss different modeling approaches such as Kimball and Inmon and explain the benefits and considerations of each.

Program

  • Fundamentals in data warehousing and dimensional modelling
  • History of data modeling and modern day approaches
  • Foundations of main cloud data warehouses
  • How to setup staging, mart and reporting layers
  • Apply optimization techniques to improve query performance

This training is for you if:

You want to understand all key concepts in data warehousing once and for all.

You care about performance and scalability of your data solutions.

You like to get your hands dirty to solve real-world problems faced by modern data warehouse practitioner.

This training is not for you if:

You have no experience in SQL at all (no worries, our SQL for Data Analysis course is enough to get you started).

You are a data consumer and focus more on delivery business values from data (Our Data Storytelling training is a better fit for you).

You only want to learn dbt (check out our dbt Learn training).

Why should I follow this training?

Take your SQL skills to the next level

Hands-on training with real life examples – learn today apply tomorrow!

Learn the most modern data modeling techniques

What else
should I know?

After registering for this training, you will receive a confirmation email with practical information. A week before the training, we will ask you about any dietary requirements and share literature if you need to prepare.

See you soon!

Course information

All literature and course materials are included in the price. 

After registering for this course, you will receive a confirmation email with practical information. 

Meet the trainers

Lucy Sheppard 

Meet Lucy Sheppard, trainer at Xebia Data. Lucy is a data science trainer and teaches many Python courses as well as dbt Learn.

Also interesting for you

View all training courses
SQL for Data Analysis

Unlock the power of data with SQL – the ultimate data management system!

SQL
View training
Data Storytelling

Create compelling visuals and engaging data stories that inform, entertain, and drive action.

Lysanne van Beek

Data Analytics
Data Visualization
2 days
In Person

Next:

11 – 12 Jul, 2024

From:

€1465

View training
dbt Learn

In partnership with dbt Labs, we offer you the dbt Learn training course. Upgrade your dbt (data build tool) skills now.

Lucy Sheppard 

Data Engineering
dbt
dbt labs
3 days
Virtual

Next:

2 Sep, 2024

From:

€1045

View training
Power BI in a Day

Learn how to turn your data sources into immersive visuals using Microsoft Power BI.

Lysanne van Beek

Data Analytics
Data Visualization
Microsoft
PowerBI
1 day
Virtual

Next:

1 Jul, 2024

From:

€645

View training
Python for Data Analysis

Learn how to code in Python and perform data analysis with our Python for Data Analysis training.

James Hayward

Data Science
Python
2 days
Virtual

Next:

24 – 25 Jun, 2024

From:

€1255

View training
Time Series Analysis & Forecasting

Learn how to extract insights, interpret seasonality and build forecasting models from time series data.

James Hayward

Data Science
4 days
In Person

Next:

27 Jun, 2024

From:

€1355

View training
Building LLM Applications

Delve into the world of Large Language Models (LLMs) and state-of-the-art generative AI.

James Hayward

Generative AI
4 days
Virtual

Next:

23 Jul, 2024

From:

€1570

View training
Docker and Kubernetes 

Learn in our Docker and Kubernetes training how Docker containers work — how to build, place and run them. Also understand how to deploy them in a Kubernetes cluster.

David Coba

CI/CD
Data and AI
Data Engineering
Docker
Kubernetes
Software Development
3 days
In Person

Next:

9 Sep, 2024

From:

€1895

View training
Apache Airflow Training 

Master Apache Airflow’s workflow magic. Seamlessly schedule, monitor, and optimize workflows. Elevate your automation game today

Data Engineering
2 days
Virtual

Next:

19 – 20 Sep, 2024

From:

€1310

View training
Create Amazing Products by Leveraging AI

Discover how to create loveable products by leveraging the power of Artificial Intelligence (AI) with this AI and product training.

Rutger de Wijs

Data and AI
Product Management
2 days
In Person

Next:

19 – 20 Sep, 2024

From:

€1355

View training
Production Ready Machine Learning

Follow our Production-Ready Python for Machine Learning training course to bring your machine learning models into production.

Enrico Erler

Data Engineering
Data Science
Machine Learning
Python
Software Development
Software Testing
3 days
In Person

Next:

25 Sep, 2024

From:

€1895

View training
Introduction to Deep Learning

Everyone talks AI, but what is it exactly? This three-day Deep Learning course will take you on a journey to demystify AI. You will learn the fundamentals of Deep Learning, how it works, how it differs from traditional Machine Learning, and how you can apply it to the most common AI applications.

James Hayward

Data Science
Machine Learning
3 days
Virtual

Next:

9 Oct, 2024

From:

€2095

View training
MLOps on GCP

Discover what MLOps is and how you can apply it in GCP (Google Cloud Platform) with our MLOps on GCP training course.

Yke Rusticus

Data Analytics
Data Engineering
Data Science
Google Cloud Platform (GCP)
3 days
In Person

Next:

11 Nov, 2024

From:

€1995

View training

Can’t find the course you’re looking for? There’s more!