Assignment

Based on the agreed upon HR project focus, create a draft outlining ten business requirements to ensure that the team has a solid understanding of the organizations requirements and goals for a HR Data Warehouse

HR schema for a project.

- The dimensional model for the project will include the following tables:

(1) - Fact Table
(1) - Salary Dimension Table
(1) - Department Dimension Table
(1) - Employee Dimension Table
(1) - Job Dimension Table

Group 1 will work as a team to, develop a fictitious organization and business case relative to a data warehouse project. The design will be a VERY SIMPLE data warehouse schema, which consists of one FACT table and four DIMENSION tables. You will perform several software development tasks, such as developing a project plan, gathering and analyzing requirements,

Phase II: Value Proposition

Group 1 will justify the business need by determining what the gain and / or benefit will be to the company after implementing the software. Maintenance, upgrades and enhancements will also be considered.

Phase III: Installation / Conversion of Software

- Define in Detail

Phase IV: Hardware / Software Testing

Define in Detail
Phase V: Training

- Define in Detail

Phase VI: Implementation

- Define in Detail

GOALS AND OBJECTIVES

BUSINESS GOALS AND OBJECTIVES

The business goals and objectives for this project will focus on creation of a data warehouse which:

- Facilitates coordination and information sharing both internal and external to the
- Provides high levels of data security.
- Provides an open, flexible, reliable technology base for the future.
- Facilitates the electronic capture of data at its source.
- Eliminate redundant data entry throughout the organization.

PROJECT GOALS AND OBJECTIVES

Project goals and objectives:

- Ensure that end users have input into the design process.
- Accomplish project business goals / objectives within defined budget and time parameters.
- Minimize impact to standard business operations within the affected units.