🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: www.wscubetech.com/landing-pages/online-data-analytics-course.html?RUclips&JAN2024&RV
Ma'am Maine RUclips par bahut Video dekha hai par Mujhe samajh nahi aaya. Aapki video me jo Aapne samjhaya Hai Vah Bahut Assan Tarika Hai Aur Samjh me A Gaya. Thank you so much Ma'am.
I will like to say, that with this tutorial one is able to land a future career in many data analysis roles, recently landed a Data analytics Internships and have worked on most of this work through there. Which this was very helpful. I am gonna graduate end of this year and hopefully will be able to use these skills and project in my upcoming interviews for jobs 🤞🧿❤️
@@anjalikumariceo Hi so I am currently finishing up my college and have been doing a few projects on my free time, I would say try to do as much internships, co ops, or even entry level jobs before going into a position more experience more a company will accept you, especially in India or even in United States, more experience the more you have a chance of getting a job. Also connections can be a big role, but unfortunately I'm an introvert and dont got a lot.
Hi Ayushi, I'm reaching out because I recently watched your videos on various data analytics topics and wanted to express my gratitude. Your explanation and guided videos were concise and incredibly helpful. I learned a lot from you. Thanks for the support!!
Thank you so much mam... Its very helpful to me.. I learned a lot from here.. And Your teaching power is immense which is easy to learn for anyone... Completed the project and posted on LinkedIn as per your instruction.
You are Excellent Ayushi Jain .Really Appreciate your time and patience for providing the clear insights on creating Dashboards :-) It will help us to create any data set professionally .
Hello Aayushi Mam, mera crore pranam aapko. I reset you a lot mam. You are the ocean of knowledge. Mey aapka koi video dekha practice bhi kiye. E wala video bhi kiya. Aapka gyan share korne keliye bahot bahot dhonobad. Iswar sada aapke sath rahe. Mam, aapse ek humble request hey ki pls mam ek hotel industry ki data analysis n dashboard using excel and power querry, is ke upor ek video daliye na mam. E video bahot logo ka bahot helpful video hoga. Thank you so much mam. Be more powerful n successful. Allways be happy n healthy. God is allways with you. Stay blessed.
This is really helpful and must recommend marketers also to look into this , as only technical knowledge is not imp once you go up higher position in the company. business knowledge must be represented by stats with excel. thank you team ws cube tech
firstly appreciating for this wonderful video, secondly sharing easy method according to me of sorting data in pivot as jan, feb or mon, tues , you can simply go to files - option - advanced - general - edit custom list - from their you can add what you want and then come to your pivot table and from sort and filter option easily custom sort.
hi iam facing a problem where i am not able to enter data into Shapes from pivot sheet it's showing an error and i have also noticed that my values are different from hers i follwed her step by step in making of this project can you please help me
@@AnasFazil-j2w got a solution? i managed to paste the data in the shape and i'm getting the standard value but when it change the month or day the value's aren't changing
Thank you so much dear mam really helpful and you have made it very easy to understand much respect and love from my side hope you and your team gets the credit and success you deserve.
How did you enter "Total Sales" text on a shape after referencing it to a measure at 1:09:14 ? I am not able to enter any text on the shape after entering the formula. Kindly help
same happened to me i figured out the solution just click on the any cell on dashboard and write the formula over there you will get the values and then copy that value and paste on the shape and do the formatting
mistake :- 1. at 35:02 when , you go for top 5 product type, you did not sort it in descending order.. you just directly apllied filter of top 5 rather than sort it in descending order 2. same mistake (as 1) done at 41:23
@@pawanupadhyay8638 I found the solution Select the cells you want to name Go to Formulas > Defined Names > Define Name Enter a unique name and choose whether you want it to be available in the sheet or the entire workbook Enter an optional comment and select OK Place the cursor in the formula where you want to add the name Type the first letter of the name and select it from the list that appears Or, select Formulas > Use in Formula and select the name you want to use Press Enter
Mam, How did you enter the "Total Sales" text on a shape after referencing it to a measure at 1:09:14? I am not able to enter any text on the shape after entering the formula. Kindly help
Thanks for great explanation, Can you please do a video on how to remove that underscore in the first Row??? Example: we have " store_location" we need to transform that to "store location" How can we do that to all the first row at a time(I mean to all the coloumn names at a time?)
1:22 I managed to paste the data in the shape and i'm getting the standard value but when it change the month or day the value's aren't changing. Can somebody help me on this issue
Hi mam, thanks alot for your time, efforts and resources. My question is when I perform the text after delimiter, nothing is happened, I think the format of date contains "/" and in your video it's format is - Please let me know how can I over come from it.
Thanks a lot for this useful tutorial. I am stucked when my measures are not changing when I want to see January data or any other data.... They are remaining the total values!!! Please help me out anyone!
i took size and count of transaction quantity to find out which size is most demand size , is this correct ?i found regualr is the most demand in market
![SQL For Data Analysis Full Portfolio Project with Practical [1Hour] | End-to-End SQL Project 2024](/img/1.gif)
🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: www.wscubetech.com/landing-pages/online-data-analytics-course.html?RUclips&JAN2024&RV
Mam maine jb condititional column create kiya toh muze sari jgh not defined aaya lg, sm, rg nhi aaya why
Can u please provide a raw file to practise
@@aushmitasaikia8003 it's in maven analytics... you can find it easily
color Hex link is still not shared pls share this link for practise
@wscubetech which Ms office version you used here?,and which we should use?
Ma'am Maine RUclips par bahut Video dekha hai par Mujhe samajh nahi aaya. Aapki video me jo Aapne samjhaya Hai Vah Bahut Assan Tarika Hai Aur Samjh me A Gaya. Thank you so much Ma'am.
I will like to say, that with this tutorial one is able to land a future career in many data analysis roles, recently landed a Data analytics Internships and have worked on most of this work through there. Which this was very helpful. I am gonna graduate end of this year and hopefully will be able to use these skills and project in my upcoming interviews for jobs 🤞🧿❤️
Sir I am on the same way please reply with whole road map currently I am in class 12
@@anjalikumariceo Hi so I am currently finishing up my college and have been doing a few projects on my free time, I would say try to do as much internships, co ops, or even entry level jobs before going into a position more experience more a company will accept you, especially in India or even in United States, more experience the more you have a chance of getting a job. Also connections can be a big role, but unfortunately I'm an introvert and dont got a lot.
@@HarpreetSingh-gz3mhaapki job lag gai ya internship kar rahe ho aap
Me bhi data analyst banne ki soch rha hu abhi graduation complete Hui h
@@aakashpicture humari akhri saal heh college meh, dehkh rehi job lehi... bs apply kra hu. Job market bs aukha heh right now
@@HarpreetSingh-gz3mhhello can u please tell me from where you got that internship from and how many projects have you done
Very Helpful.
Note : The dataset 'Coffee Shop Sales' is moved to page 6.
Thank you so much. I was really struggling
28:09 day of the week select Kiya to Mera new column nahi ban raha and transaction date 0 ho raha he
Thank you
Thank you ma'am this was really helpful for upskilling myself in data analytics using excel.
Hi Ayushi,
I'm reaching out because I recently watched your videos on various data analytics topics and wanted to express my gratitude. Your explanation and guided videos were concise and incredibly helpful. I learned a lot from you.
Thanks for the support!!
coffee shop sales data not avalable
@@raghvendrasabane2462use the discription link 🔗
Right @@raghvendrasabane2462
Simply Brilliant 👌🏻Thank you 🙏🏻
Really helpful and simple......
Thanks and regards from Pakistan
Thank you so much mam... Its very helpful to me.. I learned a lot from here.. And Your teaching power is immense which is easy to learn for anyone...
Completed the project and posted on LinkedIn as per your instruction.
You are Excellent Ayushi Jain .Really Appreciate your time and patience for providing the clear insights on creating Dashboards :-) It will help us to create any data set professionally .
Really like this video i was basically searching over youtube but i didn't get anywhere
Really love it ❤❤❤
Hello Aayushi Mam, mera crore pranam aapko. I reset you a lot mam. You are the ocean of knowledge. Mey aapka koi video dekha practice bhi kiye. E wala video bhi kiya. Aapka gyan share korne keliye bahot bahot dhonobad. Iswar sada aapke sath rahe. Mam, aapse ek humble request hey ki pls mam ek hotel industry ki data analysis n dashboard using excel and power querry, is ke upor ek video daliye na mam. E video bahot logo ka bahot helpful video hoga. Thank you so much mam. Be more powerful n successful. Allways be happy n healthy. God is allways with you. Stay blessed.
Thanks
Thank you so much mam for explaining the details of Excel related to dashboard 😊❤🙏
explained easy methods in very complicated way.
Thank you for teachings.
Thankyou mam... These dashboard tutorials are very educational and helpful for beginners like me... I came to know way more than I exoected
Thank You so much ma'am! really amazing session it upskilling my EXCEL domain.
Thank you , its really helpful.
Thankyou for making this amazing project 😇
This is really helpful and must recommend marketers also to look into this , as only technical knowledge is not imp once you go up higher position in the company. business knowledge must be represented by stats with excel. thank you team ws cube tech
Very educational session and great explanation. 👍👍
firstly appreciating for this wonderful video, secondly sharing easy method according to me of sorting data in pivot as jan, feb or mon, tues , you can simply go to files - option - advanced - general - edit custom list - from their you can add what you want and then come to your pivot table and from sort and filter option easily custom sort.
hi iam facing a problem where i am not able to enter data into Shapes from pivot sheet it's showing an error and i have also noticed that my values are different from hers i follwed her step by step in making of this project can you please help me
@@AnasFazil-j2w I am also facing problem in inserting data into shape from pivot sheet, i dont know how to resolve this issue
@@AnasFazil-j2w got a solution? i managed to paste the data in the shape and i'm getting the standard value but when it change the month or day the value's aren't changing
THANKYOU SO MUCH FOR THIS VALUABLE SESSION , GOT TO LEARN ABOUT A LOT OF THINGS ABOUT EXCEL AND HOW WE CAN DO ANALYSIS❤❤
Very informative and excellent!
Thankyou very much ma'am🙏🕉
Thanks for this information 🙏🙏🙏🙏🙏
Thank you so much dear mam really helpful and you have made it very easy to understand much respect and love from my side hope you and your team gets the credit and success you deserve.
mam serial wise convert krne mai kafi jyada complicate kr di aap ....and thank you so much for this type of video its too helpful❤❤❤❤
Loved this project!! Thank you :)
Really helpfull video,
thank you very much,
expecting more usefull video's,
🎉🎉🎉🎉
It is very nice and helpful for learning project. Pls describes insights or history as written. It will be more helpful.
Really amazing project, I watched each second 😊
Thank you so much ma'am .It is really helpful. Kudos to you
was Informative and good thankyou Ma'am
I am learning from you this is my learning project then i will make my own project by myself W video btw
Need more Tutorial like this...😊
Thank you mam you always clear a doubt
Nice mam thank you so much for helping me
Very Helpful
How did you enter "Total Sales" text on a shape after referencing it to a measure at 1:09:14 ? I am not able to enter any text on the shape after entering the formula. Kindly help
same happened to me i figured out the solution
just click on the any cell on dashboard and write the formula over there you will get the values and then copy that value and paste on the shape and do the formatting
@@ravinashetty8097 which formula
@@ravinashetty8097 simply just copy the value into the shape???
@@nishantaggarwal4985 basically gpo below that value if its H43 AND THEN manually typr h42 if value is at h42 and enter value will come
@@nishantaggarwal4985 yes it will come
Thanks for this information
Amazing explanation and best video
Thank You.
mistake :-
1. at 35:02 when , you go for top 5 product type, you did not sort it in descending order.. you just directly apllied filter of top 5 rather than sort it in descending order
2. same mistake (as 1) done at 41:23
Very informative!
thank you so much for this video..
Very nice report. How do you put into the Rounded Rectangle formula and text words "Total Sale" video time 1:09:04
have you got the solution?
@@pawanupadhyay8638 have you got the solution because i am stuck there
@@pawanupadhyay8638 I found the solution
Select the cells you want to name
Go to Formulas > Defined Names > Define Name
Enter a unique name and choose whether you want it to be available in the sheet or the entire workbook
Enter an optional comment and select OK
Place the cursor in the formula where you want to add the name
Type the first letter of the name and select it from the list that appears
Or, select Formulas > Use in Formula and select the name you want to use
Press Enter
i am also facing same issue
Transaction_time column can also be transformed by going to Add Column ribbon then time(in the end) then select time only.
I like this video ❤❤❤
thanks a lot mam 🤗🤗
❤ love from students 😊
thanks for making this, its very useful video.
Postgere SQL Tutorial need like this ❤❤
coffee sales data is not available
so what should i do now
Good Stuff!!
The dataset 'Coffee Shop Sales' is now moved to page 6 (just in case)
Well done . Mam
Mam, How did you enter the "Total Sales" text on a shape after referencing it to a measure at 1:09:14? I am not able to enter any text on the shape after entering the formula. Kindly help
i am geting issue on that can u please help
solution mila??
@@krNishant basically gpo below that value if its H43 AND THEN manually typr h42 if value is at h42 and enter value will come
Wonderful course Ma'am
But few people can only relate to your smirk while saying hell's kitchen.(6:23)
Thank you so much :)
Thankyou Ma'am 😍❤
Happy teachers day 🎉🎉🎉🎉
Very Good
Thanks for great explanation, Can you please do a video on how to remove that underscore in the first Row???
Example: we have " store_location" we need to transform that to "store location" How can we do that to all the first row at a time(I mean to all the coloumn names at a time?)
Stay Connected!
Hi! Ayushi
Thanks for the project, sorry you've not mentioned how to share the github repository project on the LinkedIn post
@36:00 why brewed black tea is shown at place 2???
At 20:47 I can't change my TOTAL BILL value field into sum, it's showing count, because it's in text format I guess.
please help!
Solved by my own 😹😹😹
Mam Data science ka bhi Course lay na bas ap e sikhaya Your Method Is well
at 20:31 price dint change into USD value remains same as it was in INR how can we apply that change
Keep it up and bring more useful videos
Wow So NYC👍👍
Thanks a lot
thank you mama
Excellent Dashboard. Kindly make a dashboard for HR related.
Awesome....
1:22 I managed to paste the data in the shape and i'm getting the standard value but when it change the month or day the value's aren't changing. Can somebody help me on this issue
May be you have not reported the connections with the slicer.
I am not getting the option of conditional column @ 8:10 please someone help
Ma'am 21:21 pe aapne exact same rupees ko exact dollar me convert kiya hai, please look at this
At 58:10 transaction I'd ka.(footfaal)Count tha y-axis m.. so dollar ku liya?
Hi mam, thanks alot for your time, efforts and resources.
My question is when I perform the text after delimiter, nothing is happened, I think the format of date contains "/" and in your video it's format is -
Please let me know how can I over come from it.
hello mam, i have MS office 2010 and don't able to work as you are like get and transform data what should I do mam pls reply
Very insightful !
i am having missing range reference 0r defined name error while referencing the KPI to DAX mesures.
Have you find the solution ? I am also having the same error.
Thanks a lot for this useful tutorial. I am stucked when my measures are not changing when I want to see January data or any other data.... They are remaining the total values!!! Please help me out anyone!
in 28:00 min Sunday is showing as 6 instead of 0 in day of week column.
How to make it 0?
anyone please help.🙏
I have the same problem. Did you solve it?
which version of excel should i use because i am not gwtting these options
mam please do in english and expecting clear explanation on average per person question. Thank you
Thanks mam
1:09:07 i am not able to get the value to the shape . Please help me
i took size and count of transaction quantity to find out which size is most demand size , is this correct ?i found regualr is the most demand in market
Just a suggestion upload the data file in google drive and then share the link. On website they have changed the data, I couldn't find it now
at 30:13 hum data ko sidha hi too sort ker skte h row labels per click kerke daywise or monthwise 🤨
same question hum aise kr skte hai pr itna bda procedure ka mtlb kya hai
Power query is also in excel?
thanx for this
i cant Add my Bill/person And Avg Order in Slicer beacuse i made this both using your 2nd option i mean 1:13:00 somebody help me😭😭
Ayushi I faced issue in data of week while insert it we get 6 instead 0 in starting??
Good video
I am using office home and student 2016 and in my case there is no pivote option in com Add-ins can you help me with that
Thanks mam, I had a doubt, even after not locking the slicers, I am not able to click on that as it says data is protected. What should I do now?
Power query editor alag se download karna padta hai kya? Because I don't have power query editor..
no