Data Warehouse - The Ultimate Guide

Focused View

Nikolai Schuler

8:48:48

10 View

01 - Intro

001 Welcome!.mp4

02:28

002 How this course works.mp4

04:26

003 What do you learn in this course.mp4

02:57

02 - Data Warehouse Basics

001 Why a data warehouse.mp4

04:42

002 What is a data warehouse.mp4

04:19

003 What is Business Intelligence.mp4

02:47

004 Data Lake or Data Warehouse.mp4

06:23

005 Demos & Hands-on.mp4

02:40

006 Setting up Pentaho (ETL tool).mp4

03:57

007 Setting up PostgreSQL (Database system).mp4

06:35

03 - Data Warehouse Architecture

001 3 Layers of a Data Warehouse.mp4

06:27

002 Staging area.mp4

07:22

003 Demo Setting up the staging area.mp4

03:39

004 Data Marts.mp4

06:27

005 Relational databases.mp4

06:23

006 In-Memory databases.mp4

06:48

007 Cubes.mp4

07:47

008 Operational Data Storage.mp4

07:29

009 Summary.mp4

04:29

04 - Dimensional Modeling

001 What is dimensional modeling.mp4

03:26

002 Why dimensional modeling.mp4

04:34

003 Facts.mp4

05:03

004 Dimensions.mp4

04:26

005 Star schema.mp4

07:39

006 Snowflake schema.mp4

05:11

007 Demo Product & Category dimension (snowflaked).mp4

10:18

05 - Facts

001 Additivity.mp4

08:28

002 Nulls in facts.mp4

04:01

003 03-Year-to-Date-facts.mp4

03:19

003 Year-to-Date facts.mp4

03:19

004 Types of fact tables.mp4

00:32

005 Transactional fact tables.mp4

03:32

006 Periodic fact tables.mp4

03:51

007 Accumulating snapshots.mp4

03:34

008 Comparing fact table types.mp4

03:35

009 Factless fact tables.mp4

04:05

010 Steps in designing fact tables.mp4

04:40

011 Surrogate Keys.mp4

06:02

012 Case Study The Project.mp4

04:37

013 Case Study Identify the business process.mp4

02:05

014 Case Study Define the grain.mp4

02:59

015 Case Study Identify the dimensions.mp4

03:29

016 Case Study Identify the facts.mp4

05:25

06 - Dimensions

001 Dimension tables.mp4

06:24

002 Date dimensions.mp4

07:24

003 Nulls in dimensions.mp4

04:42

004 Hierarchies in dimensions.mp4

04:47

005 Conformed dimensions.mp4

03:40

006 Degenerate dimensions.mp4

03:40

007 Junk dimension.mp4

08:07

008 Role-playing dimension.mp4

05:57

009 Case Study Date dimension.mp4

05:37

07 - Slowly Changing Dimensions

001 What are slowly changing dimensions.mp4

03:14

002 Type 0 - Original.mp4

01:58

003 Type 1 - Overwrite.mp4

03:43

004 Type 2 - Additional row.mp4

05:27

005 Administrating Type 2 dimensions.mp4

05:55

006 Mixing Type 1 & Type 2.mp4

02:31

007 Type 3 - Additional attribute.mp4

06:00

08 - ETL process

001 Understanding the ETL process.mp4

06:37

002 Extract.mp4

03:02

003 Initial Load.mp4

03:16

004 Delta Load.mp4

06:59

005 Load Workflow.mp4

04:15

006 Demo Quick Intro to Pentaho.mp4

09:32

007 Demo Setting up tables in SQL.mp4

04:58

008 Demo Initial Load example.mp4

10:05

009 Demo Delta Load example.mp4

13:38

010 Transforming data.mp4

04:37

011 Basic Transformations.mp4

06:05

012 Advanced Transformations.mp4

07:24

013 Demo Planning next steps.mp4

05:18

014 Demo Table setup & Complete Staging.mp4

09:11

015 Demo Transform.mp4

07:07

015 SQL-Transform.txt

016 Demo Load & Validate results.mp4

05:45

017 Scheduling jobs.mp4

05:51

09 - ETL tools

001 ETL tools.mp4

04:42

002 Choosing the right ETL tool.mp4

06:03

10 - Case Study Creating a Data Warehouse

001 Plan of attack.mp4

02:23

002 Create-public-sales.txt

002 Fact-Sales-1.csv

002 Source data & table design.mp4

08:55

003 Setting up the tables in database.mp4

02:59

004 Staging Sales Fact.mp4

07:47

005 Staging job & fixing problems.mp4

06:34

006 Load Payment Dimension.mp4

05:34

007 Transform & Load Sales Fact.mp4

09:26

007 Transform-Fact-sales.txt

008 Transform & Load job.mp4

03:10

009 Fact-Sales-2.csv

009 Final ETL job & Incremental Load.mp4

06:17

11 - ETL vs. ELT

001 What is an ELT.mp4

05:15

002 ETL vs. ETL.mp4

04:54

12 - Using a Data Warehouse

001 What are the common use cases.mp4

04:05

002 Connecting the DWH to Power BI.mp4

10:22

13 - Optimizing a Data Warehouse

001 Using indexes.mp4

05:01

002 B-tree indexes.mp4

02:42

003 Bitmap indexes.mp4

03:31

004 Guidelines for indexes.mp4

07:41

005 Demo Setting indexes.mp4

03:56

14 - The Modern Data Warehouses

001 Cloud vs. on-premise.mp4

02:47

002 Benefits cloud vs on-premise.mp4

05:50

003 Massive parallel processing.mp4

05:34

004 Columnar storage.mp4

04:19

15 - Bonus

001 Bonus lecture.html

Description

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

Who is this 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

What You Need to Know?

Basic SQL is helpful but absolutely not necessary

Laptop or PC

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Data Warehouse

Nikolai Schuler

Instructor's Courses

Are you thinking about pursuing a career as a Data Analyst or Data Scientist?Do you ever think that your career could take a leap forward if you would have more knowledge and skills in the world of data? Perhaps you are even feeling overwhelmed by the number of courses available or by the fact that your life is already too full to concentrate on one more course?I am Nikolai Schuler, I am a data scientist and BI consultant, and I have been there too... A few years ago I noticed that the world of data benefits from many new tools and technologies. However, I also realized that it is extremely difficult to get trained in the field: Practical courses with real quality content are rare and are often structured in such a way that they are incompatible with a working life full of other tasks and activities. While going through hours of research and training, I came up with the idea of creating a course that would offer extremely valuable content but that would be at the same time easy to follow due to its structure. My goal is to help as many people as possible to pursue their desired career in this new Digital Age by enabling them to upgrade their data analysis skills. I am proud to say that I am heading in the right direction as my courses have already found their audience in over 170 countries and received thousands of positive feedbacks.I am super excited about equipping you with the skillset to master Data Science and Data Analytics! If you are looking for quality AND approachable training, then jump onboard! I am really looking forward to leveling up your IT skills.-- German version --In meiner Arbeit als Data Scientist sehe ich, dass in der heutigen Zeit neue Tools riesige Vorteile bringen und sie nicht mehr wegzudenken sind. Allerdings sehe ich auch, dass es nicht immer leicht ist, sich neben der täglichen Arbeit in diese neuen Tools einzuarbeiten.Mir selbst ist es auch schwer gefallen Kurse zu finden, die einerseits qualitativ hochwertig und andererseits verständlich und gut strukturiert sind.Aus diesem Grund habe ich mich dazu entschlossen, selbst strukturierte und praxisorientierte Kurse zu erstellen.Da ich sowohl für einfache Anwender als auch für Datenspezialisten Einweisungen in Power BI und anderen Tools gebe, bin ich einerseits technischer Spezialist, habe aber andererseits auch ein gutes Gefühl für die, die nicht die reinen Datenspezialisten sind.Mir zu überlegen, wie man das Wissen wirklich sinnvoll und verständlich vermitteln kann, ist das, was mir dabei Freude macht.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.