Need for Data Warehouse

Amazon CEO wants to know the sales of the new Kindle Scribe reader they launched this year compared to other eReaders in the next 30 mins.

Where do we look for this info?

Transactional databases use every resource to serve customers. Querying on them may slow down a customer's request.
Also, they are Live databases. So they may or may not have historical data.
Chances are data format may differ for each region/country in which Amazon is doing business in.

It's not just Amazon; it's everywhere.

Companies will have multiple databases that are not linked with each other for specific reasons.

There is no reason for linking HR data to Sales data, but the CFO might need this info for budgeting.

Fun Qn: How many times have you received Marketing mail/email from the same company you have an account with?

Last updated 2 years ago

Amazon CEO wants to know the sales of the new Kindle Scribe reader they launched this year compared to other eReaders in the next 30 mins.

Where do we look for this info?

Transactional databases use every resource to serve customers. Querying on them may slow down a customer's request.
Also, they are Live databases. So they may or may not have historical data.
Chances are data format may differ for each region/country in which Amazon is doing business in.

It's not just Amazon; it's everywhere.

Companies will have multiple databases that are not linked with each other for specific reasons.

There is no reason for linking HR data to Sales data, but the CFO might need this info for budgeting.

Fun Qn: How many times have you received Marketing mail/email from the same company you have an account with?

Last updated 2 years ago