Reference no: EM13974329
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.
|
Loan and the cash from savings
: Using the payback method, determine the length of time that will be required to recoup the $400,000 investment in the new facility.
|
|
What is the entry-level education for the examples provided
: Overall, what is the salary range for people who have a background in mathematics?
|
|
Calculate each project payback period
: If the two projects are independent of each other, which projects, if any, should be selected? Explain why or why not. If the two projects are mutually exclusive, which project, if any, should be selected? Explain why.
|
|
Earnings after a six-week waiting period
: Gene, an assembly line worker, has take-home pay of $900 a week. He is injured in an accident that kept him off work for 18 weeks. His disability insurance coverage replaces 65% of his earnings after a six-week waiting period.
|
|
Discuss business analytics and data mining tools
: Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and purpose - Discuss business analytics and data mining tools including the purpose of each and what an organization is attempting to accomplish with..
|
|
Depreciation related to the equipment
: Greengage Ltd is considering to buy a main equipment to increase the company's production capacity. The equipment is expected to have a four year useful life. The capital outlay and annual net income after depreciation related to the equipment are..
|
|
Significant failures in their selection of capital projects
: Synthesize your one-paragraph position on what 3-5 specific factors you believe most likely to contribute to capital project analysis failure.
|
|
Define supply chain management in business operations
: An explanation of the general relationship that supply chain management has to any type of business operations and what do you feel could be some of the concerns (if any) with supply chain management when managing global business operations.
|
|
Describe the hypothesis stated by the author
: Describe the hypothesis/hypotheses stated by the author(s) (or objective if hypothesis not stated). Describe the study design. A. Who were study participants? B. Describe the exclusion criteria, if any.
|