Before conducting your analysis, you will need to do some data cleaning. You may use Tableau,...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647ff3b0c3b9_4266647ff3adaebb.jpg)
Transcribed Image Text:
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. 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.
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Identify the accounting periods relating to the following periods of account: (a) year to 30 November 2020 (b) 1 October 2019 to 31 July 2020 (c) 1 January 2021 to 31 January 2021 (d) 33 months to 31...
-
Race One Motors is an Indonesian car manufacturer At its largest manufacturing facility, in Jakarta, the company produces subcomponents at a rate of 300 per day, and it uses these subcomponents at a...
-
Rather, any prejudice that the jury may have harbored was due to Wal-Marts initial refusal to produce evidence of or admit the evidence of the grease spill. Rice, Justice Facts: Holly Averyt, a...
-
Rockys Automotive specializes in performing automobile safety checks. After the companys first year of operations, its accountant prepared the following summarized data report for the safety checks...
-
JED Capital Inc. makes investments in trading securities. Selected income statement items for the years ended December 31, 2014 and 2015, plus selected items from comparative balance sheets, are...
-
What is the role of ethics in treatment of workers in the modern logistics sector? Provide a specific example.
-
For the loading scenario shown, P = P2 = 100N. Lengths shown are in meters. The beam is simply supported. A (m) 0 3. Question 4 of 4 Write the equation for M as a function of x between 0 and 3m 7....
-
Explain the "bottom line" on the meaning of the Bayh-Dole Act to research institutions. In what ways do you think the Act influenced the spirit of entrepreneurship at college campuses?
-
Has the Sarbanes-Oxley Act "fixed" the problems with transparency in providing financial statements to the general public? Why or why not? Analyze a situation from the cur- rent press where the act...
-
Maas and Leauby [9] describe concept maps as a "planning tool". Explain how this can be applied to your classroom learning of finance and accounting.
-
How is stock price set at the time of company formation? What are the key factors that influence stock price pre-IPO? What dominates stock price post-IPO? How are changes in the market price of stock...
-
It seems that the idea of "putting money at risk" would apply to both the concepts of investing and gambling. Why is there such a difference in the public perception of the value of the two ideas?...
-
If ABCD is a cyclic quadrilateral such that 3 tan A +4 = 0 and 13 cos B+ 5 = 0, then a quadratic equation whose roots are tan C and tan D, is (A) 15x2-56x + 48 = 0 (B) x2-18x + 1 = 0 (C) 12x2-17x-29...
-
The following exercises are not grouped by type. Solve each equation. x610x -9
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App