Project Details

At AtliQ Hardware, a global electronics leader, we're tackling operational challenges by shifting from Excel to a data-driven approach with Power BI and SQL. Excessive reliance on Excel caused losses in some regions, prompting senior management to launch a data analytics project. Using last year's data, our goal is to boost performance and drive improvements. 📊💡

💼Finance Perspective: Displays a profit and loss statement, including metrics like GM, NP, NS, etc., and charts performance over time with respect to key metrics.
📣Sales Perspective: Illustrates customer and product performance, unit economics, and performance metrics by NS and GM%.
📣Marketing Perspective: Highlights region and product performance, unit economics, and performance metrics by NS and GM%.
🚚Supply Chain Perspective: Exhibits forecast accuracy, Net Error, trends, and key metrics by customers and product.
👨‍🎓Executive Perspective: Presents market share of competitors, trends, revenue by division and channel

Live Interactive Dashboard

Project Details

-From revenue trends to product performance metrics, the dashboard provides a holistic view of Myntra's sales landscape over the past five years.
-Drill down into specific time frames, product categories, and customer segments to uncover nuanced patterns and opportunities.
-Explore sales geographically, identifying regions of strength and potential areas for expansion.

Live Interactive Dashboard

Project Details

The dashboard provides a variety of filters to drill down and up for different granularity. The users can also filter the visualizations in the dashboard by region, state, category of products, sub-categories, and customer segments. It is also possible to filter the dashboard with 3 sliders which can determine the total amount of sales, and the amount of profit and one slider to choose the upper bound and lower bound for the order date. The dashboard is dynamic, and the filter will be applied to all the visualizations available in the dashboard.

superstore regional sales chart
In this dashboard, superstore managers can see the total profit, total sales, and the total discount of each region, they can also see details of each state by simply drilling down to the state view in each chart. This allows them to plan for each region/state inventory based on the sales number to avoid the cost of warehousing.

Live Interactive Dashboard

Project Details

In this project, I had the privilege to delve into the intricacies of sales analytics and financial reporting. Here's a breakdown of what I accomplished:

**Sales Report:**
🎯 **Project Objective:** Developed a customer performance report and conducted a detailed comparison between market performance and sales targets.

💡 **Purpose:** Empowering businesses with insights to monitor and evaluate sales activities, identifying patterns, and tracking key performance indicators.
🔍 **Importance:** Critical for effective decision-making, enabling us to determine customer discounts, negotiate effectively, and spot expansion opportunities.

**Finance Report:**
💰 **Project Objective:** Created Profit and Loss (P&L) reports by fiscal year, months, and markets.

📈 **Purpose:** Evaluated financial performance, supported decision-making, and facilitated communication with stakeholders.

Project Details

•This project presents a comprehensive Power BI dashboard for analyzing Blinkit's sales performance, customer satisfaction, and inventory distribution.
•The dashboard provides key insights and opportunities for optimization using various KPIs and visualizations

Live Interactive Dashboard