|
|
001 3 Layers of a Data Warehouse.mp4
|
MP4
|
42.4 MB
|
|
|
001 3 Layers of a Data Warehouse_en.vtt
|
VTT
|
6.6 KB
|
|
|
001 Additivity.mp4
|
MP4
|
62.5 MB
|
|
|
001 Additivity_en.vtt
|
VTT
|
8.6 KB
|
|
|
001 Bonus lecture.html
|
HTML
|
2.7 KB
|
|
|
001 Cloud vs. on-premise.mp4
|
MP4
|
16 MB
|
|
|
001 Cloud vs. on-premise_en.vtt
|
VTT
|
3 KB
|
|
|
001 Dimension tables.mp4
|
MP4
|
48.9 MB
|
|
|
001 Dimension tables_en.vtt
|
VTT
|
6.7 KB
|
|
|
001 ETL tools.mp4
|
MP4
|
25.5 MB
|
|
|
001 ETL tools_en.vtt
|
VTT
|
5.2 KB
|
|
|
001 Plan of attack.mp4
|
MP4
|
12.1 MB
|
|
|
001 Plan of attack_en.vtt
|
VTT
|
2.6 KB
|
|
|
001 Understanding the ETL process.mp4
|
MP4
|
40.7 MB
|
|
|
001 Understanding the ETL process_en.vtt
|
VTT
|
7.2 KB
|
|
|
001 Using indexes.mp4
|
MP4
|
28.5 MB
|
|
|
001 Using indexes_en.vtt
|
VTT
|
5.2 KB
|
|
|
001 Welcome!.mp4
|
MP4
|
39.3 MB
|
|
|
001 Welcome!_en.vtt
|
VTT
|
2.9 KB
|
|
|
001 What are slowly changing dimensions.mp4
|
MP4
|
17.8 MB
|
|
|
001 What are slowly changing dimensions_en.vtt
|
VTT
|
3.4 KB
|
|
|
001 What are the common use cases.mp4
|
MP4
|
23.3 MB
|
|
|
001 What are the common use cases_en.vtt
|
VTT
|
4.2 KB
|
|
|
001 What is an ELT.mp4
|
MP4
|
36.4 MB
|
|
|
001 What is an ELT_en.vtt
|
VTT
|
5 KB
|
|
|
001 What is dimensional modeling.mp4
|
MP4
|
19 MB
|
|
|
001 What is dimensional modeling_en.vtt
|
VTT
|
3.4 KB
|
|
|
001 Why a data warehouse.mp4
|
MP4
|
29.7 MB
|
|
|
001 Why a data warehouse_en.vtt
|
VTT
|
4.6 KB
|
|
|
002 B-tree indexes.mp4
|
MP4
|
16.4 MB
|
|
|
002 B-tree indexes_en.vtt
|
VTT
|
2.7 KB
|
|
|
002 Benefits cloud vs on-premise.mp4
|
MP4
|
35.5 MB
|
|
|
002 Benefits cloud vs on-premise_en.vtt
|
VTT
|
6.3 KB
|
|
|
002 Choosing the right ETL tool.mp4
|
MP4
|
30.1 MB
|
|
|
002 Choosing the right ETL tool_en.vtt
|
VTT
|
6.7 KB
|
|
|
002 Connecting the DWH to Power BI.mp4
|
MP4
|
62.6 MB
|
|
|
002 Connecting the DWH to Power BI_en.vtt
|
VTT
|
10.7 KB
|
|
|
002 Create-public-sales.txt
|
TXT
|
409.6 B
|
|
|
002 Date dimensions.mp4
|
MP4
|
49.4 MB
|
|
|
002 Date dimensions_en.vtt
|
VTT
|
7.6 KB
|
|
|
002 ETL vs. ETL.mp4
|
MP4
|
27.1 MB
|
|
|
002 ETL vs. ETL_en.vtt
|
VTT
|
4.8 KB
|
|
|
002 Extract.mp4
|
MP4
|
16.3 MB
|
|
|
002 Extract_en.vtt
|
VTT
|
3.2 KB
|
|
|
002 Fact-Sales-1.csv
|
CSV
|
305 KB
|
|
|
002 How this course works.mp4
|
MP4
|
30.4 MB
|
|
|
002 How this course works_en.vtt
|
VTT
|
5.3 KB
|
|
|
002 Nulls in facts.mp4
|
MP4
|
25.4 MB
|
|
|
002 Nulls in facts_en.vtt
|
VTT
|
4.1 KB
|
|
|
002 Source data & table design.mp4
|
MP4
|
74.3 MB
|
|
|
002 Source data & table design_en.vtt
|
VTT
|
10 KB
|
|
|
002 Staging area.mp4
|
MP4
|
49 MB
|
|
|
002 Staging area_en.vtt
|
VTT
|
7.9 KB
|
|
|
002 Type 0 - Original.mp4
|
MP4
|
10 MB
|
|
|
002 Type 0 - Original_en.vtt
|
VTT
|
2.2 KB
|
|
|
002 What is a data warehouse.mp4
|
MP4
|
25.8 MB
|
|
|
002 What is a data warehouse_en.vtt
|
VTT
|
4.3 KB
|
|
|
002 Why dimensional modeling.mp4
|
MP4
|
28.8 MB
|
|
|
002 Why dimensional modeling_en.vtt
|
VTT
|
4.7 KB
|
|
|
003 03-Year-to-Date-facts.mp4
|
MP4
|
8.6 MB
|
|
|
003 Bitmap indexes.mp4
|
MP4
|
22.5 MB
|
|
|
003 Bitmap indexes_en.vtt
|
VTT
|
3.7 KB
|
|
|
003 Demo Setting up the staging area.mp4
|
MP4
|
21.7 MB
|
|
|
003 Demo Setting up the staging area_en.vtt
|
VTT
|
3.9 KB
|
|
|
003 Facts.mp4
|
MP4
|
27.7 MB
|
|
|
003 Facts_en.vtt
|
VTT
|
4.9 KB
|
|
|
003 Initial Load.mp4
|
MP4
|
17.6 MB
|
|
|
003 Initial Load_en.vtt
|
VTT
|
3.6 KB
|
|
|
003 Massive parallel processing.mp4
|
MP4
|
37.4 MB
|
|
|
003 Massive parallel processing_en.vtt
|
VTT
|
5.6 KB
|
|
|
003 Nulls in dimensions.mp4
|
MP4
|
38.1 MB
|
|
|
003 Nulls in dimensions_en.vtt
|
VTT
|
4.8 KB
|
|
|
003 Setting up the tables in database.mp4
|
MP4
|
19.5 MB
|
|
|
003 Setting up the tables in database_en.vtt
|
VTT
|
3.3 KB
|
|
|
003 Type 1 - Overwrite.mp4
|
MP4
|
27.3 MB
|
|
|
003 Type 1 - Overwrite_en.vtt
|
VTT
|
3.9 KB
|
|
|
003 What do you learn in this course.mp4
|
MP4
|
21.1 MB
|
|
|
003 What do you learn in this course_en.vtt
|
VTT
|
3.4 KB
|
|
|
003 What is Business Intelligence.mp4
|
MP4
|
18 MB
|
|
|
003 What is Business Intelligence_en.vtt
|
VTT
|
2.6 KB
|
|
|
003 Year-to-Date facts.mp4
|
MP4
|
19 MB
|
|
|
003 Year-to-Date facts_en.vtt
|
VTT
|
3.7 KB
|
|
|
004 Columnar storage.mp4
|
MP4
|
29.5 MB
|
|
|
004 Columnar storage_en.vtt
|
VTT
|
4.4 KB
|
|
|
004 Data Lake or Data Warehouse.mp4
|
MP4
|
34.3 MB
|
|
|
004 Data Lake or Data Warehouse_en.vtt
|
VTT
|
6.5 KB
|
|
|
004 Data Marts.mp4
|
MP4
|
40.1 MB
|
|
|
004 Data Marts_en.vtt
|
VTT
|
7 KB
|
|
|
004 Delta Load.mp4
|
MP4
|
41.9 MB
|
|
|
004 Delta Load_en.vtt
|
VTT
|
7.5 KB
|
|
|
004 Dimensions.mp4
|
MP4
|
25.1 MB
|
|
|
004 Dimensions_en.vtt
|
VTT
|
4.7 KB
|
|
|
004 Guidelines for indexes.mp4
|
MP4
|
41.1 MB
|
|
|
004 Guidelines for indexes_en.vtt
|
VTT
|
7.9 KB
|
|
|
004 Hierarchies in dimensions.mp4
|
MP4
|
34.1 MB
|
|
|
004 Hierarchies in dimensions_en.vtt
|
VTT
|
5.1 KB
|
|
|
004 Staging Sales Fact.mp4
|
MP4
|
47 MB
|
|
|
004 Staging Sales Fact_en.vtt
|
VTT
|
8.3 KB
|
|
|
004 Type 2 - Additional row.mp4
|
MP4
|
40.6 MB
|
|
|
004 Type 2 - Additional row_en.vtt
|
VTT
|
5.8 KB
|
|
|
004 Types of fact tables.mp4
|
MP4
|
2.5 MB
|
|
|
004 Types of fact tables_en.vtt
|
VTT
|
614.4 B
|
|
|
005 Administrating Type 2 dimensions.mp4
|
MP4
|
43.2 MB
|
|
|
005 Administrating Type 2 dimensions_en.vtt
|
VTT
|
6.1 KB
|
|
|
005 Conformed dimensions.mp4
|
MP4
|
24.2 MB
|
|
|
005 Conformed dimensions_en.vtt
|
VTT
|
3.8 KB
|
|
|
005 Demo Setting indexes.mp4
|
MP4
|
28.2 MB
|
|
|
005 Demo Setting indexes_en.vtt
|
VTT
|
4.1 KB
|
|
|
005 Demos & Hands-on.mp4
|
MP4
|
13.7 MB
|
|
|
005 Demos & Hands-on_en.vtt
|
VTT
|
2.7 KB
|
|
|
005 Load Workflow.mp4
|
MP4
|
26.9 MB
|
|
|
005 Load Workflow_en.vtt
|
VTT
|
4.5 KB
|
|
|
005 Relational databases.mp4
|
MP4
|
37.8 MB
|
|
|
005 Relational databases_en.vtt
|
VTT
|
6.5 KB
|
|
|
005 Staging job & fixing problems.mp4
|
MP4
|
50.1 MB
|
|
|
005 Staging job & fixing problems_en.vtt
|
VTT
|
7.3 KB
|
|
|
005 Star schema.mp4
|
MP4
|
50.7 MB
|
|
|
005 Star schema_en.vtt
|
VTT
|
8.2 KB
|
|
|
005 Transactional fact tables.mp4
|
MP4
|
25.2 MB
|
|
|
005 Transactional fact tables_en.vtt
|
VTT
|
3.7 KB
|
|
|
006 Degenerate dimensions.mp4
|
MP4
|
24.2 MB
|
|
|
006 Degenerate dimensions_en.vtt
|
VTT
|
3.8 KB
|
|
|
006 Demo Quick Intro to Pentaho.mp4
|
MP4
|
57.8 MB
|
|
|
006 Demo Quick Intro to Pentaho_en.vtt
|
VTT
|
9.9 KB
|
|
|
006 In-Memory databases.mp4
|
MP4
|
37.2 MB
|
|
|
006 In-Memory databases_en.vtt
|
VTT
|
7 KB
|
|
|
006 Load Payment Dimension.mp4
|
MP4
|
33.3 MB
|
|
|
006 Load Payment Dimension_en.vtt
|
VTT
|
6.2 KB
|
|
|
006 Mixing Type 1 & Type 2.mp4
|
MP4
|
15.9 MB
|
|
|
006 Mixing Type 1 & Type 2_en.vtt
|
VTT
|
2.8 KB
|
|
|
006 Periodic fact tables.mp4
|
MP4
|
26.5 MB
|
|
|
006 Periodic fact tables_en.vtt
|
VTT
|
3.9 KB
|
|
|
006 Setting up Pentaho (ETL tool).mp4
|
MP4
|
30.4 MB
|
|
|
006 Setting up Pentaho (ETL tool)_en.vtt
|
VTT
|
4.2 KB
|
|
|
006 Snowflake schema.mp4
|
MP4
|
33.7 MB
|
|
|
006 Snowflake schema_en.vtt
|
VTT
|
5.2 KB
|
|
|
007 Accumulating snapshots.mp4
|
MP4
|
30.9 MB
|
|
|
007 Accumulating snapshots_en.vtt
|
VTT
|
3.7 KB
|
|
|
007 Cubes.mp4
|
MP4
|
44.3 MB
|
|
|
007 Cubes_en.vtt
|
VTT
|
8.1 KB
|
|
|
007 Demo Product & Category dimension (snowflaked).mp4
|
MP4
|
73.1 MB
|
|
|
007 Demo Product & Category dimension (snowflaked)_en.vtt
|
VTT
|
10.8 KB
|
|
|
007 Demo Setting up tables in SQL.mp4
|
MP4
|
29.1 MB
|
|
|
007 Demo Setting up tables in SQL_en.vtt
|
VTT
|
5.1 KB
|
|
|
007 Junk dimension.mp4
|
MP4
|
46.8 MB
|
|
|
007 Junk dimension_en.vtt
|
VTT
|
8.7 KB
|
|
|
007 Setting up PostgreSQL (Database system).mp4
|
MP4
|
39.2 MB
|
|
|
007 Setting up PostgreSQL (Database system)_en.vtt
|
VTT
|
6.9 KB
|
|
|
007 Transform & Load Sales Fact.mp4
|
MP4
|
72.4 MB
|
|
|
007 Transform & Load Sales Fact_en.vtt
|
VTT
|
10.1 KB
|
|
|
007 Transform-Fact-sales.txt
|
TXT
|
614.4 B
|
|
|
007 Type 3 - Additional attribute.mp4
|
MP4
|
43.7 MB
|
|
|
007 Type 3 - Additional attribute_en.vtt
|
VTT
|
6.6 KB
|
|
|
008 Comparing fact table types.mp4
|
MP4
|
18.3 MB
|
|
|
008 Comparing fact table types_en.vtt
|
VTT
|
3.9 KB
|
|
|
008 Demo Initial Load example.mp4
|
MP4
|
63.7 MB
|
|
|
008 Demo Initial Load example_en.vtt
|
VTT
|
10.6 KB
|
|
|
008 Operational Data Storage.mp4
|
MP4
|
44.1 MB
|
|
|
008 Operational Data Storage_en.vtt
|
VTT
|
8 KB
|
|
|
008 Role-playing dimension.mp4
|
MP4
|
36.6 MB
|
|
|
008 Role-playing dimension_en.vtt
|
VTT
|
6.3 KB
|
|
|
008 Transform & Load job.mp4
|
MP4
|
23.6 MB
|
|
|
008 Transform & Load job_en.vtt
|
VTT
|
3.2 KB
|
|
|
009 Case Study Date dimension.mp4
|
MP4
|
43.8 MB
|
|
|
009 Case Study Date dimension_en.vtt
|
VTT
|
6.1 KB
|
|
|
009 Demo Delta Load example.mp4
|
MP4
|
71.8 MB
|
|
|
009 Demo Delta Load example_en.vtt
|
VTT
|
13.2 KB
|
|
|
009 Fact-Sales-2.csv
|
CSV
|
2.8 KB
|
|
|
009 Factless fact tables.mp4
|
MP4
|
24.8 MB
|
|
|
009 Factless fact tables_en.vtt
|
VTT
|
4.2 KB
|
|
|
009 Final ETL job & Incremental Load.mp4
|
MP4
|
53 MB
|
|
|
009 Final ETL job & Incremental Load_en.vtt
|
VTT
|
6.5 KB
|
|
|
009 Summary.mp4
|
MP4
|
27.5 MB
|
|
|
009 Summary_en.vtt
|
VTT
|
4.5 KB
|
|
|
010 Steps in designing fact tables.mp4
|
MP4
|
32.6 MB
|
|
|
010 Steps in designing fact tables_en.vtt
|
VTT
|
4.8 KB
|
|
|
010 Transforming data.mp4
|
MP4
|
29.3 MB
|
|
|
010 Transforming data_en.vtt
|
VTT
|
5 KB
|
|
|
011 Basic Transformations.mp4
|
MP4
|
43.6 MB
|
|
|
011 Basic Transformations_en.vtt
|
VTT
|
6.4 KB
|
|
|
011 Surrogate Keys.mp4
|
MP4
|
37.2 MB
|
|
|
011 Surrogate Keys_en.vtt
|
VTT
|
6.5 KB
|
|
|
012 Advanced Transformations.mp4
|
MP4
|
55.9 MB
|
|
|
012 Advanced Transformations_en.vtt
|
VTT
|
7.5 KB
|
|
|
012 Case Study The Project.mp4
|
MP4
|
31.4 MB
|
|
|
012 Case Study The Project_en.vtt
|
VTT
|
4.7 KB
|
|
|
013 Case Study Identify the business process.mp4
|
MP4
|
11.9 MB
|
|
|
013 Case Study Identify the business process_en.vtt
|
VTT
|
2.1 KB
|
|
|
013 Demo Planning next steps.mp4
|
MP4
|
32.2 MB
|
|
|
013 Demo Planning next steps_en.vtt
|
VTT
|
5.7 KB
|
|
|
014 Case Study Define the grain.mp4
|
MP4
|
23.5 MB
|
|
|
014 Case Study Define the grain_en.vtt
|
VTT
|
2.8 KB
|
|
|
014 Demo Table setup & Complete Staging.mp4
|
MP4
|
55.3 MB
|
|
|
014 Demo Table setup & Complete Staging_en.vtt
|
VTT
|
9.4 KB
|
|
|
015 Case Study Identify the dimensions.mp4
|
MP4
|
28.8 MB
|
|
|
015 Case Study Identify the dimensions_en.vtt
|
VTT
|
3.8 KB
|
|
|
015 Demo Transform.mp4
|
MP4
|
49.9 MB
|
|
|
015 Demo Transform_en.vtt
|
VTT
|
7.5 KB
|
|
|
015 SQL-Transform.txt
|
TXT
|
409.6 B
|
|
|
016 Case Study Identify the facts.mp4
|
MP4
|
44 MB
|
|
|
016 Case Study Identify the facts_en.vtt
|
VTT
|
5.7 KB
|
|
|
016 Demo Load & Validate results.mp4
|
MP4
|
40.3 MB
|
|
|
016 Demo Load & Validate results_en.vtt
|
VTT
|
5.7 KB
|
|
|
017 Scheduling jobs.mp4
|
MP4
|
31.8 MB
|
|
|
017 Scheduling jobs_en.vtt
|
VTT
|
6.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
