Interested In Data Warehousing?
I’ve been writing for a while now about Data Warehousing. So far, I’ve written 7 articles. Some of them are quite basic. Others can be a little bit more complex and abstract. So, here’s a mini-guide about how I recommend reading them.
How to read my articles
If you are completely new to Data Warehousing, I recommend starting in the next post. It comprises basic information about data lakes and data warehouses. So, if you are new to these terms, I hope this post will help you to know a little bit more about them.
What is a Data Warehouse: Basic Architecture
An introduction to the Data Warehouse main concepts
If you are looking for understanding a bit more about architecture and what you need to know to put together a Data Warehouse, please take a look at the next two articles.
The first one is intended two lay down some architectural principles you should follow when defining an architecture for your Data Warehouse.
The second one is more suited for people who already have a Data Warehouse in place and want to know what other processes they should put in place, so they can improve their pipeline operability and performance.
Building a Data Warehouse: Basic Architectural principles
An approach towards simplifying data warehousing
Building a Data Warehouse Pipeline: Basic Concepts & Roadmap
Five processes to improve your data pipeline operability and performance
So far, I think you have digested a lot of conceptual information. If you want to take a look at articles a little bit more practical I think you should read these next 3.
A Data Warehouse Implementation on AWS
An implementation using AWS S3, AWS Glue, DBT, and AWS Redshift
Generalizing data load processes with Airflow
Data load processes should not be written twice, they should be generalized
Implementing the functional data engineering paradigm in data load processes by using Airflow
We integrate several data sources in a project comprising more than forty applications. Such sources are integrated by…
Finally, it’s been a long road for me when it comes to Data Warehousing. I’ve made some mistakes along the way and I’ve learned a couple of things. So, I recommend reading this next one if you want to learn about it!
Thank you for reading and for your support!
If you want to stay updated with my work, please join my newsletter! Once in a while, I share some stuff with my readers. I’ll appreciate it if you join :)