Unit 3 S15 Review Questions

731 Words3 Pages

S15 Review Questions (RQ) Business Intelligence, and Big Data Kroenke Book Chap 12 Name: __Ron Stewart____________________________________ Download the attached document and answer the Review Questions (RQ). The Review Questions (RQ) listed below can also be found in the Kroenke textbook, starting on page 526. This is NOT the entire list of Review Questions, but is a sample of 20 questions to identify the main topics in the chapter. The S15 Quiz is NOT restricted to these questions only, so all Review Questions should be studied in preparation for the Quiz and Exam 3. Please type your answer to the questions, in the space provided below. The questions selected provide information on the basic concepts for this chapter. Once you …show more content…

S15 Review Questions (RQ) Business Intelligence, and Big Data Kroenke Book Chap 12 12.1 What are BI systems? Technologies, applications, and practices for collection, integration, analysis, and presentation of business information. 12.3 Name and describe the two main categories of BI systems. Reporting Systems and Data mining. Reporting systems show activity of the company business. Data mining is used to find patterns in the company data. 12.4 What are the three sources of data for BI systems? Operational databases, acquiring data from operational databases, and purchase of data from vendors. 12.5 Explain the difference in processing between reporting and data mining applications. The reporting system has three functions, authoring, management, and delivery. It gets information from different data sources and delivers that information to users. Data mining involves mathematical statistical techniques to find relationships and patterns you can use to classify data. 12.6 Describe three reasons why direct reading of operational data is not feasible for BI applications. Slowing of database along with limited use of Bi …show more content…

It provides incremental data warehouse and Bl development. 12.17 What is a star schema? A star schema is a simple style of data mart schema. It is used to develop data warehouses and dimensional data marts. Figure 12-9 illustrates a star schema: 12.25 What do the letters RFM stand for in RFM analysis? Recency, frequency, and Monetary analysis. 12.28 What does OLAP stand for? Online Analytical Processing. 12.29 What is the distinguishing characteristic of OLAP reports? Processing complex calculations, and showing patterns from these calculations. 12.30 Define measure, dimension, and cube. MEASURE is the data used to average or sum a report. DIMENSION is a characteristic of the measure. CUBE is arrangement of measures and dimensions. 12.35 Define distributed database. A database where parts of the database are stored in multiple physical locations. 12.49 What is cloud computing? The cloud is a method of using a network of remote servers on the internet to store and process data. 12.50 What is Big Data? A term that describes the large volume of data a business deals with