Sales Data Analysis using Excel | Pivot Tables | FMCG Industry

In this video, you will understand how to analyse FMCG Sales data using Excel.
Pivot is a very useful concept used in Excel. This video will show the power of Pivot. You can literally answer any question, or analyse any dataset using Pivots

00:30 Dummy Data Overview
01:17 Objective of this video
01:26 Which Zone has the Highest Sales in India
03:04 Which City contributes Maximum for each Division
04:54 Highest Sales achieved on which Date?
05:50 Which Price Range contributes maximum to the top-line
06:48 Top 5 Distributors in terms of Sales

### Bonus Tip #### 07:57

#Exceltutorial #FMCGSales #SalesAnalysis #CPG #FMCG #FMCGAnalytics #ExcelSales

[TomHurriyet]

Thank you for sharing this informative video. I found it very helpful. Would it be possible for you to share the Excel data used in the video? I would greatly appreciate it.

[mohitkangotra]

Great video!! also can you us provide the dummy data so we can practice on our own. That would be a great help.

[karthikarthikeyan]

Thanks a lot for such a simple way to analyse a raw data. In life what happens, guy would have been a stud in sales and brought an outstanding performance, but, if he is ignorant of Pivot table tricks, there is an element of low confidence, which your video empowers.
Could you help with an automated primary order for a distributor with 4 despatches on a 20, 25, 30, 25 % flighting ( Ex for Dec 21) considering 21 day stock level and a 15 day closing stock ( Ex: for nov21), for a 5 brand ×3 sku company., please have your own hypothesis for P3M Average( past 3 months) in volume ( with automatic price column) however giving clear indication to distributor on how much he should NEFT for each of despatch
Thank you so much for this support🙏😊

[wuzotho]

Very nice informative case study, which is useful for interviews. you should place Dataset also for practicing purpose. try to add Datasets which is usually placed by many youtubers.

[kaustubh.tripathi]

Wow, a great explanation and a very in-depth video! Thanks for the same! Can you please share the data set also if possible! Thanks for the generosity in advance!!

[KaelkenYT]

Hi, can i get the dummy data for practice?

[hannanuurtsaniya]

In the pivot table fields, for the value section, why was it "count of...." instead of "sum whats the difference between count and sum? how does that affect the data?

[gvinodnair]

I doubt you should have selected Sum of Sales instead of Count of sales in all those analysis scenarios to find the right solution? It would be much beneficial for the viewers if you are generous enough to share the data file so that they can also practice it.

[devyanidas]

hii its a really good explanation for learner, can i have demo sheet for practice

[ADARSHKUMAR-swyh]

Hi sir,
One small question regarding this topic, I have attendance in sales data then I want to automatically pick attendance in attendance from sales data.

[Abhisheksoni]

Can you provide practical file of this worksheet

[saradhipeetha]

it would be better if you provide pdf file for the sales data

[SimranKaur-jezi]

If there is spelling error in city name sometimes, for example, Delhi is somewhere written in data as Deli, . Some entries are with the name Delhi . How to correct this error...

[mahendragupta-rq]

good. Can i get the dummy data for practice?

[akshatuniyal]

Hello Sir can you please share this data set to me.

[pm_shaw]

A kind request: Can you please modify all your Youtube Video descriptions- to attach the related sample Excel file, that your audience can also work on?

[manishpant]

Sir please share 1 example how we can count total executive in each ASM through Pivot

[anushkashetty]

hey can i get the dummy data for practice?

[rahulnaher]

Dude your whole sales analysis is going for a toss.. since you have summarized it as "count" not "sum" which is actually giving you the number for entries per region or any other attribute you are trying to analyze. if you don't know.. now you know!!

[anushkashetty]

hey can i get the dummy data for practice?