Portfolio - SUMIT SAGAR SAWANT

SUMIT SAGAR SAWANT

Data Analyst

Resume

2

Excel Projects

5

PowerBI Projects

1

SQL Project

About Me

Hi, I’m Sumit Sawant, Data Analyst professional with 4+ years of experience delivering scalable analytics solutions through modern data platforms. Expertise in building end-to-end interactive dashboards and data pipelines that drive data-driven decision-making. Proven track record in automation, process optimization, and stakeholder collaboration across enterprise environments.

✔ Core Strengths:
- Crafting interactive dashboards for storytelling.
- Automating processes for efficiency.
- Analyzing market trends and simplifying complex data.

✔ Achievements:
- Designed Power BI dashboards for Blinkit and pizza sales analysis.
- Completed Excel and MySQL projects focused on advanced analytics and ETL processes.
- Earned recognition for problem-solving and workflow optimization in my current role.

I’m eager to collaborate with forward-thinking teams and leverage data to unlock opportunities and drive strategic decisions.

Key Skills

Advanced Excel

SQL

MYSQL

POWER BI

POWER BI DESKTOP

POWER BI SERVICE

POWER QUERY

DAX

DATA MODELING

DATA VISUALIZATION

DATA CLEANING

Tableau

ELT/ELT

Microsoft Fabric

SSMS

Data Warehousing

Row-Level Security (RLS)

Pivot Tables

Macros

Power Automate

On-Premises Data Gateway

Stakeholder Management

Requirement Gathering

My Projects

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

Call Center Churn Analysis

Domain/Function: Call Center

Pizza Sales Analysis (Power BI)

Domain/Function: Food

Pizza Sales Analysis (MySQL)

Domain/Function: Food

𝗕𝗹𝗶𝗻𝗸𝗶𝘁 Dashboard

Domain/Function: E-commerce

HR Analytics Dashboard

Domain/Function: Human Resouce

Vrinda Store Sales Dashboard

Domain/Function: Sales

Sales & Finance Analysis

Domain/Function: Sales & Finance Analysis

My Experience

MUFG Intime India Private Limited – MIS Executive
Jul 2025 - Present

Collecting and analyzing stakeholder requirements to ensure alignment with business goals

Designed and developed interactive and user-friendly Power BI reports and dashboards using SQL Server as the primary data source

Utilized Power Automate to streamline and automate repetitive workflows and processes

Implemented Row-Level Security (RLS) to ensure secure and role-based data access

Published reports to Power BI Service within a Premium Capacity workspace for optimal performance and scalability

Configured and maintained On-Premises Data Gateways to enable seamless data refresh and connectivity

MAX Spare Limited – Dy Executive of Sales
Aug 2020 - May 2024

Developed and automated daily, weekly, and monthly MIS reports for 200+ distributors and 1000+ customers using Excel (Pivot Tables, Macros, Power Query).

Reduced manual reporting time by 40% through report automation and VBA recording.

Delivered actionable insights to sales and operations teams via custom ad-hoc reports and visual performance dashboards.

Collaborated with cross-functional teams to ensure accuracy in sales KPIs and reporting governance.

Paramount Health Services (TPA) Pvt. Ltd – Dy Executive of Sales
Jun 2019 - Jul 2020

Developed and automated daily, weekly, and monthly MIS reports for 200+ distributors and 1000+ customers using Excel (Pivot Tables, Macros, Power Query).

Reduced manual reporting time by 40% through report automation and VBA recording.

Delivered actionable insights to sales and operations teams via custom ad-hoc reports and visual performance dashboards.

Collaborated with cross-functional teams to ensure accuracy in sales KPIs and reporting governance.

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

Get Job Ready: Power BI Data Analytics for All Levels 3.0

JPMorgan Chase & Co. - Excel Skills Job Simulation

PwC Switzerland - Power BI Job Simulation

Deloitte Australia - Data Analytics Job Simulation

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Fabric Analytics Engineer Associate

SQL (Intermediate)

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/sawantsumit06/

Call Me

+91 9768266324

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardware, like many Latin American companies, faced challenges using outdated methods like Excel for data analysis. Recognizing the need for transformation, the company aimed to develop a comprehensive report analyzing operational performance using Power BI's advanced features.

View Project
Engagement

Other Tools

Power Query

MySQL

DAX

Data Modelling

DAX Studio

Finance View

Executive View

Project Details

Power BI Dashboard Overview
• Home Page: A centralized navigation hub with buttons to access different sections.
• Finance Page: Enhances financial planning, budgeting, and cost control with insights like Profit and Loss statements, Top/Bottom Products, and Customers by Net Sales.
• Sales Page: Focused on boosting revenue and market share, showcasing Customer performance by Net Sales, Gross Margin, and Gross Margin %.
• Marketing Page: Aims to improve brand visibility and engagement, featuring Segment Performance by Gross Margin% and Net Profit%.
• Supply Chain Page: Optimizes inventory and supplier relations with metrics like Forecast Accuracy and Net Error.
• Executive Page: Offers a high-level performance summary for management, including Net Sales, Gross Margin%, Revenue by channel, Top Customers/Products, and Sub-Region performance.
These skills empower me to drive data-driven decisions and add value to future projects.

Live Interactive Dashboard

PowerBI Project

Call Center Churn Analysis

Domain/Function: Call Center

Completed PwC Switzerland's Power BI Job Simulation, developing dashboards to meet client needs, analyzing HR data for gender KPIs, and providing actionable insights. Enhanced communication, technical, and problem-solving skills, focusing on data-driven decision-making and client satisfaction.

View Project
Engagement

Churn Dashboard

Customer Risk Analysis

Project Details

I completed PwC Switzerland's Power BI Job Simulation on Forage, enhancing my Power BI skills to address client data visualization needs.

- Created dashboards showcasing KPIs, responding effectively to client requirements with well-designed solutions.
- Demonstrated strong communication skills through concise, insightful email exchanges with engagement partners, delivering actionable recommendations.
- Applied analytical problem-solving to examine HR data, focusing on gender-related KPIs, and identified root causes of gender balance issues at the executive level.
- Highlighted a commitment to leveraging data for informed decision-making and delivering value-driven insights.

This experience sharpened my technical and analytical capabilities while reinforcing the importance of client-centric communication.

Live Interactive Dashboard

PowerBI Project

Pizza Sales Analysis (Power BI)

Domain/Function: Food

Analyzed one year of pizza sales data using SQL to uncover trends, customer preferences, and sales patterns. Extracted insights to optimize inventory and operations, enhancing growth and profitability. The project provided a data-driven foundation for informed decision-making.

Other Tools

Power Query

DAX

Data Modelling

Data Cleansing

Data Visualization

Category wise analysis of Orders and Revenue

Analysis by month, MOM Growth % and Distribution of Orders by Hours (hh)

Project Details

Objective: The project analyzes pizza sales data to derive actionable insights, focusing on total orders, revenue, popular pizza types and sizes, order timing, and revenue contributions.

Key Insights:
- Revenue Drivers: Classic and Supreme pizzas significantly contribute to total revenue, reflecting strong customer preferences.
- Size Popularity: Large pizzas dominate, guiding inventory planning.
- Top Categories: Classic and Chicken pizzas are best-sellers, ideal for focused promotions.
- Peak Hours: Order volumes peak during lunchtime, suggesting the need for additional staff during these hours.
- Daily Sales: An average of 138 pizzas are sold daily, aiding in inventory and workforce planning.
- Top Performers: Chicken pizzas like Thai Chicken and Barbecue Chicken lead in sales, along with Classic options such as Classic Deluxe and Hawaiian.

These insights help optimize inventory, improve service, and refine sales strategies, strength.

Live Interactive Dashboard

SQL Project

Pizza Sales Analysis (MySQL)

Domain/Function: Food

View Project
Engagement

View Project
on

Most common pizza size ordered

Distribution of orders by hour of the day

Project Details

PowerBI Project

𝗕𝗹𝗶𝗻𝗸𝗶𝘁 Dashboard

Domain/Function: E-commerce

Customers prefer Low Fat products, signaling a health-conscious trend. Fruits & Veggies lead purchases, followed by Snack Foods—key areas to stock up. Medium-sized outlets outperform larger ones. Tier 3 cities generate more revenue. 2018-established stores and Supermarket Type 1 outlets excel.

View Project
Engagement

Other Tools

Power Query

Excel

DAX

Data Visualization

ETL

Data Modelling

Customers prefer low-fat items; fruits, veggies, and snacks sell most; medium-sized outlets generate higher sales than larger ones.

Tier 3 cities, 2018 outlets, and Supermarket Type 1 stores show higher sales—more items and smart location choices drive better performance.

Project Details

📊 Blinkit Dashboard Project – STAR Summary:
Situation: Blinkit opened new stores and wanted to identify which ones deliver the most value.

Task: Analyze store performance and provide data-driven insights to guide strategy.

Action: Used Power BI, DAX, Power Query, and Excel to clean, model, and visualize data. Built an interactive dashboard highlighting key metrics.

Result: Found that "Low Fat" and "Fruits & Veggies" were top choices. Medium-sized stores and Tier 3 cities outperformed others. 2018-established stores and "Supermarket Type 1" drove higher sales. Insights support inventory and expansion decisions.

Live Interactive Dashboard

PowerBI Project

HR Analytics Dashboard

Domain/Function: Human Resouce

Created a comprehensive HR Analytics Dashboard to monitor and analyze key employee attendance metrics including Presence Percentage, Work from Home (WFH) Percentage, and Sick Leave (SL) Percentage, helping HR teams make informed and data-driven decisions.

Other Tools

Power Query

ETL

DAX

Data Visualization

Dashboard highlighting key workforce metrics

Project Details

Designed an interactive HR Analytics Dashboard highlighting key workforce metrics such as Presence %, Work From Home %, and Sick Leave %, enabling data-driven HR decisions.

Live Interactive Dashboard

Excel Project

Vrinda Store Sales Dashboard

Domain/Function: Sales

'm excited to share my recent project where I analyzed and created a sales dashboard for Vrinda Store, focusing on their annual sales for 2022. This dashboard provides valuable insights to help Vrinda understand their customers better and grow their business in 2023.

View Project
Engagement

Other Tools

EXCEL

DATA CLEANING

POWER QUERY

DASHBOARDING

SLICER

CHARTS

Vrinda Store Sales Dashboard

Project Details

Vrinda Store - 2022 Sales Dashboard Summary:
The 2022 sales analysis reveals that March recorded the highest sales, with women (64%) being the top buyers, especially those aged 30-49 (50%). Key contributing states include Maharashtra, Karnataka, and Uttar Pradesh, accounting for around 35% of sales. Major sales were driven through Amazon, Myntra, and Flipkart, contributing nearly 80%.
Recommendation: Focus marketing efforts on women aged 30-49 in the top-performing states, leveraging top e-commerce platforms with targeted ads, offers, and coupons to drive growth in 2023.

Excel Project

Sales & Finance Analysis

Domain/Function: Sales & Finance Analysis

Leveraged Pivot Tables, Power Query, Power Pivot, and Data Modeling to analyze sales data and optimize discount strategies. Used DAX formulas and Conditional Formatting to create efficient visualizations, enabling in-depth analysis and improved decision-making.

View Project
Engagement

View Project
on

Comparison between Actual Market Performance and Target

Net Sales Performance Report by market India

Project Details

🚀 Unveiling My Latest Project: Sales & Finance Analytics Report! 🌟

Excited to share my recent project leveraging Excel to deliver impactful insights into sales and financial performance! This report combines advanced Excel functionalities:

✅ Pivot Tables & Power Query for sales analysis and optimizing customer discounts.
✅ Power Pivot & Data Modeling for efficient data structuring and linking.
✅ DAX Formulas & Conditional Formatting to enhance visualization and decision-making.

🔍 Key Outcomes:
- Identified growth opportunities in untapped markets.
- Provided actionable insights to empower data-driven strategies.
- Improved clarity and speed in understanding metrics.

This experience deepened my technical and analytical skills, reinforcing the power of data-driven decision-making to drive business transformation.