|
|
001 Congratulations_.mp4
|
MP4
|
4.9 MB
|
|
|
001 Congratulations__en.srt
|
SRT
|
1.8 KB
|
|
|
001 Course Data & Code Download.html
|
HTML
|
409.6 B
|
|
|
001 Course Introduction.mp4
|
MP4
|
30.3 MB
|
|
|
001 Course Introduction_en.srt
|
SRT
|
8.6 KB
|
|
|
001 Data Solution Design Part 1.mp4
|
MP4
|
41.5 MB
|
|
|
001 Data Solution Design Part 1_en.srt
|
SRT
|
10.4 KB
|
|
|
001 Data Troubleshooting and Unit Testing.mp4
|
MP4
|
79.9 MB
|
|
|
001 Data Troubleshooting and Unit Testing_en.srt
|
SRT
|
18.5 KB
|
|
|
001 Further Data Profiling.mp4
|
MP4
|
59.4 MB
|
|
|
001 Further Data Profiling_en.srt
|
SRT
|
13.1 KB
|
|
|
001 Implementing Changes.mp4
|
MP4
|
36.7 MB
|
|
|
001 Implementing Changes_en.srt
|
SRT
|
8.4 KB
|
|
|
001 Introduction to Data Modelling.mp4
|
MP4
|
42.6 MB
|
|
|
001 Introduction to Data Modelling_en.srt
|
SRT
|
10.6 KB
|
|
|
001 Introduction to Data Profiling.mp4
|
MP4
|
41.3 MB
|
|
|
001 Introduction to Data Profiling_en.srt
|
SRT
|
10.1 KB
|
|
|
001 Introduction to Jupyter Notebooks.mp4
|
MP4
|
19.1 MB
|
|
|
001 Introduction to Jupyter Notebooks_en.srt
|
SRT
|
5.5 KB
|
|
|
001 Program Design Principles.mp4
|
MP4
|
57.1 MB
|
|
|
001 Program Design Principles_en.srt
|
SRT
|
14.3 KB
|
|
|
001 Structured Query Language (SQL)_ Joins.mp4
|
MP4
|
72.7 MB
|
|
|
001 Structured Query Language (SQL)_ Joins_en.srt
|
SRT
|
15.7 KB
|
|
|
002 Course Overview.mp4
|
MP4
|
15.8 MB
|
|
|
002 Course Overview_en.srt
|
SRT
|
6.3 KB
|
|
|
002 Example_ Create Test Data.mp4
|
MP4
|
15.6 MB
|
|
|
002 Example_ Create Test Data_en.srt
|
SRT
|
3.7 KB
|
|
|
002 Example_ Create the Item Fact Table.mp4
|
MP4
|
22.7 MB
|
|
|
002 Example_ Create the Item Fact Table_en.srt
|
SRT
|
6.4 KB
|
|
|
002 Example_ Data Profiling Using Power Query and Google Sheets.mp4
|
MP4
|
15.3 MB
|
|
|
002 Example_ Data Profiling Using Power Query and Google Sheets_en.srt
|
SRT
|
6.5 KB
|
|
|
002 Example_ Structuring Code.mp4
|
MP4
|
59 MB
|
|
|
002 Example_ Structuring Code_en.srt
|
SRT
|
8.8 KB
|
|
|
002 Exercise_ Create a Basket Table.mp4
|
MP4
|
5.1 MB
|
|
|
002 Exercise_ Create a Basket Table_en.srt
|
SRT
|
921.6 B
|
|
|
002 Exercise_ Implement an Offer Dimension.mp4
|
MP4
|
8.7 MB
|
|
|
002 Exercise_ Implement an Offer Dimension_en.srt
|
SRT
|
1.6 KB
|
|
|
002 Further Data Profiling Using a Jupyter Notebook.mp4
|
MP4
|
51.5 MB
|
|
|
002 Further Data Profiling Using a Jupyter Notebook_en.srt
|
SRT
|
15.6 KB
|
|
|
002 Install Anaconda (for Jupyter).html
|
HTML
|
614.4 B
|
|
|
002 SQL_ Set Operators.mp4
|
MP4
|
35.7 MB
|
|
|
002 SQL_ Set Operators_en.srt
|
SRT
|
8.5 KB
|
|
|
003 Data Mapping and Transformations.mp4
|
MP4
|
41.6 MB
|
|
|
003 Data Mapping and Transformations_en.srt
|
SRT
|
9 KB
|
|
|
003 Example_ Add Unit Tests.mp4
|
MP4
|
26.7 MB
|
|
|
003 Example_ Add Unit Tests_en.srt
|
SRT
|
4.7 KB
|
|
|
003 Exercise_ Dimension Tables.mp4
|
MP4
|
7.7 MB
|
|
|
003 Exercise_ Dimension Tables_en.srt
|
SRT
|
1.7 KB
|
|
|
003 Exercises_ Profiling Questions Against the Transactional Data.mp4
|
MP4
|
6.1 MB
|
|
|
003 Exercises_ Profiling Questions Against the Transactional Data_en.srt
|
SRT
|
1.4 KB
|
|
|
003 Jupyter Notebook Basics.mp4
|
MP4
|
12.1 MB
|
|
|
003 Jupyter Notebook Basics_en.srt
|
SRT
|
5.8 KB
|
|
|
003 Optional_ Data Migration and Historical Data.mp4
|
MP4
|
98.7 MB
|
|
|
003 Optional_ Data Migration and Historical Data_en.srt
|
SRT
|
20.3 KB
|
|
|
003 SQL_ Aggregate Functions and Window Functions.mp4
|
MP4
|
42.6 MB
|
|
|
003 SQL_ Aggregate Functions and Window Functions_en.srt
|
SRT
|
11.1 KB
|
|
|
003 Solution_ Create a Basket Table.mp4
|
MP4
|
25 MB
|
|
|
003 Solution_ Create a Basket Table_en.srt
|
SRT
|
6.6 KB
|
|
|
003 Solution_ Implement an Offer Dimension.mp4
|
MP4
|
58.3 MB
|
|
|
003 Solution_ Implement an Offer Dimension_en.srt
|
SRT
|
10.4 KB
|
|
|
004 Data Modelling.mp4
|
MP4
|
69.3 MB
|
|
|
004 Data Modelling_en.srt
|
SRT
|
17.8 KB
|
|
|
004 Exercises_ Implement Further Transformations.mp4
|
MP4
|
5.7 MB
|
|
|
004 Exercises_ Implement Further Transformations_en.srt
|
SRT
|
1.3 KB
|
|
|
004 Optional Exercise_ Add Further Unit Tests.mp4
|
MP4
|
3.1 MB
|
|
|
004 Optional Exercise_ Add Further Unit Tests_en.srt
|
SRT
|
716.8 B
|
|
|
004 Python Basics.mp4
|
MP4
|
25 MB
|
|
|
004 Python Basics_en.srt
|
SRT
|
11.3 KB
|
|
|
004 SQL Joins Using Pandas.mp4
|
MP4
|
31.9 MB
|
|
|
004 SQL Joins Using Pandas_en.srt
|
SRT
|
8.9 KB
|
|
|
004 Solution_ Dimension Tables Exercise.mp4
|
MP4
|
21 MB
|
|
|
004 Solution_ Dimension Tables Exercise_en.srt
|
SRT
|
5.4 KB
|
|
|
004 Solutions_ Profiling Questions Against the Transactional Data.mp4
|
MP4
|
17.2 MB
|
|
|
004 Solutions_ Profiling Questions Against the Transactional Data_en.srt
|
SRT
|
5 KB
|
|
|
005 Data Solution Design Part 2.mp4
|
MP4
|
64.5 MB
|
|
|
005 Data Solution Design Part 2_en.srt
|
SRT
|
14.2 KB
|
|
|
005 Data Validation and Reconciliation.mp4
|
MP4
|
72.2 MB
|
|
|
005 Data Validation and Reconciliation_en.srt
|
SRT
|
16 KB
|
|
|
005 Exercises_ SQL Grouping and Window Functions.mp4
|
MP4
|
6.2 MB
|
|
|
005 Exercises_ SQL Grouping and Window Functions_en.srt
|
SRT
|
1.4 KB
|
|
|
005 Solutions_ Implement Further Transformations.mp4
|
MP4
|
63.4 MB
|
|
|
005 Solutions_ Implement Further Transformations_en.srt
|
SRT
|
16.7 KB
|
|
|
006 Exercises_ Star Schema Joins.mp4
|
MP4
|
11.5 MB
|
|
|
006 Exercises_ Star Schema Joins_en.srt
|
SRT
|
3.2 KB
|
|
|
006 Solutions_ SQL Grouping and Window Functions.mp4
|
MP4
|
34.7 MB
|
|
|
006 Solutions_ SQL Grouping and Window Functions_en.srt
|
SRT
|
9.1 KB
|
|
|
007 Solutions_ Star Schema Joins.mp4
|
MP4
|
61.8 MB
|
|
|
007 Solutions_ Star Schema Joins_en.srt
|
SRT
|
10.1 KB
|
|
|
008 Example_ Dimension Snapshots.mp4
|
MP4
|
17 MB
|
|
|
008 Example_ Dimension Snapshots_en.srt
|
SRT
|
5 KB
|
|
|
Add-Basket-Table-Unit-Tests.ipynb
|
IPYNB
|
2.8 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Create-Basket-Fact-From-Functions.ipynb
|
IPYNB
|
5.4 KB
|
|
|
Create-Basket-Fact.ipynb
|
IPYNB
|
13.1 KB
|
|
|
Create-Basket-Table.ipynb
|
IPYNB
|
21 KB
|
|
|
Create-Item-Fact.ipynb
|
IPYNB
|
14.5 KB
|
|
|
Create-Offer-Dimension.ipynb
|
IPYNB
|
5 KB
|
|
|
Create-Product-Dim.ipynb
|
IPYNB
|
12.7 KB
|
|
|
Create-Store-Dim.ipynb
|
IPYNB
|
6.5 KB
|
|
|
Create-Test-Data.ipynb
|
IPYNB
|
12.7 KB
|
|
|
Dimension-Snapshot.ipynb
|
IPYNB
|
7.8 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Offer.csv
|
CSV
|
307.2 B
|
|
|
Product.csv
|
CSV
|
4.3 KB
|
|
|
Product_20210106.csv
|
CSV
|
4.7 KB
|
|
|
Product_20210107.csv
|
CSV
|
4.6 KB
|
|
|
Profiling.ipynb
|
IPYNB
|
30.9 KB
|
|
|
Refactor-Basket-Fact.ipynb
|
IPYNB
|
8.3 KB
|
|
|
Refactor-Item-Fact.ipynb
|
IPYNB
|
3.4 KB
|
|
|
Run-Item-Fact-Unit-Tests.ipynb
|
IPYNB
|
5.2 KB
|
|
|
SQL-Joins.ipynb
|
IPYNB
|
25.6 KB
|
|
|
SQL-Window-Functions.ipynb
|
IPYNB
|
20.9 KB
|
|
|
Schema-Queries.ipynb
|
IPYNB
|
7 KB
|
|
|
Store.csv
|
CSV
|
3.7 KB
|
|
|
Store_20210106.csv
|
CSV
|
3.6 KB
|
|
|
Store_20210107.csv
|
CSV
|
3.7 KB
|
|
|
Transaction-sample.csv
|
CSV
|
1.8 MB
|
|
|
Transaction.csv
|
CSV
|
77.8 MB
|
|
|
Transformations.ipynb
|
IPYNB
|
42.3 KB
|
|
|
common.py
|
PY
|
204.8 B
|
|
|
create_item_fact.py
|
PY
|
2.6 KB
|
|
|
create_offer_dimension.py
|
PY
|
1 KB
|
|
|
external-assets-links.txt
|
TXT
|
102.4 B
|
|
|
jupyter-intro.ipynb
|
IPYNB
|
512 B
|
|
|
refactor_basket_fact.py
|
PY
|
1.7 KB
|
