BUS 237 Chapter Notes -Olap Cube, Online Transaction Processing, Online Analytical Processing

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 237
• Professor: Maryam Ficociello

Document Summary

The final challenge in decision making is the quality of data. Although data that are critical for successful operations must be complete and accurate, data that are only marginally necessary do not need to be for example, some systems gather demographic data in the ordering process. But because such data are not needed to fill, ship and bill orders, their quality suffers. Problems of using operational data for bi systems: Wrong granularity too fine or not enough. Too much data too many attributes, too many data points. Inconsistent data for example, when an area code changes, the phone number for a given customer before the change will not match the customer"s number after the change. Customer name and account balance is large granularity data. Customer name, balance and the order details and payment history of every customer order is smaller granularity. Refers to the degree of summarization or detail. Coarse data are highly summarized; fine data express precise detail.