Build an Awesome Excel Dashboard | PORTFOLIO Project | Data Analyst Project | Sales Dashboard
HTML-код
- Опубликовано: 27 июл 2024
- Recommended Projects for Portfolio:
✔ Power BI KPI Dashboard: • KPI Dashboard for Begi...
✔ End to End Data Analyst Project using Python: • Data Analysis End-to-E...
0:00 - Dashboard Introduction
2:56 - Understanding the Business Problem
4:41 - Data Cleaning and Preparation
10:18 - Inserting Pivot Tables and Charts
25:55 - Creating Dashboard
Dataset Used : drive.google.com/file/d/1Gc_n...
💡Complete CRASH Course of STATISTICS: • Complete STATISTICS fo...
Complete Resource of the Project: topmate.io/ayushi_mishra/886630
➖➖➖➖➖➖➖➖➖➖➖➖➖
💡 Complete Statistics eBook (Written by me covering all topics): topmate.io/ayushi_mishra/865848
👍 Subscribe for more Data Science content: bit.ly/48MFgCf
➖➖➖➖➖➖➖➖➖➖➖➖➖
Follow me on:
✅LinkedIn: / ayushi-mishra-30813b174
✅Instagram: / techie.data
🔥 Book 1:1 call with me (Career Guidance, Resume Review, LinkedIn Profile Review) : topmate.io/ayushi_mishra
Other Useful Videos:
Data Analyst Roadmap: • 3 Months Data Analyst ...
Data Analysis Project using Python: • Data Analysis End-to-E...
Python vs R: Which is best for career? : • Python VS R | Choose t...
Data Analysis Project using Python and SQL: • Data Analysis SQL Proj...
Related keywords:
excel dashboard project for data analyst
sales dashboard
excel dashboard
excel data analysis project
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
Thank you. This Dashboard was really insightful, I got very good understanding of how to create dashboards in Excel.
The dashboard is really amazing 🤩
Thank you for this type of content 🙏
Thank you for your wonderful explanation
I have completed this project.
Your way of explanation is excellent.....it really helped me a lot.🙏🙏🙏🙏❤
Best excel project so far
I really like your video I just search Excel data analysis project on RUclips and it land me to your video your amazing 😊
Amazing. Respect from Lahore Pakistan 🎉
Mind blowing project mam, I have learn many new things. Thank you so much mam.......
Excellent maam👌 Thank you so much for providing us this kind of practical work videos ❤
Loved the content. Thankyou so much
Thank you for this video ❤
Thank you so much. From now on this is my first excel dasboard project 😃
keep learning brother ............your future is bright ,..........keep growing ❣
ma'am you are teaching amazing so thank you ....
Thanks for providing us with this valuable content. This would be really helpful for our future growth in Data Analysis Field. Loads of love Ayushi!!!! :)
bhai data analysis me job mili ya nahi
Thank you so much. Please do a SQL and Power BI end-to-end project too
GREAT JOB, KEEP IT UP.
thank you bahut badiya dashboards in execl
this project is very interesting and amazing thanks mam
Thank you really helpful
✅ Book 1:1 call with me (Career Guidance, Resume Review, LinkedIn Profile Review) : topmate.io/ayushi_mishra
Thank you very much I was waiting for this 😊👏👏👍🤗
Excellent dear.
good one and nicely explained
really very helpful ..
Very very good video thank you mam🥰🥰
Tnq so much Mem
Amazing project
I was checking your playlist - you didnot finish any complete course of any topic like python -
I like your style of to the point lecture -
So please complete all your courses till advance level -
Thanks ❤️
Appreciated
Hii, could you please help me to normalize the date format?
I have tried through replace and text to the column, but nothing is working.
I could figure out the way but I lost the filter option yearly.
enjoyed it. thank you for sharing. will you please make another excel dashboard making video.
Great
Gjb maim ❤❤❤❤
Ohh wow😯😯
Thank you very much I was waiting for this 🌟👍👍👍👌👌👌🤗
Hope you like it!
@@techclasses0810 There is nothing to dislike, and I am still watching....🤗
@@techclasses0810 It was awesomely Fantastic after watching this video gained lot of confidence and seems not very difficult to prepare a dashboard in Excel.... Thank you for explaining in the simplest way....🌟👏👏👏👍❤️
You explained in very simple language ❤
Thanks a lot 😊
i am adding this project to my resume but dont know what to write. Please suggest a small para about this project so that i can copy that in my resume
Same here...
Mis report h bhai
Did you get what to write about this project in resume
Thank you ma'am
Very good and informative video if you provide a dataset then easy to practice ...
Its available in the description, please check
@@techclasses0810 Which excel version your using mam
Worth it
I have excel 2016 , and its not showing funnel charts and other features, what to do in this case ? please help
Thanks mam
Thank you so much 👍 for sharing this video. Could you please share the raw data?
very nice teaching maam.. please make some sql tutorial with sql projects... pls pls pls
it is really good. Can you make the data analyst project in excel with the case study of the fitbit fitness tracker.
cool dashboard
Thanks didi 😊
Great Tutorial
Thanks!
Hii your Excel dashboard blog is awesome such you are doing great job, well I have a question can you share insights information of this blog. It is very helpful for me to make different types of insights.
Plzz make more videos on Data Analytics projects like this......
Sure
Amazu
🙏Thank you very much your amazing help and support Madam🙏❤
Like it
How to add funnel chart in excel ?.it is not showing in my excel...??.
Some of the dates in date column is not changing.
Can anyone help ?
Ma'am how to make report after data analysis.please make a video on that
hi mam please make a video on differnt power bi project other than sales data for resume
there is no map chart in excel 2016 !! which version u are using ? >
Hlo ma'am I wanna ask you about which window are u using and which version. Because there are some features are not in my Excel
Hello ma'am. Thank you for this useful content.
I have built a dashborad based on your video and data that you've provided. I've modified the year so that it can be more relevant. But while trying to upload it to my portfolio I am facing an issue as Web Version doesn't support Map chart or Picture Cell reference which I've included in my dashboard. So I have uploaded it on youtube and using it as my portfolio.
Please make on SQL project end to end
can anyone provide kaggle link for this dataset?
I understand to make a dashboard but the slicer is not coming like you only one pivot table is coming why like that I was tried many a times but it was not connected with each other
Mera office 2010 hai esme pura date filter nhi ho pa rha
Hey mam i have some queries about "partnership financial account" how can solving my queries?.
ma'am bahut acha dashboard tha
Glad you liked 😇
@@techclasses0810 maine bnaya tha aur last m save karne mai kuch glti hui save hi nhi hua ab dubara se bnana padega
Hi Ayushi, really appreciate your efforts!! Could you please guide how I can add project summary on my resume?
You can create the description with these points, what is the end goal of the project, how it help anyone and technology used.
Hello Sakshi I have an error while doing analysis of the count of customers per year while removing duplicates some data like the year 2016 and 2017 is also removed why is it happening can you help me in this as I have done all the steps right but after applying remove duplicates the data and the year 2016 and 2017 is gone and is not seen after remove duplicate applied.
Mam make a video on Tableau project
hey make a video maths and stats on every topics which importent for data analist role make a fast video
You are doing great. We would appreciate if you could speak English as well. Different people follow you
Wonderful dashboard but i wanted to write insights in resume can you please share insights of this project
India me F.Y. April to March hota hai to USS case me kaise ham alag alag financial year ka dekh sakte hai ??
Mam when extract year from date it's shown value error for some date,some dates format is in general format after its change datatype in date format it's shown same error again
Same problem
maine phir se bna liya
Mam sum of profit mein sorting nahi ho rahi
form where you download dataset ?
Please show how do update and upload projects in git hub
I want to learn power bi suggest from where I can learn it.
please give the link of dashboard
When i open the downloaded dataset a few dates are in the format of dd/mm/yyyy instead of dd-mm-yyyy
You can try cleaning it
To extract year from date: =TEXT(cell_number, "yyyy")
To extract month from date: =TEXT(cell_number, "mmm")
Power bi ke tutorial videos banaiye
Please add English subtitles to all videos
yr explanation to acha hai easy to understand bhi h but files practice k liye open ku ni hoti h ,
my only 4k rows sorted
Mam muja excel main invoice banana, attendance sheet, stock maitin,karna ata ha excel project kaha s milgha please tora guide kija
Even if i change the date format i am unable to extract months. This problem is getting on my nerves how to solve it.
Separate the values of the cells in which you are getting the error and then concatenate by reversing dd with mm.
Is this dash board Dynamic? So if you have more rows of data can all all charts update accordingly?
Yes it will get updated
I don't think so. Because u copy data to right side of pivot table which isn't dynamic
Report connection me pivot table sab dikh hi nahi hai
Hello mam, can you please help in changing the date format. I have been trying to change them but still not working, due to this i am unable to continue the project kindly help.
Same happening with me
😮
First of i would like to thanks sharing knowledge through video very nice, actually i have problem in sales data when i was followed by video not sorting oldest to newest, i tried lots of time but not nothing happens kindly guide me thanks.
Please check your excel version, sorting is present in every version
Thanks for reply me madam, i have new version 2018, excel 365,
Hlo mam
Mam I have passout from (POLYTECHNIC) DIPLOMA IN ELECTRICAL in 2022
So mam my question is that
Can I do a course of DATA ANALYTICS and a JOB from technical degree
If yes so which course do I prefer mam
Plz suggest
Because mam I have not graduation degree that's why I am confused
Plz suggest..plz
you have degree first
your dataset is corrupted not working , i have try 2 times and still not working
What issue you are facing with the data, please mail to my email id, will check and resolve. Thank you
Sir Mera power bi and Excel ka course Kiya hua h but diploma nhi h private company me job ke liye jaruri hota h kya diploma bhi
Only graduation degree is required. No one will ask you for any diploma
Ma'am does mba is necessary for data analyst??
No
Can I use this as an portfolio project?
Yes you can
@@techclasses0810 Mam unable to finf funnel in my excel.Did you make a customized template or its inbuilt?
Hello mam Kay Mai data analyst ban paunga
Mane pura dashboard banaya mene firr save Kiya
Iske ba jab mene dubara se open Kiya to sare chart gayab ho gaye pura dashboard pata nahi kaha chala gaya 😅
Badhboard save kyu nahi hua please tell me
I think it is because you haven't save the dataset into Excel workbook form....it would be save in .cse format...change it and then save the whole dashboard
Mam what is the project name
Its a sales dashboard
Mam power bi developer Bana hai muje SQL ana jruri hai ky
Basic knowledge of sql is necessary for handling the database
@@techclasses0810 ok thick hai mam apki linkidn profile
@@techclasses0810 our ap bhot khubsurt ho
@@sayyedsahil4184 You can find the profile in the video description or on my channel page near banner
Hello mam iam a housemaker ,I have done MSc in physics 2018 wanted to become data analyst, as per requirements I know python,numpy,pandas and little excel need your help to know how I can get internship to learn more and how can I get job this year.your guidance will be helpful.
Yes, learn sql also