Data Warehousing and
Data Modeling
Build a solid foundation of data warehousing and modeling with this training. You’ll learn everything about 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?
Diego will gladly help you further with custom training solutions.
Diego Teunissen
Data and AI Training Advisor
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.
Program
- Learn fundamentals in data warehousing and dimensional modelling
- Deep dive on dimensional modelling
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 does it look like?
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 coursesCreate compelling visuals and engaging data stories that inform, entertain, and drive action.
In partnership with dbt Labs, we offer you the dbt Learn training course. Upgrade your dbt (data build tool) skills now.
Share quality data insights with Microsoft Power BI
Learn how to code in Python and perform data analysis with our Python for Data Analysis training.
Discover how to create loveable products by leveraging the power of Artificial Intelligence (AI) with this AI and product training.
Follow our Production-Ready Python for Machine Learning training course to bring your machine learning models into production.
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.
Learn how to extract insights, interpret seasonality and build forecasting models from time series data.
Delve into the world of Large Language Models (LLMs) and state-of-the-art generative AI.
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.
