Intro

As part of Vivo Data Analytics screening, I was handed an simulated Excel Data and was challenged to provide Sales Insight, the Data consist of 2 main tables, first is a time series of April Sales, the second is sales summary of multiple models through different distribution channels. (April Data does not contain Channels information)

A look at the data after preprocessing:

April TimeSeries







First Quarter







April Analysis

As we can see from the chart bellow, sales was higher at the beginning of April and during the last 2 days. FF Model accounted for 38% of Total Sales



( Is further analysis required?)



First Quarter

The Bar-Graph bellow shows the total quantity sold in the first Quarter, February Had a huge spike in the sold quantities which positively correlates with Sales-Through of 30 per Model.

Table

Per Channel

Per Model







Expansion

The chart Bellow shows that that quantities were high in Feb regardless of the expansion, in order to provide accurate studies a larger data containing previous years data is required.

Turn Over

In order to Provide a TurnOver Analysis I need it to be first explained,

Is this the correct calculation ??

\[TurnOverRatio=\frac{\sum SellOut}{\sum SellThrough}???\]





Incentive Analysis

The table provided for the incentive analysis need a little explanation.

Is The Data Provided is the Price per Model ? if yes then there will be a huge price gap between the models, Price data is necessary to carry on with the analysis.