NewWPA

Improve database and ETL pipeline fundamentals

I recently started a new job, I’ve been thrown into a project that seems like it’s not going anywhere. The person introducing me to the project said that almost everyone who joins onto this project, leaves in a few months. I want to give it a shot and make progress in the project. I have worked with SQL extensively but not on huge datasets. Are there any books or resources that I can use to familiarize myself with ETL concepts while handling big data and creating tableau dashboards or optimizing tableau dashboard’s efficiency. Also, good SQL practices for big data. #Tableau #SQL #BigData

Societe Generale 👽resident Jul 6, 2022

Check out kimballs data warehouse book. It should give you good foundational knowledge on data modeling which will come handy.

New
WPA OP Jul 6, 2022

Thanks! I see 3 books from Kimballs data warehouse. Any specific one you would recommend?

Balyasny Asset Management abbrev Jul 6, 2022

Data Warehouse Toolkit. Which DBMS are you working with?

Verizon bnx452 Jul 6, 2022

Kimball's is a good book as mentioned. Also join r/dataengineering on Reddit. Great sub with tons of knowledge folks who are very helpful.