ReadingList :: Data Engineer (Lifelong Learning)

读书就像习武之人修炼内功，好的书可以使自己功力大大提升，就像拜师武林泰斗了；

如果能面对面学习，那就更厉害了！

这是我修炼Data Engineer功力的书单和读书进度，加油！

01 Building a Scalable Data Warehouse with Data Vault 2.0 [Paperback]

Reading Plan (to finish by 17/Dec)

Starting from 08/Oct/2023 ✅

15-Oct

• c1 ✅  09/Oct

• c2 ✅  10/Oct

• c3 ✅  16/OCT

Notes: 

1. Kimball: two-layer data warehouse
2. Inmon: three-layer data warehouse model
3. Data sources: ERP, CRM, Files etc
4. TDQM, DWQ 

 

💪💪😄😄

22-Oct

• c4 ✅  19/OCT
• c5 ✅  22/OCT

Entity definitions (Hub, Link, Sat)

SAL (same-as link), various links, sats 

29-Oct

• c6 ✅  24/OCT
• c7 ✅  26/OCT

Slow Changing Dimensions (SCD)

Star schemas

Snowflake design (indirect dimensions) 

5-Nov

• c8 ✅  02/Nov
• c9 ✅  05/Nov

MDM 

12-Nov

• c10 ✅  27/NOV ✌

Metrics and Error Marts 

19-Nov

• c11 ✅  12/Nov

Data Extraction (stage loading: historical/batch) 

26-Nov

• c12  ✅  16/Nov

DV loading 

3-Dec

• c13 ✅  28/Nov

Data Quality 

10-Dec

• c14  ✅  01/Dec 😀😀😀

17-Dec

• c15 ✅  17/OCT

Business users: Accessing Information Mart to build a multidimensional database

Merry Christmas!

嗯，应该想想怎么奖励自己了，要提前完成任务了！😀

这个假期读几本闲书吧

[The Summer Job]