Description
Please follow the instructions attached below to create the files required. Please message me if you have any questions. Since I'm going to do a video explaining the project. I attached a sample of a video that someone is explaining it. So I need the same explanation of how you did it in a word so I could explain it in the video step by step please. Also keep the video as an example of the project. https://www.youtube.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Part 1) The Data
The data included sales and profit data of various cities in the different states in the United States
and included the zip code and sale dates. First I started by looking at the trends in profit and sales
per state and later decided to add cities to that analysis to finer refine the data. This showed
clearly the areas that I needed to have a closer look at and hence used the map visualizers to
clearly see the distribution at a glance. I really had a problem connecting how the various
departments and items sold to how they affected the trend and hence created a stacked bar chart
to see the values of profit per department over the years.
Part 2) Workbook Sheets
This visualization shows the sum of profits per city categorized by state represented by a
horizontal bar and sorted in descending order per state. From this visual aid, it can be ...