Sales Data Analysis using Excel | Pivot Tables | FMCG Industry
HTML-код
- Опубликовано: 22 окт 2021
- 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
Great video!! also can you us provide the dummy data so we can practice on our own. That would be a great help.
Tks
Many Thanks....helped me a lot
I’m glad you liked it, Raquel!! 😊
VERY HELPFUL THANKS
You're welcome!
hii its a really good explanation for learner, can i have demo sheet for practice
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🙏😊
Thanks for the appreciation. I’ll definitely share the hypothesis with you. 👍
@@analyticalguy Been a Pleasure.thank you so much
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!!
me also need same thing.
Thank you 🙏
I’m glad you liked it Glenn!! 😀
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.
In the pivot table fields, for the value section, why was it "count of...." instead of "sum of....."? whats the difference between count and sum? how does that affect the data?
Hi, can i get the dummy data for practice?
Nice information
Thanks Amit 👍👍
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.
Sure, thanks for your feedback.
How can I this dataset? Thank you
From where we can download same data?
Please share this dataset
Hi May I please have the dummy data?
Can you provide practical file of this worksheet
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.
Thanks Vinod, I’ll share the data file.
Pdf mil sakti
Sir please share 1 example how we can count total executive in each ASM through Pivot
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...
You can use Control + H to find and replace the wrong text. Or you can make an extra column with conditional example: if C2:C10 = "Delhi","Deli" or you make Data validation(combo box) to prevent this errors, or use the Option under File to do self correction. The best is data validation. But if the data comes from outside, just use Control +H to correct. Still there other options for this problem.
Hello Sir can you please share this data set to me.
it would be better if you provide pdf file for the sales data
good. Can i get the dummy data for practice?
Hi Mahendra, I have already attached the dataset. Did you get it?
@@analyticalguy where ia the dataset sir? I cannt get it
Nice sir i have a question
Hi Adnan, pls tell me 🙂
A kind request: Can you please modify all your RUclips Video descriptions- to attach the related sample Excel file, that your audience can also work on?
hey can i get the dummy data for practice?
Hi Anushka, did you get the dummy dataset?
Can I have the data?
Where can i get dataset
Please share your email ID, I’ll share the dataset over there.
@@analyticalguy hie can u also send me the dummy data
@@analyticalguy May I also get the dummy data
Hi, could I get this dummy data please
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!!
Thanks Rahul for pointing it out. I should have summarized by "Sum" instead of a default "Count". But the concept will remain the same nonetheless.
hey can i get the dummy data for practice?
Hi Anushka you can use the dataset used in this video. Let me know if you assistance
@@analyticalguy How to get the data in this data for practice