Prathmesh Tamsekar

Data Aspirant

[email protected] +91 7719950478

Resume

Hello, I am

Prathmesh Tamsekar.

1

Excel
Project

1

PowerBI
Project

About Me

I’m a Data Analyst who enjoys turning data into useful business insights using Excel, Power BI, SQL, and Python. With a B.Com degree in Accounting, I naturally approach data from a business and finance point of view, focusing on insights that actually help in decision-making. I’ve worked on real-world projects in finance, sales, marketing, and HR, where I analyzed trends, built dashboards, and explained data in a clear and practical way. These projects reflect how data is used in real business situations—tracking performance, finding gaps, and improving outcomes.
I enjoy the full data process, from cleaning and organizing data to creating visuals and sharing insights. Alongside my projects, I regularly share data-related content, which has helped me communicate insights more clearly and simply. My portfolio below highlights my projects, problem-solving approach, and continuous learning journey. I’m curious by nature and focused on building data solutions that support better business

Key Skills

advance excel

power bi

Effective Communication

Stakeholder Management

My Projects

Excel-Sales-Analytics-of-AtliQ-Hardware

Domain/Function: Finance & Sales Analytics

HR Attendance & Work Pattern Analysis – AtliQ Hardwares

Domain/Function: HR Analytics | Workforce & Attendance Analysis

Awards & Certificate

Excel: Mother of Business Intelligence

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

Digital Marketing

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.

Mail Me

[email protected]

https://www.linkedin.com/in/prathmesh-tamsekar/

Call Me

+91 7719950478

GitHub

https://github.com/pathyatamsekar/Excel-Sales-Analytics-of-AtliQ-Hardware

Excel Project

Excel-Sales-Analytics-of-AtliQ-Hardware

Domain/Function: Finance & Sales Analytics

Analyzed financial and sales data using Excel to track customer performance, profitability, discounts, and targets. Built structured reports and dashboards to support business decisions across finance and sales teams.

View Project
Engagement

View Project
on GitHUB

Customer-level sales analysis comparing 2021 actuals vs targets across countries, highlighting revenue gaps, underperforming regions, and variance percentages to support data-driven sales planning and performance improvement.

Market-wise Profit & Loss analysis for FY 2021, showing net sales, COGS, gross margin, and GM%, enabling comparison of profitability across regions and identification of high- and low-margin markets for better financial decision-making.

Project Details

This project focuses on analyzing financial and sales performance data using Excel to help businesses understand profitability, customer behavior, and target achievement. I worked on multiple Excel reports, including P&L statements, customer performance analysis, discount approval analysis, scenario planning, and priority matrix dashboards.

Using Pivot Tables, advanced formulas, and structured layouts, I analyzed revenue, costs, margins, discounts, and targets across different periods. The project helps identify high-performing customers, loss-making segments, pricing and discount issues, and gaps between targets and actual performance.

I also created scenario planning tools to evaluate different business outcomes and priority matrix dashboards to support better decision-making. This project demonstrates how Excel can be used effectively for real-world finance and sales analytics without complex tools.

PowerBI Project

HR Attendance & Work Pattern Analysis – AtliQ Hardwares

Domain/Function: HR Analytics | Workforce & Attendance Analysis

Analyzed HR attendance data using Power BI to uncover employee presence, WFH trends, and sick-leave patterns. Built an interactive dashboard to support HR decisions on hybrid work planning, office utilization, and employee well-being.

View Project
Engagement

Interactive Power BI dashboard displaying employee attendance insights, including presence %, WFH %, and sick leave %, with daily and weekday trends to analyze hybrid work patterns and support HR planning and decision-making.

April 2022 HR attendance analysis showing presence %, WFH %, and sick-leave trends by date and weekday, with employee-level details to highlight hybrid work behavior, mid-week office presence, and support short-term workforce planning decisions.

Project Details

This project focuses on analyzing employee attendance and work patterns for AtliQ Hardwares in a hybrid work environment. Using Power BI, I transformed raw attendance data into an interactive dashboard that provides clear insights into presence %, work-from-home %, and sick leave %.

The dashboard helps HR teams understand how employees work across different days, weeks, and months. I analyzed weekday trends, identified higher mid-week office presence, tracked WFH behavior, and highlighted unusual sick-leave spikes that may indicate potential health or engagement issues.

Employee-level views allow HR to drill down into individual attendance behavior, while trend visuals support office capacity planning, team engagement activities, and hybrid policy decisions. This project demonstrates my ability to convert HR business questions into meaningful KPIs and build dashboards that explain not just what is happening, but why it is happening.