Project Details

- Developed a comprehensive Profit and Loss (P&L) report for AtliQ Hardware (FY 2019 - 2021) using advanced Excel features.

- Utilized Pivot Tables to provide granular insights into revenue streams and expense categories.

- Analyzed product performance with a focus on:
- Top 10 and bottom 10 products by sales.
- Year-over-year sales comparison for 2019, 2020, and 2021.
- Automated data cleaning using Power Query, reducing manual work by approximately 4 hours.

- Deployed DAX-based calculation models to increase report accuracy by 30%, offering more nuanced and flexible data insights.

- Enabled AtliQ Hardware to better understand their financial performance, supporting more informed strategic decisions

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

This dashboard provides a comprehensive overview of sales performance for Vrinda Store, breaking down key metrics like total sales, orders, category-wise revenue, and customer demographics. It includes:
- Total Sales: ₹21.4M
- Orders: 31.05K
- Category-wise Sales: Top-selling items include Sets (₹10.5M), Kurtas (₹5.0M), and Western Dresses (₹3.1M).
- Geographic Sales Insights: Maharashtra leads with ₹3.01M, followed by Karnataka and Uttar Pradesh.
- Customer Demographics: Women dominate purchases, especially adults (44%), while senior women account for 13.3%.
- Market Share by Channel: Amazon leads (35.5%), followed by Myntra (23.4%) and Flipkart (21.6%).
The dashboard helps identify sales trends, customer preferences, and top-performing locations and channels, making it valuable for business strategy and marketing decisions.

Live Interactive Dashboard

Project Details

Title: Ad-Hoc Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task: As a hypothetical applicant, I:

Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.

Live Interactive Dashboard