Business Research > EXAM REVIEW > Business Intelligence Review Exam 2022 Graded A+ (All)
What's the most important thing about a Data Warehouse? - ANSWER It becomes a single version of truth for a company. What is a 'data warehouse'? - ANSWER A physical repository where relational data... are specially organized to provide enterprise-wide, cleansed data in a standardized format What does a data warehouse do? (3 Key Terms) - ANSWER "The data warehouse is a collection of integrated, subject-oriented databases designed to support DSS functions, where each unit of data is non-volatile and relevant to some moment in time" What is relational data? - ANSWER Used in data warehouses. For example, in UKH terms, a FSC has rates and J-codes. A CMP list links J-codes to rev codes or DRGs. Therefore, two totally different systems/processes/servers (CMP v FSC) can read each other and collaborate. What is a data mart? - ANSWER A departmental small-scale "Data warehouse" that stores only limited/relevant data Dependent Data Mart - ANSWER A subset that is created directly from a data warehouse Independent Data Mart - ANSWER A small data warehouse designed for a strategic business unit or a department. Operational Data Stores (ODS) - ANSWER A database often used as an interim area for a data warehouse. Oper Marts - ANSWER An OPERational data MART Enterprise Data Warehouse (EDW) - ANSWER A data warehouse for the entire enterprise Meta Data - ANSWER Data about data. It describes the contents of a data warehouse and the manner of its acquisition and use. Data Warehouse Framework (30,000FT) - ANSWER Data Sources -> ETL Process (IMPORTANT, Acct No vs Customer No, etc) -> [ACCESS START] Enterprise Data Warehouse (Meta is used to find data inside of the warehouse) -> Data marts (if applicable, per individual department [ACCESS END] -> Applications and visualization Types of data sources that feed a DW - ANSWER ERP, Legacy, POS, Other OLTP/wEB, External Data ETL Process States - ANSWER Select, Extract, Transform, Integrate, Load Typical types of Applications/visualization - ANSWER Routine reports, data/text mining, OLAP, dashboards, web reports, custom applications (Tableau) 10 factors that potentially affect the architecture selection design - ANSWER Information interdependence between organizational units Upper management's information needs Urgency of need for a data warehouse Nature of end-user tasks Constraints on resources Strategic view of the data warehouse prior to implementation Compatibility with existing systems Perceived ability of the in-house IT staff Technical issues Social/political factors What does ETL stand for? - ANSWER EXTRACT the data. TRANSFoRM the data into useful information (via relational data), LOAD it into a system for use! What is data integration? - ANSWER Integration that comprises three major processes: Data access, data federation and change capture. What is EAI? - ANSWER Enterprise Application Integration: A technology that provides a vehicle for pushing data from source systems into a data warehouse. What is EII? - ANSWER Enterprise Information Integration: An evolving tool space that promises real-time integration from a variety of sources, such as multidimensional databases, web services, etc. Data Integration and the Extraction, Transformation, and Load (ETL) Process - ANSWER 1. [Packaged application data , legacy system data, other internal app data] -> 2. Transient Data source [Extract, transform, cleanse, load] -> 3. Into a data warehouse, or data mart What is OLTP? - ANSWER OnLine Transaction Processing. Live data. online transaction processing. Focus is on efficiency of routine tasks. What is OLAP? - ANSWER OnLine Analytical Processing. Converts data to information for decision support. What factors can cause failure in data warehouses? (8) - ANSWER Lack of executive sponsorship Unclear business objectives Cultural issues being ignored Change management Unrealistic expectations Inappropriate architecture Low data quality / missing information Loading data just because it is available Factors that affect scalability for a data warehouse: - ANSWER The amount data in a warehouse, how quickly the DW is expected to grow, the number of users, the complexity of the user queries. What is the definition of good scalability? - ANSWER Good scalability means that queries and other data-access functions will grow linearly with the size of the warehouse "If it can't be measured... - ANSWER it can't be managed." Actionable Insight Definition - ANSWER is a term in data analytics and big data for information that can be acted upon or information that gives enough insight into the future that the actions that should be taken become clear for decision makers. Disciplines involved in data mining... - ANSWER Statistics, AI, MIS / Management Science Systems What are the relationships when disciplines of data meet? - ANSWER Pattern recognition, mathematical modeling, machine learning, Das What happens when different disciplines meet up? - ANSWER Data mining, at it's best. It takes a team, not just one person or one source. [Show More]
Last updated: 1 year ago
Preview 1 out of 6 pages
Computer Science> EXAM REVIEW > Business Intelligence Review Exam 2022 With complete solution (All)
What's the most important thing about a Data Warehouse? - ANSWER It becomes a single version of truth for a company. What is a 'data warehouse'? - ANSWER A physical repository where relational data...
By MARKALLAN , Uploaded: Aug 11, 2022
$10
*NURSING> EXAM REVIEW > NHA PCT – Review Exam 2022 (All)
NHA PCT – Review Exam 2022-Which of the following abnormalities is associated with large U waves on the EKG - A decreased potassium level cause U waves to become visible on the EKKG A patient car...
By PROF , Uploaded: Apr 20, 2022
$13.5
*NURSING> EXAM REVIEW > NURS 6501 Midterm Exam Review Guide (Weeks 1-6. Compilation in 99 Pages) (All)
Nurs 6501 Midterm Exam Review Guide (Weeks 1-6) Cellular Processes and the Genetic Environment 1. Describe cellular processes and alterations within cellular processes. 2. What is the impact of t...
By SuperSolutions© , Uploaded: Nov 24, 2020
$15
*NURSING> EXAM REVIEW > NUR2063 / NUR 2063 Essentials of Pathophysiology Exam Review Latest Update Rasmussen College (All)
NUR 2063 Essentials of Pathophysiology Exam Review 1. A potentially lethal condition in which there is an acute elevation of circulating thyroid hormones is called _______________ - ANS: Thy...
By quiz_bit , Uploaded: Oct 28, 2020
$12
*NURSING> EXAM REVIEW > Multidimensional Care (MDC) 1 MDC EXAM 2 REVIEW -. (Rasmussen College) (All)
MDC EXAM 2 REVIEW 11:19:19 1. The effects of Immobility a) Interventions that improve flexibility • P.R.E.P.(Perform passive ROM, Reposition Q2HR, Encourage independent activity as much as possible...
By SuperSolutions© , Uploaded: Dec 11, 2020
$11
*NURSING> EXAM REVIEW > NUR 2356 / NUR2356 Multidimensional Care I (MDC I) Exam 2 Review. Rasmusssen College (All)
1. What is a function of the musculoskeletal system? -Assist with movement 2. As a nurse you know that during aging, a normal musculoskeletal change would be? -A patient that came to the cli...
By nurse_steph , Uploaded: Nov 15, 2020
$11
*NURSING> EXAM REVIEW > NR566 / NR 566 Advanced Pharmacology for Care of the Family Final Exam Week 5 Review (Graded A) Chamberlain College of Nursing (All)
NR-566 Advanced Pharmacology for Care of the Family Final Exam Week 5 Review 1. What therapy and its dose is started within 48 hours of a TIA or ischemic stroke? - 2. Causes of sickling / S...
By quiz_bit , Uploaded: Oct 08, 2020
$9
*NURSING> EXAM REVIEW > NUR 2063 / NUR2063 Essentials of Pathophysiology Final Exam Review Modules 1 & 2 & 3 Latest Update Rasmussen (All)
Modules 1 & 2 & 3 Essentials of Pathophysiology Final Exam Review
By quiz_bit , Uploaded: Nov 02, 2020
$15
*NURSING> EXAM REVIEW > NURS 6501 / NURS6501 Advanced Pathophysiology - Module 8 Knowledge Check (Latest Update) Walden University (All)
Review Test Submission: Module 8 Knowledge Check
By quiz_bit , Uploaded: Jan 13, 2021
$9.5
*NURSING> EXAM REVIEW > NR566 / NR 566 Advanced Pharmacology for Care of the Family Week 3 Quiz Study Guide . (Graded A) Chamberlain College of Nursing (All)
NR-566 Advanced Pharmacology for Care of the Family Week 3 Quiz Study Guide If a patient is taking an ACEI and develops a persistent dry cough, what should the provider do? Which cl...
By quiz_bit , Uploaded: Oct 08, 2020
$15
Connected school, study & course
About the document
Uploaded On
Aug 11, 2022
Number of pages
6
Written in
This document has been written for:
Uploaded
Aug 11, 2022
Downloads
0
Views
20
Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students
Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.
Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality
Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·