Portfolio - Darshan G

Excel Project

Sales and Finance Analysis

Generated reports that will assist the sales team in assessing customer performance and comprehending market performance in relation to their goal/objective.

View Project
Engagement

View Project
on GitHUB

Customer performance report provides net sales performance of each customer across years

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

Project Details

For this project, I used Excel Pivot tables to create a sales report that will help businesses find potential business expansion opportunities in promising countries, as well as determine effective customer discounts and facilitate customer negotiations.

The reports that are produced will give businesses practical insights and suggestions on how to improve customer satisfaction, increase sales, 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

By utilizing sales data analysis, businesses can unlock new opportunities, drive growth, and maintain their competitiveness in the ever-changing market landscape. The overall goal of this project is to equip businesses with the tools and insights they need to monitor, assess, and handle their sales activities.

Excel Project

Sales and Finance Analysis

Generated reports that will assist the sales team in assessing customer performance and comprehending market performance in relation to their goal/objective.

View Project
Engagement

View Project
on GitHUB

Customer performance report provides net sales performance of each customer across years

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

Project Details

For this project, I used Excel Pivot tables to create a sales report that will help businesses find potential business expansion opportunities in promising countries, as well as determine effective customer discounts and facilitate customer negotiations.

The reports that are produced will give businesses practical insights and suggestions on how to improve customer satisfaction, increase sales, 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

By utilizing sales data analysis, businesses can unlock new opportunities, drive growth, and maintain their competitiveness in the ever-changing market landscape. The overall goal of this project is to equip businesses with the tools and insights they need to monitor, assess, and handle their sales activities.

Hello, I am

Darshan G

2

About

Key

My

Sales and Finance Analysis

Sales and Finance Analysis

Contact Me

Email

Github

Linkedin

Call

Darshan G

Download Resume