Project Details

Developed a sales performance report using Excel Pivot Tables to help businesses evaluate customer performance, identify effective discount strategies, and support negotiations. The report also highlights potential expansion opportunities in promising countries by analyzing sales data across regions.

Key Learnings & Skills:

Pivot Tables for data summarization
Power Query for data cleaning
Basic DAX for calculations
Conditional Formatting for visual enhancement
Report Beautification for clear presentation
Sales Metrics Analysis to extract business insights
This project provides actionable insights to optimize sales strategies, improve customer satisfaction, and drive revenue growth. It equips businesses with the analytical tools needed to monitor and enhance sales performance, unlocking growth opportunities in a competitive market.

Project Details

The goal of this project was to create a unified Power BI report catering to stakeholders across sales, marketing, finance, and the executive team. The focus was on building robust data models, designing user-friendly dashboards, and providing drillable insights for in-depth analysis.
Key Learnings:
Power Query (basic & advanced operations)
Data modeling with 10+ tables
Basic & complex DAX formulas
Choosing effective visuals & formatting
Dashboard design principles
Bookmarks for navigation
Deploying reports to Power BI Service
Incorporating stakeholder feedback
Working with sales, marketing, finance & supply chain metrics
This project enhanced my end-to-end BI development skills and taught me how to align data solutions with diverse business needs.

Live Interactive Dashboard

Project Details

Designed a data-driven Power BI dashboard to help the Revenue Management team make informed decisions by tracking key hotel performance KPIs.
Tools:
Power BI for visualization
Excel as data source
Key Processes:
Data import, cleaning & transformation using Power Query
Building data models & relationships
Creating DAX measures for critical KPIs
Ensuring data accuracy and reliable insights
Designing an intuitive dashboard for better storytelling
KPIs Tracked:
Total Bookings, Total Revenue, Average Rating, Total Capacity
Successful Bookings, Cancellation Rate, Revenue Loss, Occupancy %
Learnings:
Improved DAX and data storytelling skills
Gained insights into revenue management strategies
Enhanced UI/UX design for business dashboards

Live Interactive Dashboard

Project Details

AtliQ Mart, a growing FMCG manufacturer based in Gujarat, faced customer retention issues as some key customers chose not to renew contracts due to delivery service gaps. Essential products were frequently delivered late or incompletely, impacting service quality.
To address this, I developed a multi-view Power BI dashboard to track On-Time (OT%), In-Full (IF%), and OTIF% metrics across all customers. This real-time visibility enabled the supply chain team to quickly identify and resolve service issues, improving contract renewals by 15% and boosting customer satisfaction.
The dashboard also reduced manual reporting efforts by 6 hours per week and provided instant access to key performance insights, enhancing operational efficiency and supporting AtliQ Mart’s future expansion plans into Tier 1 cities.

Live Interactive Dashboard

Project Details

AtliQ Hardwares, a leading computer hardware manufacturer with operations across India and international markets, faced challenges in accessing timely insights to support quick and informed decision-making.
To address this, I designed and executed SQL queries to extract critical business data from their databases, enabling the management to monitor key performance metrics across sales, inventory, and operations.
The extracted data was then transformed into an interactive Power BI dashboard, offering clear visual insights into performance trends, bottlenecks, and opportunities.
This end-to-end process — from querying data to building user-friendly visual reports — enhanced data visibility, streamlined decision-making, and empowered stakeholders with actionable insights to drive business growth in a highly competitive market.