Master Data Warehousing, Dimensional Modeling & ETL processDo 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 lecturesLearn from a real expert - crystal clear & straight-forwardMaster theory & practice - hands-on demonstrations, assignments & quizzesWe will implement a complete data warehouse - end-to-endUnderstand everything step by step from the absolute basics to the advanced topicsLearn the practical steps and the important theory to upskill your careerThis 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 BasicsData Warehouse architectureData Warehouse infrastructureData ModelingSetting up an ETL process Dimensional Modeling: Facts & DimensionsImplementing a comeplete data warehouse hands-onSlowly Changing DimensionsUnderstanding ETL toolsELT vs. ETLAdvanced topics like: Columnar storage, OLAP Cubes, In-memory databases, massive parallel processing & cloud data warehousesOptimizing a data warehouse using indexes (B-tree in
What you'll learn
Data Warehouse Basics
Data Warehouse architecture
Data Modeling
Setting up an ETL process
Implementing a complete data warehouse hands-on
Understanding ETL tools
Dimensional Modeling including facts and dimensions