BBG 101 Lecture Notes - Lecture 20: Data Warehouse, Business Intelligence, Bastion

• School: Tunxis Community College
• Department: Business – General
• Course: BBG 101
• Professor: Boccaccio

Document Summary

For large amounts of data, data warehouses are the most. Primary functions of a data warehouse our information. Must make an organisation"s information easily accessible. Must be adaptive and resilient to change. Must be a secure bastion (place, maintaining particular principles) that protects. Must serve as a foundation for improved decision making. Collection point for integrated, subject-oriented strategic information. Source of information that is delivered to data marts. Stages to move form operation data to data warehouse data. Data storage getting data into a data warehouse. Some data elements of operation data is useful to decision making. Others are not as valuable for this purpose. Need therefore to extract only useful data from an operation database before brining it into the dw. Ensures only valuable data forms part of dw (to create business intelligence) Transformation (a process of dealing with inconsistencies) Inconsistencies between operational databases leads to poor quality in dw.