ITM 309 Lecture Notes - Lecture 16: Zillow, Business Analytics, Business Intelligence

• School: MSU
• Department: Information Technology Mgmt
• Course: ITM 309
• Professor: Rodammer

Document Summary

Lack of flexibility (program tightly linked to data) Flexibility (programs not linked directly to data) Database management systems: database management systems (dbms) software through which users and application programs interact with a database. The business benefits of data warehousing: data warehouses extend the transformation of data into information. I(cid:374) the (cid:1005)99(cid:1004)"s e(cid:454)e(cid:272)uti(cid:448)es (cid:271)e(cid:272)a(cid:373)e less (cid:272)o(cid:374)(cid:272)er(cid:374)ed (cid:449)ith the da(cid:455)-to-day business operations and more concerned with overall business functions. The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes. Multi-dimensional analysis: databases contain information in a series of two-dimensional tables. In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows. Dimension a particular attribute of information. Cube common term for the representation of multidimensional information. Information cleansing or scrubbing: an organization must maintain high-quality data in the data warehouse.