Project Details

In this project, I developed a comprehensive sales report using Excel pivot tables to provide businesses with actionable insights. The report enables businesses to determine optimal customer discounts, streamline negotiations, and identify market expansion opportunities. By analyzing key sales metrics, businesses can refine their sales strategies, improve customer satisfaction, and boost revenue.

Key skills and tools utilized:

Pivot Tables: Efficiently summarize and analyze large datasets
Power Query: Transformed and cleaned data for better insights
DAX: Applied basic expressions to enhance data analysis
Conditional Formatting: Improved data visualization for clearer insights
Report Aesthetics: Enhanced readability for a more professional presentation
This project empowers businesses to make data-driven decisions, uncover new growth opportunities, and drive overall sales performance.

Project Details

"The project aimed at creating a comprehensive dashboard for sales, marketing, finance, and executive stakeholders. Key objectives included:

Establishing a strong Data Model: Ensuring a solid foundation for analysis.
Crafting a User-Friendly Design: Building intuitive reports tailored to stakeholder needs.
Delivering Interactive Insights: Allowing deeper exploration of data through drilldowns.

In this project, I gained experience in:

Power Query (both basic and advanced techniques)
Writing basic and complex DAX formulas
Data modelling with 10+ tables
Selecting appropriate visuals and formatting
Applying dashboard design principles
Using bookmarks for interactive features
Deploying reports in Power BI Service
Implementing stakeholder feedback
Analyzing metrics from Sales, Marketing, Finance, and Supply Chain"

Live Interactive Dashboard

Project Details

AtliQ Grands, a renowned five-star hotel chain in India, has thrived for 20 years but is now facing declining market share and revenue in the luxury and business segment due to rising competition and suboptimal management decisions. To counter this, the managing director launched a "Business and Data Intelligence" initiative to drive growth and regain market position.

Achieved Objectives:
✔ Developed key metrics based on stakeholder requirements.
✔ Designed a dashboard aligned with stakeholder mock-ups.
✔ Extracted valuable insights beyond predefined metrics.

This initiative aims to enhance data-driven decision-making and optimize business strategies.

Project Details

AtliQ Hardwares aimed to improve data-driven decision-making by expanding its analytics team through a SQL-based challenge replicating real-world business scenarios. I analyzed 10 business queries, wrote optimized SQL queries to extract insights, and presented findings in an executive-level report. This required expertise in data modeling, query optimization, and business analysis to uncover key trends and support strategic decisions.

Key Takeaways:

Advanced SQL – Joins, subqueries, CTEs, window functions, and performance tuning.
Data Analysis – Identifying trends, anomalies, and key business drivers.
Business Storytelling – Presenting insights in a structured, decision-focused format.
Strategic Impact – Using data to drive operational improvements.
This project strengthened my ability to analyze complex data, optimize queries, and translate insights into actionable recommendations, bridging the gap between data and business strategy.