Master Data Warehousing, Dimensional Modeling & ETL process

Do you want to learn how to implement a data warehouse in a modern way?

This is the only course you need to master architecting and implementing a data warehouse end-to-end!

Data Modeling and data warehousing is one of the most important skills in Business Intelligence & Data Engineering!

This is the most comprehensive & most modern course you can find on data warehousing.

Here is why:

• Most comprehenisve course with 9 hours video lectures
• Learn from a real expert – crystal clear & straight-forward
• Master theory & practice – hands-on demonstrations, assignments & quizzes
• We will implement a complete data warehouse – end-to-end
• Understand everything step by step from the absolute basics to the advanced topics
• Learn the practical steps and the important theory to upskill your career

This course will take you all the way to being able to architect and implement a data warehouse in a company in a professional manner.

Here is what you’ll learn:

• Data Warehouse Basics
• Data Warehouse architecture
• Data Warehouse infrastructure
• Data Modeling
• Setting up an ETL process
• Dimensional Modeling: Facts & Dimensions
• Implementing a comeplete data warehouse hands-on
• Slowly Changing Dimensions
• Understanding ETL tools
• ELT vs. ETL
• Advanced topics like: Columnar storage, OLAP Cubes, In-memory databases, massive parallel processing & cloud data warehouses
• Optimizing a data warehouse using indexes (B-tree indexes & Bitmap indexes)
• Practically using and connecting a data warehouse