Nikhil Kumar

A highly motivated and detail-oriented Data Analyst with a strong foundation in data analytics, machine learning, and predictive modeling. Proficient in Python, SQL, and business intelligence tools, with a passion for uncovering insights from data and solving complex problems. Experienced in statistical analysis, feature engineering, and data visualization.

Hotel Booking Data Analysis and Cancellation Predictions

• Performed an in-depth EDA on Hotel Booking Data to understand customer behavior and reach across the year.
• Identified key features affecting a customer’s decision to cancel their booking with the hotel from the data.
• Deployed an efficient pipeline consisting of K-Fold cross-validation, Feature Engineering, and more, to accurately predict the cancellation of a booking.
• Achieved a maximum accuracy of 86%, helping restrict revenue and customer loss for hotels.

Business Statistics and Analysis Capstone Project

• Merged and cleaned the data of the American Housing Survey for the years 2007, 2009, 2011, and 2013.
• Performed Hypothesis Testing to compare the market values of vacant and occupied houses.
• Built a Predictive Model for the market value of housing units using Linear Regression in MS-Excel.
• Performed Holdout Analysis to measure the accuracy of the developed model.