Data warehouse

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process. Subject-Oriented: A data warehouse can be used to analyze a particular subject area.

Data Warehousing and Business Intelligence
    Data Warehouse Definition
•    Data Warehouse Architecture
    Data Warehousing Concepts
•    Dimensional Data Model
•    Star Schema
•    Snowflake Schema
•    Fact Table Granularity
•    Fact And Fact Table Types
•    Slowly Changing Dimension
•    Type 1 Slowly Changing Dimension
•    Type 2 Slowly Changing Dimension
•    Type 3 Slowly Changing Dimension
•    Conceptual Data Model
•    Logical Data Model
•    Physical Data Model
•    Conceptual, Logical, and Physical Data Model
•    Data Integrity
•    What Is OLAP
•    MOLAP, ROLAP, and HOLAP
•    Bill Inmon vs. Ralph Kimball
•    Factless Fact Table
•    Junk Dimension
•    Conformed Dimension
    Data Warehouse Design
•    Requirement Gathering
•    Physical Environment Setup
•    Data Modeling
•    ETL
•    OLAP Cube Design
•    Front End Development
•    Report Development
•    Performance Tuning
•    Query Optimization
•    Quality Assurance
•    Rollout To Production
•    Production Maintenance
•    Incremental Enhancements
    Data Warehousing Trends
•    Quick Implementation Time
•    Lack Of Collaboration with Data Mining Efforts
•    Industry Consolidation
•    How To Measure Success
•    Why Data Warehouses Fail
    Business Intelligence
•    Business Intelligence Tools
•    Business Intelligence Uses
    Business Intelligence Software
•    General Considerations
•    Database/Hardware Selection
•    ETL Tool Selection
•    OLAP Tool Selection
•    OLAP Tool Market Share
•    Reporting Tool Selection
•    Metadata Tool Selection
•    Open Source Business Intelligence
•    Data Warehouse Team Personnel Selection
    Master Data Management
    Data Warehousing Books
•    ETL Books
•    OLAP Books
•    General Books
•    Data Modeling Books
•    Business Intelligence Books
•    Vendor-Specific Books

Last modified: Wednesday, 20 July 2016, 3:06 AM