Portfolio - Shreyash Shinde

Shreyash Shinde

Sales Data Analyst

Resume

1

Excel Project

1

PowerBI Project

About Me

I’m a data analyst with over 7 years of experience in sales and supply chain analytics, currently working at Asian Paints. My expertise lies in transforming complex datasets into actionable insights through tools like Power BI, Excel, and SQL. I’ve led high-impact projects involving 8M+ rows of sales data, built interactive dashboards for daily performance, KPIs, and schemes, and automated manual reporting processes, saving significant time. I bring hands-on experience with SAP S/4 HANA, Salesforce, and MySQL, and have worked closely with cross-functional teams to streamline reporting for both frontline teams and senior leadership. My background also includes roles in production planning, service engineering, and procurement at companies like Kirloskar and Alfa Laval, equipping me with a well-rounded understanding of business operations. I hold certifications in Power BI, Excel, and Salesforce, and my B.Tech education laid the foundation for analytical problem-solving.

Key Skills

Power BI

Excel

SQL

My Projects

Sales Analytics

Domain/Function: Sales

Business Insights 360

Domain/Function: IT Hardware

Driving Sales Excellence Through Financial and Sales Analytics | Benchmarking, insights and strategic recommendations

Domain/Function: Global Engineering Services Company

Awards & Certificate

Power BI Data Analytics for All Levels 3.0

Excel: Mother of Business Intelligence

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/shreyash-shinde-31jan/

Call Me

+91 87969875111

Excel Project

Sales Analytics

Domain/Function: Sales

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively

Market Performance vs Target Report

Customer Net Sales Performance displays the yearly net sales performance for each customer.

Project Details

In this project, I developed a sales report using Excel Pivot Tables to help businesses understand their sales performance better. This report is a powerful tool for identifying the best customer discounts, making negotiations easier, and finding new markets to explore.

The insights from these reports can help businesses improve their sales strategies, boost customer satisfaction, and increase revenue.

Below things are covered in project.

1. Use Pivot Tables for quick data analysis.
2. Apply Power Query for smooth data processing.
3. Understand the basics of DAX (Data Analysis Expressions).
4. Use Conditional Formatting to highlight important information.
5. Make reports visually appealing and easy to read.
6. Analyze key sales metrics effectively

Overall, this project gives businesses the insights they need to enhance their sales efforts and discover new growth opportunities through data analysis.

PowerBI Project

Business Insights 360

Domain/Function: IT Hardware

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. My objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

Contains PNL statement, Gross Margin%, Net sales

Contains customer performance, product performance and Unit economics

Project Details

The main aim of this project was to create a comprehensive dashboard for stakeholders across sales, marketing, finance, and the executive team. The focus areas included:

Robust Data Model: Building a solid foundation for data analysis.
User-Friendly Design: Creating intuitive reports that cater to user needs.
Interactive Insights: Offering drillable features for in-depth data exploration.

Below things are covered in the 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

Driving Sales Excellence Through Financial and Sales Analytics | Benchmarking, insights and strategic recommendations

Domain/Function: Global Engineering Services Company

A data-driven sales analytics framework for TTL, featuring KPIs, benchmarking, peer insights, and dashboard visuals to enhance forecasting, territory planning, and performance tracking.

View Project
on

Other Tools

Power BI

Excel

KPIS to consider by TTL

Benchmarking consideration to be done by TTL

Project Details

Driving Sales Excellence through Data
This presentation outlines a strategic sales analytics framework for Tata Technologies, integrating KPIs, benchmarking, and financial insights. It features a dynamic dashboard and peer comparisons across revenue, profit, CSAT, and geographical mix. It also highlights best practices in forecasting, territory management, and performance tracking, drawn from industry leaders. The goal: to enable data-driven decision-making and elevate TTL's sales performance.