Business Intelligence Review Exam 2022 Graded A+

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: 2 years ago

Preview 1 out of 6 pages