Project Details

🚀 Ad Hoc SQL Analysis Project
In this project, I tackled 10 ad hoc data requests with precision, delivering actionable insights to top-level management and empowering strategic decision-making.

🔑 Key Skills Demonstrated:

🛠 Basic SQL Commands: Extracting and manipulating data effortlessly.
📊 GROUP BY, ORDER BY, HAVING Clauses: Organizing and filtering data effectively.
📈 Aggregate Functions: Summarizing data for impactful insights.
🔗 Joins: Seamlessly connecting datasets for comprehensive analysis.
🧵 CTEs & Subqueries: Solving complex queries with advanced techniques.
💡 Impact:
This project sharpened my ability to analyze raw data, uncover meaningful insights, and communicate findings through compelling presentations. It strengthened both my technical expertise and soft skills, showcasing how data can be a powerful driver of real-world business strategies.

🌟 Outcome: Improved decision-making capabilities and a deeper understanding of data-driven business solutions.

Project Details

Project Details
🎯𝗧𝗮𝘀𝗸:
Crafting Accessible Reports - Net Sales Performance, Market Analysis, Yearly & Monthly, Profit & Loss.

🛠️ 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
Harnessing Pivot Tables for insightful reports. Power Query for seamless data transformation. Power Pivot for robust data models.

📚 𝗞𝗲𝘆 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:

✅ Functional Knowledge

✅ Data Transformation & Modeling

✅ Data Modeling

✅ DAX Measures

✅ Pivot Table Reports

✅ Fine-Tuning

✅ User Empathetic Report Generation

🚀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗥𝗲𝘀𝘂𝗹𝘁𝘀:
Empowered stakeholders with data-driven reports showing an overall increase in net sales and gross margin percentage.

Project Details

In this project, I created a Power BI report for stakeholders in sales, marketing, finance, and executive teams. My focus was on building a robust data model that accommodates complex datasets while ensuring an intuitive, interactive design. This enabled drillable insights for informed decision-making.

I enhanced my skills in Power Query for advanced transformations and used both basic and complex DAX formulas for deeper analysis. The data model integrated over ten interconnected tables, with carefully selected visuals to convey key narratives. By applying dashboard design principles, I ensured clarity and impact, with features like bookmarks enhancing user experience.

The report was deployed via Power BI Service, incorporating stakeholder feedback for improvement. Analyzing vital metrics across departments has empowered teams to make data-driven decisions and drive business success, fostering a culture of analytical thinking

Live Interactive Dashboard

Project Details

I crafted this project as a third-party data analyst to assist AtliQ Grand, a renowned hotel chain, in reclaiming lost market share and boost revenue. Facing tough competition and lacking data-driven decisions, they sought expertise to turn the tide.

This project offers three comprehensive views:

Performance Overview:
Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage. Detailed metrics such as average rates and cancellation percetage are included.

Revenue Breakdown:
Delves into revenue distribution across cities, hotel categories, and booking platforms. These insights are crucial for optimizing sales strategies.

Booking Analysis:
Examines booking patterns, cancellations, and guest behavior. This yields actionable insights to improve operational efficiency and drive revenue growth.

I learned the following things in this project
1. Data Visualization
2. Revenue Analysis
3. Presentation Skills
4.Critical thinking
5. Dax

Live Interactive Dashboard

Project Details

Project Details
🎯𝗧𝗮𝘀𝗸:
Analyze AtliQ Grands' booking data to address declining revenue.

🛠️ 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
Cleaned and transformed data, created metrics, and generated insights.

📚 𝗞𝗲𝘆 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:
✅ Pandas Library
✅ Handling Null Values
✅ Concatenation and Merging
✅ Plotting with Matplotlib
✅ Data Exploration & Understanding

🚀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 & 𝗥𝗲𝘀𝘂𝗹𝘁𝘀:
"Presidential" rooms stand out with a 59.28% occupancy rate, while Delhi leads in overall occupancy at 61.51%. Weekends consistently outperform weekdays, suggesting potential for targeted marketing. June saw high occupancy in Delhi and Hyderabad. Mumbai takes the revenue lead, but monthly revenue varies, hitting ₹38,99,40,912 INR in July 2022 and ₹40,83,75,641 INR in May 2022.