Data Modeling for Decision Support Systems
Duration: 2-day (full course) or 1-day (reduced version)
Seminar Overview
This in-depth, technical course teaches the fundamental concepts for modeling a data warehouse, operational data store, and a data mart using both 3rd normal form, multi-dimensional (star schema and snowflake) modeling, and object techniques. Also, hands-on workshops are used to transform end users' requirements into physical data warehouse/data mart models.
Benefits To Your Company
- Learn how to construct logical and physical decision support data models.
- Understand how to building multi-dimensional models (star and snowflake).
- Construct data models that are flexible to changing data warehouse and data mart requirements.
Who Should Attend & What You Will Learn
Database Designers will learn to…
- Identify the key business data necessary to store in the physical data models in order for the data warehouse to provide value to its end users.
Lead Designers and Business Analysts will learn how to…
- Design attainable requirements for the data warehouse.
- Understand how to create e-Business solutions that deliver value.
Seminar Outline
- Understanding Decision Support
- Data Warehouse
- Data Mart
- Operational Data Store
- Building normalized, multi-dimensional, and object models
- Requirements definition
- Understand how to work with business users to build the data model
- Logical data modeling
- Transforming the logical model into a physical data warehouse or data mart model
