Computer Science > EXAM REVIEW > Business Intelligence Review Exam 2022 With complete solution (All)

Business Intelligence Review Exam 2022 With complete solution

Document Content and Description Below

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

Reviews( 0 )

Recommended For You

 Business Research> EXAM REVIEW > Business Intelligence Review Exam 2022 Graded A+ (All)

preview
Business Intelligence Review Exam 2022 Graded A+

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 Nancylect , Uploaded: Aug 11, 2022

$10

 Health Care> EXAM REVIEW > NHA CCMA EXAM REVIEW 2022 Chief Complaint (With complete solution) (All)

preview
NHA CCMA EXAM REVIEW 2022 Chief Complaint (With complete solution)

NHA CCMA EXAM REVIEW 2022 Chief Complaint (With complete solution)NHA CCMA EXAM REVIEW 2022 Chief Complaint (With complete solution)NHA CCMA EXAM REVIEW 2022 Chief Complaint (With complete solution)NH...

By Otieno , Uploaded: Aug 03, 2022

$15

 Health Care> EXAM REVIEW > 2022 DOT: Comprehensive Review for NRCME Exam | with COMPLETE SOLUTION (All)

preview
2022 DOT: Comprehensive Review for NRCME Exam | with COMPLETE SOLUTION

Corrective lenses that are prohibited by the FMCSA, including: - ✔✔lenses that correct distance vision in one eye and near vision in the other. telescopic lenses Medical guidelines for the driver w...

By Tessa , Uploaded: Jul 16, 2022

$10

 Social Sciences> EXAM REVIEW > NMAT Reviewer: Social Science Section with COMPLETE SOLUTION | 143 Questions with 100% Correct Answers (All)

preview
NMAT Reviewer: Social Science Section with COMPLETE SOLUTION | 143 Questions with 100% Correct Answers

What do you call the historical, economic, social, and cultural factors that influence mental processes and behavior? - ✔✔Context *Everything that people think, say, and do is affected and influence...

By Tessa , Uploaded: Jun 26, 2022

$10

 Health Care> EXAM REVIEW > NBME Review, UWorld Review (1875 Questions with 100% Correct Answers) 181 Pages with COMPLETE SOLUTION (All)

preview
NBME Review, UWorld Review (1875 Questions with 100% Correct Answers) 181 Pages with COMPLETE SOLUTION

What can be associated with gastric cancer at the gastroesophageal junction? - ✔✔H. pylori What is esophagitis with linear ulcers associated with? - ✔✔CMV What is esophagitis with "punched-out" ulce...

By Tessa , Uploaded: Jun 16, 2022

$12

 Medical Studies> EXAM REVIEW > CMAA Certification Test Review 2022 with COMPLETE SOLUTION (All)

preview
CMAA Certification Test Review 2022 with COMPLETE SOLUTION

CMAA Certification Test Review 2022 with COMPLETE SOLUTION Which of the following types of referrals is used in an emergent situation? - ✔✔STAT Which of the following schedules more than one patien...

By AMAZING GRACE , Uploaded: Jun 09, 2022

$10

 Medical Studies> EXAM REVIEW > CMAA Certification Test Review 2022 with COMPLETE SOLUTION Which of the following types of referrals is used in an emergent situation? - ✔✔STAT Which of the following schedules more than one patient at the same time with the same provider while still allowing adequate time within the hour to see all scheduled patients? - ✔✔Wave booking Which of the following is an OSHA regulation that must be reviewed yearly to ensure compliance? - ✔✔Blood borne pathogens standard Which of the following methods organizes patient records in chronological order according to the department that provided the care? - ✔✔SOMR An older adult patient presents to a physician's office with his adult daughter to clarify when to take his new medication. Which of the following actions should the medical administrative assistant take? - ✔✔Advise the daughter and patient that the physician will speak to them about the prescription For medical billing purposes, which of the following is good practice when updating information from established patients? - ✔✔Request verification of current patient information at each visit Once a physician signs advance directives, the medical administrative assistant should have which of the following witness the signature? - ✔✔Non-affiliated individual Which of the following prefixes means "masculine"? - ✔✔AndrAn office manager asks a medical administrative assistant to mail a letter to a patient who is being dismissed from the practice. Which of the following methods should the assistant use to mail the letter? - ✔✔Certified Mail (All)

preview
CMAA Certification Test Review 2022 with COMPLETE SOLUTION Which of the following types of referrals is used in an emergent situation? - ✔✔STAT Which of the following schedules more than one patient at the same time with the same provider while still allowing adequate time within the hour to see all scheduled patients? - ✔✔Wave booking Which of the following is an OSHA regulation that must be reviewed yearly to ensure compliance? - ✔✔Blood borne pathogens standard Which of the following methods organizes patient records in chronological order according to the department that provided the care? - ✔✔SOMR An older adult patient presents to a physician's office with his adult daughter to clarify when to take his new medication. Which of the following actions should the medical administrative assistant take? - ✔✔Advise the daughter and patient that the physician will speak to them about the prescription For medical billing purposes, which of the following is good practice when updating information from established patients? - ✔✔Request verification of current patient information at each visit Once a physician signs advance directives, the medical administrative assistant should have which of the following witness the signature? - ✔✔Non-affiliated individual Which of the following prefixes means "masculine"? - ✔✔AndrAn office manager asks a medical administrative assistant to mail a letter to a patient who is being dismissed from the practice. Which of the following methods should the assistant use to mail the letter? - ✔✔Certified Mail

CMAA Certification Test Review 2022- Practice #122 Questions with Complete Solution Which of the following types of referrals is used in an emergent situation? - ✔✔STAT Which of the following sche...

By AMAZING GRACE , Uploaded: Jun 09, 2022

$10

 Medical Studies> EXAM REVIEW > CMAA Review Practice Test (#1 & #2 ) 2022 – with COMPLETE SOLUTION (All)

preview
CMAA Review Practice Test (#1 & #2 ) 2022 – with COMPLETE SOLUTION

CMAA Review Practice Test (#1 & #2 ) 2022 – with COMPLETE SOLUTION Entries in the medical record should be made with: A. Yellow Highlighter B. A #2 pencil C. Black pen D. Black Sharpie Marker -...

By AMAZING GRACE , Uploaded: Jun 09, 2022

$10

 Health Care> EXAM REVIEW > Ultrasound Vascular Registry Exam Review with COMPLETE SOLUTION (All)

preview
Ultrasound Vascular Registry Exam Review with COMPLETE SOLUTION

What is the first branch of the aortic arch? - ✔✔Innominate artery/ Brachiocephalic Name the three branches of the aortic arch? - ✔✔a. Innominate artery/ Brachiocephalic b. Lt CCA c. Lt Subclavian...

By Tessa , Uploaded: May 28, 2022

$10

 *NURSING> EXAM REVIEW > NHA PCT – Review Exam 2022 (All)

preview
NHA PCT – Review Exam 2022

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

$10.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
54
0

Document information


Connected school, study & course



About the document


Uploaded On

Aug 11, 2022

Number of pages

6

Written in

Seller


seller-icon
MARKALLAN

Member since 1 year

55 Documents Sold


Additional information

This document has been written for:

Uploaded

Aug 11, 2022

Downloads

 0

Views

 54

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

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.

custom preview

Get the best grades

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

custom preview

Earn from your notes

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.


$10.00

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

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 are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·