Visualizations: Part A Calculate and show (bar chart) the total sales by year an

Visualizations: Part A
Calculate and show (bar chart) the total sales by year and month for 2015 and 2014.
Which was the lowest / highest year and month? Calculate the difference of the total sales by month of 2015 from 2014. Show and describe how they compare.
Create a line chart for each of the years of sales (each year as a separate line). Describe the trends (if any).
Create a bar chart that shows the total sales by year.
Create a pivot table that shows the total sales by state and by year. Use conditional formatting visualizations to help show the differences.  
Analytical Techniques: Part B
How does 2015 compare to the previous 2 years? What are the rates of change?
What are the total sales for the “black Friday” sale of 2015? (Use Friday – Monday.) Was this a “good” black Friday sale? How do we know?
Which states / years are outliers?
Which state has grown / declined the most by total sales from 2014 to 2015?
Which state has grown / declined the most by quantity of sales from 2014 to 2015?
Calculate the average sales by state. Calculate the average sale standard deviations by state. Calculate which of the 3 states had averages that were most different from the total of all states’ average. 

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *