Assignment: Data Vizualization Fundamentals - Tableau (100 points) Read the brief case below. Using Tableau Desktop Profession Edition, complete the questions. I Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for busy times of the year. Instructions: Use the excle spreadheet provided and import the data to Tableau. Complete the tasks below. Upon completion you will submit this word document with your screen shots attached along with your Tableau file (.thy). 1. Open Tableau. 2. Import the excel file - Final_Orders_Clean.xlsx. 3. Create an inpecjgip between market_fact table and the rest of the tables as shown below[ Hint: Drag and drop the tables in the Data Source space] e market_fact+ (Final_Orders) market_fact Oorders_dimen O prod_dimen Oshipping_dimen 4. Double check your join statements to make sure the correct primary key and foreign keys are in place. [HINT: order_id and ad_id 5. Click on "Goto Worksheet" at the bottom to insert a blank worksheet for your questions for each question, take a screen shot of your visualization. Be sure to save your Tableau file and upload the Tableau file along with a document including your screen shots. 10 points each 1. Management wants to see how much is spent in Shipping Costs across the different Product Categories and Sub Categories for each Ship Mode. Add a new sheet titled Q1 and create the following data visualization. Required Components: 1) A table with both the Product Categories and Subcategories listed. 2) Shipping Costs for each Ship Mode. 3) Color the Shipping Costs based on the Product Subcategory. Using the same data, create a circle views chart. Do you see any outliers What are they? 2. Management is eager to know the Total Sales, Average Sales and Average Discount across the Product Categories and Sub Categories, using a color coded Bar Chart. Add a new sheet titled Q2 and create the following data Visualization. Required Components: 1) A bar chart to represent the Total Sales for each Product Subcategory. 2) Color the bar chart using Average Discount 3) Add labels to the bar chart representing average sales for each sub category. Choose another visualization to display the data. What is the difference? Is one preferred over another? 3. Historically the company has provided discounts to their Top 10 customers in terms of Profit. Using Packed Bubbles, find the Top 10 customers. Add a new sheet titled Q3 and create the following data visualization. Required Components: 1.) Use packed bubbles to display your results and list the top 10 customers. 2.) Color code the bubbles based on Cust id. 3.) Add a filter to filter and show only the Top 10 customers based on Sum of Profit 4). Display the Sust id and sum of profit amount (in S) in each bubble. 4. Management wants to see the proportion of the Base Margin by Product Category across the 3 Product Categories. Use a Pie Chart, display the split of the sum of Product Base Margin across the Categories. Add a new sheet titled Q4 and create the following data visualization. Required Components for Question 4: 1.) Use a Pie Chart to display your results. 2.) The angle of the pie chart is dependent on the sum of Product Base Margin. 3.) Label the sections of the Pie Chart with the Product Category and Sum of Product Base Margin. 4.) Change the font of the Product Base Margin to Bold and Red. 5. Management wants to compare product profit and sales by quarter. They want a quick view by each product sub category. Choose the data visualization to best represent this. Add a new sheet titled 05 and create the following data visualization. Required Components for Question 5: 1.) Use a visualization of your choice. 2.) Add labels for profit, sales, and product sub category. 3.) Add colors. 6. To make the presentation more appealing, put together your visualizations as a storyboard. Required Components for Question 6: 1.) Create a storyboard. 2.) Insert a cover page to highlight what the report is about. 3.) On each page add text to explain the visualization/findings. Assignment: Data Vizualization Fundamentals - Tableau (100 points) Read the brief case below. Using Tableau Desktop Profession Edition, complete the questions. I Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for busy times of the year. Instructions: Use the excle spreadheet provided and import the data to Tableau. Complete the tasks below. Upon completion you will submit this word document with your screen shots attached along with your Tableau file (.thy). 1. Open Tableau. 2. Import the excel file - Final_Orders_Clean.xlsx. 3. Create an inpecjgip between market_fact table and the rest of the tables as shown below[ Hint: Drag and drop the tables in the Data Source space] e market_fact+ (Final_Orders) market_fact Oorders_dimen O prod_dimen Oshipping_dimen 4. Double check your join statements to make sure the correct primary key and foreign keys are in place. [HINT: order_id and ad_id 5. Click on "Goto Worksheet" at the bottom to insert a blank worksheet for your questions for each question, take a screen shot of your visualization. Be sure to save your Tableau file and upload the Tableau file along with a document including your screen shots. 10 points each 1. Management wants to see how much is spent in Shipping Costs across the different Product Categories and Sub Categories for each Ship Mode. Add a new sheet titled Q1 and create the following data visualization. Required Components: 1) A table with both the Product Categories and Subcategories listed. 2) Shipping Costs for each Ship Mode. 3) Color the Shipping Costs based on the Product Subcategory. Using the same data, create a circle views chart. Do you see any outliers What are they? 2. Management is eager to know the Total Sales, Average Sales and Average Discount across the Product Categories and Sub Categories, using a color coded Bar Chart. Add a new sheet titled Q2 and create the following data Visualization. Required Components: 1) A bar chart to represent the Total Sales for each Product Subcategory. 2) Color the bar chart using Average Discount 3) Add labels to the bar chart representing average sales for each sub category. Choose another visualization to display the data. What is the difference? Is one preferred over another? 3. Historically the company has provided discounts to their Top 10 customers in terms of Profit. Using Packed Bubbles, find the Top 10 customers. Add a new sheet titled Q3 and create the following data visualization. Required Components: 1.) Use packed bubbles to display your results and list the top 10 customers. 2.) Color code the bubbles based on Cust id. 3.) Add a filter to filter and show only the Top 10 customers based on Sum of Profit 4). Display the Sust id and sum of profit amount (in S) in each bubble. 4. Management wants to see the proportion of the Base Margin by Product Category across the 3 Product Categories. Use a Pie Chart, display the split of the sum of Product Base Margin across the Categories. Add a new sheet titled Q4 and create the following data visualization. Required Components for Question 4: 1.) Use a Pie Chart to display your results. 2.) The angle of the pie chart is dependent on the sum of Product Base Margin. 3.) Label the sections of the Pie Chart with the Product Category and Sum of Product Base Margin. 4.) Change the font of the Product Base Margin to Bold and Red. 5. Management wants to compare product profit and sales by quarter. They want a quick view by each product sub category. Choose the data visualization to best represent this. Add a new sheet titled 05 and create the following data visualization. Required Components for Question 5: 1.) Use a visualization of your choice. 2.) Add labels for profit, sales, and product sub category. 3.) Add colors. 6. To make the presentation more appealing, put together your visualizations as a storyboard. Required Components for Question 6: 1.) Create a storyboard. 2.) Insert a cover page to highlight what the report is about. 3.) On each page add text to explain the visualization/findings