KPI DASHBOARD in Excel-Part 2 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi
Вставка
- Опубліковано 13 жов 2024
- KPI DASHBOARD in Excel-Part 2 | How to create a KPI Dashboard in Excel | Step by Step | in Hindi
KPI dashboard in one of the most used dashboards in business. This video is the first part of KPI dashboard video series on how to create a KPI Dashboard in Excel. In this video, you will learn to create KPI Dashboard step by step in excel.
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#kpidashboardinexcel #dashboard#Innozant #exceldashboard
सर बहुत धन्यवाद
Sumproduct पहले ऐसे कभी नही देखा था
आप बहुत अच्छा काम कर रहे हैं
जय हिंद🇮🇳
Sir ab mujhe lag raha hai ki mujhe mere real instructor and guide mil gaye hain
I feel confident ki ab me nayi nayi cheeze sikh kar career me age badh paunga.
Thanks for your videos
Ek question h bhai
Ram
Sham
Neha
Ram
Dhoni
Sehwag
Ganguly
Dhoni
Muje...unique name chahiye
Formula se
Karke batao jaldi bhai
@@sukhdevsingh-xm8nz BRO IF I ASSUME THAT THE VALUES ARE IN A COLUMN THAN WE MAY APPLY THIS FORMULA
=IF(COUNTIF($A$1:$A$8,A1)=1,A1,"")
AUR AGAR AP CHAHTE HO KI FIRST OCCURANCE PAR PRINT HO TO YE USE KAR SAKTE HAI:
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
THERE ARE ALSO SO MANY WAYS LIKE REMOVE DUPLICATES VALUE OR USING ADVANCED FILTER.
AUR HAR KISI KI ALAG ALAG APPROACH AND FORMULA HO SAKTE HAIN. HOPE APKO YE SAHI LAGE
Good Sanjay..M happy for you.👍❤️
@@Innozant It's all your blessings sir
Akhir student kiska hun
@@SanjayKumar-uw9kn wa bhai mast .....thanx ....mai index + small...se kr raha tha jo bahut bada formula tha thanx br
Excellent sir 🙏 sir mai apki sari video dekha hu sir Ajj mai advance excel me excellent hua hu to apki vajah se sir app bahut achhe se samajhte ho har ek farmula bahut hi bariki se batate hai.
Sir apka bahut bahut dhanyavad sir🙏🙏🙏
Thanks Sharda aapke itne valuable appreciation ke liye..God bless You..Happy learning ❤️
Bahut hee smooth teaching hai aapki...thank you 🙏
Thanks Sonika.. Really means a lot
Good Evening Sir,
App ka video🎥 dekhne ke baad mein Mujhe bahut kuch naya sikhne mila.
Is tarha ka video banane ke liye Thank you🙏🙏🙏🙏 So much.
Kuch Kuch Problem ho raha hai.
Shot Out Please🙏🙏🙏🙏🙏🙏🙏🙏
after watching your dashboard series I realised data analyzing skill is much more required than excel and as I merely have some basic or moderate knowledge in excel I have to enhance my excel skill too... time lage ga.. but I am not going to show my back. Thank you for your extra ordinary effort.
Great Amitabh Ji .Keep Exploring 👍👍
@@Innozant Sir we are learning many things from your video however i have to know 2 things. 1st i have big data and i want to make pivot table with scroll button. so i prepared it and take this to dashborad. So if i select 1 item detail to see. One item sales show in dash board but it show total as well and so many extra lines with so many 0 0 0. how to remove this. 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% pen sale which i dont want.
Your contribution to enhance my excel skill will always be appreciated, thanks is not enough, respect your work।।
Thanks Abhinav.Keep Exploring
धन्यवाद सर जी आपने डैशबोर्ड को बहुत अच्छी तरह से समझाया।
वरना डैशबोर्ड को समझना इतना आसान नहीं है
Thanks Tejpal Ji🙏❤️ Dashboard ki jai baar practise karna hai nahj to bhool jayenge.
Really, you are wonderfull excel teacher.
I am really want to learn from you...if you take online class I will join...waiting
Thanks Pramod Ji for you valuable appreciation.
Yes we are running live and offline classes,Kindly visit Innozant website or connect us with team Innozant for more information about upcoming batches (Contact no available in any latest video intro)
Very informative sir ji thank you🙏🙏🙏
Thank you for a brilliantly explaining KPI. it made things easy
Thanks dear
sir g kamal ka dash board sikhaya ap ny...
Thanks Adnan
Very useful video 🎉 Thank You Sir 😊
Your videos are very good for those who really want to learn excel. Main thing is you give time and effort to learners to grow their capabilities to extreme level in excel.
I really appreciate your hard work. Keep it up. 👍
Thanks Pawan..Happy Learning dear.❤❤Really means a lot ti me dear
@@Innozant TRY to make an English version to favor world wide learners
Sir could you send me Excel sheet
Interesting and knowledgeable kpi dashboard, khud surat dashboard thanks guru g
Thanks Puran,Iska practice jaroor karte rehna nhi to bhool jaoge .🙏❤️
Sir This is so amazing KPI dashboard. Today I practiced 10 Times KPI DASHBOARD in Excel-Part 1 videos. My doubt clear. KPI DASHBOARD in Excel-Part 2 Mind blowing. You are a legend. This is THE BEST tutorial that I have ever seen on Excel. You have ignited my passion to learn.
Thanks Sandeep,I knw you are dedicated candidate and willing to learn new concept everyday to enhance your skills.God bless you dear 🙏❤️🙂
very nice, language and method is very easy to understand.. truly appreciate.
Thanks Jay.. Complete both part 1 and 2 steo by step ..Happy Learning
Very effective dashboard thanku very much sir excellent part 2 I practice this 4 to 5 times.Good night sir😊😊
Practice jaroor karna Satish Ji Dashboard ka
Sir ji mujhe aap ka kpi program bahut achcha laga. lekin mujhe same kpi table goole sheet me chahiye. kya aap ek or video google sheet ke liye bana sakte he please?
Thanks sir , I needed the dashboard videos that i got on your channel.
❤❤🙏🙏
Very good but very tough for beginners.. need to prepare simple dashboard
Start fr basic dashboard
Brilliant video, outstanding usage of formulas
Thanks Sameer Ji Happy Learning
Sir thank you so much for this traning
Dear Sir
Pivot chart pe video nai banai ap ne
Ye sab calculations pivot table ma kar k dashboards nai ban sakta?
Very good
excellent
great bhai..
Thanks Goldy
Sir mujhe 2 questions put up krne h aapse
1) Sir MIS m kon kon se topics cover hote h ?
Basic excel, advance excel
Ye to ptaa h mujhe but or bhi koi topic h ky jo MIS job k interview m cover krnw pdte h ?
My 2 question second comment m h
Dear Kunal...Basic Excel Playlist 2 Nd Video dekhiye..Why MIS .
Maine complete detail me smjhaya hai data science ko.👍♥️🙏
Sir data analysis par vedio kab upload karengai aap and dashboard series ke or vedio ayengai kya
Haan krenge upload data analysys case study.
Dashboard ke bhinaur videos ayenge jald playlist me
धन्यवाद
Thanks Ravi
hello sir i cant find the practice workbook from the direct link the page link is not opening form the mentioned link in the discription.
Thank you
Nice video
Excellent. You have shown the easy way of doing Dash Board. Thanks a lot. Expecting some more good videos in the days ahead. Doing a great job indeed for the benefit of Excel lovers.
Thanks Gopala Sir🙏🙂
Oho9
@@Innozant o
Super information sir. But in previous vedio target set is the confusion
Why..it is random value only
Thanks a lot sir ji
Thanks
Sir sumproduct formula ni apply ho rha year walay mn guide kr dyn plz
Excellent 👌 You are making great educational content, you are being undervalued, I wish for to get 1 Million subscribers soon ❤️❤️❤️
Thanks Abhijeet Ji for such a valuable appreciation and your concern.Really means a lot to me dear.. Thanks for being part of Innozant 👍❤️
very nice sir
Nice sirji
kya ye dashboard excel2007 me chal sakta hai
Haan...new function koi use Kahan Kiya hai..step by step video dekhke khudse banaiye.
Super video sir
Sir please upload more videos on each type of dashboard. Thanks a lot!!
Thanks Saurabh Ji❤❤
great
Hat's of u sir god bless u
Thanks , Practice Kai baar Dashboard ki .ok
@@Innozant ok sir...
Very helpful
Thanks dear
Nice explained sir. 👍
Thanks Nilesh Ji🙏❤️
Sir, I had made this performance sheet but the data does not come correct form can I send your that sheet please you check where I do mistakes..?
sir pls help me Bahut problem a rhi hai ki jb hm developer tab se koi bhi button insert krte hai us button control krne ke liye control ka option nhi ata aur us button pr click krne pr vba ki coding a jati pls sitr
sir kia interviews main kpi deshboard k bhi question ate hain
Not mandatory.mpivot table se aayenge
Thank you very much sir, its very helpful for me ............Sir could you Please upload monthly expense Calculator Vs income..Thank you very much !!
Ok..dear.
Give me some time.will.upload it
2) Sir MIS jobs k liye interview m kuch questions puch jaate h jaise
Purpose of MIS, Different types of MIS, core principles of MIS, Level info. Requirement in an MIS, Level of decision making , advantage of MIS in bussiness, different approaches used in designing an MIS ???
Iske upar video banaya hai..Live interview series dekhiye...confidence badhega usse Aapka.🙏❤️
Super..
Thanks ❤️
Sir kya kahi Job interview ke liye KPI Dashboard tak se hi kam chal jayega
Mis executive ke profile ke loye apply kr rhe hain to dashboard se jyada ques nhi..excel se aayega..use sahi kriye..aur Interview attend krna start kriye.
Thanks Sir❤️
And also Thanks sir you do a wonderful work for us I am also belongs to Bihar and I am very happy when I know that you also belongs to Bihar and also from Maithil
Sir mujhe ek Excel problem hai aap solution kya desire hai kya ?; Mujhe multi value result ke liye vlookup formula nahi set ho raha hai
example; table data me two coloms
condition me data lookup karana hai
Aise samajh nhi aayega..excel sheet ya data format share kijiye
Sir, Can you please suggest which DBMS is the best to practice SQL commands amongst these two MICROSOFT server & MYSQL?
Choose any editor theme is minor differences of syntax
Could you suggest to make performance chart on basis of digital marketing team.
you want performance chart only or Dashboard dear
Both
@@Innozant if you can help then it's would be easy to manage my work well.
❤❤❤❤❤
Need more vedio on dashboard guru g
Daily production wise dashboard template kese banega agar team ki report or individual report publishe karna hoga to example total advisor production count, average apt, IT issue, brk, team meeting, total log in hr,. Data can in increase or decrease
It is possible in dash bord
Haan abhi the Dashboard ke bht saare video aane Hain dear...Time lgega lekin is channel par aisa koi series nhi Hoga Jo na dikhe aapko..Seekhaane ke maqsad se is platform se Juda hu main..Have patience dear.tc.gn
Target is always going to be changed, how could we fixed that. And also in this vedio I can see your department bar colour has been changed. Plz let me know how ??
Make it value as i use randbetween there,kindly watch video again steo by step you may able to understand each and every step
@@Innozant after following your instructions, made it value, it's getting now fixed as a single digit. After the change in the performance data of the employees it has not changed now it is not changing anymore
Sir, I am getting value error when I apply sum product formula here. What would be the reason ? When I press F9 to check and logic looks correct . Pls advise?
Thanks
Kavita
Value error shows when we press enter instead of Ctrl shift enter
Kindly check the dataset and applied formula again♥️
Sir, I did double check but still same error. Sending u in telegram if u could pls advise
Thanks a ton
Kavita
Awesome Sir🙏
Thanks Vishnu ji.happy learning
Good sir 👍
Thanks Ram.Rehearse on regular basis.🙏🙂
Sir aap or bhi vedio upload karengai kya dash board se related
Offcourse aur bhi uoload hona hai Dashboard series
@@Innozant sir dashboard series ke question milengai kya
Sir last graph me all employees hai pr aapne iske title me 1 employee ka naam kyu diya" Srikant badge"
Sir, aap purchase and sale ka kpi dashboards banaye
👍❤️
gooD viDeo Sir
Thanks Tohid Sahab.Do practice on regular basis.🙏❤️
Sir aapne koin sa excel ( office) use kiya hai like 7 ..10 koin sa kyo ki mera excel mai developer nhi aata hai
Dear Kajal..Developer tab enable Krna hota hai file -options -customize ribbon me jaake
Thank you..
thanks sir
Thanks dear
Monthwise nikalna hoga to kaisy nikalengy
Kiya Ms Excel ka use real me Company me hota h MIS ke liye.
Offcourse...bina excel ke gujara hi nahi h dear
Brothet please sales man ka monthly quarterly yearly dash board ka ek video banao na please, usmay employee ka attendance present, absent, uska performance grading kay saath, grooming ratings, visual merchandising rating, sales ranking, sales target vrs achievement ratings, percentage..msg bada hai par aapkay liye chutki ka kaam hi..
Sir dashboard meeting me present karne types kya kya hai?
Without sharing data how to share dashboard with team mates?
Ok..video bnane ki koshish bkrta hu ispe
Why did you use sumproduct instead of sumifs to calculate the total data for the years? and also, why is years in the 1st array of the sumproduct function, wouldn't that multiply the year with the data wrongly?
Dear sumproduct is array funtion and works in group,and 2nd thing in above mentioned dashboard there is no such big difference if we use sumproduct instead of sumifs and it won't calculate wrong data calculation as when we have single array our sumproduct funcation just add thos values instead of multiply..Kindly debug the formula and try to understand Tasnim,also recommend you to learn Array and Sumproduct Function from Playlist Array and Sumproduct step by step 🙏♥️
Still issue you may connect us Will guide you for the same .
Need your help in this regard.I have two dates eg 03-11-20 and 12-12-20 in cells A2 and A3, in cell B5 I want to mention "PRE HOSPITALIZATION BILLS FROM (03-11-20 TO 12-12-20)" Please demonstrate how to do this. When i tried this the two dates are shown in date serial formats, but i want it show in date formats only.i want the every thing to be dynamic, when i change the dates it should reflect in sentence.
Pass text before date as date sereal consider it as datevalue. Or you may share your worksheet data format will help you out
Sir apne last wale chart m title srikant yani employee name q Kiya because chart to pure ek particular department ka data show kar raha
Employee wise report bhi to hai dear
There's a another way to create dashboards using power pivot options in excel which is a much more convenient way of creating dashboard where neither renaming of data is necessary nor application of formula and would deliver the exact charts without any error ur way of creation of dashboard couldn't be applied in a real work scenario as it would consume much time and it's not clear whether a change in data would automatically be reflected in your charts as well...
Dear Abhijit Thanks for sharing your opinion, Kindlg note that we are trying to provide conceptual knowledge to make them aware the flow of Dashboard development, Dear not a single way, many more ways to create Dashboard these days using data visualization tool....Soon you may able to watch the video for the same.❤❤❤🙏🙏🙏
Anyone please help me... i couldn't set formula in chart title...please help me to write down here that particular formula ''Departmentwise Report from ''&B14&'' to''&G14, in a correction format.
Hlo sir sir main je apki dashboard ki series pichle week sabi videos download kar li thi but apne offset formula bohat use kiya hai wo sir muje nhi atta itna app plc offset formula ko bi basic se advance ki videos upload kre sir
Gaurav Ji video..UA-cam par hi Dekha kren 😁Aise download krke dekhenge to mehnat humari bekar dear ..bht mehnat hota hi video prepare krne me boss. Happy Learning 🙏🙏🙏
@@Innozant ok ok sir but main abb dash board ki video nhi dekhuga maine dload karlithi but main apni abb sabi videos online dekhuga youtube par thnq
👍
👍👍👍
oh..hope you complete this dashbkard by your own
@@Innozant yes sir
@innozant Sir we are learning many things from your video however i have to know 2 things. 1st i have big data and i want to make pivot table with scroll button. so i prepared it and take this to dashborad. So if i select 1 item detail to see. One item sales show in dash board but it show total as well and so many extra lines with so many 0 0 0. how to remove this. 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% pen sale which i dont want.
Share your assignment sheet on @innozantofficial telegram id
@@Innozant i already shared
sir , 3:40 me jo formula laga rhe he sumproduct ka mera error aa rha he , =SUMPRODUCT((YEAR=B$12)*INDIRECT(($A17&"_"&"data"))). It shows #NAME? error, what this error , and how to solve it.
name errir tab jab Aap reference/naming range galat paas kar rahe hain..phirse rk baar recap lijiye..naming range miss Kiya hai aapne
Excellent video but your explanation very fast please next time slow
Thanks Dear...❤️🙏
Noted..Will take care of it in nead furure ❤️🙏
sir ji make a dash board different parameters like sale ,txn,avg,different years
Yes Kishore ,Soon you may able to see Sales, Performance and other Daahboard too.Happy learning 👍🙏❤️
Please send the practice file 🙏
Unable to download practice file ..error: practice file does not exist ..
Kindly download it from Master link available in video description ♥️👍
@@Innozant got it thanks ..
Can you share these formats
Download link are there in video description..kindly download it and practice
i'm unable to download to practise file , kindly look this issue
It is available in video description link is there
charan kaha he aap k 👏
There is a problem while applying Sumproduct Formula, it did not work.
You are doing som e mistake dear..kindly download the koi dashboard assignment file from given link and again recheck
गजानन जी
शुरू मे मुझे भी दिक्कत हो रही थी
आज काम कर रहा है
सर बहुत धन्यवाद
Sumproduct पहले ऐसे कभी नही देखा था
आप बहुत अच्छा काम कर रहे हैं
जय हिंद🇮🇳
My radio button is not working please help
Issue ?
Second Video is incomplete, because in starting of the video you have connected three dep. with other options , how you haven't discuss.
Kindly watch first video of Kpi followed with 2nd video dear.
its complere video of KPI.❤️🙏
Kindly provide training file
Kindly download it from video description.. assignment master file link are there
Links please
How to get a raw data
What rank you want . kindly share your query
practice file does not exists😓😓
Kindly download it from assignment master link given in video description.Direct file link is broken but you may able to download it from main link
Plz send me excel file
Kindly download all assignments from second link given in video description.
Sahi say nahi samjhaty or adha adhura bataty hain
Rajeev ji..aap ek ek comment jarur padhke dekhen students ka ki maine ek ek step in detail process btaya hai ki nahi .aap ydi steps jo btaye gye hain wo galat krenge to kaise aayega output
Thank you