Elite-Hospitality Dashboard

Revitalized revenue for a multinational hotel chain grappling with declining revenue and share prices. Spearheaded a comprehensive initiative, leveraging key metrics (Realization Percentage, ADR, URN, DSRN, DBRN, DURN, RevPAR) to optimize pricing, enhance premium room revenue, and address geo-issues

Zomato Case Study

The project involves creating a Zomato database schema and querying it for various insights. It includes finding customers who haven't ordered, average dish prices, top restaurants by monthly orders, revenue analysis, and customer preferences.

Wallmart Sales Data Analysis

Walmart Sales Data Analysis project explores sales trends, top-performing branches, and product insights from Kaggle's Walmart Sales Forecasting Competition data. The goal is to optimize sales strategies and enhance performance.

Spotify Case Study

The provided queries focus on extracting valuable insights from the dataset, including the total active users each day, total active users each week, the number of users making purchases on the same day they install the app, the percentage of paid users in different countries, and the number of user

Supply Chain Dasbhoard

Developing a comprehensive order fulfillment analytics system focusing on Line Fill Rate, Volume Fill Rate, On-Time Delivery %, In Full Delivery %, and On-Time In Full (OTIF) % to enhance supply chain efficiency and customer satisfaction.

AtliQ Mart Promotion Analysis (FMCG Domain)

Evaluate promotional effectiveness during Diwali 2023 and Sankranti 2024, focusing on Bengaluru, Chennai, and Hyderabad. Analyze top products and regional preferences to optimize strategies and boost sales. Key Performance indicators : Incremental Revenue% , Incremental Sold Unit%