(Only 5 questions) You will need to download Tableau to see the analytics architects. https://www.tableau.
- All requirements under the attach files. (Only 5 questions) You will need to download Tableau to see the https://www.tableau.com/tft/activation, then Download the latest version of Tableau
- Desktop Key: TDYF-44B5-C410-2C40-568A
- Instructions: Click on the link above and select Get Started. On the form, enter your email address for "Business email"; and under "Organization", please input the name of your school(ASU).
Analytics mindsetBig Deals For EACH of the questions in 2B, please list the question, describe your answer and also describewhat your solution is to the problem. You should require about a paragraph for each question todescribe your answer and to state your solution. Part IIb:Background:You spent time discussing the strategy with your team and came up with a series of questions to ask togain insights from company data. These are listed below.1. Redesign the operations and marketing strategy for stores in Florida and specifically target nonperforming storesa. How are the sales patterns compared with customer patterns?b. How do the sales and customers of each store-type compare?c. How are the sales of each store compared with other stores? d. Does any store have any unusual pattern in sales that could indicate an issue or opportunity?e. Does any store have any unusual pattern in the number of customers who have visited orpurchased or not purchased products at the store that could indicate an issue or opportunity?You’ve shared these questions with your analytics architects. They have provided you with some analyticsdashboards and worksheets from the data that was available using Tableau software. These aredescribed below. Note: if there is additional data that you believe would be useful to answer yourquestions but it is not included in the dashboards, assume that it is not available at this time.► Summary dashboard: provides sales and total customers (visitors to the stores) for each month in2014 and provides 2014 average monthly sales and average monthly customers by store type► Purchase price analysis: provides a tree map to show average purchase price by store type withthe upper left corner being the highest and the lower right corner being the lowest. By clicking on thestore type in the legend, all stores within that category will be highlighted for viewing.► Monthly sales by store: provides monthly sales by store along with an average and median for allstores in alphabetical order.► Store sales by product category: provides 2014 sales by product category by store Analytics mindset case studies – Big Deals© 2016 Ernst & Young Foundation (US). All Rights Reserved.SCORE No. MM4216 1 ► Annual sales by store: provides annual sales by store trending from the lowest performing stores tothe highest performing stores with an average and median for all stores.► Customer analysis dashboard: provides total customers with purchases and customers withoutpurchases by store with an average and median for all stores in alphabetical order. It also provides acircle analysis of the median of the percentage of customer purchasers to the total customers bystore type. By clicking on the store type in the legend, all stores within that category will behighlighted for viewing.Required: ► Use the Analytics_mindset_case_studies_BigDeals_florida_sales_summary.twbx file. Revieweach of the dashboards and worksheets to gain insights and prepare responses for each of thequestions that were identified. Analytical mindset case studies – Big Deals© 2016 Ernst & Young Foundation (US). All Rights Reserved.SCORE No. MM4216 2
Show more
