Make Sales Dashboard in Excel Hindi | How to build interactive Sales Dashboard Step by Step
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Learn how to create a Sales dashboard in excel.Sales dashboard is an easy graphical representation of sales data that's intended to enable sales managers to make better decisions.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Dashboard & Reports -Dashboard_sales.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#dashboardinexcel #excelinterviewquestion #Innozant #dashboardtutorial #salesdashboard
Great knowledge sharing. Appreciate your support and help. None of the content as far as I know on you tube is systematic. There are knowledge chunks spread unorganised. Thanks for sharing your knowledge organised amazingly. God Bless
Thanks Wasi...Happy Learning.. Thanks for being part of Innozant family.
yes you are right Wasi..sir is great
@@Innozant Sir we are learning many things from your video however i have to know 2 things. 1st i have big data with approx 100 items and 150 sales areas so i want to make pivot table bar chart with scroll button and spin button. 2nd I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% in pie chart pen sale which i dont want.
Show less
Sir we are learning many things from your video however i have to know 2 things. 1st i have big data with approx 100 items and 150 sales areas so i want to make pivot table bar chart with scroll button and spin button. 2nd I have to see 1 item sales % in whole sales of stationary shop. example my total sales is of Rs100 for all items including of pen sale of 15 Rs. i will select pen to know the sale data of pen. this show pen sale data. but i want to know when i select pen it also shows how much % of sale of this pen is in total sale of 100. coz when i select pen it shows 100% in pie chart pen sale which i dont want.
I never seen such a great teacher like you sir , you explain everything in excellent way . 🙇♂️🙇♂️
Thanks dear...have a wonderful career ahead
Hy sir, aap kmaaal k teacher hain aap k lectures sy boht insire hain hum boht kch seekhny ko milta hai
14:50 jo mujhe janna tha wo start hua. Par mene video fir bhi pura dekha he. Ye kuch adhura tha mere gyaan me jise aapne pura kiya he. 🙏🙏🙏 bahot bahot dhanyawad
Love you Vishal ju.Happy learning ❤️👍
Thank you sir, I'm 49 yrs old and recently wanted to learn dashboard, watching your videos has motivated to learn it. You have very easy and nice of teaching. Wish I could learn by attending your class physically but still online teaching will still help. Once again thank you very much
Thanks Farid sahab..
keep learning ..Keep exploring.
You may join our live classroom training session.
Sir this is magnificent. Such a powerful pedagogy, slow pace, easy steps. Thank you very much, you are the lifeguard of my professional career! Many many thanks Sir. Gold richly bless you.
Thanks Sandeep,Aapne Live Interview Video nhi dekha hai kya..Use dekhke Sharmaji ke liye feedback dijiye.ki unka selection hona chaiye tha ya nahi
@@Innozant सर मै आपके सारे विडोज़ देखता हूँ | और मैने आपका Live Interview 5 बार देखा है पूरा | और कॉमेंट भी डेली करता हूँ हर वीडियो मै | आपने रिप्लाई भी करा है|
Oh..Myjhe yaad nahi raha hoga..aap humesha comment krte h that's a why . thanks
👍🏻 thumbs up veli veli lemoni
Free of cost 🤔 learn a lot from this channel advance excel
Thanks Ankit.Keep Learning
This is the easiest way of creating dashboard. Slicer helps a lot; I could develop dashboard in less than a hour without any prior knowledge. Well explained
Thanks Akash Ji
I pray to God that you will have countless subscribers thank you very much sir for giving priceless knowledge.
Thanks Bhoopendra,Watch Full video till end aur jaise bataya hai khud se banaiye Sales dashboard basics start kiya hai aaj se
Ha bhai sir bahut accha padhate hai bhai
@@paramjeet975singh3 yes bro u are right
@@Innozant I never watch your incomplete video sir thanks sir
@@paramjeet975singh3 ye baat to sahi kaha
👏👏👏 bahut mzedar vedio sir ji
Thanks Rohit Ji
Sir, your videos are making me more and more confident in excel.... Please also start series on Power Bi...
Thanks dear...Sure dear..after power pivot and power series ..you may see power bi series
Yes sir start series on Power BI, hum jabi sikhenge
Teesra comment he sir. Maza aagya sir. Excel sabse shandaro chizo me se ek. Views se de motivate mat hona. In future jaruru achhe views aayenge
Thanks Vishal ji aaple pyar aur respect ke liye ❤️❤️
You are Great 🎉🎉🎉
thank you, sir.
Your teaching style is excellent.
Your videos are very well organized which makes them easy to learn.
You are doing a great job by providing education for free. It is very helpful for the students who do not have money for such courses.
Thanks Shubham for your valuable appreciation 👍❤️
Got confidence that even I can do this❤😊😊
Thanks
You are great sir
Wah sir ese hi power bi type dashboard ka video chahiye tha.me jarur dekhunga puri series time nikal k. Thank u
Thanks Vishal Ji🙏❤️
Sir you gave a very important information of your dashboard. I have used in Office and make a visualization dashboard to present the productivity reports.
Thank you much needed
very nice. you should be awarded with a medal.
❤️Thanks Ashish ji
Kindly make more sales and KPI Dashboard. Your way of teachings is very interesting and easy to understand. Thanks
Sure dear... Thanks ❤️🙏
Great Sir,
My favourite two you Tuber is in gk-gs-khan sir patna and in computer science your channel
Thanks Rakesh Ji..Really means a lot to me dear..God bless you .happy learning
Excellent sir.
It would be helpful if you create a video for Excel data cleansing from a raw data file.
Sure Anirban Ji,Will surely make video for the same soon.. Thanks for suggestion.Happy Learning dear.
Sir u r awesome really really and thanks alot
Thanks dear
Great way of teaching
Awesome video sir🔥😎
Great sir
Amazing video
thank u so much sir
apka bataya hua step meko jaldi samjh me aa jata hai
Thanks Pavan.. exercise file download kijiye..aur jaise jaise jaise bataya hai practise kar lijiye saath ke saath ek baar..
@@Innozant hanji bilkul aisa hi hoga
Great Sir, Sir VBA KO class bhi Start kijiye plz
VBA playlist start ho chuka hai..kindly check
Sir thanks for this video, jio
Thanks dear 🙏❤️
I like it, very helpful for me.
Thanks Sir.
Thanks Dear..Happy Learning
I also complete today this one thanks sir 👌🙏
Veru good Arti..tc..happy learning
Superb
Thank you for growing us in a career.
👍
Thank you
Good morning sir very nice
Good morning Satish ji.hv a nice day.thnks
Thank You for sharing such a nice video
I made the complete excel sheet as explained for my own data. i would like to know how can i automatically reflect the changings that i will make in the Raw Data? Is it possible or i need to make different file every time?
Once again thank you and i am waiting for you response.
Sir you are killing it.
❤️❤️
Wonderful video sir
Thanks Vivek ji❤️
TQ....sir
Hi, if we keep adding data in the data base, will our chart automatically add that data?
thanks
Great explained in very simplest way. Interested in Joining the tutorial. Please advise.
Thanks Syed..Keep learning ❤️
Great work,&very helpful information
I love you sir
Great Sir. very helpful.
Thanks Shrikant ji😊
Nice sir really it's very helpful for me
Thanks Dear..❤️👍
Super Sir
Thanks dear
Interesting, well explained, thank you.
Thanks Rohini
Thanku sir ji👍
Aage humlog badhte ja rahe hain course me but piche ke topic bhi revise krte rhna humesa ..bhulna nhi hai
Excellent brother
Thanks Mahaboob.. Practice jarur Krna.. Execerciae file alreday diye gaye hain
Amazing video sir.
Thanks Gangeshwar Ji,We welcome you to experience the taste of success with Innozant-Seed of Success.Happy Learning
Too beautiful
Thanks Verma Ji ❤🙏
Sir main aik Garments industry mein job krta hun
Mujhy daily base py production and perforamnce report bnana hoti hain
Production reports k liye 2,3 lecture chahiyein
Thanks innozant channel,,
Need your help
Wow video
Thanks Sandeep Ji..Happy Learning dear..God bless you.❤️🙏
Sir the way you explain
❤️❤️❤️
Amazing
Thanks Abhishek ji..Happy Learning ❤️
Sir ji u r really great 🙏 thanks
Thanks dear👍❤️❤️🙏
Hello Sir, Can you make s video of state wise weekly sales.
Nice sir,
Sir kya aap python bhi karate hokya
Apne institute me.
Thanks..Yes Python bhi karate h
Sir ek dashboard logistics me dispatch department k liye banaye jisme invoice value pr kitna percentage transporter charge kr rha different locations k liye EST delivery time aur actual delivery time
Outstanding Sir and very helpful👍🏻👍🏻👍🏻
Sir progressive dashboard aap banaye hain. Please share link
Haan hai already iska video..aap chart playlist me Jake dekhen
@@Innozant Bahut Bahut Shukriya Sir
Excellent
Thanks Rashid sahab
Can I contact with u sir
@@rashidjawed9174 @innozantofficial telegram id for excel queries
very nice sir
You are awesome!!!!
Thanks Suresh ji❤️🙏
Sir, jab hum graph ke baad dashboard bnate h toh month aur year slicer me repeat ho rha h. Kya karo slicer mein month aur year one time show ho
Hi sir very nice video,when I am going to click on chart & trying to use slicer button from analyse tab it is not visible...any reason behind that
Aisa Hona to nhi chaiye..kaunsa version use krte h
@@Innozant 2016
Sir can we delete pivot data after making dashboard??
sir is sheet mein date column to hai nahi for pivot mein kaise liyaa aapne.
Superb sir
Thanks dear,Keep watching ,Learn and share
Thanx sir, jaldi reply k liye
Sir mera 1 dout or h
Kai baar vlookup m bola jata h ki pehle vlookup ko sort krna pdta h
Pr vo to bina sort k bhi ho skta h
Sir please aap kisi ek video m 2 min ki video m ise clear kr dijiye
Haan data sort karna hota hai lekin vlookup bht hi optimized function hai nhi bhi sort krenge to koi issue nhi aata hai lekin aap yhi lookup me karke dekhiye galat value pick kar leta hai bina data sort kiye.
Lookup ka video dekhie aap ek baar maine usme smjhaya hua hai.
Thanx again sir for quick reply
Maine kai youtubers ko dekha h pr unka reply 5-6 din m aata tha or kabhi kabhi to aata bhi nhi tha or aapka reply quick aata h
Or aapke padhane k way or concept btane or samjhane k way bahut accha h
Thanks Kunal,Hope you start learning step by step from video,Kindly note that I am uploading step by step complete course tutorial.Watch..Leanrn..Enhance skills and Wishing you blooming career ahead.🙏♥️🙂
Sir dashboad ki sirf yehi videos h yaa aap or bhi upload krenge
Offcourse Kunal ji ,abhi to dashboard ke concept ko seekhaya hai ,ab Dashboard development ke videos aayenge ,alag alag typr ke dashboard jaise sales,kpi,hr and many more..
Sir practice ke liye data kha se downloads kre ye
Sir ye excel 2007 me ho sakta h kya
but sir in this dashboard when I filter the any customer by silcer thn remove to top five ke place par sab a ja rahe h
Dear Sanjeev. Base criteria koi ek hi rhega na.Top 5 jisme laga hua hai wo dikhauey Uske baad bhi filter krnege to kis basis par top 5 dikhaye bechara sochiye 😁♥️❤️🙏
❤
🙏
Mast🤗😎
Thanks
Muje jrorat the eske sir mis executive mai dynamic chart ke demand hai thanks
Just started Sales Dashboard..time ke saath bht saare KPI Dashboard seekhenge.ok
Interesting sir.but not able to connect all slicers pl advise
Report connection ise nhi Kiya aapne?
@@Innozant sir Report connection option not understand pl explain sir
Sir, mis report & dashboard me kya difference hai.
Jha ji..aap dashboard playlist ke video start se dekhen..step by step smjhaya hai.. dashboard kya hota hai report kya hota hai ..and uses
Sir humko practice karne ke liye jo aap video dal rahe ho vahi data hame share karo practice ke liye discription me
Wahi data hai description me dear..even seprate MIS Assignment master folder hai playlist wise..wo download krke practice karen
Sir pls share excel dashboard learning playlist
Sir pls share excel dashboard learning playlist.
Seprate playlist for dashboard is already there
Allah aap ko nazar bad saay bacha aay.Aameen.............
Thanks dear...God bless You.. Happy Learning
I tried but what I observed is the report connection is not available for one of the pivot tables. I've also tried adding extra column to make the source same but same thing. The report connections available for 2 pivot tables but not for the other one.
Why? Kindly recheck the issue and let me know
Sir revenue drag kiya values mein toh dollar sign gayab ho jaata hai aur 4 5 and 6 vales aa raha hai vertically, lekin wohi revenue row label mein ya column label mein drag kiya toh amount dollar sign ke saath aa raha hai sir is problem ko kaise solve karein?
Means ? Drag krenge formula to reference change to hoga na
Sir woh dollar sign raw data mein dikha rah hai lekin pivot ka values section mein insert karne se single digit aa raha hai pata nahi kya excel issue hai 2019 ka?
Want to join your online classes
Ok .You may contact/Whatsapp us for more information.(Contact details available on Innozant website or TH-cam about section or , Latest video End screen)
Will guide you
u look like Rahul Bagga (actor)...😂😂😂😂 exact..same to same...😂😂😂
Sir koi v aap data par work krte ho to please datasheet download ka link v diya kijiye taki practice v kar ske fir galti se sikh paye
Dear harek video me use kiya gya example ka datasheet already diya gyabhai link me..aap assignment master link open kriye video description se
@@Innozant ok then thanku 👍
when we click on my chart cant find analyze option
Why dear ..what error your wil get
Thanx.... Sir python karne ka koi fayda ni hai kyoki mai excel seekh raha hu pls batana sir...ap bahut mehnat karte ho thanx
Kyu nahi hai Fayda.Learning ek process hai..Abhi hum Excel Seekh rahe hain..Phir SQL ki bhi jarurat hogi knowledge ki Data analytics ke liye.. Automation karna hoga to VBA bhi seekhna hoga.Data Visualization ke liye best tool hai Power BI wo bi seekhenge.
Jitna knowledge enhance krte jayenge life me value add hoga aur aage badhenge.
Jinhe Technical ke taraf jana hai wo Python with Data science krnege..
@@Innozant muje sir janna ki agar mai excel +vba seekh leta hu to muje isi field mai aage badhna ho to kya karna chahiye......
1)excel
2) vba of excel
3)???????
Sql, power bi, oracle, my sql, c++, python?? Pls sir batana
Excel ki hi line mai career banana hai??
Aap Basic Excel Playlist ka 2nd Video Dekhiye..Why MIS
Agar aapka background non technical hai to sql aur ek visualization tool kijiye powe bi ..asaan hai seekh jayenge
@@Innozant okk thanx sir
Hello Sir -
What this file can you please send me that file please
Description me master assignment link hoga dear
Here in first chart you wrote as chart Title"Total Sales by year" But it showed as month wise ????
Dea jan to dec ka data show haina us year ka thats why it said total saled by year
@@Innozant but how about 2013 & 2014 which is given in raw data ?? Nowhere it's showing
🙏👌
Thanms Arti
Can you help plz
Sir after creating chart, when I clicked on Sales rep and customer slicer then clear filter from slicer, then Top 5 Sales Rep and Top 5 Customer charts shows data for whole customer and sales rep instead of Top 5, Please suggest sir
First filter the data then create chart based on that
@@Innozant sir mene data filter karke hi banaya chart but problem udhar aati hai sir jab hum slicer se ek employee per click karke, slicer ko unfilter karte hai to niche chart mein top 5 ki jagah sare employee ka data aa jata hai. Please guide sir
Apne bola aage aayega btaiyega but abhi tak nhi btaye
Kya batana tha dear? have patience.ij sequence course karen..har ek topic in depth covered hain
Industry level project bnana btaiye jisme 300 400 rows ho 10 12 column ho