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!!!! :)
@@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....🌟👏👏👏👍❤️
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.
Developed a comprehensive sales dashboard in Excel, involving data cleaning, pivot tables, and various visualizations like sales by category, profit trends, and customer insights. This project provides clear actionable insights into sales performance and trends.
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.
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 -
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.
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.
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
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
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.
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.
actualy jo date order apne btaya wo blkull theek hogya lekin cell # 4000 se age meri dates order nhi hui or year or month ka formula b year or month k coloums pr exact same cell se formula apply nhi ho rha .... could you plz suggest me the solution for this
The dashboard is really amazing 🤩
Thank you for this type of content 🙏
isa ki sheet mila jaygi kay
Your way of explaining things is very good . And you are very organised. Thanks.
Thank you
Thank you so much. From now on this is my first excel dasboard project 😃
keep learning brother ............your future is bright ,..........keep growing ❣
Thank you. This Dashboard was really insightful, I got very good understanding of how to create dashboards in Excel.
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
Best excel project so far
Your way of explanation is excellent.....it really helped me a lot.🙏🙏🙏🙏❤
Excellent maam👌 Thank you so much for providing us this kind of practical work videos ❤
Amazing. Respect from Lahore Pakistan 🎉
Mind blowing project mam, I have learn many new things. Thank you so much mam.......
Thank you mam 🙏 this the best dashboard of Excel 🎉❤
Thanks and welcome
I really like your video I just search Excel data analysis project on RUclips and it land me to your video your amazing 😊
I really appreciate this video 🥰
Glad it was helpful!
Thank you for your wonderful explanation
I have completed this project.
You explained in very simple language ❤
Thanks a lot 😊
Really amazing 👍👍 , thank you 🙏
ma'am you are teaching amazing so thank you ....
GREAT JOB, KEEP IT UP.
this project is very interesting and amazing thanks mam
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....🌟👏👏👏👍❤️
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
good one and nicely explained
Great jo job ❤
Thank you! 😄
Thank you so much. Please do a SQL and Power BI end-to-end project too
Loved the content. Thankyou so much
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.
Thank You Very Much !!👍👍
Enjoyed it. Thank you for sharing. Please make a new video on sql + excel+powerbi.
Thanks, will do!
nice make more vdios like this great content
Sure.
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
Developed a comprehensive sales dashboard in Excel, involving data cleaning, pivot tables, and various visualizations like sales by category, profit trends, and customer insights. This project provides clear actionable insights into sales performance and trends.
Give to ChatGPT and ask it to generate points for my resume with metrics and add the same to your project
Great Tutorial
Thanks!
enjoyed it. thank you for sharing. will you please make another excel dashboard making video.
Gjb maim ❤❤❤❤
addmy
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.
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 -
amazing dashboard
Thank you
Imformative
Excellent dear.
it is really good. Can you make the data analyst project in excel with the case study of the fitbit fitness tracker.
thank you bahut badiya dashboards in execl
Thank you so much 👍 for sharing this video. Could you please share the raw data?
Thanks mam.. ❤
Apne end me conclusion to bataya hi nhii pure dashboard ka insight
Plzz make more videos on Data Analytics projects like this......
Sure
Thank you for this video ❤
is this enough for data analyst role to be put up in resume?
You are doing great. We would appreciate if you could speak English as well. Different people follow you
very nice
Very very good video thank you mam🥰🥰
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.
Thank You so much for providing us with this valuable content, But i can`t find this excel file
Thanks madam !
really very helpful ..
I have excel 2016 , and its not showing funnel charts and other features, what to do in this case ? please help
Amazu
Koi bta sakta hai ki ye Excel ke kis version me bna hai 2013 yah us se uper
🙏Thank you very much your amazing help and support Madam🙏❤
Amazing project
Mam power BI pe ek complete course ka video banayen. By the way Thanks for giving such valuable content🙏.
very nice teaching maam.. please make some sql tutorial with sql projects... pls pls pls
mam insted of creating another pivot table , you can copy the same pivot table
can you plzz share the data set that would be very helpful
Given in description
Wonderful dashboard but i wanted to write insights in resume can you please share insights of this project
Ma'am how to make report after data analysis.please make a video on that
Why do u always use pink theme?👀
I like the color
Thank you really helpful
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.
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
Solution bta dy
Tnq so much Mem
Thanks a lot
To extract year from date: =TEXT(cell_number, "yyyy")
To extract month from date: =TEXT(cell_number, "mmm")
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
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
Where we can download this table??
Link given in description
Thank you ma'am
can anyone provide kaggle link for this dataset?
Thank you
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
India me F.Y. April to March hota hai to USS case me kaise ham alag alag financial year ka dekh sakte hai ??
Great
Thanks mam
Nice
Thanks
❤
Hi, my Order date is not taking correct format. Please help me here
cool dashboard
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,
hi mam please make a video on differnt power bi project other than sales data for resume
Please make on SQL project end to end
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
How to add funnel chart in excel ?.it is not showing in my excel...??.
Mera office 2010 hai esme pura date filter nhi ho pa rha
Upgrade karlo office 2021 me switch ho jao
there is no map chart in excel 2016 !! which version u are using ? >
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
😮
actualy jo date order apne btaya wo blkull theek hogya lekin cell # 4000 se age meri dates order nhi hui or year or month ka formula b year or month k coloums pr exact same cell se formula apply nhi ho rha .... could you plz suggest me the solution for this
Worth it
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
yr explanation to acha hai easy to understand bhi h but files practice k liye open ku ni hoti h ,
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.
Appreciated
Where's the data sheet?
Please share the data sheet
Given in the description