The reports above show the average sales and profit of a business over a 4 year period.

It outlines the performance of the business highlighting the top 5 (highest performing) and bottom 5 (lowest performing) cities in which the business is located and the most frequently used ship modes by product category over a 4 year period.

  • While the first report gives the general overview of average sales, it tells that the business experienced the lowest sales point in January, the steepest deep in February and the total highest sales in March, all in 2014. From then on there was a decline up until June and September.

  • The pattern of increased sales for each year is in January and March and deeps in February except in 2016. there happens to be increased sales towards the end of the years without any particular patterns around the months of August, September and October in 2014,16 and 17 in no specific pattern.

  • In 2014, second class ship mode recorded the highest use, while same day ship mode was lowest in the same year.

  • Jamestown recorded the highest average sales and Abilene the lowest in these years.


The second report is filtered to show the average profit of office supplies in the month of March in the entire four year period of this business.

  • The report shows the highest average profit in March in the 4 year period in 2015, there is a correlation with the profit from ship mode also being the highest in the same year.

  • Atlanta ranks as the city with the highest average profit while Bryan is the lowest.