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.
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 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.
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!
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
Pivot table mein apke sheet pe month dikha raha hai but jab main pivot table mein dekh raha hoon to date format mein a raha hai. To use kaise change kare. Group mein mein month, quarter ka option nahi a raha hai kindly solve it.
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 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.
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
This type of content should not be free on TH-cam ,thank you so much brother
Thanks bro i have learned more excel key techniques in dashboard buildings from this session ♥♥
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!!!
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.
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!!!
Excellent bhia wow what a work great
SUPERB . Thanks for the useful video
BHAI GJAB AWESOME WORK YOU ARE DOING A GENIOUS YOU ARE I HAVE FOLLOWED YOUR FULL VIDEO
tq sir for amazing explanation and arrangement of the dashboard
THANK YOU SO MUCH BHAI MUCH APPRECIATED
Happy to help
nice video, but pls can you do the one where itll be english throughout? commenting from Nigeria
Awesome video, very helpful
GOOD JOB MAY GOD BLESSED YOU FOR YOUR 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.
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 ?
Please use below formula for KPI design :). It will take time to search in excel. Thanks Swapnajeet.
[Green] ▲ 0%;[Red] ▼ -0%
Thanks
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
Hi. Thank you for the video
I followed all the steps and got a very excellent dashboard
God bless.
I await more videos
THANK YOU
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
sir please make vedio on project explanation to client on power bi.Thanks
Thanks for the wonderful informative session 💯💯💯
HI, if we change the values will the spark line change accordingly?
sir , why do not you make only project based course with vedioes... that will be help full for us..plese make
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
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.
Thank you brother
Please do you have an English version of this project?
Excellent
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
Can u make videos on SQL?
Thanks so much for the wonderful video. Appreciate if you can share the dashboard in excel?
Glad you liked it ✨
Thank bro
Thank you so much sir
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!!!
Love to learn but how do i get the english version. Thanks.
commendable
Amazing.. 👍..
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
Can you make access to data available?
The year filter is not working for YOY Growth. Please suggest something
Sir what insights we recieved from this dashboard?
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!
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
Can u plz write the explanation what we have done in this project so we can write it on resume
Pivot table mein apke sheet pe month dikha raha hai but jab main pivot table mein dekh raha hoon to date format mein a raha hai. To use kaise change kare. Group mein mein month, quarter ka option nahi a raha hai kindly solve it.
when i m putting order date in row coloum its not showing year what to do ?
Hi! can you tell me the data source? i need it, thank you
Hey Sir, this is fantastic video tutorial . Loved working on it.Can I use it in my resume ?
Definitely
Really good
Wow great
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?
I want a custom investment profit loss stock buy and sell with margins elegant and dynamic graphics how do I contact you?
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..
@Data Tutorials how did you derive the month from the order date?
Yes
@@datatutorials1 how did you derive the month from the order date?
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
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!
In ecom platform many products are return, please let me know what to do for return?
maza aa gya
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?
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
MAP CHART IS NOT SHOWN IN OFFICE 2016 HOW CAN I MANAGE ?
What id data Name nd where i can found it???
You should do one in english
Really wish this was in english
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
can u please share the excel sheet with dashboard
Ready file is chargeable
hey sir...where did you get this dataset?
Kaggle
can this all be done with version 2010 ?
Yes
WHAT IF I CHANGE YEAR AND THEN ALL THE % WILL NOT WORK AS THE FORMULA IS FOR 2014VALUE/2013 VALUEAND NOT FOR OTHER VALUE
How do we get the reason behind the low sales in bottom 10 states with respect to sales???
Plz answer!!!
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
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 ?
Hi, Data show only for view. Cann't download. Please open download restriction.
Access now
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
Where can we download
Bhai profile nai nikal raha hai mera 😢
Where do I get this data
Sir can we make data from tally
Yes
Hi can we buy this ?
How to download 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
Same problem
custom maion kaise banaye arrow yehi explain karna chahiye copy nahi ho ra hai
I know it is Superstore dataset of Tableau.
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
Kindly send Data link for practice
Hi sir, can I get business analyst job based on Excel?
You can get as an MIS Executive
1:17:20
Kaise banaye
Can you share this Dashboard please
Contact me on my WhatsApp number available in description of this video
42:42
Bhaiya ji Jo deta h Ka naam kya h
Data link is in discription box of video
50:15
This video is not in English...so sad 😢