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'? -
... [Show More] 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. [Show Less]