BTE 210 Lecture Notes - Lecture 8: Online Analytical Processing, Information Builders, Cognos
Document Summary
Decision making is difficult due to the following trends: number of alternatives is constantly increasing, most decisions must be made under time pressure. Increased uncertainty in the decision environment: often necessary to rapidly access remote info, consult with experts, or conduct a group decision-making session. Capture, collect, integrate, store and analyze data. Generate info to support business decision making. The scope of bi: smaller organizations: excel spreadsheets, larger organizations: data mining, predictive analytics, dashboards. Popular bi apps: sas, hyperion, business objects, spss, cognos, information builders, ms excel. Bi apps for data analysis: multidimensional analysis or online analytical processing (olap) Allows users to analyze data in such a way to quickly answer business questions. The process of searching for valuable info in a large database, data warehouse, or data mart. Used in: retailing and sales, banking, manufacturing and production, insurance, police work, healthcare, marketing: decision support systems (dss)