Retail data analysis

The dataset you have received is a fabricated dataset and as such has the following limitations. 

a. POS sales are a direct factor of POS units and Retail and all sales are assumed to be at full retail.

b. Returns or negative sales do not exist in this database.

c. The instock given is an average instock for each stated time period but does have some inconsistencies between L13wks and L52 weeks.

Please utilize excel to complete the below tasks, and attach your working analysis file for evaluation. Also, the following objectives must be met.

· Show the productivity of “winners” and “losers” as well as any insights into possible driving factors.

· Utilize graphs and/or charts to show case an important insight that might be lost in mere data summary.

· Explain why this insight is important to us? To Retailer? To the Customer?

· Create a list of other data points and attributes you feel would be important for a holistic analysis, be as exhaustive as you are curious.

Please submit ASAP.