3. Define oltP OLTP(online transaction processing) is a type of computer processing where the computer responds immediately to user requests. Each request is considered to be a transaction, which is a computerized record of a discrete event, such as the eceipt of inventory or a customer order 4. Define OLAP OLAP(online analytical processing)is processing for end-user ad hoc reports, queries, and analysis. Separating the oltP from analysis and decision support provided by OlaP enables the benefits of Bi that were described earlier and provides for competitive intelligence and ad vantage as described next 5. List some of the implementation topics addressed by Gartner's report Gartner's framework decomposes planning and execution into business, organization, functionality, and infrastructure components. At the business and organizational levels, strategic and operational objectives must be defined while considering the available organizational skills to achieve those objectives. Issues of organizational culture surround ing bI initiatives and build ing enthusiasm for those initiatives and procedures for the intra-organizational sharing of BI best practices must be considered by upper management-with plans in place to prepare the organization for change 6. List some other success factors of Bl If the company's strategy is properly aligned with the reasons for DW and BI initiatives, and if the company's IS organization is or can be made capable of playing its role in such a project, and if the requisite user community is in place and has the proper motivation, it is wise to start BI and establish a BI Competency Center (BICC)within the company. The center could serve some or all of the following functions The center can demonstrate how bi is clearly linked to strategy and execution of strategy A center can serve to encourage interaction between the potential business user communities and the is organization The center can serve as a repository and disseminator of best bi practices between and among the different lines of business Standards of excellence in BI practices can be ad vocated and encouraged throughout the company 6 Copyright C2018 Pearson Education, Inc
6 Copyright © 2018Pearson Education, Inc. 3. Define OLTP. OLTP (online transaction processing) is a type of computer processing where the computer responds immediately to user requests. Each request is considered to be a transaction, which is a computerized record of a discrete event, such as the receipt of inventory or a customer order. 4. Define OLAP. OLAP (online analytical processing) is processing for end-user ad hoc reports, queries, and analysis. Separating the OLTP from analysis and decision support provided by OLAP enables the benefits of BI that were described earlier and provides for competitive intelligence and advantage as described next. 5. List some of the implementation topics addressed by Gartner’s report. Gartner’s framework decomposes planning and execution into business, organization, functionality, and infrastructure components. At the business and organizational levels, strategic and operational objectives must be defined while considering the available organizational skills to achieve those objectives. Issues of organizational culture surrounding BI initiatives and building enthusiasm for those initiatives and procedures for the intra-organizational sharing of BI best practices must be considered by upper management—with plans in place to prepare the organization for change. 6. List some other success factors of BI. If the company’s strategy is properly aligned with the reasons for DW and BI initiatives, and if the company’s IS organization is or can be made capable of playing its role in such a project, and if the requisite user community is in place and has the proper motivation, it is wise to start BI and establish a BI Competency Center (BICC) within the company. The center could serve some or all of the following functions. • The center can demonstrate how BI is clearly linked to strategy and execution of strategy. • A center can serve to encourage interaction between the potential business user communities and the IS organization. • The center can serve as a repository and disseminator of best BI practices between and among the different lines of business. • Standards of excellence in BI practices can be advocated and encouraged throughout the company
The IS organization can learn a great deal through interaction with the user communities, such as knowledge about the variety of types of analytical tools that are needed The business user community and Is organization can better understand why the data warehouse platform must be flexible enough to provide for changing business requirements It can help important stakeholders like high-level executives see how BI play an important role Another important success factor of Bi is its ability to facilitate a real-time, on- agile environment Section 1.5 Review Questions 1. Define analytics The term replaces terminology referring to individual components of a decision support system with one broad word referring to business intelligence. More precisely, analytics is the process of developing actionable decisions or recommendations for actions based upon insights generated from historical data language: " looking at all the data to understand what is happening, what wiy ptive Students may also refer to the eight levels of analytics and this simpler descri happen, and how to make the best of it What is descriptive analytics? What are the various tools that are employed in descriptive analytics? Descriptive analytics refers to knowing what is happening in the organization and understand ing some underlying trends and causes of such occurrences. Tools used in descriptive analytics include data warehouses and visualization applications 3. How is descriptive analytics different from trad itional reporting? Descriptive analytics gathers more data, often automatically It makes results available in real time and allows reports to be customized What is a Dw? How can data warehousing technology help to enable analytics? A data warehouse, introduced in Section 1.7, is the component of a BI system that contains the source data. As described in this section, developing a data warehouse usually includes development of the data infrastructure for descriptive analytics--that is, consolidation of data sources and making relevant data available in a form that enables appropriate reporting and analysis. a data warehouse serves as the basis for developing appropriate reports, queries, alerts and trends 5. What is predictive analytics? How can organizations employ predictive analytics? Copyright C2018 Pearson Education, Inc
7 Copyright © 2018Pearson Education, Inc. • The IS organization can learn a great deal through interaction with the user communities, such as knowledge about the variety of types of analytical tools that are needed. • The business user community and IS organization can better understand why the data warehouse platform must be flexible enough to provide for changing business requirements. • It can help important stakeholders like high-level executives see how BI can play an important role. Another important success factor of BI is its ability to facilitate a real-time, ondemand agile environment. Section 1.5 Review Questions 1. Define analytics. The term replaces terminology referring to individual components of a decision support system with one broad word referring to business intelligence. More precisely, analytics is the process of developing actionable decisions or recommendations for actions based upon insights generated from historical data. Students may also refer to the eight levels of analytics and this simpler descriptive language: “looking at all the data to understand what is happening, what will happen, and how to make the best of it.” 2. What is descriptive analytics? What are the various tools that are employed in descriptive analytics? Descriptive analytics refers to knowing what is happening in the organization and understanding some underlying trends and causes of such occurrences. Tools used in descriptive analytics include data warehouses and visualization applications. 3. How is descriptive analytics different from traditional reporting? Descriptive analytics gathers more data, often automatically. It makes results available in real time and allows reports to be customized. 4. What is a DW? How can data warehousing technology help to enable analytics? A data warehouse, introduced in Section 1.7, is the component of a BI system that contains the source data. As described in this section, developing a data warehouse usually includes development of the data infrastructure for descriptive analytics—that is, consolidation of data sources and making relevant data available in a form that enables appropriate reporting and analysis. A data warehouse serves as the basis for developing appropriate reports, queries, alerts, and trends. 5. What is predictive analytics? How can organizations employ predictive analytics?