Project Details

This project presents a comprehensive financial and operational analysis of Uber using a structured, data-driven approach. Leveraging tools like Power BI and Excel, I explored key performance indicators such as revenue, number of rides, profit margins, and cost structure. The project focuses on understanding Uber's financial trends, identifying growth patterns, and offering insights on operational efficiency. Data visualization techniques were applied to present actionable findings clearly and interactively. The project also incorporates comparative metrics and insights from competitor platforms to provide a broader market context. This work demonstrates my ability to translate raw data into strategic business insights, reflecting skills in data analytics, storytelling, and financial interpretation.

Live Interactive Dashboard

Project Details

Zepto Grocery Sales Dashboard

Developed an interactive Power BI dashboard to analyze Zepto’s grocery sales, outlet performance, and product distribution. Integrated a filter panel for dynamic insights based on outlet location, size, and item type, enabling data-driven decision-making.

🔹 Key Features:

Sales Analysis: Total sales, average sales, ratings, and item visibility.
Performance Breakdown: Outlet-wise comparison across different locations and sizes.
Trend Analysis: Outlet establishment growth over time.
Data Modeling & DAX: Custom calculations for accurate reporting.
Category Insights: Sales distribution across grocery product categories.
📊 Tools Used: Power BI, Excel, DAX, Data Modeling

This dashboard helps businesses identify sales trends, optimize inventory, and improve overall performance. 🚀

Live Interactive Dashboard

Project Details

Power BI Hospitality Dashboard analysing key metrics like revenue (₹1.71B), occupancy (57.8%), RevPAR (₹7.34K), and ADR (₹12.7K). City-wise insights show Mumbai leading (₹668.6M). Booking trends highlight reliance on third-party platforms. Customer ratings average 3.62, with Delhi hotels scoring highest (3.8). Data-driven insights enhance decision-making. 🚀

Live Interactive Dashboard

Project Details

As part of the Codebasics Virtual Internship, I worked on a comprehensive SQL project analyzing the performance of a Tech Influencer’s Instagram handle. Using raw SQL queries, I explored user engagement patterns, content effectiveness, and growth metrics. The project involved 10 business-critical questions that were answered through advanced SQL techniques like CTEs, stored procedures, aggregations, and date functions. I visualized insights in a structured presentation, identified trends in reach, likes, saves, post types, and follower growth. Finally, I concluded the project with key recommendations for boosting digital presence. This project demonstrates my ability to turn raw social media data into actionable business insights.

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.

Project Details

In this project, the goal was to create a single report for stakeholders across sales, marketing, finance, and the executive team. Key focuses included:

1. Robust Data Modeling
2. User-friendly Report Design
3. Drillable Insights

Through this project, I gained expertise in:

- Power Query (both basic and advanced operations)
- Basic & complex DAX formulas
- Data modeling with 10+ tables
- Selecting appropriate visuals and formatting
- Applying dashboard design principles
- Utilizing bookmarks for interactive reports
- Deploying in Power BI Service
- Gathering and acting on stakeholder feedback
- Analyzing sales, marketing, finance, and supply chain metrics

This project helped me refine my skills in creating a powerful, multi-departmental reporting solution.

Live Interactive Dashboard

Project Details

Coffee Shop Sales Dashboard
This Excel dashboard provides a comprehensive analysis of coffee shop sales, visualising key performance metrics such as total sales ($6.98M), total footfall (1,49,116), average bill per person ($4.69), and average order value ($1.44). It features insights on sales distribution by product category, order size preferences, peak sales hours, store performance, and top-selling products like Barista Espresso and Hot Chocolate. Interactive filters allow for month-wise and day-wise analysis, helping businesses optimise inventory, pricing, and operational efficiency.