Home Assignment 2 Total Factors: 100
Due Date: By 11:30 PM on March eight, 2022 Based mostly on the info offered in D2L (USA.xlsx), present govt crew with visualized knowledge to Help them with decision-making. [Please submit the link of your tableau dashboard not the complete tableau file. Please review the lecture video on how to create this link.] Government Overview
1. Establish Key measures and supply combination values for every of them 2. Create and calculate profitability KPI; present the contribution of every product line for the
generated revenue three. Establish the profitability of the corporate throughout completely different states of the nation; are they
above the benchmark? four. How is every product line performing when it comes to the gross sales?
Worthwhile Merchandise: Discover essentially the most worthwhile merchandise bought by the group
5. Discover the merchandise which can be excessive in gross sales amount and worthwhile to the corporate 6. Evaluate all of the merchandise primarily based on profitability KPI and the variety of portions bought by
the corporate 7. Discover the product that gives excessive revenue quantity regardless of revenue ratio
Goal Market/Prospects Utilizing essentially the most worthwhile merchandise knowledge, establish goal buyer profiles/market utilizing the attributes accessible to us in regards to the prospects
eight. Marital Standing 9. Gender 10. Age group/era, and 11. Commute distance
GRADING: Your grades might be primarily based on the next standards:
• Visualization shows solutions to at the least 7 (out of 11) questions [45] • Interactive Dashboards are created (should embrace actions and filters) [50] • Clarify every visualization you’ve got created [5]
