BISM1201 Lecture Notes - Lecture 10: Online Analytical Processing, Online Transaction Processing, Logical Data Model
30 Sep 2018
School
Department
Course
Professor
Document Summary
Business intelligence & competitive advantage: business intelligence systems a definition, an information system, provide information for improving decision making, vary in characteristics and capabilities, vary in the way they help foster the competitive advantage of a business. This is shown in the right-side figure above! A reporting application uses a reporting tool to compile data from multiple sources into a form that is information for the user. Reporting bi systems deliver reports to authorised users at appropriate times using operations: sorting, grouping, calculating, filtering, formatting. Two such applications are: olap and rfm analysis. Olap is based on precalculated data (remember the logical architecture oltp, olap) An olap report shows simple arithmetic operations on data: sum, average, count etc. Has a dynamic format: user can change report structure and view online. Contains measures: data items to be manipulated, e. g. total sales, average cost. Contains dimensions: characteristics of measures, e. g. purchase date, customer type, location, sales region.
