Saturday, April 25, 2009

Project Proposal

  1. Select a Company
    1. Name
    2. Scope

  2. Gather the requirement to complete each stage. Prepare Requirement Design
    1. Physical Sources
    2. Facts and Dimensions
    3. Hierarchies
    4. Subject Areas
    5. Answers
    6. Dashboards 
  1. Functional Design
    1. Type of Business
    2. Need for OBIEE
    3. No. of Departments
    4. Existing system / Data Sources
    5. How the data moving from OLTP to OLAP
    6. What reports
    7. What Dashboards 
  1. Technical Design
    1. Data sources / Database
    2. Facts and Dimension tables

                                                              i.      At least two fact tables

                                                            ii.      At least three dimension tables

    1. Columns in each table, keys, etc.
    2. Dimension modeling / Hierarchy
    3. Field naming convention
    4. Subject Areas
    5. Reports

                                                              i.      Each report specifications

                                                            ii.      Columns

                                                          iii.      Filters

    1. Dashboards
    2. Pages
    3. Reports of each page 
  1. Develop RPD (Final RPD need to be submitted)
  2. Develop Answers/Reports
  3. Develop Dashboard and Pages
  4. Presentation

No comments:

Post a Comment