At the end of the chapter, let us summarize all things we learnt in this chapter. Being the heart of the book, this chapter tried to teach us many aspects of development, starting from getting the data from the source system to converting it into the data insight visualization for end users to consume it.
We started with understanding the data extraction process, where we learned about ETL (Extract, Transform, and Load). Within the ETL process, we focused mainly on the extraction process, where we learned about full load and incremental load. We saw what kind of data would need what kind of load strategy.
In incremental load, we saw how to handle three main scenarios, namely insert, update, and delete. We also saw the scripting and sample outputs for each one of them.
After the extraction phase, we started with data modeling and learned about dimensional modeling with...