/AtliqHospitality_analysis_resumeproject

This is a Codebasics resume project for Challenge #1 : Provide Insights to Revenue Team in Hospitality Domain

I have participate in Codebasics Resume Project Challenge for building Data project Portfolio. This challenge give me a great chance to develop my Data Analysis skills. I have tried my best to complete the challenge. Hope to receive some feedbacks for my improvement process so that I could do better for further project in the future.

For your information, Codebasics is a Youtube channel covering many topics, including Programming, Data Science, Data Analytics, Artificial Intelligence, Machine Learning, Data Structures, Software Srchitecture, etc. I am so lucky to be a subscriber and learn many things in Data field.

Project Github Link: https://github.com/leducnguyen21/AtliqHospitality_analysis_resumeproject

Code Basics Challenge Link: https://codebasics.io/event/codebasics-resume-project-challenge

Code Basics Youtube Channel: https://www.youtube.com/c/codebasics/featured

About Challenge:

This is a Codebasics resume project for Challenge #1 : Provide Insights to Revenue Team in Hospitality Domain

Domain: Hospitality / Function: Revenue

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

Task:

You are a data analyst who has been provided with sample data and a mock-up dashboard to work on the following task. You can download all relevant documents from the download section.

  1. Create the metrics according to the metric list.
  2. Create a dashboard according to the mock-up provided by stakeholders.
  3. Create relevant insights that are not provided in the metric list/mock-up dashboard.

Things I have learned from the challenge:

  1. Clean data and connect data sets
  2. Creating measures and calculated columns (to create other metrics)
  3. Finding insights after EDA process
  4. Usage of slicers to narrow down the requirements.
  5. Building Menu bar for several sheets in Power BI
  6. Choose specific color for the dashboard to improve visualisation

Once again, thank you Dhaval Patel and Hemanand Vadivel for establishing this kind of challenges that helps people who are looking forward to step into the analytics career

#codebasicsresumeprojectchallenge #powerbi #dashboard #dataanalysis #codebasics #dataanalytics #data #hospitality

dashboard