Data Warehouse – The Ultimate Guide
Master Data Warehousing, Dimensional Modeling & ETL process
What you’ll learn
-
Architect & implement a professional data warehouse end-to-end
-
You will learn the principles of Data Warehouse Design
-
You will master ETL process in both theory & practise
-
You will implement in a case study your own data warehouse & ETL process
-
You will learn the modern architecture of a Data Warehouse
-
Dimensional Modeling in a professional way
Requirements
-
Basic SQL is helpful but absolutely not necessary
-
Laptop or PC
Description
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
By the end of this course you will be able to design & build a complete data warehouse from the ground up. You will have the knowledge, the practical skills and the confidence to implement a modern data warehouse professionally.
Everything you need to be a highly proficient data architect, data engineer, data analyst or Business Intelligence expert!
Join now to get instant & lifetime access – of course backed by the no-questions-asked 30 days money back guarantee!
Who this course is for:
- Data Analyst that want to upskill and learn how to build a data warehouse
- Data Engineers that want to learn about data warehousing and data modeling
- People that want to become a data architect, BI consultant, data engineer or data analyst
- Data professionals that want to upskill in Business Intelligence & Data Modeling
Created by Nikolai Schuler
Last updated 6/2023
English
English [Auto]
Size: 3.36 GB
Google Drive Links
Download Part 1 | Download Part 2
Torrent Links
https://www.udemy.com/course/data-warehouse-the-ultimate-guide/.