Description
Using the star schema developed in Portfolio Milestone 1 - Option 1 in Module 3 and incorporating your instructor's feedback, develop and execute the SQL commands to create the tables, define the variables and their attributes, and apply the constraints to your fact and dimension tables.
Your deliverable for this Portfolio Milestone is a report containing the following information:
- Changes to your business process, business questions, and fact table grain from Module 3
- Updated version of the star schema incorporating your instructor's feedback
- Screenshot of fact and dimension tables
- Listing of SQL commands
Your paper should be three to five pages in length, organized and well-written, and in conformity with the CSU Global Writing Center (Links to an external site.).
In support of your response, cite and integrate at least one credible outside source, which can be your textbook. Place the sources in a reference page formatted in accordance with APA style. This reference page does not count toward the total page requirement. The CSU Global Library is a great place to find these resources.
Explanation & Answer
Attached.
Data Warehouse Star Schema
Data warehouse not only reports and analyze data but also is considered as the heart of
business intelligence. Data Warehouse stores both historical and current data in a central place
where analytic reports for corresponding individuals can be created. This report introduces a Star
Schema with much focus on sales evaluation and performance. I intend to add multi-layer ETL
design concepts, indexing, and partitioning to improve query execution and performance. For
quality, various correlations are analyzed among various tables and created using rigorous DQA
rules. On transition, incremental and full loading will be required in the system and data loading
will be automatic. Also, a reporting section will be implemented for customer concerns. Other
dimensions, including procurement, finance, and human resource are open for future design.
Requirement Analysis
According to table 1 below, there are interesting areas that can be used to come up with a
viable database. Sales facts are considerable, indicating that sales persons are important
individuals in the organization. They define the geographical location, customer relations,
suppliers, products and even suppliers. With this data it is possible to come up with new
performance system and make long-term reasonable judgment for better performance.
After a close look at the table and highlighting the correlations between various sources,
there is a reasonable assumption. Effective performance is determined by the number of
customers per sales...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Breakfast at Tiffanys
by Truman Capote
The Rhythm Section
by Mark Burnell
The Dispossessed
by Ursula Kroeber Le Guin
Underground A Human History of the Worlds Beneath our Feet
by Will Hunt
The Scarlet Letter
by Nathaniel Hawthorne
Tess of the DUrbervilles
by Thomas Hardy
Sharp Objects
by Gillian Flynn
The Hobbit
by J. R. R. Tolkien