Preamble
Thought of writing this series of posts to explain about what a data warehouse is and what are all the layers it has.
Warehouse
What is data warehouse and why do we need one ?
We are living in a digital age and anything and everything we see and use is supported by data collected from various inputs, For example the wearable watch you are wearing and the mobile phone you are using, these generates massive amount of data which need to be carefully analysed, stored and statemented by your provider, so that they can add up fees and charge you for the usage on your next bill.
The same goes to your daily transactions on your banking account, whether its your credit card or its your debit card, gets stored, sorted, analysed and statemented by your bank to provide you interest and charge a fee for your usage if needed. Soanywhere you get this reports (statements) generated for a massive amount of data generated by various events (may be by you), you can safely assume that these data are stored in a warehouse and an analytical processing is done on top of it, which generates all the statements your receive.