If you want to learn data analytics using projects like this then check our data analyst BootCamp: codebasics.io/bootcamps/data-analytics-bootcamp-with-practical-job-assistance
I have enrolled in this course but it was told that i will get 2 projects in python one is hospitality domain data analysis and another is Medical data extraction but in bootcamp it only shows one project i.e hospitality domain data analysis only.
This is why I look very highly at Indians. They are extremely intelligent people and are very professional. You can see how they approached this problem systematically and I'm happy that they detailed every step of the way. I am extremely impressed at Mr. Hemanand Vadivel. Thank you for sharing this!
This was very insightful......non of your competitors are doing this .....i strongly recommend you that bring guest like this from different domain to share their insights like this so that we can get benefit .Who ever agree, do like the comment so that daval can cosider this idea
In between Doing this project with video i feel like I'm a data analyst in this company and building a report and forgot that I'm learner 😅. Really fantastic project which give us real feel.
learnt a lot from this video...like how will be stakeholders requirements and metrics they look for which we could not figure out on our own...thanks a lot
Just vow. I have been trying to switch career at 40 and have been learning PowerBi for 1 year, when feasible, but never came across this channel. I was just byhearting concepts but never knew how I would be useful . This video clearly insights into how valuable a data analyst can be in decision making. Thank you so much. I am confident I will definitely land a job this year. All the best to people who are planning to start data analytics career.
This video is a gem for those who want to understand data analysis. The information gathering part is invaluable as this sort of experience is usually not shared on RUclips vidoes. Although I do not work in hospitality industry, the vidoe taught me how to interact with clients and get the appropriate information about the domain as well as the client's requirements. Thanks Dhaval for this wonderful experience.
I have an issue My values are same as the video except the % values which are shown below as week on week changes ...they are totally different from yours ...formulas i have used are also correct. Kindly help.
Hey , can you also publish some parts of the project of "Atliq before 5g and after 5G " by first prize holder , just the technique in the final report page. Not the whole, Just the final page technique. Thank you.
I cant download the dataset even if I follow the instruction i am getting the following error message: This XML file does not appear to have any style information associated with it. The document tree is shown below.
hi sir im your paid course student for practicing i am watching this video, in downloading u did not given final dashboard to complete remain task....../?
In revenue wow change % if suppose we select may-23 as a filter the weeks will be automatically be filtered and the highest weak no-23 and then revenue wow change % will be as per w-23 because it will fetch the maximum weak number as per dax that's fine. But let suppose if we select week number by ourself as week 23 then also the Revenue wow change % answer should be same but it is showing different please help
For Revenue wow change % measure, why we are using reccw= calculate fns and then applying a filter because once we select any weak letz say 23 then realisation measure inside it will show only data for weak 23 instead we need to open the filters for recpw that's logical because we need to calculate for the previous weak then the selection. Please can anyone explain this?
revenue_wow_%change = var revcw = CALCULATE([Revenue],dim_date[wn]=SELECTEDVALUE(dim_date[wn])) var revpw = CALCULATE([Revenue],dim_date[wn]= SELECTEDVALUE(dim_date[wn])-1) return (revcw - revpw)/revpw hii,i have used this formula to calculate wow % & i verified it giving me correct ans,but this ans are different from your ..how it is ..does my logic is wrong??
dim_date Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. dim_hotel Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. dim_rooms Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. fact_aggregate_bookings Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. fact_bookings Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Please some one help me to fix this.
Wow... this kind of amazing content no one is providing............... even other paid courses dont have such superb content like this.. Please bring more videos on different domains... Thanks a lot!
Hi, Codebasic teams, A big thanks for making such of information enriching videos, which is really helpful for new-commers. But I would like to pass-on a comments regarding the chapter "Building metrics using DAX" - instead of applying formula to extract "weekend / weekdays", it would be easier to go edit on raw files of "dim_date" & loading on Power BI directly.
Kudos to you guys amazing work… you guys very we’ll understand what needs to be taught.. I work as a data analyst and I can understand how important these skills are…
hello sir,i wanted to make my career in data science field,but issue is that,,i am a B.A. graduatee .so,please help me out.... could i pursue data science as profession rather i am belonging from non-engineer background,,,pleease reply as soon,,its help me a lot...thanks and keep growing..
Hats off man to you Sir for providing such an amazing experience of self learning and execution of the project at the same time. Would love to see more of the content in the coming videos and by far I have not seen such an explanation where we are actually get acquainted with the business terms and in the same time communicating with the stake holders and providing decisions based on this.
Could you make a video - explaining that WOW stuff? Week over-week metrics. I tried multiple times, but couldn't understand it. Loved the content, Knowledge, domain-specific details, Video Editing, and Everything. Thank you so much. Keep up the good work Dhaval and Hemanand.
This is very useful video, who want to do projects. I have one suggestion, Can you plz do all videos on all projects that you have posted. As any one who are preparing that will be more useful.
Yes that is the plan. Second video on supply chain project is coming up. My schedule is quite hectic so it is taking time but it is in my todo list for sure.
every time iam very eagrly waiting for u video sir you r giving premium content for free ex;giving real time and giving project documents and kt also which is very excellent
Hi, I have watched the video halfway through and find it amazing, especially bringing in the SME, which is really super helpful. now I am trying to follow the video and have downloaded the files from the given link, however, I do not see any "input folder" or data files mentioned in the video, can you guide me please how to access those files. Many thanks 1. dim_date 2. dim_hotels 3. dim_rooms 4. fact_aggregated_bookings 5. fact_bookings
Hi , you will find all the csv files in the resume challenge page of Codebasics. Dhaval sir shown how to download them step by step in the initial Part itself (Timestamp: 1:47) . Could you please check them and please let us know if you have face further issues. Thank you!
@@KiranDeepMarala I am working alongside the video and I have come across this hurdle, I would appreciate it if you can help me out with this? when replicating the variables ( WoW% - all of them) they are not showing the result when checking the details this message is showing. Error Message: MdxScript(Model) (57, 63) Calculation error in measure 'Key Measures'[Revpar_WoW_Change%]: DAX comparison operations do not support comparing values of type Text with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.
Hi, you can find the updated metrics list in the resource section(link: codebasics.io/resources/end-to-end-data-analyst-project). Can you check that, please let us know if you face any further issues. Thank You
Waw❤ this is really a wonderful Video which leads to crack any interview ,the level of asking questions and interactions with client is really awesome 👏 thank you ❤
I think that is the best power project video i have ever learned from and this video not only for just follow along, we also using skills of BI to create this project
Thank you for this. I have been looking for a hospitality dataset or project for my Portfolio. I'm currently enrolled in your Code Basics class online, and I love it too!!!, but this is a lifesaver because it aligns with my previous career and can help me cross to the analytics.
Hi, I was trying to do this project, I have 1 doubt , in dim_date file, 1st column " date" is corresponding to 2022 and 2nd column "mmm yy" corresponding to 2024, why its like that.... just confused ,I am new to this ...... Can anyone explain this
"Revenue WoW change % = Var selv = IF(HASONEFILTER(dim_date[wn]),SELECTEDVALUE(dim_date[wn]),MAX(dim_date[wn])) var revcw = CALCULATE([Revenue],dim_date[wn]= selv) var revpw = CALCULATE([Revenue],FILTER(ALL(dim_date),dim_date[wn]= selv-1)) return DIVIDE(revcw,revpw,0)-1" Can Anyone Explain me this ?
only the mockup dashboard snap is available in the downloaded file, other snaps and recording zip files which you are referring is missing in the zip folder sir
Hii Sir Thank You for the amazing Video Sir Having said that I have a few doubts, The tooltips and the Wow Terms seems to be changed than what is shown in the video, Can You please share what is done differently. Even for the revenue one, the tooltip is not same. Please help me with the same
Amazing way to learn Data Analysis. I really like the way requirement gathering happen in this video. We need more such content. Thank you for this awesome video.
This is the Actual Sceanrio Based Reports ,Qudos to Trainers and StakeHolder, This is slap for the people who are selling just their course and not showing the right industries need
Hey, I tried all the measures shared in the metrics list and there was no issue till dax no 20. However I am getting error from dax no 21 for WOW % change and also the code looks quite difficult to understand. Please help me here as I see other learners are getting same error as well.
Bro, you do not need to use the same formula as mentioned in the metrics list. You can make 3 new measure , First one is for current week, 2nd one is for past week and last one is for the result such as Revenue Change(WOW) %
@@krrishdeshwaljaat1068 I tried that way by creating current week, previous week, wow but they are not showing any results. 😢 For revenue wow it's blank and occupancy wow it's 0.00%. Can you help me?
In my data analytics journey, I found this video to be truly exceptional, and I was able to create a dashboard thanks to it. I want to express my gratitude to Sir Dhaval for sharing this valuable resource.
Hello Dhaval and Hemanand Vadivel sir, I am very grateful for such amazing lectures and videos you provide, I have explored various sources for learning but the way you explain things is really commendable. Step-by-step explanations and then challenges to work on further steps make us learn by doing hands-on projects. Involving subject matter experts in the case study helps to understand the industry terms and industry expert insights. I really appreciate all the efforts by you and the Codebasics Team. Thank you so much for giving such amazing lessons.
Just because there is not much content available over data analyst projects, it doesn't mean this is good. There is no explanation on what he is doing by his side. Skipping steps. Incomplete. I get the challenge part, bit it already was a challenge on the site. You cannot make a clickbait by saying end to end project and then put a challenge there. Its a shit move
Hi Dhaval Sir, May I know the difference between revenue generated and revenue realized in facts booking table. Please correct me if I am wrong, I think the total revenue should be the summation of revenue generated. Also, one more thing to add on , that is if we want to show up the Room Revenue by doing the summation of Revenue Realized Is this Possible Sir.. Need to clarify and correct me pleaseeee
Hello guys anybody can tell me... That I am distance bba graduate can I become data analyst.. I heard that IT MNCs not considered distance graduate... So please guide me what options for me to become a data analyst and get a job in reputed organization?
Hi @codebasics team, Prathamesh here! I think to measure present booking id's in following data you had used count instead of CountA to count number of booking ID's present in the data, because count will only add up the Numeric data type, Please check with that, Beginners might get confused.
The level of teaching and discussion with the stakeholders to be super amazing. Initially, I felt lazy when starting the project, but after seeing the discussion led by Abhisek Sir and Hemant Sir, it was just wow! Really, that was impressive.
![Data Analyst Projects for Interview | Guided and Unguided Projects [6 Solid Projects]](http://i.ytimg.com/vi/prPBBS6wbYA/mqdefault.jpg)
![Data Analyst Projects for Interview | Guided and Unguided Projects [6 Solid Projects]](/img/tr.png)
![Power BI for HR | How to Build an Interactive Dashboard & HR Data Analytics [2024]](http://i.ytimg.com/vi/kqmqO_OPEbE/mqdefault.jpg)
If you want to learn data analytics using projects like this then check our data analyst BootCamp: codebasics.io/bootcamps/data-analytics-bootcamp-with-practical-job-assistance
I have enrolled in this course but it was told that i will get 2 projects in python one is hospitality domain data analysis and another is Medical data extraction but in bootcamp it only shows one project i.e hospitality domain data analysis only.
Why is it showing the checkout date, where the booking status is "cancelled" and "no-show" ?
Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids
This is why I look very highly at Indians. They are extremely intelligent people and are very professional. You can see how they approached this problem systematically and I'm happy that they detailed every step of the way. I am extremely impressed at Mr. Hemanand Vadivel. Thank you for sharing this!
I think the data set isn't available now can anyone help me out.
@@Todebunkyouregogo to the link in the description
when i wanna learn a technical skill i always always check for indians they are very smart
@@Todebunkyourego I'm facing same problem i downloaded the data set but its not in the format so that power bi can extract did u got that??
This was very insightful......non of your competitors are doing this .....i strongly recommend you that bring guest like this from different domain to share their insights like this so that we can get benefit .Who ever agree, do like the comment so that daval can cosider this idea
This video is top-notch for data analysts, covering all the important stuff they need to know.
In between Doing this project with video i feel like I'm a data analyst in this company and building a report and forgot that I'm learner 😅.
Really fantastic project which give us real feel.
learnt a lot from this video...like how will be stakeholders requirements and metrics they look for which we could not figure out on our own...thanks a lot
could you please share data set of this video?
Just vow. I have been trying to switch career at 40 and have been learning PowerBi for 1 year, when feasible, but never came across this channel. I was just byhearting concepts but never knew how I would be useful . This video clearly insights into how valuable a data analyst can be in decision making. Thank you so much. I am confident I will definitely land a job this year. All the best to people who are planning to start data analytics career.
Can you help me ??
This video is a gem for those who want to understand data analysis. The information gathering part is invaluable as this sort of experience is usually not shared on RUclips vidoes. Although I do not work in hospitality industry, the vidoe taught me how to interact with clients and get the appropriate information about the domain as well as the client's requirements. Thanks Dhaval for this wonderful experience.
Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys
Thanks for this video. Really helpful.😇
Grat work! Thanks for the effort. Im wondering why do we substrut 1 in the WoW hange measures when we return divide(revcw,revpw)-1
Amazing video and team has really put lot of effort.. kudos to the team and wish them best of luck and would like to get more videos like this....
how much time should an expert typically take to finish this type of dashboard?
Untill whys stop occuring!
Very nice
Very valuable video and project
Why is it showing the checkout date, where the booking status is "cancelled" and "no-show" ?
I Just want to know is there is no voice in videos for further dashboard creation
1:11:32 Hyderabad ❤
Where is the video? Cant find any
its very good
31:00... Sir inspite doing left click and drag and drop I m unable to make relationship .I have tried n number of times but I am unable to do it ...
I have an issue
My values are same as the video except the % values which are shown below as week on week changes ...they are totally different from yours ...formulas i have used are also correct.
Kindly help.
Hey , can you also publish some parts of the project of "Atliq before 5g and after 5G " by first prize holder , just the technique in the final report page. Not the whole, Just the final page technique. Thank you.
yes I am going to publish guided videos for every single resume challenge project. Stay tuned and keep an eye on this channel
@@codebasics Sure even a brief on last report would work wonders ,just techniques in 5 . Super thanks
Pls start making videos on Tableau also bro..
There are 2 filter of filter by room class
I cant download the dataset even if I follow the instruction i am getting the following error message: This XML file does not appear to have any style information associated with it. The document tree is shown below.
I just tried it and it works for me. On codebasics.io, have you created an account? It is required to download files
hi sir im your paid course student for practicing i am watching this video, in downloading u did not given final dashboard to complete remain task....../?
which kind of datasets i practice as intermediate learner... n from which site to download other than kaggle
Suddenly my WoW Measures are not working, It's giving error like: Could not load this Visual.
Is anyone else facing this issue, Please HELP.
In revenue wow change % if suppose we select may-23 as a filter the weeks will be automatically be filtered and the highest weak no-23 and then revenue wow change % will be as per w-23 because it will fetch the maximum weak number as per dax that's fine. But let suppose if we select week number by ourself as week 23 then also the Revenue wow change % answer should be same but it is showing different please help
For Revenue wow change % measure, why we are using reccw= calculate fns and then applying a filter because once we select any weak letz say 23 then realisation measure inside it will show only data for weak 23 instead we need to open the filters for recpw that's logical because we need to calculate for the previous weak then the selection. Please can anyone explain this?
Sir pls share the Excel file link🔗
Raw data set xls/csv is there in resource???
@codebasics 39:35 when i am creating a new measure named "Revenue" with exact formula that sir is using - It shows (Blank), can somebody help?
why W32 has removed 47:58
image of abhishek on the caption is atleast 10 years old
After working on this project how do I upload it in GitHub
actually sir I am unable to download the data file....
i getting error msg from dax measure 21 please me to understand
revenue_wow_%change =
var revcw = CALCULATE([Revenue],dim_date[wn]=SELECTEDVALUE(dim_date[wn]))
var revpw = CALCULATE([Revenue],dim_date[wn]= SELECTEDVALUE(dim_date[wn])-1)
return (revcw - revpw)/revpw
hii,i have used this formula to calculate wow % & i verified it giving me correct ans,but this ans are different from your ..how it is ..does my logic is wrong??
I used his formula though....shit ain't turning up in the dashboard.....shows error.....
All the WoW % are throwing up error in the dashboard
Try to use above one
dim_date
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
dim_hotel
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
dim_rooms
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
fact_aggregate_bookings
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
fact_bookings
Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '.
Please some one help me to fix this.
Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.
Sir the date column in these files shows '#' multiple times and not the actual date value
but in fact_booking there is no revenue_realized column sir
Last stakeholders review is gold ......
👍👍
Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!
Wow... this kind of amazing content no one is providing............... even other paid courses dont have such superb content like this..
Please bring more videos on different domains...
Thanks a lot!
Hi, Codebasic teams,
A big thanks for making such of information enriching videos, which is really helpful for new-commers. But I would like to pass-on a comments regarding the chapter "Building metrics using DAX" - instead of applying formula to extract "weekend / weekdays", it would be easier to go edit on raw files of "dim_date" & loading on Power BI directly.
Can we consider all Dim Table act as Conformed Dimension as I can see all dim tables refer more than one subject area, please suggest
Sir can you email me complete hotel projects excel files with data and power bi files with data
Thanks for this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics
Kudos to you guys amazing work… you guys very we’ll understand what needs to be taught.. I work as a data analyst and I can understand how important these skills are…
bhai file kaha h
@@jaitiwari241 Follow the "Link to resources" link available in the description
hey I think the dataset isn't available now, can anyone help me out.
hello sir,i wanted to make my career in data science field,but issue is that,,i am a B.A. graduatee .so,please help me out.... could i pursue data science as profession rather i am belonging from non-engineer background,,,pleease reply as soon,,its help me a lot...thanks and keep growing..
I'm working with same data but Mera revenue 1708 million aa rha hai ??? Kya problem Hui h ??
Pls reply
Hats off man to you Sir for providing such an amazing experience of self learning and execution of the project at the same time. Would love to see more of the content in the coming videos and by far I have not seen such an explanation where we are actually get acquainted with the business terms and in the same time communicating with the stake holders and providing decisions based on this.
Glad you liked it. I would encourage you to participate in our resume projects on codebasics.io
@@codebasics yes definitely
revenue and other metrice used with week on week change% is showing error in power bi
Hi, Is the error resolved?
@@KiranDeepMarala are you facing d same bro
@@diveshbabaria723 Hi divesh, Can you please share what error facing exactly! This helps us to debug better.
Could you make a video - explaining that WOW stuff? Week over-week metrics. I tried multiple times, but couldn't understand it. Loved the content, Knowledge, domain-specific details, Video Editing, and Everything. Thank you so much. Keep up the good work Dhaval and Hemanand.
same issue
Refer the pdf files in that they have explained wow metrics line by line
how can we get these datasets and content so we can do practice please provide
I have a doubt, are power bi dashboards dynamic? As in, if I change some values in the dataset ,would it automatically get updated in the dashboard?
yes
Can we consider this video as a virtual internship? The content is top notch. Thank you!!!
This is very useful video, who want to do projects. I have one suggestion, Can you plz do all videos on all projects that you have posted. As any one who are preparing that will be more useful.
Yes that is the plan. Second video on supply chain project is coming up. My schedule is quite hectic so it is taking time but it is in my todo list for sure.
every time iam very eagrly waiting for u video sir you r giving premium content for free
ex;giving real time and giving project documents and kt also which is very excellent
Hi, I have watched the video halfway through and find it amazing, especially bringing in the SME, which is really super helpful. now I am trying to follow the video and have downloaded the files from the given link, however, I do not see any "input folder" or data files mentioned in the video, can you guide me please how to access those files. Many thanks
1. dim_date
2. dim_hotels
3. dim_rooms
4. fact_aggregated_bookings
5. fact_bookings
Hi , you will find all the csv files in the resume challenge page of Codebasics. Dhaval sir shown how to download them step by step in the initial Part itself (Timestamp: 1:47) . Could you please check them and please let us know if you have face further issues. Thank you!
@@KiranDeepMarala Thank you for pointing me in the right direction, much appreciated.
@@KiranDeepMarala I am working alongside the video and I have come across this hurdle, I would appreciate it if you can help me out with this? when replicating the variables ( WoW% - all of them) they are not showing the result when checking the details this message is showing.
Error Message:
MdxScript(Model) (57, 63) Calculation error in measure 'Key Measures'[Revpar_WoW_Change%]: DAX comparison operations do not support comparing values of type Text with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.
@@israry5623 did you able to resolve
Sir, there are only 8 metrics list in downloads provided, can you please check and help us with 26 measures list
Hi, you can find the updated metrics list in the resource section(link: codebasics.io/resources/end-to-end-data-analyst-project). Can you check that, please let us know if you face any further issues. Thank You
@@KiranDeepMarala thanks 🙏
Very informative and well explained by Abhishek 👏👏
Waw❤ this is really a wonderful Video which leads to crack any interview ,the level of asking questions and interactions with client is really awesome 👏 thank you ❤
one of the top level content with bussiness perspective , we need more like this with anand, vedivel
I think that is the best power project video i have ever learned from and this video not only for just follow along, we also using skills of BI to create this project
Thank you for this. I have been looking for a hospitality dataset or project for my Portfolio. I'm currently enrolled in your Code Basics class online, and I love it too!!!, but this is a lifesaver because it aligns with my previous career and can help me cross to the analytics.
Could you please send the data set , actually i can't download it from his blog
Hey! Can you please guide me. I will also buy this course. Howz it going? Can we connect on LinkedIn for the same?
Hi, I was trying to do this project, I have 1 doubt , in dim_date file, 1st column " date" is corresponding to 2022 and 2nd column "mmm yy" corresponding to 2024, why its like that.... just confused ,I am new to this ...... Can anyone explain this
"Revenue WoW change % =
Var selv = IF(HASONEFILTER(dim_date[wn]),SELECTEDVALUE(dim_date[wn]),MAX(dim_date[wn]))
var revcw = CALCULATE([Revenue],dim_date[wn]= selv)
var revpw = CALCULATE([Revenue],FILTER(ALL(dim_date),dim_date[wn]= selv-1))
return
DIVIDE(revcw,revpw,0)-1"
Can Anyone Explain me this ?
What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣
only the mockup dashboard snap is available in the downloaded file, other snaps and recording zip files which you are referring is missing in the zip folder sir
Hii Sir Thank You for the amazing Video Sir
Having said that I have a few doubts, The tooltips and the Wow Terms seems to be changed than what is shown in the video, Can You please share what is done differently. Even for the revenue one, the tooltip is not same.
Please help me with the same
Amazing way to learn Data Analysis. I really like the way requirement gathering happen in this video. We need more such content. Thank you for this awesome video.
Heyi i think the dataset isn't available now can anyone help me out.
Pulp fiction font 👍
This is the Actual Sceanrio Based Reports ,Qudos to Trainers and StakeHolder,
This is slap for the people who are selling just their course and not showing the right industries need
Occupancy % = DIVIDE([Total Succesful Bookings],[Total Capacity],0) anyone can help me in solving this problem
Sir your effort are amazing....
Thank you so much for this project words are less to appreciate your work.
Hey, I tried all the measures shared in the metrics list and there was no issue till dax no 20. However I am getting error from dax no 21 for WOW % change and also the code looks quite difficult to understand. Please help me here as I see other learners are getting same error as well.
Bro, you do not need to use the same formula as mentioned in the metrics list. You can make 3 new measure , First one is for current week, 2nd one is for past week and last one is for the result such as Revenue Change(WOW) %
@@krrishdeshwaljaat1068 I tried that way by creating current week, previous week, wow but they are not showing any results. 😢 For revenue wow it's blank and occupancy wow it's 0.00%. Can you help me?
Please do same for retail industry if possible ..
great work. we expect more such projects in the future........
In my data analytics journey, I found this video to be truly exceptional, and I was able to create a dashboard thanks to it. I want to express my gratitude to Sir Dhaval for sharing this valuable resource.
Glad it helped!
sir do we have any internships for data analytics and i am intersted in internship please help me find one
not bad......real life
Hello Dhaval and Hemanand Vadivel sir, I am very grateful for such amazing lectures and videos you provide, I have explored various sources for learning but the way you explain things is really commendable. Step-by-step explanations and then challenges to work on further steps make us learn by doing hands-on projects. Involving subject matter experts in the case study helps to understand the industry terms and industry expert insights. I really appreciate all the efforts by you and the Codebasics Team. Thank you so much for giving such amazing lessons.
Excellent video as always, very informative and insightful.
Thanks for this awesome info. live from nairobi Kenyan
Just because there is not much content available over data analyst projects, it doesn't mean this is good. There is no explanation on what he is doing by his side. Skipping steps. Incomplete. I get the challenge part, bit it already was a challenge on the site. You cannot make a clickbait by saying end to end project and then put a challenge there. Its a shit move
WHY??? my revenue is blank in bangalore and certain other cities? is there any mistake I have done or the data is wrong can you help please
Hi Dhaval Sir, May I know the difference between revenue generated and revenue realized in facts booking table. Please correct me if I am wrong, I think the total revenue should be the summation of revenue generated. Also, one more thing to add on , that is if we want to show up the Room Revenue by doing the summation of Revenue Realized Is this Possible Sir.. Need to clarify and correct me pleaseeee
Hello guys anybody can tell me... That I am distance bba graduate can I become data analyst.. I heard that IT MNCs not considered distance graduate... So please guide me what options for me to become a data analyst and get a job in reputed organization?
total capacity doesn't make sense? Aren't you accounting for the capacity multiple times as there are duplicates of the same propertyid
Very informative video. Thanks team
Hi @codebasics team, Prathamesh here! I think to measure present booking id's in following data you had used count instead of CountA to count number of booking ID's present in the data, because count will only add up the Numeric data type, Please check with that, Beginners might get confused.
I have a career gap of 3 yrs.. How I deal with it in a interview.. I want to restart as data analyst
Hyderabad is all time favorite for everyone
Can a Power BI begginer opt for this particular project ?
My line chart is not displaying properly when I use the tool tip. 1:07:06 Anyone else experience this and how can I fix it?
actualluy i need some help if i put this project on my resume how can i describe this project step by step?????/
The level of teaching and discussion with the stakeholders to be super amazing. Initially, I felt lazy when starting the project, but after seeing the discussion led by Abhisek Sir and Hemant Sir, it was just wow! Really, that was impressive.