Data Warehousing and
Data Modeling
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.
Rozaliia Khafizova
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.
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 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.
Learn how to turn your data sources into immersive visuals using Microsoft Power BI.
Learn how to code in Python and perform data analysis with our Python for Data Analysis training.
Follow our Production-Ready Python for Machine Learning training course to bring your machine learning models into production.
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.
Learn exactly how Docker containers work — how to build them, how to place your applications in them and how to run them.
Discover how to create loveable products by leveraging the power of Artificial Intelligence (AI) with this AI and product training.
Master Apache Airflow’s workflow magic. Seamlessly schedule, monitor, and optimize workflows. Elevate your automation game today
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.
Discover what MLOps is and how you can apply it in GCP (Google Cloud Platform) with our MLOps on GCP training course.
