OYO Rooms Revenue & Booking Analysis

Developed an interactive Power BI dashboard to analyze OYO Rooms' revenue, bookings, cancellations, and guest behavior. Key insights include 57.87% occupancy rate, 24.83% cancellation rate, and Elite & Premium rooms driving the highest revenue. The analysis highlights opportunities for dynamic pricing, flexible cancellation policies, and enhanced customer retention strategies.

Tools Used:

• Power BI , SQL

GoodCabs: Transport & Mobility Data Analysis

Developed an interactive Power BI dashboard to analyze key metrics for a cab service, including repeat passenger rates, revenue trends, trip demand patterns, and target achievements. Provided actionable insights to optimize operations, enhance customer satisfaction, and align business strategies with emerging trends.

Tools Used:

• Power BI , SQL

AtliQ Motors EV Market & Infrastructure Analysis

Conducted an in-depth analysis of India’s growing Electric Vehicle (EV) market using Power BI, focusing on state-wise sales, charging infrastructure growth, and market penetration rates.

Tools Used:

• Power BI , SQL, Excel

Hotel operations insights

Leveraged Power BI for data-driven hotel improvements. Analyzed guest satisfaction, operations, and revenue. Identified booking trends, service gaps, and optimized pricing strategies.

Tools Used:

• Power BI , SQL, Excel

Hospital Data Analysis

This project is an interactive healthcare navigator dashboard designed to provide a comprehensive view of various healthcare metrics.

Tools Used:

• Power BI , SQL, Excel

Electric Vehicle Data Insights

Created an interactive Tableau dashboard analyzing EV trends. Highlights include Tesla's market leadership, adoption growth, and key performance metrics like average EV range and top models.

Tools Used:

• Tableau , SQL, Excel

Market Performance Analysis

This Power BI dashboard provides an in-depth analysis of sales data for Blinkit, focusing on various aspects such as item type performance, outlet performance, customer ratings, and sales trends over time.

Tools Used:

• Power BI , SQL, Excel

Coffee Sales Data Analysis using Excel

Utilized advanced Excel analytics to conduct a comprehensive analysis of coffee shop sales data. This project highlights key sales trends, top-performing products, and customer purchase behavior. Analyzed seasonal sales patterns to assist in inventory management and marketing strategies.

Tools Used:

• Excel

Crop Recommendation System ML

Designed and implemented a crop recommendation system using various machine learning models. The system analyzes soil composition, weather conditions, and crop yield data to provide actionable suggestions to farmers. This project focuses on improving agricultural productivity and sustainable farming practices.

Tools Used:

• Python, Machine Learning

Bank Loan Report Analysis Using SQL

Performed sql quires using SSMS and analyze key banking metrics, including loan applications, funded amounts, and customer segmentation.

Tools Used:

• SQL ,SSMS