1. Database Design
    1. Determine the priority of subject areas.
      1. Define priority of data marts.
      2. Define Dimensions for initial data mart.
    2. Implement Business Rules For Dimensions.
    3. Define Model Hierarchy.

       

    4. Implement Dimensional Attributes.
      1. Implement meta data definitions.
      2. Design dimension tables.
      3. Review SQL scripts for dimension table creation.
    5. Determine Fact Table Grain.
      1. Review query requirements.
      2. Calculate performance of most complex queries.
      3. Define look-up table requirements.
      4. Determine potential performance issues and bottlenecks.
      5. Determine fact table partitions.
    6. Implement Fact Table(s)
      1. Implement meta data definitions.
      2. Implement fact table metrics.
      3. Ensure relational integrity between fact table and dimension tables.
      4. Review fact table SQL scripts for table creation.
    7. Define Load Strategy.
    8. Review Model With Business Users.
      1. Ensure integrity of model.
      2. Ensure business process is being followed.
      3. Ensure semantics are accurate.
      4. Discuss any limitations.
      5. Discuss changes and expected results of implementing changes.
    9. Implement Changes to Model.
    10. Review Model With Users.
      1. Implement any necessary changes to model.
    11. Determine Indexes.
      1. Define indexes in model schema.
    12. Implement Model DDL and indexes in database.