1 Analyse performance data from all areas of the business In this task, you will use the 'PoS Data from Stores' time series data.

pls help me for this assessment

2.1 Analyse performance data from all areas of the business

In this task, you will use the 'PoS Data from Stores' time series data.

R 1. calculate the performance of all stores in terms of total revenue

R 2. prepare a table that summarises the performance of each store by year [2010-2015] inclusive:

·      must be in a cross-tabular format

·      consolidate the quarterly figures by year

·      show the grand totals of each store by year ([2010-2015] inclusive)

·      show the grand totals of all stores by year ([2010-2015] inclusive)

·      list the stores from the highest performing to the lowest

R 3. plot the performance trends:

·      chart 'Top 11 - highest revenue generating' stores by year

·      chart 'Bottom 11 - lowest revenue generating' stores by year

·      your visualisations must conform to the Reporting Standards

R 4. analyse these performance trends:

·      identify the three stores that generate the highest revenue

·      identify the three stores that generate the lowest revenue

·      identify the three stores with the highest overall jump

·      identify the three stores with the highest overall slump

·      compare the performance of the best and worst performing stores

R 5. write a summary based on your analyses:

·      draw insight on the success of marketing activities

·      suggest three strategies that A & A Coffee should consider to improve overall performance

·      explain how each activity would be helpful to generate more leads

R 6. word count is approximately 400 words in total.