A significant part of your grade this semester will be the delivery of a group project. Students will be divided into teams of 2 to 4 members. Within the teams, students will work together to write a proposal for the implementation of a data mart. The proposal will be a business case study that could be presented to your management in an effort to support and justify your request for the development of the data mart. The proposal should articulate what subject(s) orientation the data mart will be built around, why you feel that a data mart would be beneficial to your organization, and what benefits you expect to derive from the implementation of the data mart.

You will also be responsible for creating such a data mart (or data warehouse) in your assigned database. Your responsibility will be to create all necessary tables, as well as to populate those tables with actual or fictitious data. Data need not be voluminous. Approximately 10-50 rows in each dimension table, and 100-200 rows in each fact table.

As part of this project, it is important to work as a group, as all students within a team will receive the same grade for the group effort. Additionally, each member of the team will also be graded independently based on the effort he/she contributed to the project. Instructor will not get involved in any group discord

Your group project is important!

    Yes, your project important, so take it seriously. That being said, the purpose of the project is to:

  1. Learn and apply critical knowledge obtained in this class.
  2. Give you the opportunity to work within a team setting to accomplish a defined goal.

Your project should include:

A project proposal write-up... And the hands-on component...