This assignment uses a GCU-provided virtual machine.

Note: This assignment will be used as the basis for an assignment in Topic 6.

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” document to complete the assignment.

Review the “Dimensional Schema” video within the “Video Playlist: Relational Databases for Business Applications,” located in the topic Resources.

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 Mountain King within the Chicagoland region for the 1st quarter of 2024.
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

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.