Week 4: Discussion – Data Warehouses & Online Analytical Processing (OLAP)
•Compare a data warehouse used for decision support to an operational database. How do the data warehouse and the operational database differ in their purpose, their structure, the technology they use, and the way they are managed? Why would a company need both?
•How could a large online retail firm like Amazon make use of OLAP (Online Analytical Processing)? What are some dimensions they might use to analyze their data, and what insights could they gain from this analysis?