Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Before conducting your analysis, you will need to do some data cleaning. You may use Tableau, Python, Data Prep, Excel, or any other tool
Before conducting your analysis, you will need to do some data cleaning. You may use Tableau, Python, Data Prep, Excel, or any other tool you are comfortable with. Please make sure to fix the date and create groups that separate the US states into regions. Here is a link that explains the five generally accepted US regions: https://education.nationalgeographic.org/resource/united-states-regions/ B. Additionally, you can use Tableau, Python, Excel, or any other tool to create groups. Here is a link to help you create groups in Tableau in a straightforward manner: https://vizualintelligenceconsulting.com/blog-tableau-groups-vs-sets/B> Using Tableau and the dataset sales_records_1C.csv (in the module "Data Sets" in Canvas Decide which type of chart(s) to be used to represent the data. Explore the total sales - combining all the categories -with all five regions (that you have created - see above) - in the four years. Explore the sales of each category of products for each region (that you created - see above) within the four years. Select at least one chart for the total sales and at least one for the sales of each category for each region within the four years to visualize the data within Tableau. Capture the screenshots showing the charts you created to visualize the data. Write a report that you would give the director that discusses the business insights you can gain from the data visualization. The report should also include any other information you feel the director needs. Remember only to include the needed details and visualization in the report. If there are additional charts you would like to include as a supplement, add that as an Appendix.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started