Portfolio - Virendra Singh

Excel Project

Sales Analytics(FMCG)

We have created 2 report using pivot table for sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales: Containing Net Sales performance of each customer

Market Performance vs Target: Pertaining Market performance comparison with set target.

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 will help in providing actinaable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have used below features of excel to create the report:

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.

PowerBI Project

Business Insights 360 Dashboard (Sales, Finance, Marketing and Supply Chain)

Project goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make informed decisions and reduce the use of excel to compete in the market with other companies.

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard (Sales, Finance, Marketing and Supply Chain)

User-empathetic landing page as a part of dashboard design

Data modelling involving 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

Live Interactive Dashboard

Python Project

AtliQo Bank Credit Card Launch

The objective of this project is to analyze credit card transaction data to uncover patterns, detect anomalies, and provide actionable insights that can enhance customer service in order to launch new credit card for AtliQo bank

View Project
Engagement

View Project
on GitHUB

Phase : Summary

Hypothesis

Project Details

Analyze customers' transactions and credit profiles to figure out a target group for the launch of AtliQo bank credit card.

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality

Hospitality domain analysis on KPI like ADR, Occupancy, DSRN, DBRN, DURN etc to check revenue and sales pattern. This analysis help owner to launch new deal offer on weekend or week days basis occupancy.

View Project
Engagement

Dashboard view

Model view

Project Details

Performed Hospitality domain analysis on AtliQ hotel chain where analyze key metrics of the domain like Revenue, Occupancy, DSRN, ADR etc.

Hello, I am

Virendra Singh

1

2

1

About

My

Sales Analytics(FMCG)

Business Insights 360 Dashboard (Sales, Finance, Marketing and Supply Chain)

AtliQo Bank Credit Card Launch

Hospitality Analysis

Contact Me

Email

Github

Linkedin

Call

Virendra Singh

Download Resume