Build an Awesome Excel Dashboard | PORTFOLIO Project | Data Analyst Project | Sales Dashboard

[@ChandanKumar-fg2nu]

The dashboard is really amazing 🤩 Thank you for this type of content 🙏

[@ashishkhanger4412]

isa ki sheet mila jaygi kay

[@not_a_userz]

Thank you so much. From now on this is my first excel dasboard project 😃

[@i_love_you-m9n]

keep learning brother ............your future is bright ,..........keep growing ❣

[@stressfreesuperstars]

Your way of explaining things is very good . And you are very organised. Thanks.

[@techclasses0810]

Thank you

[@shubhamtiwari4024]

Best excel project so far

[@amitshelke9447]

Thank you. This Dashboard was really insightful, I got very good understanding of how to create dashboards in Excel.

[@DaudAsif-pl3ci]

Amazing. Respect from Lahore Pakistan 🎉

[@prithvinandan]

Mind blowing project mam, I have learn many new things. Thank you so much mam.......

[@rohanbilwal6974]

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!!!! :)

[@AnkitSingh-sq4xq]

bhai data analysis me job mili ya nahi

[@mushrafbehlim9546]

ma'am you are teaching amazing so thank you ....

[@travellingswing1610]

Excellent maam👌 Thank you so much for providing us this kind of practical work videos ❤

[@dattatrayshirke3479]

Really amazing 👍👍 , thank you 🙏

[@babita612]

Your way of explanation is excellent.....it really helped me a lot.🙏🙏🙏🙏❤

[@shayanxxmark21]

I really appreciate this video 🥰

[@techclasses0810]

Glad it was helpful!

[@MdRizwan-qo3iu]

Thank you for your wonderful explanation I have completed this project.

[@AbdulAziz-wr6gq]

this project is very interesting and amazing thanks mam

[@muraliiyer7850]

GREAT JOB, KEEP IT UP.

[@nikigupta3201]

You explained in very simple language ❤

[@techclasses0810]

Thanks a lot 😊

[@pratikkhond8786]

I really like your video I just search Excel data analysis project on KZbin and it land me to your video your amazing 😊

[@themoonstruckgurl]

Thank you so much. Please do a SQL and Power BI end-to-end project too

[@divyanshuranjan6984]

Loved the content. Thankyou so much

[@shikharsharma213]

Thank You Very Much !!👍👍

[@jkll435y]

good one and nicely explained

[@Nailipari]

Great jo job ❤

[@techclasses0810]

Thank you! 😄

[@creationbyme280]

Thank you mam 🙏 this the best dashboard of Excel 🎉❤

[@techclasses0810]

Thanks and welcome

[@BiKe_LoveRs98]

Thanks mam.. ❤

[@shivamsrivastav5576]

Enjoyed it. Thank you for sharing. Please make a new video on sql + excel+powerbi.

[@techclasses0810]

Thanks, will do!

[@aditipatil9491]

nice make more vdios like this great content

[@techclasses0810]

Sure.

[@partappuriastudio4435]

Koi bta sakta hai ki ye Excel ke kis version me bna hai 2013 yah us se uper

[@diyaghosh5104]

enjoyed it. thank you for sharing. will you please make another excel dashboard making video.

[@echodelta7680]

To extract year from date: =TEXT(cell_number, "yyyy") To extract month from date: =TEXT(cell_number, "mmm")

[@poonamrathod4049]

it is really good. Can you make the data analyst project in excel with the case study of the fitbit fitness tracker.

[@asifsattar-nv4di]

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 -

[@rakeshsharma-pn8pn]

thank you bahut badiya dashboards in execl

[@indrajitdas8811]

Thank You so much for providing us with this valuable content, But i can`t find this excel file

[@EnglisMotivational]

amazing dashboard

[@techclasses0810]

Thank you

[@EducationHub112]

Very good and informative video if you provide a dataset then easy to practice ...

[@techclasses0810]

Its available in the description, please check

[@Sahil-ev5pm]

@@techclasses0810 Which excel version your using mam

[@sanshichauhan7885]

@@techclasses0810 is it paid ?, its asking to pay some amount, the dataset is not given.

[@sakshiv5380]

Hi Ayushi, really appreciate your efforts!! Could you please guide how I can add project summary on my resume?

[@techclasses0810]

You can create the description with these points, what is the end goal of the project, how it help anyone and technology used.

[@ShivamChaudhary-jn4kw]

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.

[@_finger_bites_]

Thank you for this video ❤

[@dhirendkr7306]

Thank you so much 👍 for sharing this video. Could you please share the raw data?

[@BilalBilsl-uw9vp]

Excellent dear.

[@anshu_chauhan471]

Please make on SQL project end to end

[@amalarya1]

Imformative

[@funnyvideo.2295]

Gjb maim ❤❤❤❤

[@ashishkhanger4412]

addmy

[@anilworldwide]

Thanks madam !

[@jayeshkumbhani1531]

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.

[@ChaitanyaBhargava-k5n]

is this enough for data analyst role to be put up in resume?

[@exceltips305]

Very very good video thank you mam🥰🥰

[@recipy532]

Apne end me conclusion to bataya hi nhii pure dashboard ka insight

[@pavangsk8404]

very nice teaching maam.. please make some sql tutorial with sql projects... pls pls pls

[@shawsubham097]

really very helpful ..

[@dilnawazahmed949]

Plzz make more videos on Data Analytics projects like this......

[@techclasses0810]

Sure

[@amandeepbadgujjar7096]

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.

[@KishanManocha-o7c]

Thanks a lot

[@DPMotivationDhruvPandit]

Amazing project

[@saurabhrmahajan]

very nice

[@NohablaEspnaol]

Thank you

[@GOVINDTHAKRE]

Mam power BI pe ek complete course ka video banayen. By the way Thanks for giving such valuable content🙏.

[@Bhupendarvlogxd7io]

पर teacher sa excel file muja save karni nahi aw rahi project to bana leya plese reply mam ❤❤❤❤❤❤

[@dikshatripathi6209]

Ma'am how to make report after data analysis.please make a video on that

[@nishanth4323]

Ohh wow😯😯 Thank you very much I was waiting for this 🌟👍👍👍👌👌👌🤗

[@techclasses0810]

Hope you like it!

[@nishanth4323]

@@techclasses0810 There is nothing to dislike, and I am still watching....🤗

[@nishanth4323]

​@@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....🌟👏👏👏👍❤️

[@Aryan_Mathur_]

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

[@henry9746]

Same here...

[@Rahul-vv4dn]

Mis report h bhai

[@karthiknimada]

Did you get what to write about this project in resume

[@AnandRai-s7b]

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.

[@praveenroyal2941]

Give to ChatGPT and ask it to generate points for my resume with metrics and add the same to your project

[@makarsh29]

mam insted of creating another pivot table , you can copy the same pivot table

[@rana_osman13]

Thank you really helpful

[@swastikaggarwal221]

I have excel 2016 , and its not showing funnel charts and other features, what to do in this case ? please help

[@SanjibBag-MyPortfolio]

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.

[@910raj]

Tnq so much Mem

[@JKelvinFallah]

You are doing great. We would appreciate if you could speak English as well. Different people follow you

[@vashitvaraj3520]

can anyone provide kaggle link for this dataset?

[@ajaynirmal3150]

India me F.Y. April to March hota hai to USS case me kaise ham alag alag financial year ka dekh sakte hai ??

[@karthiknimada]

Wonderful dashboard but i wanted to write insights in resume can you please share insights of this project

[@paulabhilash5852]

hi mam please make a video on differnt power bi project other than sales data for resume

[@kimtan110]

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

[@SALONIVASHISHTH]

can you plzz share the data set that would be very helpful

[@techclasses0810]

Given in description

[@BalajiBhajan111]

Great Tutorial

[@techclasses0810]

Thanks!

[@angadgupta8438]

Mam sum of profit mein sorting nahi ho rahi

[@geetika09]

Great

[@shubhamsingh-vz5qo]

Thanks ❤️

[@prernatayal]

Hi, my Order date is not taking correct format. Please help me here

[@SumitDas-y9l]

Mam muja excel main invoice banana, attendance sheet, stock maitin,karna ata ha excel project kaha s milgha please tora guide kija

[@GigglyGiraffes]

yr explanation to acha hai easy to understand bhi h but files practice k liye open ku ni hoti h ,

[@The____One]

Thanks mam

[@saurabhsahu1135]

Thank you ma'am

[@swastikaggarwal221]

there is no map chart in excel 2016 !! which version u are using ? >

[@neelumewara7994]

How to add funnel chart in excel ?.it is not showing in my excel...??.

[@PritamPaul717]

Thanks didi 😊

[@sudhansubhol6052]

Mam make a video on Tableau project

[@West_Side100]

🙏Thank you very much your amazing help and support Madam🙏❤

[@no_more_stressss]

ma'am bahut acha dashboard tha

[@techclasses0810]

Glad you liked 😇

[@no_more_stressss]

@@techclasses0810 maine bnaya tha aur last m save karne mai kuch glti hui save hi nhi hua ab dubara se bnana padega

[@AnkushMishra-q5l]

Why do u always use pink theme?👀

[@techclasses0810]

I like the color

[@AbdulBasit-bd9td]

cool dashboard

[@utkarshjaiswal303]

Power bi ke tutorial videos banaiye

[@Vaishali_kitchencorner]

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

[@jitendrajd5595]

Mera office 2010 hai esme pura date filter nhi ho pa rha

[@saarvibe]

Upgrade karlo office 2021 me switch ho jao

[@riyanplex5623]

Appreciated

[@somranjan5810]

Some of the dates in date column is not changing. Can anyone help ?

[@manasavenkatareddy381]

Please show how do update and upload projects in git hub

[@Vaishali_kitchencorner]

Report connection me pivot table sab dikh hi nahi hai

[@Hellyeah22916]

hey make a video maths and stats on every topics which importent for data analist role make a fast video

[@techclasses0810]

✅ Book 1:1 call with me (Career Guidance, Resume Review, LinkedIn Profile Review) : topmate.io/ayushi_mishra ✅ Job Preparation and Interview Guide: topmate.io/ayushi_mishra/842027

[@nishanth4323]

Thank you very much I was waiting for this 😊👏👏👍🤗

[@utkarshjaiswal303]

I want to learn power bi suggest from where I can learn it.