End to End Data Analytics Project | Power BI Project

End to End Data Analytics Project | Power BI Project | Hospitality Domain

Рет қаралды 324,992

Күн бұрын

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/resources/end-t...
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.com/codebasics?fa...

Пікірлер: 268

@codebasics Жыл бұрын

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

@Iqbalsharib4 8 ай бұрын

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.

@muadrahman1332 6 күн бұрын

Why is it showing the checkout date, where the booking status is "cancelled" and "no-show" ?

@muadrahman1332 6 күн бұрын

Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids

@didyouknowthat.channel Жыл бұрын

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!

@Canadianvixen Жыл бұрын

I think the data set isn't available now can anyone help me out.

@PavanKumar-uw7si Жыл бұрын

@@Canadianvixengo to the link in the description

@Batira583 5 ай бұрын

when i wanna learn a technical skill i always always check for indians they are very smart

@Software_Techno 23 күн бұрын

@@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??

@shujashakir9952 Жыл бұрын

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 KZfaq 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.

@yashkanojiya1146 10 ай бұрын

This video is top-notch for data analysts, covering all the important stuff they need to know.

@1hpdell Жыл бұрын

Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!

@atithembram9768 Жыл бұрын

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

@anivesh2225 7 ай бұрын

one of the top level content with bussiness perspective , we need more like this with anand, vedivel

@MotivationByHeart007 7 ай бұрын

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.

@chinunayak6494 3 ай бұрын

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.

@perfectionist6624 9 ай бұрын

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!

@amanpandey5673 Жыл бұрын

What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣

@mohammadzeeshan992 Жыл бұрын

Sir your effort are amazing.... Thank you so much for this project words are less to appreciate your work.

@nishagenani6408 3 ай бұрын

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.

@AsifDawood 9 ай бұрын

Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys

@AkshayKumar-iz2kd Жыл бұрын

Last stakeholders review is gold ......

@codebasics Жыл бұрын

👍👍

@mytalents260 8 ай бұрын

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

@Mohpra Жыл бұрын

Thanks for this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics

@syedasherahmed949 Жыл бұрын

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.

@codebasics Жыл бұрын

Glad you liked it. I would encourage you to participate in our resume projects on codebasics.io

@syedasherahmed949 Жыл бұрын

@@codebasics yes definitely

@muhammadazam8422 Жыл бұрын

Excellent video as always, very informative and insightful.

@tayyabanaz1421 11 ай бұрын

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.

@codebasics 11 ай бұрын

Glad it helped!

@nikhilsk2026 2 ай бұрын

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 ❤

@vijayabhaskarreddyrajupale7945 Жыл бұрын

Awesome! Great content with detailed steps of an end to end power bi project

@arpitagarwal8485 Жыл бұрын

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.

@Canadianvixen Жыл бұрын

Heyi i think the dataset isn't available now can anyone help me out.

@kalyanirayudu6885 Жыл бұрын

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

@akhilmaurya9189 Жыл бұрын

Awesome , well explained videos i have found Thanks @Abhishek for provinding wonderfull the hotel business insights and matrix

@desmond7182 Жыл бұрын

Just appreciate your work guys so informative and helpful.

@jyotirautela8633 Жыл бұрын

Very informative and well explained by Abhishek 👏👏

@himanshutripathi6114 10 ай бұрын

Dhaval Patel sir ,,, is the best teacher ... He understands the problems of students ..

@sografarheen1722 5 ай бұрын

Hi Dhaval sir your teaching skills are to the next level excellent your a boon for new folks

@asamadawais Жыл бұрын

Highly impressive vedio. Hats off to your expertise guys❤

@filmytrendz4990 Жыл бұрын

Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.

@sureshbabus1790 Жыл бұрын

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....

@nithyapalanisamy4904 Жыл бұрын

great work. we expect more such projects in the future........

@fahmidapinky9311 3 ай бұрын

This video is so helpful. Want more this kind of explanation video.

@ayushurmaliya5217 Жыл бұрын

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…

@jaitiwari241 Жыл бұрын

bhai file kaha h

@ahmedatharmohiuddin1388 Жыл бұрын

@@jaitiwari241 Follow the "Link to resources" link available in the description

@Canadianvixen Жыл бұрын

hey I think the dataset isn't available now, can anyone help me out.

@user-wf5fq3rw6p Жыл бұрын

Thanks a lot Mr Dhoval ! Your way of teaching was amazing and your channel was like goldmine for beginners like me

@codebasics Жыл бұрын

Most welcome!

@perfectionist6624 Жыл бұрын

Hey Dhaval, Please bring such more dashboards..... Thanks a ton... ❤

@omharne1386 Жыл бұрын

really very very good thing i learn about the power BI

@narpathify Жыл бұрын

That was a great insight and an interactive session.

@rudrenshahiwala Жыл бұрын

Very informative video. Thanks team

@rohil3072 Жыл бұрын

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.

@Canadianvixen Жыл бұрын

Heyi I think the dataset isn't available now can anyone help me out.

@Simeon-iz8rz 3 ай бұрын

Can we consider this video as a virtual internship? The content is top notch. Thank you!!!

@otiasammy Жыл бұрын

Thanks for this awesome info. live from nairobi Kenyan

@justinnacu Жыл бұрын

This is great! it's like being part of the team. I learned a lot thankyou!

@mayphos3589 Жыл бұрын

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.

@poojapradhan39 Жыл бұрын

Could you please send the data set , actually i can't download it from his blog

@udeshrajput2594 7 ай бұрын

Hey! Can you please guide me. I will also buy this course. Howz it going? Can we connect on LinkedIn for the same?

@alkaarora5722 Жыл бұрын

please continue to make these type of video on real type data for BI very very Useful Thanks

@umarhayatkhanlodhi3358 Жыл бұрын

Nice Project, thanks to share and teaching

@prasenjit_hazra 11 ай бұрын

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.

@Chaithrika6363 Жыл бұрын

Thank you for your amazing work!

@TrEndYWOrldviDeos Жыл бұрын

Thanks for this video. Really helpful.😇

@Hannah-hg7xr 11 күн бұрын

Such a great explanation!! Thanks codebasics team for amazing insights

@sarihaddu 5 ай бұрын

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.

@trending_video999 5 ай бұрын

Can you help me ??

@alishakumari3663 8 ай бұрын

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❤❤

@codebasics 8 ай бұрын

I'm really glad you found the video valuable and insightful! Thanks for your kind words. 🌟

@ananthlytics 7 ай бұрын

Hyderabad is all time favorite for everyone

@vaijayantigulve4883 Жыл бұрын

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...!!

@Siddharth_Matada Жыл бұрын

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

@poojapradhan39 Жыл бұрын

could you please share data set of this video?

@mohandattabayya5584 7 ай бұрын

Very Insightful video sir !!

@poojamali9506 10 ай бұрын

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.

@codebasics 10 ай бұрын

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.

@gaykesavita2303 11 ай бұрын

Thanks a lot Mr Dhaval sir ,so more learning point in DAX function,how to visualization of data in properly format

@pratiek8s Жыл бұрын

Really informative. It was an amazing session!

@codebasics Жыл бұрын

Glad you enjoyed it!

@youtubeuser996 Жыл бұрын

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.

@vaibhavsrivastava7945 6 ай бұрын

Very nice Very valuable video and project

@techtalkwithaswar 11 ай бұрын

you guys done a great job..

@muadrahman1332 6 күн бұрын

Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids

@dhackmt Жыл бұрын

Hey thankyou so much i learnt alot

@bharathau8085 Жыл бұрын

Really informative!

@SanghmitraaSisodiya Жыл бұрын

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.

@marotipolkamwad254 Жыл бұрын

same issue

@sandipjabade1 Жыл бұрын

Refer the pdf files in that they have explained wow metrics line by line

@satishk1464 Жыл бұрын

very nice work

@santoshkumar-wq4qd 11 ай бұрын

This is GOLD

@soumyamanjunath3855 4 ай бұрын

how much time should an expert typically take to finish this type of dashboard?

@KamranMumtazAhmed 28 күн бұрын

Untill whys stop occuring!

@houssnachana5709 Жыл бұрын

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

@SantoshKumar-yr2md 3 ай бұрын

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

@priyanshuverma3716 Жыл бұрын

thanx for the project sir....its very helpful for us.. plz tell how to mention this project in resume

@ananyamitra6645 Жыл бұрын

awesomeee!!!

@meenayv4902 Жыл бұрын

Please do same for retail industry if possible ..

@NouYunho 9 ай бұрын

ty so much!!!!!!!!

@tanishqvaibhav5003 11 ай бұрын

very helpful

@girlnextdoor5991 Жыл бұрын

Sir the date column in these files shows '#' multiple times and not the actual date value

@NagaRaju-lf4ke Жыл бұрын

its very good

@parikshitrajpara5706 10 ай бұрын

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!

@classicemmaeasy2292 Жыл бұрын

As a person starting out from scratch can I begin with this tutorial

@muhammadmustafa2023 8 ай бұрын

Thanks a lot.

@onkarkulkarni7988 8 ай бұрын

Where is the link of the data set

@reddaiahreddymallu Жыл бұрын

Thank you for the amazing content. A quick question…How much time is an analyst given to complete this kind of a project in corporate setup? @codebasics

@abhishekanand370 Жыл бұрын

Depends on the criticality of the ask... most critical asks are delivered in 24hours

@SantoshKumar-yr2md 3 ай бұрын

how can we get these datasets and content so we can do practice please provide

@KamranMumtazAhmed 28 күн бұрын

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).

@HrithickBarani 21 күн бұрын

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.

@arpitchampuriya9535 8 ай бұрын

Dashboard creation 45:16

@zakirhussain4193 Жыл бұрын

Pls start making videos on Tableau also bro..

@AmanKumar-uq3zk Жыл бұрын

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..

@roses292 11 ай бұрын

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

@bvinay5737 Жыл бұрын

1:11:32 Hyderabad ❤

@vinodpvenu8553 Жыл бұрын

Hi, what would you suggest for a senior management professional who has taken up business analytics as his next career option and what all he should be master of, or atleast what all he should be aware of for getting a job in analytics industry'... Please suggest.

@jaitiwari241 Жыл бұрын

revenue and other metrice used with week on week change% is showing error in power bi

@KiranDeepMarala Жыл бұрын

Hi, Is the error resolved?

@jaitiwari241 Жыл бұрын

@@KiranDeepMarala are you facing d same bro

@KiranDeepMarala Жыл бұрын

@@diveshbabaria723 Hi divesh, Can you please share what error facing exactly! This helps us to debug better.

@israry5623 Жыл бұрын

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

@KiranDeepMarala Жыл бұрын

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!

@israry5623 Жыл бұрын

@@KiranDeepMarala Thank you for pointing me in the right direction, much appreciated.

@israry5623 Жыл бұрын

@@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.

@800pa Жыл бұрын

@@israry5623 did you able to resolve

@antarabanerjee1314 11 ай бұрын

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

@YG-jb2in Жыл бұрын

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.

@jaitiwari241 Жыл бұрын

I have a career gap of 3 yrs.. How I deal with it in a interview.. I want to restart as data analyst

@srigayathri6775 3 ай бұрын

where is the link to dataset

@saurabhkshirsagar4997 6 ай бұрын

I Just want to know is there is no voice in videos for further dashboard creation

@lavyasplanet2025 Жыл бұрын

which kind of datasets i practice as intermediate learner... n from which site to download other than kaggle

@musicwithbrothers3646 5 ай бұрын

hello codebasics team that is a vary good video for learning .. But can you tell me that BOOKING % BY PLATFORM AND the BOOKING % BY ROOM CLASS FORMULA is it right ? beacuse in the time of doing this the booking % by platform also counts the directly offline booking as well . same thing goes for the BOOIKING % BY Room class. Please reply me on this