Scribd
Upload
47 views5 pages

Sales Data Analysis and Forecasting Guide

The document outlines a series of analytical tasks related to sales data, including calculating month-on-month averages for weekdays, forecasting November closures, and analyzing fluctuations in Sign-Up Rates. It emphasizes the use of graphs and descriptive statistics for insights, while addressing data discrepancies and methods for cleaning the dataset. Key metrics such as Conversion Rate and Average Order Value are defined with specific formulas for calculation.

Uploaded by

omc.msdsm01
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
47 views5 pages

Sales Data Analysis and Forecasting Guide

The document outlines a series of analytical tasks related to sales data, including calculating month-on-month averages for weekdays, forecasting November closures, and analyzing fluctuations in Sign-Up Rates. It emphasizes the use of graphs and descriptive statistics for insights, while addressing data discrepancies and methods for cleaning the dataset. Key metrics such as Conversion Rate and Average Order Value are defined with specific formulas for calculation.

Uploaded by

omc.msdsm01
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1) Provide a view for the month-on-month average for each weekday, for any 3 relevant

sales data metrics, without using Pivot Tables.


2) What is the total expected forecast for Nov closure? Feel free to use any predictive
technique on Excel to determine this.
3) You are asked by a stake-holder if there are any fluctuations in the Sign-Up Rate and what
insights you get from the trend of the same. How would you answer that?

We can Answer using the Graph and the Descriptive statistic of this data

4) Are there any discrepencies/anomalies in the data? If yes, how would you fix or clean up the
same?

1) Find Missing Values - There is No missing


value

2) Identify Duplicates- We can not remove duplicate value, otherwise data cant make sense
5) What insights can you draw from the overall dataset?

Key Metrics Calculation:

 Conversion Rate:
o Use the formula: =C2/B2 (where C2 is Net Orders and B2 is Daily Active Users).
Drag it down to calculate the conversion rate for each day.

 Average Order Value (AOV):


o Use the formula: =E2/C2 (where E2 is Net Sales and C2 is Orders).

You might also like