9) Create visualization for your first management question.

(Note:Figures P13.3.2G (page 615) and P13.3 (page 616)

This assignment provides an opportunity to demonstrate the value of your data warehouse from Project 2 Milestones 1 and 2. It involves exporting data from your data warehouse to Excel (or Tableau or other graphing package of your choice), then using the graphing tools to create simple visualizations of your data. Simple visualizations are excellent for communicating effectively with users and managers.

Submit a picture of the visualizationembedded in your submission document followed by a short description (2-3 sentences) that explains the visualization for the intended user.

FIGURE 13.11 STAR SCHEMA FOR SALES LOCATION TIME LOC_ID TIME_ID LOC_DESCRIPTION TIME_YEAR REGION_ID TIME_QUARTER M LOC_STATE M SALES TIME_MONTH LOC_CITY TIME_ID TIME_DAY 25 records LOC_ID TIME_CLOCKTIME M CUST_ID 365 records CUSTOMER PROD_ID M CUST_ID PRODUCT SALES_QUANTITY CUST_LNAME PROD_ID SALES_PRICE CUST_FNAME SALES_TOTAL PROD_DESCRIPTION CUST_INITIAL 3,000,000 records PROD_TYPE_ID CUST_DOB Daily sales aggregates PROD_BRAND 125 records by store, customer, and PROD_COLOR product PROD_SIZE PROD_PACKAGE PROD_PRICE 3,000 recordsFIGURE 13.10 ATTRIBUTE HIERARCHIES IN MULTIDIMENSIONAL ANALYSIS Time dimension Year Quarter Month Week Total of Q1 Q2 Q3 Q4 product All products Product A Product B Product Product C By product type dimension Location hierarchy ........ Region One product Total of quarters State City Store