Abhijeet Kamble’s Post

🚀 Excited to Add Yet another Data Analysis Project to my Portfolio! 📶 I'm thrilled to share that I've successfully completed a Data Analysis Project for AtliQ Hotels, a prestigious luxury hotel chain in India operating across Mumbai, Delhi, Hyderabad, and Bangalore. The challenge was to delve into their business data spanning from May 2022 to Aug 2022, to uncover insights and understand the underlying trends affecting their business. The project, executed in Python using Pandas within Jupyter Notebook, followed a structured approach: 1️⃣ Data Import and Exploration : Understanding the dataset's structure and content. 2️⃣ Data Cleaning : Ensuring data quality and consistency. 3️⃣ Data Transformation : Preparing the data for analysis. 4️⃣ Analysis Insights : Extracting actionable insights to drive business decisions. The dataset was comprehensive, comprising three dimension tables and three fact tables, with approximately 1.35 Lakh rows of data. Through this project, I honed my skills in data analysis, particularly in leveraging Panda's powerful groupby and merge functions. I extend my heartful gratitude to Dhaval Patel and Hemanand Vadivel of Codebasics for their invaluable guidance and continuous motivation throughout this project. 🔗 GitHub link : https://lnkd.in/gqVcDUmK Your feedback and suggestions are highly appreciated as they contribute to my growth and development. Let's continue our journey of data exploration and analysis together! 💡#dataanalysis #pandas #jupyternotebook #codebasics

🌟 Excited to Share My Latest Data Analytics Project!🌟 I'm thrilled to showcase my second project under Unified Mentor, Unified Mentor Private Limited — the AtliQ Hotels Data Analysis Project. This project involved a deep dive into the hotel industry, focusing on data-driven insights and strategic recommendations to help AtliQ Grands overcome challenges like revenue decline and market share loss. 🚀 Key Insights: - Presidential rooms have the highest occupancy (59.28%), while Standard rooms lag behind (57.92%). - Delhi leads with a 61.52% occupancy rate, while Bangalore has room for improvement at 56.34%. - Weekends show much higher occupancy (73.96%) compared to weekdays (56.34%). 🔧 Tools & Techniques Used: - Pandas for data manipulation and analysis. - Matplotlib for insightful visualizations. - NumPy for numerical operations. - Data Cleaning Techniques to ensure data quality. 📊 Recommendations: To address these challenges, I provided actionable strategies, such as: - Boosting weekday occupancy through corporate offers. - Improving services and customer experience in underperforming regions like Bangalore. - Optimizing revenue generation in cities like Hyderabad. I'm incredibly grateful to Unified Mentor, Unified Mentor Private Limited for guiding me through this journey! I’m excited to keep growing, learning, and applying my skills to solve real-world business problems through data analytics. You can check out my full analysis and insights on GitHub here: [https://lnkd.in/gD57Xv8C] 🔗 #DataAnalytics #Python #AtliQHotels #HotelIndustry #DataDriven #Pandas #Matplotlib #DataVisualization #UnifiedMentor #LinkedInLearning #GrowthJourney #SQL #LinkedIn #Data #IT #Corporate #MySql #DataAnalysis #Tableau #PowerBI #Learning #LearnTogether #LinkedInCommunity #BusinessAnalytics

🌟 Excited to Share My Latest Project! I recently completed a detailed data analysis for Atliq Grands, a well-known hotel chain with a strong presence in major Indian cities like Mumbai, Bangalore, Delhi, and Hyderabad. 🏨 📊 The project involved analyzing booking data from various channels, including their website and popular platforms like MakeMyTrip, LogTrip, and Tripster. 🌐 🔍 Using tools like Python and pandas, I uncovered key insights, including a decline in market share and revenue, which highlighted areas for improvement. 🚀 💡 Working closely with Atliq's management team, we turned these insights into actionable strategies to improve customer experience, enhance bookings, and drive revenue growth. 📈 🎯Project Approach: ➡️Collected and cleaned booking data, guest demographics, and stay details. ➡️Preprocessed the data, handling missing values and outliers. ➡️Conducted exploratory data analysis (EDA) to discover trends. ➡️Created data visualizations to highlight key findings. 🎯Outcomes: ➡️Identified customer preferences, peak booking seasons, and behavior trends. ➡️Delivered insights to enhance customer satisfaction and streamline operations. ➡️Produced visual reports to guide strategic decisions. 🎯Key Learnings: ➡️Data Cleaning, Processing, and Transformation ➡️Exploratory Data Analysis ➡️Feature Engineering ➡️Data Visualization ➡️Insight Generation GitHub : https://lnkd.in/g4wienr2 👏 Special Thanks Big thanks to my mentors, Hemanand Vadivel and Dhaval Patel, for their guidance during this project as part of my training at Codebasics. #DataAnalyst #DataAnalytics #Codebasics #AtliQ #python #HospitalityAnalysis

Hello Everyone! Exciting News! ✈️ I'm thrilled to share my latest project: the Codebasics Resume Project Challenge #1 - Hospitality Analytics. 𝑪𝒉𝒂𝒍𝒍𝒆𝒏𝒈𝒆 𝑶𝒗𝒆𝒓𝒗𝒊𝒆𝒘: 𝐀𝐭𝐥𝐢𝐐 𝐆𝐫𝐚𝐧𝐝𝐬 owns multiple five-star hotels across India and has been in the hospitality industry for the past 20 years. Their hotels are located in major cities such as Delhi, Mumbai, Hyderabad, and Bangalore, and cater to both luxury and business travelers. The hotel rooms are categorized as Standard, Elite, Premium, and Presidential. 𝑷𝒓𝒐𝒃𝒍𝒆𝒎 𝑺𝒕𝒂𝒕𝒆𝒎𝒆𝒏𝒕: AtliQ Grands is experiencing a decline in market share and revenue in the luxury/business hotel category. 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬: - 𝐎𝐯𝐞𝐫𝐚𝐥𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐁𝐨𝐨𝐤𝐢𝐧𝐠 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 - 𝐑𝐚𝐭𝐢𝐧𝐠 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝑻𝒆𝒄𝒉 𝑺𝒕𝒂𝒄𝒌: - Power BI - Excel - Power Query - DAX 𝐊𝐞𝐲 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐌𝐞𝐭𝐫𝐢𝐜𝐬: - 𝐑𝐞𝐯𝐞𝐧𝐮𝐞 - 𝐎𝐜𝐜𝐮𝐩𝐚𝐧𝐜𝐲 % - 𝐑𝐞𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 % - 𝐀𝐃𝐑 (𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐃𝐚𝐢𝐥𝐲 𝐑𝐚𝐭𝐢𝐧𝐠) - 𝐑𝐞𝐯𝐏𝐀𝐑 - 𝐃𝐒𝐑𝐍 - 𝐃𝐔𝐑𝐍 - 𝐂𝐚𝐧𝐜𝐞𝐥𝐥𝐚𝐭𝐢𝐨𝐧 % 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬: 1. Data cleaning and snowflake schema modeling 2. Page navigation, tooltips, and conditional formatting 3. Created various visualizations including gauge, line, ribbon, line and clustered columns chart, and matrix table 𝑺𝒐𝒇𝒕 𝑺𝒌𝒊𝒍𝒍𝒔: 1. Gained domain knowledge in hospitality 2. Understood stakeholders' requirements from mock-up dashboards Explore more with the Live Dashboard: https://lnkd.in/gvTm2vsR Thank you, Abhisek Gorai Special thanks to Dhaval Patel, Hemanand Vadivel, and the entire Codebasics team for their unwavering support and mentorship throughout this transformative #data #sales #project #learning #dataanalytics #datacleaning #visualization

Hello LinkedIn Community! 🌟 I’m excited to share my latest Python project, completed as a part of my Data Analyst Bootcamp 3.0 from Codebasics, focusing on Data Analysis in the Hospitality Sector! 🐍🏨 Project Highlight: AtliQ Grands – Strategic Hospitality Analysis 🌐 AtliQ Grands, a fictional yet impactful hospitality leader across four cities, set out to tackle market challenges with a data-driven approach. Here’s a glimpse into our journey: 1. Data Cleaning: 🔍 Refined guest numbers and revenue data 🔄 Addressed outliers and null values to ensure accuracy 2. Data Transformation: 📊 Created an 'Occupancy Percentage' metric to turn raw data into actionable insights 3. Revenue Analysis: 📈 Delhi shows high occupancy but lower revenue 💵 Mumbai leads in revenue generation 📆 July emerges as the peak revenue month 4. Booking Insights: 💳 40.9% of bookings use 'others' payment methods; suggests a strategic opportunity Key Takeaways: ➡ Bangalore struggles with booking performance compared to Mumbai ➡ AtliQ Seasons excels in minimizing cancellations with strategic pricing 🔗 Explore the full project and Jupyter notebooks on GitHub: https://lnkd.in/gSxEnnNK A huge thank you to Codebasics, Dhaval sir and Hemanand sir for their guidance and support throughout this project! 🙌 #DataAnalysis #Python #DataScience #DataAnalytics #HospitalityIndustry #BusinessIntelligence #DataCleaning #DataTransformation #RevenueAnalysis #Analytics #Codebasics #GitHub #DataDriven #DataInsights

Hey everyone! Just completed the Codebasics resume challenge #1, and I'm thrilled to share this achievement with you all! 📉 Problem Statement : AtliQ Grands, a chain of five-star hotels in India, has been struggling with declining market share and revenue due to competitive challenges and management issues. To address this, their managing director plans to use business and data intelligence for better strategies. Lacking an in-house analytics team, they're looking to hire an external service provider for insights from their historical data. 🚀 Project Goal: Elevate Atliq Grands' luxury business hotel segment through data-driven strategies and business intelligence. 📊 Key Takeaways: ✔️ Acquired Metrics: Revenue, RevPAR, ADR, DBRN, DSRN, DURN, Realisation %, occupancy, and cancellation %. ✔️ Power BI Fundamentals: Delved into data cleaning, tool tip creation, and diverse chart creation. ✔️ Soft Skills: Enhanced domain knowledge in hospitality and better comprehension of stakeholder dashboard needs. 🧠 Key Insights: 🌆 Revenue: Mumbai soared at 669M, while Delhi lagged at 294.50M. 🛌 Occupancy Trends: Delhi led in occupancy (60.55%) despite the lowest DSRN, while Bangalore followed at 55.77 📅 Weekend Trends: Occupancy surged by 7% on weekends compared to weekdays with negligible RevPAR difference. 🌟one more observation is Avg rating plays a crucial role which impacts on occupancy % 𝑹𝒆𝒔𝒐𝒖𝒓𝒄𝒆 𝒍𝒊𝒏𝒌𝒔: Interactive Dashboard : https://lnkd.in/gzGvAnfR Full Video Presentation link : https://lnkd.in/gRu8PQ9j 🙏 Grateful to Dhaval Patel and Hemanand Vadivel for this opportunity! Excited to leverage these Power BI skills for a transformative career journey as a data analyst. #DataAnalytics #CareerGrowth #PowerBI #LearningJourney #Atliq #ProfessionalDevelopment #Codebasics #Hospitality #VideoPresentation #BusinessIntelligence"

I am thrilled to share my Power BI dashboard for the Codebasics resume challenge a journey that equipped me with valuable skills in data analytics Project overview: AtliQ Grands, a leading Indian hotel chain, aims to revitalize its market position by leveraging Business and Data Intelligence. Facing challenges from competitors and management decisions, they seek external data analytics expertise to extract insights from their two-decade-long hospitality data. Client details: Domain: Hospitality Function: Revenue Task: My role as a data analyst involved creating metrics, developing a dashboard based on stakeholder mock-ups, and uncovering additional insights beyond the provided framework. The aim was clear - provide the Revenue Team at AtliQ Grands with actionable insights to reverse their revenue decline. Key Dashboard Insights The Hotels: AtliQ Exotica hotel generates the highest revenue which is 320M. hi City: Mumbai city has the highest revenue which is 669 million. © Avg.rating: The Highest Average rating of the top 2 cities is Delhi which is 3.8 and Hyderabad i.e., 3.7. 6% Category: Hotels are categorized into two classes business and luxury. Revenue generated by Luxury class is by 62% & Business class is by 38%. Booking: The highest booking done by other platforms is around 40.9% followed by Make My Trip at 20% and the last one is direct offline by 5%. Check out the complete interactive dashboard on the link below and let me know your suggestions in the comment section https://lnkd.in/gcmkR6Zq Dhaval Patel and Hemanand Vadivel, Appreciate your invaluable guidance. Your wisdom and expertise left a lasting impact. Thanks for sharing knowledge and inspiration. hashtag #Gratitude #Mentorship #project #datavisualization #datamodeling #datacleaning #dax #businessanalyst #dataanalyst #datamodeling #powerbi #codebasics #dataanalysis #data

My First Python Data Analysis Project in Hospitality domain 🚀 I’m thrilled to share that I’ve successfully completed a comprehensive Data Analysis project for AtliQ Hotels, a prestigious luxury hotel chain in India operating across Mumbai, Delhi, Hyderabad, and Bangalore. 🔍 Project Overview: AtliQ Grands, with their two-decade presence in the hospitality industry, were facing stiff competition and losing market share and revenue. To tackle this, their revenue management team sought actionable insights from their historical data to regain their competitive edge. 🎯 Task at Hand: As a data analyst, I was tasked with delving into their business data spanning from May 2022 to August 2022 to uncover insights and understand the trends affecting their business. 🛠️ Tools Used: - Jupyter Notebook - Python (Pandas) - Canva ❇️ Process Followed: 1️⃣ Data Import and Exploration: Understanding the dataset's structure and content. 2️⃣ Data Cleaning: Ensuring data quality and consistency by removing negative values and outliers. 3️⃣ Data Transformation: Preparing the data for analysis through merging, aggregation, value formatting, and concatenation. 4️⃣ Analysis Insights: Extracting actionable insights to drive business decisions, including creating occupancy percentage columns and answering specific questions posed by the team. Concepts and Functions Used: - merge(), concat(), groupby() - min(), max(), sum(), value_counts() - unique(), to_datetime() - shape, describe(), info() - mean(), median(), std() - isnull(), fillna(), apply() 🙏 Acknowledgments: A heartfelt thank you to Dhaval Patel sir, Hemanand Vadivel sir, and the entire Codebasics team for their unwavering guidance and support throughout this project. A special shoutout to the #DataAnalystBootcamp for laying the foundation of my skills. #DataAnalysis , #python , #pandas , #analytics , #codebasics , #jupyternotebook , #canva , #insightsgeneration , #insights , #businessanalytics

👋 Hello everyone, 😊 Thrilled to announce the completion of my latest project: 'Data Analysis in Hospitality Domain'! 🎉🏨 Delving deep into the world of hospitality through Python programming at Codebasics, I've uncovered valuable insights that I'm eager to share. From guest trends to revenue optimization strategies, this project showcases my proficiency in data analytics within the dynamic hospitality industry. ⚙ 🛠 Skills and Techniques Used in this Python Project:- ✅ Data collection from CSV files 📄 ✅ Data Cleaning ✅Exploratory data analysis ✅Data manipulation using libraries - Pandas and NumPy ✅Data visualization tool - Matplotlib 📊 ✅Data transformation - merging data frames, creating new columns 🏩 Data Analysis in Hospitality Domain - Project Overview ⬇ AtliQ Grands, a renowned hotel group with a 20-year legacy across four major cities in India, is currently navigating challenging competition within the hospitality sector. Faced with declining revenue and bookings, the management has proactively embraced data-driven decision-making. As a data analyst, I've been entrusted with leveraging insights from diverse datasets to formulate strategies aimed at revitalizing revenue 📈 streams and enhancing customer engagement. I would like to extend my sincere thanks to Dhaval Patel for his valuable guidance and support 🙏 🙏 Your feedback and thoughts on the 🎞 presentation would be greatly appreciated 💬 ! You can find it here 👇 Thank you in advance for taking the time to review it. 🤝😊 #DataAnalytics #HospitalityIndustry #RevenueOptimization #HotelManagement #DataAnalysis #HospitalityTrends #PythonProgramming #DataVisualization #DataAnalysisHospitalityDomain #PythonDataAnalyst

𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐀𝐧𝐧𝐨𝐮𝐧𝐜𝐞𝐦𝐞𝐧𝐭! I'm thrilled to announce the completion of a captivating Python project at Codebasics "Hotel Domain Analysis Using Python" 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰: Facing tough competition and a decline in revenue, Atliq Grands sought solutions. Utilizing Python, I delved deep into the hotel domain, providing actionable insights for customer retention and revenue growth. 𝐈𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐋𝐢𝐧𝐤 : GitHub Link : https://lnkd.in/gRpvwtkS 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬: ➡️Data Cleansing: Resolving missing values and outliers. ➡️Data Transformation: Added occupancy percentage columns. ➡️Insight Generation: Addressed vital questions such as average occupancy rates, weekday versus weekend occupancy, city-wise revenue, monthly revenue trends, and platform-specific revenue analysis. 𝐒𝐤𝐢𝐥𝐥𝐬 𝐀𝐜𝐪𝐮𝐢𝐫𝐞𝐝: ➡️Python Proficiency: Skilled in data analysis, cleaning, transformation, and visualization. ➡️Data Visualization: Employed Matplotlib to craft compelling charts and bars. ➡️Pandas Mastery: Expertise in data manipulation techniques like groupby, concat, merge, handling NA values, and CSV file reading. 𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: ➡️Revenue Leaders: Mumbai took the lead with 669M INR; May emerged as the top revenue-generating month with 581.93M INR. ➡️Customer Favorites: Presidential rooms received the highest rating at 3.69; Delhi distinguished itself with an average rating of 3.78. ➡️Occupancy Champion: Delhi not only excelled in ratings but also boasted the highest occupancy at 62.47%. 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐚𝐭𝐢𝐨𝐧𝐬: ➡️Mumbai Momentum: Invest in targeted marketing to further enhance revenue. ➡️Premium Enhancement: Elevate the Premium room experience for improved ratings and potential revenue growth. ➡️Optimize Delhi Stays: Despite high ratings, explore strategies to maximize room bookings. ➡️Weekend Promotions: Capitalize on the weekend rush with targeted marketing campaigns on Fridays and Saturdays. A heartfelt thank you to Dhaval Patel and Hemanand Vadivel for their invaluable guidance! #python #pandas #dataanalysis #dataanalytics #businessanalytics #businessanalyst #datacleaning #datatransformation #dataanalyst #visualization #fresher #hiring #manager #freshershiring #pythonprogramming #jupyternotebook