Portfolio - Priyanshu Singh

Excel Project

Sales and Financial Analytics (FMCG)

Domain/Function: Sales and Financial Analytics (FMCG)

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills .

View Project
on GitHUB

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

Business Insights 360 for Finance, Sales, Market and Supply Chain

Domain/Function: Finance, Sales, Market and Supply Chain

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

Business Insights 360 for Finance, Sales, Market and Supply Chain

Finance Insights: Unveiling key financial metrics and trends from the project's analytics dashboard .

Data Model: Incorporating 10+ Tables .

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics.

Hello, I am

Priyanshu Singh

1

1

About

Key

My

Sales and Financial Analytics (FMCG)

Business Insights 360 for Finance, Sales, Market and Supply Chain

Awards

Contact Me

Email

Github

Linkedin

Priyanshu Singh