0% found this document useful (0 votes)
8 views51 pages

Monthly Sales Analysis and Insights

Uploaded by

kayciliusgaming
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views51 pages

Monthly Sales Analysis and Insights

Uploaded by

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

(empty)

Overall Sales of the Month

Sum of Final Price

12
10
8
6
4
2
0
Total
12
10
8 Sum of Final Price
6
4
2
0
Average Sales per Transaction, Highest Sale Order, Lowest Sales Order /

Data
Average of Final Price Min of Final Price Average of Final Price
owest Sales Order / Transaction
No of Sales, Overall Sales, Average Sales of Each Agent

(empty)
ent
No of Sales, Overall Sales, Average Sales of Each Agent along with Onli
ent along with Online and Offline transactions
Overall Sales for each product - Highest to Lowest sales by Product
duct
Overall Sales for each product - Only if the product is Crispy
Overall Sales for each product - Only if the sale value is over 10000
000
Overall Sales, Average Sales of Each Product but Only when the Order was placed
he Order was placed Online
Overall Sales for each day of the Month
Overall Sales for each day of the Month and also the Customer Satisfaction for Each
Satisfaction for Each day of the month
Top 3 Products & Bottom 3 Products in terms of the Overall Sales, but include the C
es, but include the Customer Satisfaction
Group the Rating of the Customers into 3 categories and find the sales for each of th
Highly Satisfaction - 8 and above
Neutral - 4 to 8
Poor Satisfaction - less than 4
e sales for each of that category
Group the Sale Dates into Week and Find the sales for Each Week
ek
Group the Products Into Cripy, Spicy and Other and perform basis analysis of the sam
sis analysis of the same
Analyze the Reports Using Slicer for Online Vs Offline Sales and also by Agents

Sum of Final Price Average of Final Price

Column E Sale Amount Column E


(empty) (empty)
Total Result Total Result

Column O Sale Amount Column O


(empty) (empty)
Total Result Total Result
by Agents

Avg Price

Avg Price
Analyze the Reports Using Slicer for Dates

Sum of Final Price Average of Final Price

Column E Sale Amount Column E


(empty) (empty)
Total Result Total Result

Column O Sale Amount Column O


(empty) (empty)
Total Result Total Result
Avg Price

Avg Price
Overall Sales Overall C-Sat No of Orders

Agent Wise Sales Agent wise C-Sat Agent wise Orders

Product Wise Sales Product wise C-Sat Product wise Orders


Average Discount % Apply 1 slicer of your choice but for the entire report

Agent Wise Discount

Product Wise Discount

You might also like