The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
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 inthe 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 assignment 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.
I just want to know what the Star schema should look like, because course history and course pre requisites don’t seem to fit the grain of the fact table and when I account for them the schema becomes a normalized snow flake schema, so I was wondering if I should create a second star schema and if so what would it look like?
Show more
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more