Portfolio - Onkar Kulkarni

Onkar Kulkarni

Data Aspirant

Resume

1

PowerBI Project

1

Excel Project

About Me

Hello!👋 I'm Onkar Kulkarni, a passionate date enthusiast on a journey to become a proficient data analyst. With a solid foundation in mathematics, I'm actively honing my skills in data analysis tools in Excel, PowerBI, MY SQL, python to harness the power of data and drive informed decisions.
Why Choose Me?
📊 Analytical Mindset: My background in mathematics has equipped me with a sharp, analytical mindset, allowing me to approach complex problems with precision and clarity.
🛠️ Data Tools Enthusiast: I'm dedicated to mastering the latest data analysis tools, ensuring I stay at the forefront of industry trends and best practices.
🧮 Problem-Solver: I thrive on solving real-world challenges through data-driven solutions, consistently seeking innovative ways to optimize processes.
🔍 Detail-Oriented: My keen attention to detail ensures accurate data interpretation and reporting, enabling confident decision-making.
🌟 Passion for Growth: I'm driven by continuous learning.

Key Skills

Power BI

Python

Effective Communication

Problem Solving

Stakeholder Management

My Projects

Atliq Hardware Business Optimization Dashboard

Domain/Function: Business

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: Sales

Awards & Certificate

Post Graduation Program in Data Analytics

PwC Switzerland - Power BI Job Simulation

Tata - Data Visualisation: Empowering Business with Effective Insights Job Simulation

Programming Foundation and Data Analytics with Python

Data Analytics with Python

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/onkar-kulkarni-b769bb150/

Call Me

+91 8308563190

GitHub

https://github.com/onkarkulkarni545

PowerBI Project

Atliq Hardware Business Optimization Dashboard

Domain/Function: Business

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

View Project
on GitHUB

Data Modelling involving 10+ tables

Designing a landing page that connects with users, making it an essential part of our dashboard.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends, revenue by division and channel, top 5 customer

Live Interactive Dashboard

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: Sales

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report displays the yearly net sales performance for each customer.

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

In this project, I have created a sales report utilizing Excel pivot tables. This report serves as a valuable tool for businesses to determine optimal customer discounts, streamline negotiation processes, and identify opportunities for expanding into promising markets. The reports I've crafted offer actionable insights to assist businesses in enhancing their sales strategies, enhancing customer satisfaction, and increasing revenue.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics
Overall, this project revolves around equipping businesses with the tools and knowledge necessary to enhance their sales efforts. By delving into sales data, businesses can uncover growth.