Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

The Comprehensive Sales & Customer Insights Dashboard for Grabit is designed to provide a data-driven approach for improving business performance. The project will utilize Power BI to analyze and visualize:

✅ Sales Performance: Revenue trends, top-performing products, sales by region.
✅ Customer Satisfaction: Feedback analysis, Net Promoter Score (NPS), customer retention.
✅ Inventory Distribution: Stock levels, demand forecasting, supply chain efficiency.

By implementing interactive visualizations and KPI tracking, this dashboard will help Grabit’s stakeholders make informed decisions on sales strategy, customer experience, and inventory management. The final outcome will be a dynamic, real-time Power BI dashboard that enhances operational efficiency and business growth.

Live Interactive Dashboard

Project Details

AtliQ Grands, a leading luxury hotel chain, is facing revenue decline due to increased competition and ineffective decision-making. To regain market share, their management seeks business and data intelligence solutions using historical data analytics. This project will build a Power BI dashboard to analyze sales trends, occupancy rates, customer segmentation, and competitor strategies. Key KPIs like RevPAR, ADR, and demand forecasting will help optimize pricing, marketing, and operational efficiency. The dashboard will provide actionable insights to enhance customer experience, improve revenue management, and drive strategic growth in the competitive luxury hotel industry.

Live Interactive Dashboard

Project Details

* Conducted a complete sales data analysis project using **PostgreSQL**.
* Cleaned and standardized inconsistent data entries (e.g., unified `Item_Fat_Content` values) to ensure accurate and reliable reporting.
* Generated essential business KPIs:

* 📊 Total Sales (in millions)
* 📈 Average Sales and Ratings
* 🧾 Total Number of Orders
* Analyzed sales performance across key business dimensions:

* Product Categories (Item Type)
* Fat Content Labels
* Outlet Establishment Year
* Outlet Size and Location
* Outlet Type
* Calculated sales contribution percentages by outlet size using window functions.
* Delivered grouped insights (total sales, average rating, item visibility) by outlet type to support high-level strategic decisions.
* Utilized advanced SQL features: CASE, aggregation functions (SUM, AVG, COUNT), and window functions for percentage calculations.

Project Details

AtliQ Grands, a leading hotel chain with a 20-year presence across India, faced a sharp decline in revenue and market share due to aggressive competitor strategies. To support recovery, I contributed as part of the analytics team by delivering data-driven insights.

🧠 Understood the business challenge and stakeholder goals

📥 Collected and explored multi-hotel operational and financial data

🧹 Cleaned and transformed raw datasets to ensure accuracy and consistency

📊 Performed exploratory data analysis (EDA) to identify patterns and trends

📌 Highlighted key performance bottlenecks across outlets

📈 Delivered actionable insights to guide pricing, occupancy, and strategy

💼 Helped AtliQ's leadership make informed decisions to regain market position

This project demonstrates end-to-end data analytics application in the hospitality sector, combining business context with technical execution.