MIS171 Lecture Notes - Lecture 2: Data Warehouse, Olap Cube, Online Analytical Processing

• School: Deakin University
• Department: Business and Law
• Course: MIS171
• Professor: All

Document Summary

Uses data to understand past and present performance and make informed decisions. We will use some of the most commonly used data analysis tools and methods to explore and summarise data to gain some insights. The business will typically want answers to questions about when, for what, (cid:449)he(cid:396)e, (cid:271)(cid:455) (cid:449)ho(cid:373), fo(cid:396) (cid:449)ho(cid:373), i(cid:374) (cid:449)hi(cid:272)h (cid:272)u(cid:396)(cid:396)e(cid:374)(cid:272)(cid:455) (cid:396)ather than one single (cid:395)uestio(cid:374) su(cid:272)h as (cid:862)(cid:449)hat is the att(cid:396)itio(cid:374) i(cid:374) last si(cid:454) (cid:373)o(cid:374)ths? (cid:863) For example, if a business wants to obtain a complete picture of its possible customers, they have to gather data about the customers from many different systems. A data warehouse combines all these different data sources and provides a quick and easy way to analyse data. The technical part of the data warehouse ensures the collection and joining of data. The business part of the data warehouse ensures the transformation of the data into information.