Dynamic Excel Dashboard from Start to End Development | Ecommerce Sales Analysis Dashboard

[@zeusmark8940]

So many learnings from this 90 minutes video. Kudos to you!

[@MotoTra]

This type of content should not be free on KZbin ,thank you so much brother

[@harikrishna2833]

Thanks bro i have learned more excel key techniques in dashboard buildings from this session ♥♥

[@dipaksingh4673]

1 Number Bro👍👍 You are real Data Analyst...

[@datatutorials1]

Thanks bro, keep supporting

[@DesiDose8]

How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@DesiDose8]

@@datatutorials1 How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@falaksaeedkhan5318]

Bhaiyya ji..... You are a wonderful man and even more marvellous teacher. Thanks a lot brother. Thanks a lot. May you achieve the best of your life, and may Allah guide you to the right path in life. Love you a lot brother.❤❤❤❤❤

[@DesiDose8]

How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@kunalkumaraiml2365]

Thank you so much for such great and insightful project as a beginner in Excel.

[@shashankverma2364]

Bhai tu jo bhi hai lekin jis tarike se tune btaya hai sayed koe na bta paye kaise create karna h dashboard thanks a Lot bro ❤️❤️💜🌼 Genuine people tum jaise hi content creator ki wajah se utube dekhte h i will follow you and subscribe you and learn from you 💖

[@DesiDose8]

How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@mashokhan8811]

Excellent bhia wow what a work great

[@manishnegi6927]

BHAI GJAB AWESOME WORK YOU ARE DOING A GENIOUS YOU ARE I HAVE FOLLOWED YOUR FULL VIDEO

[@nethra9449]

Awesome video, very helpful

[@ankitparjapati7846]

GOOD JOB MAY GOD BLESSED YOU FOR YOUR WORK.

[@basavarajm.k9552]

SUPERB . Thanks for the useful video

[@chandrashekhargt1172]

tq sir for amazing explanation and arrangement of the dashboard

[@Vanguard1729]

HI, if we change the values will the spark line change accordingly?

[@okojieidemudia2601]

Hi. Thank you for the video I followed all the steps and got a very excellent dashboard God bless. I await more videos

[@Safar31234]

Kindly make more videos it is helping me a lot

[@caezarjoseffjacob888]

hi. i think if you filter your data according to year , example you choose 2012, there will be an error in your YOY growth, how do you fix that

[@aishwaryapattnaik3082]

Very clear explanation. Can you make complete end to end projects for Portfolios using SQL and Power BI please.

[@datatutorials1]

Glad you liked it ✨

[@aamirrather-ee8le]

Hello where did you reach in data analyst journey plx rply

[@aamirrather-ee8le]

mujhe apna saaath hi sikhata ap khud b sekhta aisa ma b sikhta

[@rishikeshsharma6997]

What if you don't have Map Chart option in Excel ?

[@mukesh1984rai]

Thanks for this wonderful video. I was worried because tomorrow I have to make a presentation for my office. This video helped me a lot. If you have any specific course for dashboards then also I want to buy this.

[@sundayamoo84]

nice video, but pls can you do the one where itll be english throughout? commenting from Nigeria

[@harshsinha6933]

Hello Bro, My YOY growth is not updating while selecting slicer filters in the dashboard. Let me know where I am missing? Please. Waiting for your response.

[@rajachanpreetsingh]

Thanks for the wonderful informative session 💯💯💯

[@alispeaks6182]

THANK YOU SO MUCH BHAI MUCH APPRECIATED

[@datatutorials1]

Happy to help

[@shrutipravingore6451]

Can you please make a video on how to save and share in both pdf and excel format? As the dimensions matters!

[@abhishekkumar-qi3is]

sir please make vedio on project explanation to client on power bi.Thanks

[@kajalsharma5889]

Hi swapnajeet, thanks for explaining in amazing way ,your video was recommended to me by one of my linkedin member . few things i have not understand *firts map chart in my case its showing 70% of the data only and the number formating which you done in top 5 sales i tried the same but the numbers are coming up differently could you please mention why map is not working rest thanks for your efforts in making this video

[@datatutorials1]

For map you need to connect your system to internet connection, and you should have at least 2019 excel version

[@kajalsharma5889]

@@datatutorials1 thanks for responding

[@ronygeorge1996]

Can u make videos on SQL?

[@tunjiadeleke389]

Please do you have an English version of this project?

[@Nexus26688]

THANK YOU

[@a_mhite2]

Please use below formula for KPI design :). It will take time to search in excel. Thanks Swapnajeet. [Green] ▲ 0%;[Red] ▼ -0%

[@datatutorials1]

Thanks

[@nehapetkar96]

The year filter is not working for YOY Growth. Please suggest something

[@mkkhan8695]

Sir what insights we recieved from this dashboard?

[@shahriarrahman6989]

@Data Tutorials how did you derive the month from the order date?

[@datatutorials1]

Yes

[@shahriarrahman6989]

@@datatutorials1 how did you derive the month from the order date?

[@sameerabanu3115]

commendable

[@kajalyadav4299]

Hello, can you please explain how you were able to create grouping by year and quarter, when you created the first combo chart of sales and profit analysis. Because I tried to first extract month from each date coloumn but was unable to. Please help.

[@rahulk-m9h]

you can do it with the help of pivottable

[@thatsmylife]

Nice explanation Sir step by step Tabs very accurately positioned according to the hierarchy

[@datatutorials1]

Thanks

[@DesiDose8]

@@datatutorials1 How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@Only_ambi]

I tried the YOU growth but i got an error after using filter to change the year, i go a ref- error, any idea why?

[@ejazahmed5716]

Amazing.. 👍..

[@DesiDose8]

How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@leelasaimadhurimunisetti6542]

Hello sir, i am trying to create the increase and decrease formula but when i am trying to paste the increase symbol in format bar it is showing letter p and decrease symbol as q what should I do

[@fiazahmed1960]

For up arrow press alt key and hold + type 30 then release the key you will get ▲ and for ▼ press and hold alt key and type 31

[@gaminggod7726]

Bhaiya, in the map chart if you are inserting the slicer then after clicking at any year, Grand Total is automatically coming in the table and in values it is showing error in 4 boxes. Please tell me how to solve it.

[@datatutorials1]

Have you linked slicers to all charts

[@gaminggod7726]

@@datatutorials1 yes I did after doing it, actually it's happening Grand total box is automatically coming in chart..

[@hayaabokmail3581]

Can you make access to data available?

[@shubhodeepmitra8914]

maza aa gya

[@shreshth_gyaan]

can this all be done with version 2010 ?

[@datatutorials1]

Yes

[@YashSingh-rf2hz]

when i m putting order date in row coloum its not showing year what to do ?

[@HenilJain1]

hello sir , i tried to make pivot table but in pivot table it is showing that you have blank values but i am not able to see any blank values. pls help sir

[@marwaomar3804]

me too, but I reached to solution by clicking on the blank cell choosing the slicer setting then choosing hide items with no data. I'm not sure if that's true or wrong!

[@kamlamalviya111]

In ecom platform many products are return, please let me know what to do for return?

[@rishikeshsharma6997]

What if you don't have Map Chart option in insert Chart ???

[@adeyemileyefashiku648]

Love to learn but how do i get the english version. Thanks.

[@imranmohammed2644]

Thanks so much for the wonderful video. Appreciate if you can share the dashboard in excel?

[@datatutorials1]

Glad you liked it ✨

[@sahilsingroha270]

Sir mai Excel 2013 use kar raha hu uske map chart or waterfall chart nahi hai, konse version me aayege ye sab

[@datatutorials1]

Try using version MS Office 2016 or above

[@bilalhassankhan221]

Excellent

[@khushbujaiswal-y5c]

sir can you plz tell me how to add this project in linkedin. i tried onedrive but than it show some charts are not supported, i also tried to upload a video of my dashboard in linkedin but video is not uploading there.

[@Official_Suraz]

MAP CHART IS NOT SHOWN IN OFFICE 2016 HOW CAN I MANAGE ?

[@PodcastDecode]

mera first time pr order id add krne pr row label ki poori list agyi koi year month nai aya koi help kr skta hai?

[@bikashkumarparida7595]

sir , why do not you make only project based course with vedioes... that will be help full for us..plese make

[@mbacreator-g3p]

hey sir...where did you get this dataset?

[@datatutorials1]

Kaggle

[@vishalsarate3834]

Thanks Sir

[@khaledkhalifa3132]

good job I speak arabic and english only but i undertud your explanation , can you please mention the version of excel that you use ?

[@datatutorials1]

Office 2021

[@khaledkhalifa3132]

@@datatutorials1 thank you very much

[@jfzr_]

Hi! can you tell me the data source? i need it, thank you

[@pasha9806]

the pivot table activity takes so long, please suggest something?

[@datatutorials1]

Its the easiest way to

[@pasha9806]

@@datatutorials1 yes, I figured it out. Thanks for the reply!

[@arslanfaraz519]

how did you derive the month from the order date?

[@syedasad5037]

Thank you brother

[@rishabh1791]

In pivot table order date is displayed in months, but in my case pivot is retrieving data as it is in table i.e. mm/dd/yy format. how to club individual dates in form of months

[@datatutorials1]

Hi Rishabh, if you are not getting the month column automatically generated in your Excel, you can create a custom column in the data. Use this formula to do this TEXT(A2, "mmmm"). Here A2 will be the cell where your first date value would be, and then drag this formula in that column till the end. I hope this helps if not reach me on my WhatsApp number mentioned in description of the video

[@mojojojo71]

I was having the same problem after wasting lot of time i found that you just have to GO IN ANALYZE TAB AND CLICK ON GROUP SELECTION UNDER GROUP RIBBON AND THEN SELECT MONTHS.

[@datatutorials1]

Yes this can be done to generate automatically from the date field, thanks @mojojojo71

[@mojojojo71]

@@datatutorials1 bro nice tutorial but please mention your software versions from next time its difficult for us to find why its not working i have been installing all versions of ms office plus/pro 13 but couldn't get map but just found that its not available in excel 13.

[@datatutorials1]

Yes, definitely, thanks for bringing this up

[@bomb143]

Sir, I made a similiar dashboard for practice but whenever I click on any of the slicer value for eg: Consumer then the KPI values i.e in quantity #11608 and other KPI becomes zero.

[@datatutorials1]

Can you share me the screenshot of KPI sheet and dashboard on my mail

[@bomb143]

@@datatutorials1 sure sir

[@mhitdhiman1722]

Thank bro

[@treijunta1467]

I want a custom investment profit loss stock buy and sell with margins elegant and dynamic graphics how do I contact you?

[@bomb143]

Thank you so much sir

[@Adarshi.]

What id data Name nd where i can found it???

[@sajidhussain-hy8nw]

Wow great

[@DesiDose8]

How do we get the reason behind the low sales in bottom 10 states with respect to sales??? Plz answer!!!

[@manangoyal3896]

WHAT IF I CHANGE YEAR AND THEN ALL THE % WILL NOT WORK AS THE FORMULA IS FOR 2014VALUE/2013 VALUEAND NOT FOR OTHER VALUE

[@syedalsalehmohammed9975]

Your the best

[@gaptours1897]

Sir can we make data from tally

[@datatutorials1]

Yes

[@vaidiksirsate6776]

Really good

[@vishwajeetjadhav-3809]

Can u plz write the explanation what we have done in this project so we can write it on resume

[@abhishekswarup5352]

I have a huge number of products ,how can I make it in a dashboard ? It became too long

[@shimaamohamed6658]

WHY YOY NOT WORKING WITH SLICER GIVE ME ERROR ?

[@kanchanvyas5490]

Hey Sir, this is fantastic video tutorial . Loved working on it.Can I use it in my resume ?

[@pooravraj7805]

Definitely

[@flavio225]

Where can we download

[@siddarajpujari6988]

Where do I get this data

[@niconisyncomm2599]

Hi can we buy this ?

[@NikhilGuptha-fy5le]

can u please share the excel sheet with dashboard

[@datatutorials1]

Ready file is chargeable

[@shreshth_gyaan]

maine order date dala pivot table mein to aise nhi aa rha data jaise video mein h (year,quarter). Jaisa main data mein h waise hi pivot table mein aa rha h . How to fix it ?

[@datatutorials1]

Aap extract kar sakte ho month and quarter

[@shreshth_gyaan]

@@datatutorials1 extract krne k liye option hi to nhi aa rha. How to get that option ?

[@siddarajpujari6988]

How to download it

[@mdhabiburrohman5626]

Hi, Data show only for view. Cann't download. Please open download restriction.

[@datatutorials1]

Access now

[@nischalaks9838]

Hi sir, can I get business analyst job based on Excel?

[@datatutorials1]

You can get as an MIS Executive

[@muhammaduseram9405]

i am unable to convert data to table , is this access issue? Lol what wrong with file not even converting to table after pressing CTL + T

[@SameerAnsari-tv5ot]

Same problem

[@vini_kartik]

Really wish this was in english

[@Aditya99000]

Kaise banaye

[@parvezrehman9977]

Can you share this Dashboard please

[@datatutorials1]

Contact me on my WhatsApp number available in description of this video

[@edwinotieno9189]

You should do one in english

[@SameerAnsari-tv5ot]

Bhai profile nai nikal raha hai mera 😢

[@siddarajpujari6988]

Kindly send Data link for practice

[@Aditya99000]

Bhaiya ji Jo deta h Ka naam kya h

[@datatutorials1]

Data link is in discription box of video

[@arbaazshah7946]

1:17:20

[@Official_Suraz]

custom maion kaise banaye arrow yehi explain karna chahiye copy nahi ho ra hai

[@harish1838]

42:42

[@arbaazshah7946]

50:15

[@abhishekchauhan9854]

bro can you plzz re upload the original data kyuki date format ki galte ha data me kafi kafi place me months ki place pe dates ha and error ha uski wajha se bahot plzz re upload like you can check order date me 3rd date and many more

[@datatutorials1]

Sure, thanks for letting me know