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 organ
...
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]
