1. Wrap-up
Outstanding! You have made it to the end of this course on Introduction to Data Warehousing. We've covered so much in this brief course.
2. What we covered - Chapter 1
We started by covering some of the basics of data warehousing, including what is a data warehouse, its life cycle, and how it compares to data lakes and data marts.
3. What we covered - Chapter 2
With some basics under our belt, we looked at the different layers of a data warehouse, the differences between Inmon and Kimball designs, and OLAP and OLTP systems.
4. What we covered - Chapter 3
We continued learning by covering fact and dimension tables, slowly changing dimensions, row and column store, and Kimball's four-step process.
5. What we covered - Chapter 4
We also compared ETL and ELT processes, reviewed data cleaning, and implementing a warehouse on-premises or in the cloud. Finally, we brought it all together with an example of designing a data warehouse for a startup.
Wow, this is a fantastic list.
6. Things we didn't cover
However, a few things we didn't cover include digging into SQL fundamentals, building data pipelines, or analyzing the data in the warehouse. If you want to learn more about these topics, I'd recommend exploring these further.
7. Learning more
Here are some additional DataCamp courses or books you might enjoy.
8. Good bye and thank you!
Good bye and thanks!