Portfolio - Harshal Chandrakant Mane

Excel Project

Excel: Sales & Profitability Analytics

Domain/Function: Customer Performance Report

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance. Importance of analyzing sales data: Identify sales patterns and track key performance indicators (KPIs).

View Project
on GitHUB

View Project
on

Excel dashboard for P&L analysis by year and market with filters, YOY comparison, and key metrics to support financial decision-making at AtliQ Hardwa

Excel P&L dashboard by market with filters and gross margin analysis to compare 2021 financial performance across global regions for AtliQ Hardwares.

Project Details

Project Objective:
Develop Profit and Loss (P&L) reports segmented by Fiscal Year and Market to provide clear financial visibility.

Purpose of Sales Analytics:
Enable evaluation of financial performance, support strategic decision-making, and enhance communication with stakeholders.

Importance of Finance Data Analysis:
Facilitates benchmarking against industry standards and historical trends, serving as a foundation for accurate budgeting and forecasting.

Role of Reports:
Aligns financial planning with organizational strategy and builds stakeholder confidence in the company's financial outlook.

PowerBI Project

Power BI: Business Insights 360

Domain/Function: Supply Chain

Created a Power BI app for AtliQ Hardware with 5 business views (Finance, Sales, Marketing, Supply Chain, Executive) to deliver end-to-end insights for data-driven decision-making.

View Project
on GitHUB

P&L dashboard showcasing net sales, gross margin, and cost insights across years, markets, and products to track financial performance trends

Sales dashboard analyzing customer-wise net sales, gross margin %, and product performance to identify top contributors and improvement areas.

Project Details

This Power BI application, titled Business Insight 360, was built for AtliQ Hardware to provide comprehensive, role-based analytics across five key business domains—Finance, Sales, Marketing, Supply Chain, and Executive. Each view delivers tailored insights: from detailed P&L statements and customer performance trends to marketing ROI, forecast accuracy, and executive-level KPIs. The dashboard supports dynamic filtering across products, customers, time periods, and regions. The app consolidates over a million records from diverse sources, enabling teams to monitor performance, identify opportunities, and take strategic actions. Its modular design ensures clarity, ease of use, and scalability for future enhancements.

Live Interactive Dashboard

SQL Project

SQL: Consumer Goods Ad-hoc insights

Domain/Function: Supply Chain

Performed ad-hoc SQL analysis for a consumer goods company to identify top customers, products, and regional sales performance for FY2021. Utilized joins, CTEs, aggregations, and window functions to derive insights supporting business decisions.

View Project
on GitHUB

Identified top 5 customers and products by net sales for FY2021 to support revenue performance evaluation.

Analyzed customer sales distribution by region for FY2021, calculating each customer's share of total net sales.

Project Details

Executed ad-hoc analysis using SQL to support strategic decisions for a consumer goods business. Developed queries to identify top 5 customers and products by net sales for FY2021, helping prioritize key revenue contributors. Additionally, analyzed regional customer performance by calculating net sales distribution and percentage contribution, enabling better regional targeting and segmentation strategies. Used common table expressions (CTEs), aggregations, and window functions to efficiently process and summarize large transactional datasets from sales and customer dimension tables. This project showcased strong SQL skills in data extraction, transformation, and summarization aligned with business KPIs.

Hello, I am

Harshal Chandrakant Mane

1

1

1

About

Key

My

Excel: Sales & Profitability Analytics

Power BI: Business Insights 360

SQL: Consumer Goods Ad-hoc insights

My

Awards

Contact Me

Github

Linkedin

Harshal Chandrakant Mane