Step 4. Establishing an effective internal control review process for security and privacy 2. What skills should a DWa possess? Why? Familiarity with high-performance hardware, software, and networking technologies since the data warehouse is based on those Solid business insight, to understand the purpose of the dw and its business justification Familiarity with business decision-making processes to understand how the dw will be used Excellent communication skills. to communicate with the rest of the organization 3. What recent technologies may shape the future of data warehousing? Why? Following are some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing Sourcing: Acquisition of data from diverse and dispersed sources Web, social media, and Big Data · Open source software Saas(software as a service)"The Extended ASP Model · Cloud computing Infrastructure: Architectural--hard ware and software--enhancements Columnar(a new way to score and access data in the database) Real-time data warehousing Data warehouse appliances(all-in-one solutions to Dw) Data management technologies and practices In-database processing technology (putting the algorithms where the data is) In-memory storage technology(moving the data in the memory for faster New database management systems Copyright C2018 Pearson Education, Inc
11 Copyright © 2018Pearson Education, Inc. Step 4. Establishing an effective internal control review process for security and privacy. 2. What skills should a DWA possess? Why? • Familiarity with high-performance hardware, software, and networking technologies, since the data warehouse is based on those • Solid business insight, to understand the purpose of the DW and its business justification • Familiarity with business decision-making processes to understand how the DW will be used • Excellent communication skills, to communicate with the rest of the organization 3. What recent technologies may shape the future of data warehousing? Why? Following are some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing. Sourcing: Acquisition of data from diverse and dispersed sources • Web, social media, and Big Data • Open source software • SaaS (software as a service) “The Extended ASP Model” • Cloud computing Infrastructure: Architectural—hardware and software—enhancements • Columnar (a new way to score and access data in the database) • Real-time data warehousing • Data warehouse appliances (all-in-one solutions to DW) • Data management technologies and practices • In-database processing technology (putting the algorithms where the data is) • In-memory storage technology (moving the data in the memory for faster processing) • New database management systems
Advanced analytics As the world of business becomes more global and complex, the need for business intelligence and data warehousing tools also becomes more prominent. The fast improving information technology tools and techniques seem to be moving in the right direction to address the needs of the future business intelligence systems Section 3.9 Review Questions 1. What is business performance management? How does it relate to Bl? Business performance management(BPM) refers to the business processes, methodologies, metrics, and technologies used by enterprises to measure, monitor, and manage business performance. It is also known as corporate performance management(CPM), enterprise performance management(EPM), and strategic enterprise management(SEM). It can be considered to be a type of BI tool/technique. The most significant differentiator of B PM from any other bl performs that link strategy to execution in order to optimize business p set of tools and practices is its strategy focus. BPM encompasses a closed-lod pr 2. What are the three key components of a BPM system? According to Colbert(2009), a BPM encompasses three key components. The first is a set of integrated, closed-loop management and analytic processes (supported by technology) that addresses financial as well as operational activities The second involves tools for businesses to define strategic goals and then measure and manage performance against those goals. and the third component involves a core set of processes, includ ing financial and operational planning, consolidation and reporting, modeling, analysis, and monitoring of key performance indicators(KPIs), linked to organizational strategy 3. List and briefly describe the four phases of the BPM cycle The BPM cycle contains four main phases. First is to strategize. This involves answering the question, "Where do we want to go?"), and involves a high-level, long-term plan. Missions, visions, and objectives are key components of this ase. The second phase is to plan, which answers the question, How do we get there? Key elements here are a detailed operational plan and a financial plan includ ing budget. The next phase is to monitor and analyze, which answers the question, How are we doing? Here is where KPIs, dashboards, reporting, and analytics are helpful. Finally come action and adjustment, based on comparing our analysis results against our plans. Sometimes this means changing the way we operate, and sometimes it means adjusting our strategy Copyright C2018 Pearson Education, Inc
12 Copyright © 2018Pearson Education, Inc. • Advanced analytics As the world of business becomes more global and complex, the need for business intelligence and data warehousing tools also becomes more prominent. The fast improving information technology tools and techniques seem to be moving in the right direction to address the needs of the future business intelligence systems. Section 3.9 Review Questions 1. What is business performance management? How does it relate to BI? Business performance management (BPM) refers to the business processes, methodologies, metrics, and technologies used by enterprises to measure, monitor, and manage business performance. It is also known as corporate performance management (CPM), enterprise performance management (EPM), and strategic enterprise management (SEM). It can be considered to be a type of BI tool/technique. The most significant differentiator of BPM from any other BI tools and practices is its strategy focus. BPM encompasses a closed-loop set of processes that link strategy to execution in order to optimize business performance. 2. What are the three key components of a BPM system? According to Colbert (2009), a BPM encompasses three key components. The first is a set of integrated, closed-loop management and analytic processes (supported by technology) that addresses financial as well as operational activities. The second involves tools for businesses to define strategic goals and then measure and manage performance against those goals. And the third component involves a core set of processes, including financial and operational planning, consolidation and reporting, modeling, analysis, and monitoring of key performance indicators (KPIs), linked to organizational strategy. 3. List and briefly describe the four phases of the BPM cycle. The BPM cycle contains four main phases. First is to strategize. This involves answering the question, “Where do we want to go?”, and involves a high-level, long-term plan. Missions, visions, and objectives are key components of this phase. The second phase is to plan, which answers the question, “How do we get there?” Key elements here are a detailed operational plan and a financial plan including budget. The next phase is to monitor and analyze, which answers the question, “How are we doing?” Here is where KPIs, dashboards, reporting, and analytics are helpful. Finally come action and adjustment, based on comparing our analysis results against our plans. Sometimes this means changing the way we operate, and sometimes it means adjusting our strategy