- Select a Company
- Name
- Scope
- Gather the requirement to complete each stage. Prepare Requirement Design
- Physical Sources
- Facts and Dimensions
- Hierarchies
- Subject Areas
- Answers
- Dashboards
- Functional Design
- Type of Business
- Need for OBIEE
- No. of Departments
- Existing system / Data Sources
- How the data moving from OLTP to OLAP
- What reports
- What Dashboards
- Technical Design
- Data sources / Database
- Facts and Dimension tables
i. At least two fact tables
ii. At least three dimension tables
- Columns in each table, keys, etc.
- Dimension modeling / Hierarchy
- Field naming convention
- Subject Areas
- Reports
i. Each report specifications
ii. Columns
iii. Filters
- Dashboards
- Pages
- Reports of each page
- Develop RPD (Final RPD need to be submitted)
- Develop Answers/Reports
- Develop Dashboard and Pages
- Presentation