Project Details

This Excel Mastery project demonstrates a comprehensive skill set, ranging from basic data cleaning to advanced financial analytics. By combining the precision of VLOOKUP and INDEX-MATCH with the analytical prowess of statistical concepts and Power Pivot, the user is equipped to transform raw data into valuable business insights, making informed decisions that drive success.

Project Details

A stringent quality assurance process validated data integrity, verified calculations, and fine-tuned the dashboard's performance. The result is a user-friendly, comprehensive dashboard offering holistic insights into sales, finance, marketing, executive, and supply chain performance. This project not only showcased technical proficiency but also underscored the capacity to distill complex datasets into actionable intelligence, empowering stakeholders to make informed decisions with confidence.

Live Interactive Dashboard

Project Details

AtliQ Grands: Regaining Luxury Hospitality Leadership Through Data

Facing declining market share and revenue, luxury hotel chain AtliQ Grands embarked on a data-driven journey of transformation. By collaborating with a skilled data analyst, they unlocked the power of their historical data, transforming it into actionable insights.

The analyst crafted custom metrics tailored to AtliQ Grands' unique objectives, built a comprehensive dashboard for clear visualization, and uncovered hidden opportunities beyond the pre-defined metrics. This resulted in:

Improved Revenue Management: Dynamic pricing strategies and targeted marketing campaigns optimized revenue generation.
Enhanced Guest Experience: Data-driven insights led to tailored offerings and services, exceeding guest expectations.
Strategic Decision-Making: Informed by data, AtliQ Grands made strategic decisions, leading to a significant increase in market share and a remarkable resurgence in revenue.

Live Interactive Dashboard

Project Details

Atliq Hardwares, a major computer hardware company, needed help making better decisions using data. As a Data Analyst learner, I tackled a challenge from Tony Sharma, their data boss.

Using SQL, I answered 10 important questions about the company's data. These questions were crucial for the top bosses to understand. Then, I created an informative presentation with images to show what I found.

This project shows I'm good at understanding data and sharing it in a way that makes sense to everyone. It helps Atliq Hardwares make smarter choices and grow their business.