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

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

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

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 -

Best excel project so far

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

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

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

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

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

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

Mam sum of profit mein sorting nahi ho rahi

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

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

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

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

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

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

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

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

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

When i open the downloaded dataset a few dates are in the format of dd/mm/yyyy instead of dd-mm-yyyy

Really amazing 👍👍 , thank you 🙏

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

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

Thanks mam

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

Hey mam i have some queries about "partnership financial account" how can solving my queries?.

Gjb maim ❤❤❤❤

Thanks madam !

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

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.

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

Please show how do update and upload projects in git hub

Very very good video thank you mam🥰🥰

Hello mam Kay Mai data analyst ban paunga

Amazing project

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

I am facing the date issue can anybody help please.... dates are not in the same format some are in the / type and some of the dates are in - type Please help if any of you faced this problem

your dataset is corrupted not working , i have try 2 times and still not working

Thank you really helpful

Great Tutorial

please give the link of dashboard

Is this dash board Dynamic? So if you have more rows of data can all all charts update accordingly?

Power bi ke tutorial videos banaiye

Amazu

Tnq so much Mem

Great

ma'am bahut acha dashboard tha

Worth it

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.

maine phir se bna liya

Ma'am does mba is necessary for data analyst??

Can I use this as an portfolio project?

Yeh sab bahut lamba process hah ,you can build a dashboard by using power bi dashboard exporting Excel files usse aap visualisation kar sakte hoh comparing these

Like it

Sorry nahi samajh aa raha hai

Its a good project but I dont understand what you are saying, its not english

Mame aapki help chahiye ?

Hello

hiii

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

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

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

❤

Thanks mam.. ❤

Please make on SQL project end to end

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

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

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.

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

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

nice make more vdios like this great content

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

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

can anyone provide kaggle link for this dataset?

this project is very interesting and amazing thanks mam

Amazing. Respect from Lahore Pakistan 🎉

But u don’t connect Coustumer count 😢

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

good one and nicely explained

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

GREAT JOB, KEEP IT UP.

Mam excel basic se pdaya nai

Imformative

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

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

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

Thanks a lot

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

Thank you

very nice

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 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.

Report connection me pivot table sab dikh hi nahi hai

Mam what is the project name

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.

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

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

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

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