data warehouse set up with star schema

Project Description:

module 8: portfolio project
view grade infograde: n/a
star schema data model for student performance (350 points)

imagine that you are a senior data warehouse architect for lecal corporation. your company has been contracted by the u.s. department of education to develop a data warehouse which will track student performance on a series of planned nationwide tests as part of a new stem (science, technology, engineering, and math) initiative.

specifically, new tests will be created for the five subjects of: algebra, geometry, calculus, chemistry, and physics.

the data warehouse to be designed will produce annual average test scores for graduating seniors for each test in the five subject areas. all graduating seniors, regardless of the type of k-12 school they attended (e.g., public, private, parochial, home schooled, etc.), are to be included in the data warehouse.

the system must include all relevant courses in the students’ course history and the final course grades. prerequisite courses and grades are to be included as well. course names and numbers are non-standard among the nation’s school districts and educational institutions and tend to change from year-to-year. also, course grades are non-standard.

the reporting system for this data warehouse will produce tabular statistics and graphical color-coded charts of year-to-year progress by student’s course preparation, race, gender, special education status, esol (english speakers of other languages), and family income level. note that these demographic statuses can change for students year-to-year and even within a school year.

your portfolio project task is to prepare a proposal for a star schema data model to meet the requirements of this system. determine what dimension and fact tables will be required, what data they will contain, what data is to be collected, and how the source data is to be uniformly integrated into the data warehouse. describe the challenges, encountered or expected, with data collection, transformation, and loading that may occur. describe the challenges to keep your data model flexible enough to handle the vast number of different evolving courses.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $20 to $50
Total Proposals: 3
1 Current viewersl
114 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.5
    98 Jobs 44 Reviews
    $45 in 1 Day
  • 4.9
    669 Jobs 427 Reviews
    $50 in 2 Days
  • 4.6
    648 Jobs 468 Reviews
    $40 in 2 Days