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.❤❤❤❤❤
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 💖
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.
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.
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
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
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
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!
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.
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.
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.
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.
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 ?
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
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
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 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.
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
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.❤❤❤❤❤
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
1 Number Bro👍👍
You are real Data Analyst...
Thanks bro, keep supporting
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
@@datatutorials1 How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
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 💖
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
Thank you so much for such great and insightful project as a beginner in Excel.
Excellent bhia wow what a work great
Good Work. Appreciated your hard insightful work...
Kindly make more videos it is helping me a lot
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.
tq sir for amazing explanation and arrangement of the dashboard
GOOD JOB MAY GOD BLESSED YOU FOR YOUR WORK.
BHAI GJAB AWESOME WORK YOU ARE DOING A GENIOUS YOU ARE I HAVE FOLLOWED YOUR FULL VIDEO
nice video, but pls can you do the one where itll be english throughout? commenting from Nigeria
Very clear explanation. Can you make complete end to end projects for Portfolios using SQL and Power BI please.
Glad you liked it ✨
Hello
where did you reach in data analyst journey plx rply
mujhe apna saaath hi sikhata ap khud b sekhta aisa ma b sikhta
What if you don't have Map Chart option in Excel ?
Hi. Thank you for the video
I followed all the steps and got a very excellent dashboard
God bless.
I await more videos
Awesome video, very helpful
SUPERB . Thanks for the useful video
Thanks for the wonderful informative session 💯💯💯
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
Please use below formula for KPI design :). It will take time to search in excel. Thanks Swapnajeet.
[Green] ▲ 0%;[Red] ▼ -0%
Thanks
HI, if we change the values will the spark line change accordingly?
sir please make vedio on project explanation to client on power bi.Thanks
commendable
THANK YOU
THANK YOU SO MUCH BHAI MUCH APPRECIATED
Happy to help
Can you please make a video on how to save and share in both pdf and excel format? As the dimensions matters!
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
Excellent
Can u make videos on SQL?
Thanks Sir
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.
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
For map you need to connect your system to internet connection, and you should have at least 2019 excel version
@@datatutorials1 thanks for responding
Nice explanation Sir
step by step
Tabs very accurately positioned according to the hierarchy
Thanks
@@datatutorials1 How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
Amazing.. 👍..
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
maza aa gya
Thank you brother
sir , why do not you make only project based course with vedioes... that will be help full for us..plese make
Really wish this was in english
Wow great
Thank bro
Thank you so much sir
Can you make access to data available?
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
Really good
The year filter is not working for YOY Growth. Please suggest something
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
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!
when i m putting order date in row coloum its not showing year what to do ?
Please do you have an English version of this project?
Love to learn but how do i get the english version. Thanks.
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?
Thanks so much for the wonderful video. Appreciate if you can share the dashboard in excel?
Glad you liked it ✨
Hi! can you tell me the data source? i need it, thank you
Can u plz write the explanation what we have done in this project so we can write it on resume
Hey Sir, this is fantastic video tutorial . Loved working on it.Can I use it in my resume ?
Definitely
Sir what insights we recieved from this dashboard?
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.
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.
you can do it with the help of pivottable
What if you don't have Map Chart option in insert Chart ???
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?
You should do one in english
In ecom platform many products are return, please let me know what to do for return?
good job I speak arabic and english only but i undertud your explanation , can you please mention the version of excel that you use ?
Office 2021
@@datatutorials1 thank you very much
how did you derive the month from the order date?
I have a huge number of products ,how can I make it in a dashboard ?
It became too long
MAP CHART IS NOT SHOWN IN OFFICE 2016 HOW CAN I MANAGE ?
WHAT IF I CHANGE YEAR AND THEN ALL THE % WILL NOT WORK AS THE FORMULA IS FOR 2014VALUE/2013 VALUEAND NOT FOR OTHER VALUE
What id data Name nd where i can found it???
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
I want a custom investment profit loss stock buy and sell with margins elegant and dynamic graphics how do I contact you?
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
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.
Have you linked slicers to all charts
@@datatutorials1 yes I did after doing it, actually it's happening Grand total box is automatically coming in chart..
Where can we download
the pivot table activity takes so long, please suggest something?
Its the easiest way to
@@datatutorials1 yes, I figured it out. Thanks for the reply!
Sir mai Excel 2013 use kar raha hu uske map chart or waterfall chart nahi hai, konse version me aayege ye sab
Try using version MS Office 2016 or above
Where do I get this data
custom maion kaise banaye arrow yehi explain karna chahiye copy nahi ho ra hai
Hi can we buy this ?
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.
Can you share me the screenshot of KPI sheet and dashboard on my mail
@@datatutorials1 sure sir
@Data Tutorials how did you derive the month from the order date?
Yes
@@datatutorials1 how did you derive the month from the order date?
can u please share the excel sheet with dashboard
Ready file is chargeable
Hi, Data show only for view. Cann't download. Please open download restriction.
Access now
How to download it
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 ?
Aap extract kar sakte ho month and quarter
@@datatutorials1 extract krne k liye option hi to nhi aa rha. How to get that option ?
hey sir...where did you get this dataset?
Kaggle
can this all be done with version 2010 ?
Yes
Kindly send Data link for practice
I know it is Superstore dataset of Tableau.
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
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
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.
Yes this can be done to generate automatically from the date field, thanks @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.
Yes, definitely, thanks for bringing this up
1:17:20
Sir can we make data from tally
Yes
42:42
Kaise banaye
50:15
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
Sure, thanks for letting me know
Hi sir, can I get business analyst job based on Excel?
You can get as an MIS Executive
This video is not in English...so sad 😢
Bhaiya ji Jo deta h Ka naam kya h
Data link is in discription box of video
[Green]▲0.00%[Red]▼0.00% bhai ye kyu add nhi ho rha h
Add a ; in between two formats for negative and positive
Can you share this Dashboard please
Contact me on my WhatsApp number available in description of this video
Translate in English
Mera order date sirf date mai aa rha h na hi quarter na hi year mai
Hi, try to use timeline instead, it has all date
@@datatutorials1 where I will find that?
In pivot table option tab