Site Map

Data Warehousing > Site Map

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

Glossary

Site Map

Resources

---

Copyright © 2022   1keydata.com   All Rights Reserved     Privacy Policy   About   Contact

• Data Warehouse
• Data Warehouse Definition
• Data Warehousing Concepts
• Data Warehouse Design
• Data Warehousing Trends
• Business Intelligence
• Business Intelligence Software
• Business Intelligence Conferences
• Master Data Management
• Data Warehousing Books
• Glossary
• Site Map
• Resources
•  
• SQL Tutorial