Assign the most appropriate letter to the corresponding BI question (Q1...etc).
Questions: Terms:
Q1_________ A. Data sources
Q2. _________ B. Data Mining Tools
Q3. _________ C. Independent Data Mart
Q4. _________ D. OLTP
Q5. _________ E. OLAP
Q6. _________ F. Dependent Data Mart
Q7. _________ G. Data Warehouse
Q8. _________ H. Operational Data Store
Q9. _________ I. Staging
Q10. _________ J. Operational Data Mart
Q11. _________ K. ETL
Q12. _________ L. Business Analytics Tools
Fill in the Blank Questions:(Most of these answers are terms on the previous page. Use the term not the letter.)
1. A _________ is a central repository of historical data, organized in such a way that access is easy (using a Web browser) and manipulation for decision support is convenient.
2. _________ is an umbrella term that includes architectures, tools, databases, applications, and methodologies.
3. _________ is a class of information analysis based on databases that looks for hidden patterns in a collection of data which can be used to predict future behavior.
4. _________ handle a company's routine ongoing business. These data sources are organized to quickly process transactions.
5. In contrast to the previous question, a _________ is typically a distinct system that provides a data structure that will be made use of in analysis.
6. _________ is a subset that is created directly from the data warehouse. It has the advantages of using a consistent data model and providing quality data.
7. _________ is a class of analytics tools that helps an organization align its strategy with what is happening within the operation.
8. _________ is a small data warehouse designed for a strategic business unit or a department that does not rely on the data warehouse for its content.
9. _________ is the science of analysis applied with information technology.
10. ________ is the set of processes used to get data from the data source into the data warehouse.
11. An area used to hold the data while it is being transformed and eventually loaded into the data warehouse is known as a __________ area.
12. While data warehouses are loaded on a scheduled basis, __________ holds operational data that is more current than in the data warehouse.
13. _________ are the OLTP databases and other data that are eventually loaded into the data warehouse.
Essay Questions:
Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and purpose.
Explain the ETL process in two or more paragraphs. Be sure to include the definition of ETL, what happens in each stage and what the final result is. Be sure to spend a significant amount of effort explaining the T stage.
Discuss business analytics and data mining tools including the purpose of each and what an organization is attempting to accomplish with each in two to three paragraphs.