Designing a dimensional (star) model involves considering which dimensions to use with the Fact table representing the chosen subject. The goal of this part is to design a dimensional (star) model for a data warehouse that enables analysis of sales by Product, Customer, Store, and Date.
For this assignment, refer to the “SYM-408 Dimensional Diagram” (attached below) document to complete the assignment.
Design a dimensional (star) model and include the following:
1. Design the Dimensions and the Fact.
2. Take a screenshot showing your Dimensions and Fact.
3. Load the Dimensions and the Fact with relevant data from the operational database you designed in Step 1 above, making sure to capture all of the queries.
4. Take a screenshot(s) to show that all relevant data has been loaded.
5. Write a query in SQL to get the quantities of the sold products on Wednesday in the category Footwear provided by vendor Pacific Gear within the tri-state region between the 1st and the 2nd quarter of 2013.
6. Take a screenshot showing the query and the results.
7. In a succinct paragraph, explain how the ability to obtain information like that discovered in the above query could guide critical business decisions.
Submit the following in a single document compatible with the digital classroom (e.g., Microsoft Word). Include a one-line description above each screenshot.
· Screenshot showing Dimensions and Fact
· Screenshot(s) showing all relevant data loaded
· Screenshot(s) showing query and results of query
· Paragraph explaining how queries like this could guide critical business decisions
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Expand All Rubric CriteriaExpand All
Dimensions and Fact
Loads Dimensions and Fact with Relevant Data
Query in SQL
Explains How the SQL Query Can Guide Critical Business Decisions
Mechanics of Writing
Solid Academic Writing and Documentation
SYM-408 Dimensional Diagram
Is this the question you were looking for? Place your Order Here
DO YOU NEED HELP WITH THIS ASSIGNMENT ?
At LindasHelp.com , I can take care of all your academic needs including your individual & learning team papers & power points, your Accounting, Finance, Math and QNT labs, sheets, quizzes, discussion questions and Final exams. All the work I complete for you is guaranteed to be 100% original, plagiarism free, edited, APA formatted and just ready for you to add your name on it.