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.

  • Airlines

  • Bank Transactions / ATM transactions

  • Restaurant chains, and so on.

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

  • Sales Database

  • Customer Service Database

  • Marketing Database

  • Inventory Database

  • Human Resources Database

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?

PreviousFeatures of Data WarehouseNextCurrent State of the Art

Last updated