Full Project in Excel with Interactive Dashboard | Excel Tutorial for Beginners
HTML-код
- Опубликовано: 9 июл 2024
- In this video will learn data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.
Excel Dataset Download (direct): bit.ly/3X381ok
Excel Dataset Download (google drive): bit.ly/3Ypatqu
Excel GitHub Link: bit.ly/40vbJtI
➖➖➖➖➖➖➖➖➖➖➖➖➖
SUBSCRIBE!
Do you want to become a Data Analyst? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science. So, what are you waiting for..
👍 Subscribe Now: bit.ly/3Fc7Gc6
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content⭐
00:00 Intro
00:43 Project Intro
01:20 Sample Questions
01:54 Excel Data
02:16 Data Cleaning
06:27 Data Processing
10:17 Data Analysis
31:32 Interactive Dashboard
34:56 Insights
35:55 Next Steps
36:49 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
More Excel Tutorial videos:
🔖Forecasting in Excel - Must Skill for Data Analyst
• Forecasting in Excel -...
📢Full Excel Tutorial in one Video: • Excel Tutorial For Beg...
🔖Excel Tutorial Playlist: • Excel for Beginners | ...
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
👉Instagram: / rishabhnmishra
👉LinkedIn: / rishabhnmishra
👉Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
More SQL Tutorial Videos:
📢Full SQL Tutorial in One Video: • SQL Tutorial for Begin...
🔖SQL Portfolio Project: • Data Analyst Portfolio...
🔖Most Asked SQL Interview Question: • Most Asked SQL Intervi...
🔖SQL Tutorial Playlist: • SQL Tutorial In Hindi
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
#exceltutorial #dataanalytics #dataanalystproject
Related keywords:
data analyst project
data analyst project for beginners
data analyst portfolio project
data analysis project
data analyst projects for resume
data science project,
data analyst excel project
excel tutorial
excel tutorial for beginners
end to end project for data analyst
excel project for data analyst
excel project
report in excel
dashboard in excel
Hi folks, in case anyone facing issue to download the excel Vrinda Store dataset can use this google drive link: bit.ly/3Ypatqu
Thank you, Rishabh bhaiya. This link is working. 😃
Hii rishabh sir..I have doubt..Can you please suggest me..what is the use of python (numpy,pandas, matplotlib) in data analyst job.. because same work we can do easily in POWER BI..
And for automation also done by macros and vba in Excel..
Bhaiya ye dataset view only hai, pls give me access, need to complete this project today.🙏🙏
Request send kr rakha hu already
Tableau project b bna do please
@@deepakrai6824 bhai apne kiya dataset download? O b sirf 3months ka hai na?
BRUH, this is the only video over 30min which i watched NON-STOP without moving a muscle!!!!!!!!! I am glad I found you!
Glad you liked it ✅️ keep learning n keep growing 🚀
Brother you're soooooooooooooooooooo talented I swear. I have never got powerbi, excel and sql clearly but with your videos you made everything crystal clear...please please keep posting such content. I am watching you every single day :)
Correct ..bhai
Do uh know SQL Can uh help me
You are the best teacher for any beginner. Randomly found out about your videos and they are all so simplified..can't tell you. Please keep uploading videos to make this easy for people like us.
Glad you liked it ✅️
@@RishabhMishraOfficial plzz tell us how can we get valuable certificates we want...
Wow, this Excel dashboard tutorial is exactly what I needed! You have covered almost all the essential topics in just a short amount of time. Amazing! Thanks for sharing your expertise with us!
Glad it was helpful! ✅️
@@RishabhMishraOfficial brother plzz tell if there is any certificate or not..for excel from your side..how wwe will get recognised certificates
@@ZaidAhmad-mu7si do projects instead of collecting certificates
@@kousik8042 but employer ask for standard certificates as well..also certification gives value to linkedin and cv
can a beginner do this tutorial????///
Sir Thanks for your extensive and easy-to-understand lectures.
I have learned Power BI and Excel from your RUclips lectures, these are very helpful.
This is what every fresher and learner who is in starting zone want.. Thank you sir for this type of video it helps many fresher for making their project.
Glad it was helpful ✅️
This video was everything I needed to understand dashboard creation. So beautifully explained! BIG THANK YOU :D
We need teachers like you. Thank you so much sir for making this awesome video. You nailed it !
Glad you liked the content ✅️
Hey Rishabh, you just nailed it. One of the best video on making interactive dashboard, you made everything crystal clear. You presented everything from the very basic and It was worth watching your video. May God bless you and have a great future ahead.
Glad it helped ✅️
Thank you brother for the amazing dashboard.. you explained it very easy to understand! Keep up the good work..
Hi Rishabh! your video on Excel Dashboard is very helpful same as Power BI. I am leaning some new skills quite easily. Thank you for sharing your wonderful Data Science skills. God Bless you.
I really appreciate all the sincere efforts for making this kind of content and Brother you don't have an idea how you are changing the lives of common people .. Thank you so much ...!!
I appreciate that! Keep learning n keep growing 🚀
Seriously sir i am very thankful to you I was searching for such content which is understandable for beginners like me that have no actual idea about data analyst how does perform his task thank you very much sir keep making videos god bless you
Glad it helped you, all the very best :)
This video was everything I needed to understand dashboard creation. So beautifully explained! BIG THANK YOU SIR🙏🙏🙏👏👏👏
Bhaiya bhut logo ki video dekhi but aapke jaisa koi nai hai
Amazing video, covered all important topics within 38 mins and is very informative.
Glad you liked it! ✅️
Really appreciate your efforts. This is definitely going to help me add weight to my resume
Glad it was helpful!
Watching this RUclips video has been incredibly enlightening for me, and I've learned so much from it. Thank you for sharing such valuable content!
Glad it was helpful! ✅️
Finally, after searching for 2 days I found something great. I am new to this domain and i was not sure where to start. Thank you so much for helping.
Glad it was helpful! ✅️
Hi Rishabh, Great Dashboard, as always great explanation, crisp, concise and clear. Great content, you're a guiding light to many others like me, I really appreciate your efforts, keep it up.
Glad it was helpful ✅️
Not only created the dashboard but also shared the insights ❤️❤️
Glad you liked it ✨️
"I created a slicer for 1st pivot table and I would like to connect it to other pivot tables. However, when I go to Slicer --> Report Connections, there is only one pivot table. " How to fix this issue?
@@arshittyagi3035 i think you made mistake in creating pivot table or maybe you do not make separate pivot table
@@arshittyagi3035I am having same issue how to solve it ??
I have done this project. I have learned a lot from this End to End Project. It is recommended by my side to other folks for praticing the excel skills. thanks
I don't usually comment on videos but you have done amazing job. Haven't watched such a informative video till date. Thank you for the video.
Glad you liked it ✨️ thanks ✅️
Good job 👍👍👍
Keep educating like this with great examples
Thank you, I will ✨️
This Project helped me a lot and Finally i made a project on Excel and Boost up My confidence level .
Thanks a lot for this .🙏🙏🙏🙏🙏
Glad to hear that! 🚀
You are a great tutor. Liked your way of explaining, content, Visuals.
Simply amazing, crustal clear, calm, no unnecessary commentary, very crysp and understandable oresenation and walkthrough.....🙏 Saadar Pranaam.
Glad you enjoyed it! 😉
what an Amazing video it was. Learned a lot of things. Did your one hour excel video first before getting in this and that made me grasp things really fast. Now will do Powerbi as I've already did SQL and Python
Python from wherr did you study? " pls reoly
With just one video bro I have not only created an impressive excel project but learned alot related to Pivot Tables. Thankyou for the information you are providing us.
Glad to hear that u learned something.. 🚀
In data cleaning process
HOW he is SAYING BY SIMPLY LOOKING ONLY SOME VALUES IN FILTER that all values are correct THERE IS SIGN STATING NOT ALL ITEMS ARE SHOWN THERE
there CAN BE SOME TEXT OR SOMETHING DIFFERENT SPECIAL CHARACTERS CAN BE THERE IN DATASET
Also there can be empty data
boht boht dhanyawad, tutorial hindi mei n short rakhne k liy....bade tutorial follow along krte krte boht time nikal jata hai n pura nhi follow krne k karan se mann bhi hatt jata tha sikhne se.
Glad you liked it ✨️
Bhaiya yaar kya si bataya h aapne me 4 din se paresaan tha do aur channels pe mene dekha whaa wo log slicer me itna problem create krwa de re the......but finally my dashboard is ready 👍👍👍👍. Thank you thanks a lot
Great content 👍 definitely adding this in my CV
Eshank Bhai good morning.
Bhai ji data analysis ke bare me aapse kuchh Jankari lena tha.
So please aap apna contact no. Sand kijiye Bro
Bro how can I will add this my cv it means what should I write in my cv about this project please help me??
How to add this in CV?
Yes same que
@@sameerazmi3241did u add in ur cv?
made my first data analysis project, THANKYOU SO MUCH
Glad it helped! Keep learning n keep growing 🚀
Thank you so much Rishabh. I found your channel is one of the best for all who are looking for job in data domain. I really liked all your content. You are a true gem. You don't talk unnecessary things, all content is on point and helpful.
Glad you liked the content n it's helpful ✅️
just finished this awesome excel project😌😌 your way of explaining was quite easy and interesting. Thanks, Rishabh 👍👍
Glad you liked it ✨️
how to download this sheet, it is available only for views. sir, please give me a access to edit this sheet
Bhaiya mere excel mein kaafi feature nhi hai like combo chart etc. Kyuki older version hai. New version kaa kuch jugaad ho sakta hai??
i also wanted to do this project but the shared data is having only 3 months of data and in the video there is whole year data ,is you worked on 3months of data only?
You deserve 1m subscribers ❤
Great great content!! Simple and to the point!
Glad you liked it! ✅️
Certainly! Here's a corrected version of your sentence:
"I recently found your channel. I have taken many payment courses, and trust me, you are among the top 5 of the previous tutors. All the very best, bro."
To get the drop-down arrow for each column & apply filter use shortcut:- Ctrl+Shift+L 😊
thanks!!
thanks, bro this was really helpful!
What should I use for paste as values
just copy whole column then paste as value ,,, 😁😆 ik it has been 5 months @@h.a.r.i.
thankss
By seeing your video sir first time I made this project Alhamdulillah
Same out put came as you shown in this video .
Thank you very much sir.
Thanks Rishab for your amazing explanation. Nice teaching style.
Only because of you . I learnt sql , python and power bi and got placed in it company as team leader mis with decent package thanks 👍🙏
Bhaiya please help i am tier 3 engineering college I am applying for internship in data analyst but companies not responding please help
Glad to hear that ✅️ congratulations ✨️🚀
in case power sql and power bi is good can i get job ...plz reply
Hey, this series of yours is extremely helpful. I honestly couldn't have come across it at a better time. I just want to know one thing, for the first question, why did you take 'Amount & Order ID' and not 'Amount & Quantity'. From the question I understand that it is asking for the quantity sold so wouldn't it be better if we use quantity and not order ID. If you could explain this it'd be really helpful.
yes you can use quantity as well. But in this video i just wanted to check the count of orders (not sum), so it doesn't matter which column u use for calculating count. But you can also make a chart like Total Amount (sum) vs Total Quantity (sum)
@@RishabhMishraOfficial Understood. Thank you!
Wo मां बहुत लक्की है जो आपके जैसा बेटा पाई जो अपने सभी छोटे भाइयों को आगे बढ़ाने में इतना मदद kr रहे हैं धन्यवाद Rishav भैया आपको भगवान हमेशा तरकी दे आप खूब आगे बढ़ो❤❤❤
Your lectures are very insightful and helped a lot, thank you👍😊
Brother one request, please upload more SQL, python projects, and also how to apply for interview and tips, projects which are already in your channel is very helpful, great work😊
Noted ✅️
I don't speak or understand Hindi but found the video to be very helpful. This will count as my second data analytics project soon to be uploaded on Github. :)
Glad you liked ✅️ 👍
This was really insightful !
Perfect bhai I have been working on Excel for 7 years after watching this I just want to become a pro, InshaAllah ill start learning and practising..... thank you for you efforts and sharing such valuable knowledge big brother 🙏
Glad it was helpful ✅️
Keep learning n keep growing 🚀
Ctrl +shift+l.. for filter
Sir in ur link there are only 3 months like ( april,may,june) but in ur video there are all 12 months, So its only 3 month data not annual data
Its full data
@@RishabhMishraOfficial there r only 3 months?and if I am directly downloading it from 1st link.. In date columns showing###### in all columns.. I lost my excitement 🙃
@@nurulhuda3203 same
@@nurulhuda3203 just increase the size of the column and u will be able to see the whole date
Thanks bro
Thank You Bhaiya Most Needed Video to Get Start for Data Analyst Learning
This is my first Project in my career as a beginner that helped me to understand how it works by using Excel skills, Thank U so much for your effort to learn us. I have done every step U have learned us in this amazing video and made my own analysis using the Excel file that You have attached it. You U Again ana Again and Again😍😍😍😍😍😍😍
Awesome 👌 Keep learning n keep growing 🚀
@@RishabhMishraOfficial how will we get cert of excel and this project we made..what we will put in resume..
Bhai me hi seekhne ke chakkar Me 10 baar dekh chuki hu 😂😂😂
Fir shikhe ki nahi
करत-करत अभ्यास के, जड़मति होत सुजान रसरी आवत जात ते सिल पर परत निसान
Mai bhi 7-8 bar dekh chuka hu abhi tk complete nhi hua🥲
Bhaiya me 20 baar dekh chuka hu or hamesha se download hai
Digital marketing ka v ek practical video bana dijiye. Project k sath
Thank you Rishabh for this amazing video. Just finished with this Project and then decided to write this. You explained each point so well.
Glad it helped ✅️
BRO,EXCELLENT. WHAT A SIMPLE WAY TO ANALYSE A MASSIVE PROJECT IN 38 MIN
Glad it was helpful! ✅️
This video is really helpful specially for beginner level data analysis project experience.I saw many videos of data analysis projects and wanted to follow up but got stucked in the middle because most of them explain the things in a complicated manner .But you are really amazing ❤️ Your explanation was really simple that helped me to understand the things very clearly .Thank you so much . I'm gonna add this project on my LinkedIn profile 🎉
Glad it was helpful! ✅️
You made my job a lot easier. I will definitely add this in my résumé
Glad it was helpful!
This is one of the best videos I have seen for Excel Projects.
Glad you liked ✅️
Sir sir ...maine life me 1st tym ek project banaya and wo bhi sirf excel se...i really really really loved it...mai abhi infosys me as mobile testing me hu and i am on bench ...but i thought to switch my field to data analytics just by watching roadmap of urs...so much thanks ...i loved this project...amazing ...❤❤❤❤❤..i will definitely add this project in my resume..after i will cover all my skills...thanks alot sir ..god bless u...great work
All the best 👍
One of the Best Video for Excel I have seen , Great Explanation Sir 👍👍
Glad you liked it ✨️
You are literally a GEM 💎 I have searched tons of videos on this field but you made it so simple 🥹😍 Thank you so much ❤
My favourite channel for data analytics
brother you are one of million Who tech properly and share hidden trick. Thank you.. You have my honorable and respect . Salute YOU Brother
Glad you liked 👍
Literally so well explained 👌
Major skills used in this single video : Data cleaning, Data processing, Pivot charts, Dashboard, Insights and Conclusion
Great work as always ✨
Glad you liked it! ✅️
rishabh bro great content once again ♥️this, Kindly provide these kind of projects which tells us real life work of data analyst that how data analyst works and kindly share problems with solutions to solve those problems, So we will gain knowledge of the field Rishabh hope you will enlighten us Thanks 👍
You are such a pro and an honest guide!
Glad you liked it ✅️
"THANKU SO MUCH SIR", the way you teach. it's very simple and get to easy. keep it up ❤❤❤❤❤❤❤❤❤❤
Glad you liked ✅️
Thank u..hepled a lot...keep making more such videos.😄😍😍
What a great session like podcast.. Hope more videos will come on Excel in adavce method... Thanks a lot bro 👍👍🤜🤜
Glad you liked it 👍
Wow! AMAZING👍
The first video that surprises me with a tons of knowledge that is actually important
Glad you liked ✅️
It was one of the best project tutorial I always watch your videos for learning SQL, POWER BI, and MS Excel Thank you for providing such a good Content
Glad it was helpful! ✅️
Thank You So much Bro for your videos and your consistency. Really It's too useful for every one to use basic excel and do some analysis. keep sharing your knowledge and teaching bro. Thank You so much for the project.
Glad you liked ✅️
This video shows very detailed and easy way to understand that how to analyze and make a effective dashboard. Great teaching skills
Glad it was helpful!
Successfully completed this amazing video❤
The best tutorial so far , thenx a lot
Glad you liked ✅️
What a magician you are🎉 loved your work, keep it up.
Glad it was helpful ✅️
Great Man ❤
Thanks a lot! Great video. Will surely add this in my resume !
Glad it was helpful! ✅️
Thanks a lot, bhaiya the whole playlist was a solid insightful playlist. :) I wish you the best and looking forward to learn more from your channel.
Glad you liked ✅️
Your Content is informative and easy to understand. Nice explanation, in a single video i have learned how to make dashboard. Thank You.
Glad it was helpful! ✅️
fantastic sir, got the general idea, more help full than besic data anlyst describing videos
This video is so good. I watch this video without any break and create a dashboard on excel as a sample project. Thanks for this video sir❤
Glad it was helpful! ✅️
Worth to watch.. of ever second.
Glad it's helpful ✅️
Thank you for the wonderful job .
Thank you for this... I learned alot from this. and I am also learning Power BI from your videos...
Thanks bro for these wonderful job...
Glad you liked it ✅️
no words for your appreciation, please keep it up sir. we need some critical as well as advance projects in Excel.
Glad you liked ✅️ n noted ✅️
Finally my search is complete . Rishabh bhaiya you have all the quality and technique of teaching that the freshers is looking for .
Glad you liked the content ✅️
bro u are really gr8...I'm following ur roadmap for data analytics and trying to learn each and every skill from ur channel which is in the roadmap...lots of love bro💗💗
More appreciated 👍
More power to you 💖
Thanks for sharing this with us..
This was so helpful and amazing! Thank you for this
Glad it was helpful! ✅️
Thank you for this video. Learning a lot from your videos.
Thank you so much sir, I leaned a lot today from you. completed this project all by myself.
Awesome, keep learning n keep growing 🚀
Thank you so much for sharing such a valuable content!! Kindly bring more such projects, Thanks once again!!!
More projects to come! 👍
Thankyou for posting these kind of videos. Today I did my first report and I'm so happy. Please post more videos like this.
Glad you liked it ✅️ all the very best 👍
Thanks a lot brother. This is my first project practice. ✨keep shining
Glad you liked ✅️
you are life saviour bro...lots of love and respect ❤❤
Glad you liked ✅️
I usually don't comment, but I really have to thank you for this video. You are great. May you get more success in your life.
I appreciate it 💯, keep learning n keep growing 🚀