Video není dostupné.
Omlouváme se.
End to End Data Analytics Project | Power BI Project | Hospitality Domain
Vložit
- čas přidán 17. 08. 2024
- How Data Analysts Build Dashboard in Real Time?
You will understand how data analysts build dashboard in real time in this video featuring an industry expert Abhishek Anand (revenue manager in OYO) & Hemanand who is a data analytics expert.
This is also a solution to the Resume Project Challenge #1 conducted by Codebasics. You can download all the resources and create your own dashboard for building knowledge and adding it to resume.
Link to All resources: codebasics.io/...
00:00:00 Introduction
00:05:44 Mockup review and business requirement discussion
00:23:17 Data transformation using power query
00:33:09 Building metrics using DAX
01:10:02 Stakeholder review
01:35:27 Closing
Abhishek's LinkedIn Profile: / abhishekanand-nm
Dhaval's Linkedin Profile: / dhavalsays
Hemanand's LinkedIn Profile: / hemvad
Do you want to learn technology from me? Check codebasics.io/... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.co...
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.
@@Canadianvixengo to the link in the description
when i wanna learn a technical skill i always always check for indians they are very smart
@@Canadianvixen 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 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 CZcams 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.
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.
Last stakeholders review is gold ......
👍👍
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.
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!
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.
one of the top level content with bussiness perspective , we need more like this with anand, vedivel
Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!
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!
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.
Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.
Wowwww this is gem video for any Data analyst enthusiast.
This is not normal video where u r doing the same repeatable thing of creating a dashboard.
For all those things they have provided the resources with the help of them they can create ur dashboard.
They have utilised most of the time in this video for understanding the business like how and what should a data analyst should do, and what should be there approach after landing into the job.
Just love it❤❤
I'm really glad you found the video valuable and insightful! Thanks for your kind words. 🌟
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 ??
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
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.
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?
This platform is a goldmine...!!
Whether I land a job or not , I have been learning so so much from your videos. Can't thank you enough... 🙏🙏
May your businesses flourish and you become a billionaire very soon...!!
God bless...!!
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
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.
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.
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
Sir the date column in these files shows '#' multiple times and not the actual date value
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.
Dhaval Patel sir ,,, is the best teacher ... He understands the problems of students ..
how much time should an expert typically take to finish this type of dashboard?
Untill whys stop occuring!
What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣
Hi Dhaval sir your teaching skills are to the next level excellent your a boon for new folks
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?
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 ❤
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.
Can we consider this video as a virtual internship? The content is top notch. Thank you!!!
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
its simply great. I like the way the conversation went. Hemanandh shoot the right questions to get better insights. Wonderfull. I fell in love with these videos. Thank you
Thanks for this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics
Very informative and well explained by Abhishek 👏👏
This video is so helpful. Want more this kind of explanation video.
how can we get these datasets and content so we can do practice please provide
Sir your effort are amazing....
Thank you so much for this project words are less to appreciate your work.
Hyderabad is all time favorite for everyone
Why is it showing the checkout date, where the booking status is "cancelled" and "no-show" ?
please continue to make these type of video on real type data for BI very very Useful Thanks
Thanks a lot Mr Dhoval !
Your way of teaching was amazing and your channel was like goldmine for beginners like me
Most welcome!
great work. we expect more such projects in the future........
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
Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids
Very informative video. Thanks team
where is the link to dataset
Such a great explanation!! Thanks codebasics team for amazing insights
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.
where is the remaining recorded video , its not available in the zip file.
Thanks for this awesome info. live from nairobi Kenyan
Excellent video as always, very informative and insightful.
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 ...
That was a great insight and an interactive session.
Just appreciate your work guys so informative and helpful.
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
Highly impressive vedio. Hats off to your expertise guys❤
Awesome , well explained videos i have found Thanks @Abhishek for provinding wonderfull
the hotel business insights and matrix
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?
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 🙏
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.
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
really very very good thing i learn about the power BI
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
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
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
Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys
where is the sample linkedin post for the reference ? it will be very helpfull if you provide that as well
but in fact_booking there is no revenue_realized column sir
Where is the video? Cant find any
Awesome!
Great content with detailed steps of an end to end power bi project
Beautiful and too helpful 🎉
Please do same for retail industry if possible ..
This is great! it's like being part of the team. I learned a lot thankyou!
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?
Thanks for making such an informative video.
You guys are doing such a good work. This video has increased my motivation to pace up my learning into this interesting field and become a data analyst.
Heyi I think the dataset isn't available now can anyone help me out.
very nice work
Nice Project, thanks to share and teaching
One thing that I want to mention here is ALWAYS CHECK YOUR DATA TYPE WHILE TRANSFORMING THE DATA BEFORE MOVING THE DATA TO POWER BI OR EXCEL (SPECIALLY THE COLUMNS HAVING NUMBERS IN THEM).
Thanks buddy for mentioning this. Due to 'Text' datatype of 'wn', 'WoW' measure was not working for me. Finally figured it was data type issue and saw this comment as well.
Very Insightful video sir !!
actualluy i need some help if i put this project on my resume how can i describe this project step by step?????/
my dashboard doesn't show the sum of the whole column at the bottom .... what to do?
This is GOLD
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....
Hey Dhaval, Please bring such more dashboards.....
Thanks a ton... ❤
I Just want to know is there is no voice in videos for further dashboard creation
I have a career gap of 3 yrs.. How I deal with it in a interview.. I want to restart as data analyst
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.
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
why there is error in total in this dashboard ??? weekend and weekday?
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 have a question: You were able to identify that there was just one entry of "week 32" (47:00), and decided to remove it. I suppose you were already aware of this outlier and therefore able to identify it.
But if the data is absolutely new to us and we are unaware of these outliers, then how can we find and deal with them? Using Python to perform visualizations or by some other methods? Can you please tell us more about it?
Thank you for your help; you are doing an excellent job!
Thanks a lot Mr Dhaval sir ,so more learning point in DAX function,how to visualization of data in properly format
Download file is free at website?
@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?
Hi Sir, where I can download the resources for this video, coz whenever I click on what you provided to us is not working (404) ERROR. so could you please help me with this.... thanks in Advance