Portfolio - Vineet Kumar

Hello, I am

Vineet Kumar

Data Aspirant

2

Excel
Projects

About

Welcome to my world of data-driven discovery! I'm an aspiring Data Analyst with a burning passion for transforming raw information into valuable insights. While my academic journey led me to a Bachelor's degree in B.Com my true calling emerged in the realm of data analysis.

My toolkit is powered by Excel, Power BI, SQL, and Python - the instruments that enable me to uncover hidden stories within numbers. I thrive on turning complex data sets into actionable knowledge, fueling strategic decision-making.

Technical

Skills

Excel

PowerBI

SQL

Communication Skills

Critical Thinking and Problem-Solving:

Continuous Learning and Adaptability

My

Projects

Sales Analytics (FMCG)

Created two reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target

Finance Analytics (FMCG)

Created two reports for the finance team which will help them to evaluate market performance and understand their market performance with respect to their target.

Awards

& Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Contact Me

Github

https://github.com/vineetkinhaofficial

https://www.linkedin.com/in/vineet-k-b06312256/

Vineet Kumar

Data Aspirant

Excel Project

Sales Analytics (FMCG)

Created two reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target

View Project
Engagement

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Excel Project

Finance Analytics (FMCG)

Created two reports for the finance team which will help them to evaluate market performance and understand their market performance with respect to their target.

View Project
Engagement

Market Performance Report: Provides top 10 product performance of each market across years

Market Performance Report: Provides new product performance of each market in year 2021

Project Details

Project Description:

In this project, I created a finance report using excel pivot tables which will enable businesses to determine effective market performance, facilitate negotiations with markets, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their finance performance. By leveraging finance data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Full Name *

Email *

Phone Number *

I want to know about: *

I agree to use my communication details for further communication from codebasics.

Hello, I am

Vineet Kumar

2

About

Technical

My

Sales Analytics (FMCG)

Finance Analytics (FMCG)

Awards

Contact Me

Github

Linkedin

Vineet Kumar