Final Exam – Focus Areas Chapter 9 Business Intelligence (BI) Systems – are information systems that process operational and other data to analyze past performances and to make predictions. The patterns, relationships, and trends identified by BI systems are called business intelligence (page 247). 1) ________ process operational and other data in organizations to analyze past performance and make predictions. A) Virtualization techniques B) Live migration technique C) Business intelligence systems D) Windowing systems Question 1) Straight Term (BI) Three primary activities of BI – [page 249]. 1. Acquire data – obtaining, cleaning, organizing, relating and cataloging source data 2. Perform analysis – reporting, data mining and BigData 3. Publish results – print, web servers, report servers and automation a. Push publishing – delivers business intelligence to users without any request from the user b. Pull publishing – requires the user to request BI results Data Warehouse – a facility for managing an organization’s BI data [page 255]. The functions of a data warehouse are to: Question 2) Straight Term for Data Warehouse 2) A ________ is a facility for managing an organization's business intelligence data. A) datasheet B) dataspace C) data warehouse D) data table ● Obtain data ● Cleanse data ● Organize and relate data ● Catalog data Problems with Operational Data – [page 256] Question 3) What is the problem with source data? A B C D E All of the above ● Dirty data – e.g. a value of “B” for customer gender, a value of “213” for customer age ● Missing values ● Inconsistent data ● Data not integrated ● Wrong granularity – the level of detail represented by the data – e.g. customer’s browsing history may be useful but overwhelming if you wanted to know something specific like an ad located differently on the screen ● Too much data (too many attributes or data points)
Question 4) If it was the accounting department? Answer: DATA MARTS A ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular an ACCOUNTING department. A) data mart B) data room C) datasheet D) dataspace Data Marts – is a data collection, smaller than the data warehouse, that addresses the needs of a particular department or functional area of the business [page 258]. Data Mining – is the application of statistical techniques to find patterns and relationships among data for classification and prediction. Data mining techniques emerged from the combined discipline of statistics, mathematics, artificial intelligence, and machine learning [page 259]. Question 5) What uses statistical and mathematical techniques to find patterns? Answer: DATA MINING 5) ________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.
You've reached the end of your free preview.
Want to read all 9 pages?