Data Ware Project Documentation Template - Free Download | Page 5
4.1, 3006 votes
Please vote for this template if it helps you.
Scope should be defined by the Business Owner. A scope statement should be created and reviewed and signed
off by all core team members.
Once the project scope has been defined and agreed upon, the Business Owner will create an inventory of the data
elements and reports required to support the defined scope. The Business Owner should try to identify the source
system and data domains as well as the needs and the gaps of the project.
Review all of the data elements and the reports. Engage in detailed discussions to profile the data and determine
the business rules around the data. Identify any data issues, challenges and try to identify any risks. Document
and define the business and data requirements in the Business Requirements Document. Determine the security
requirements as well; who should be able to view the data, and who should not.
The Business Requirements document should be reviewed and signed off by the core team so everyone is aware of
the actual requirements.
Develop the Conceptual Data Design, the Logical Models, the Security structure, and the BOE layout.
Construct the physical database structures, and load sample data. Build the BO Universe prototype, (note: this
step skips a mature ETL step).
Validate the data model with the customer by visually displaying the model in BO. Determine if the model works
as expected, it comprises all of the required data. Review the BO Universe layout, design and data quality with the
customer to ensure if meets their expectations.
This is validation is strictly for the design of the data model, and not the actual data. The data will be validated
during User Acceptance Testing (UAT)
If the prototype did not get approved by the customer, go back to the Analyze step to ensure there is a common
understanding on the business requirements. Follow the next steps in sequence until the Prototype has been
validated by the customer; Analyze, Design, Prototype, Prototype Validation.
Business Definition and Data Source