Portfolio - Arnab Bhor

PowerBI Project

Mitron Credit Project

The purpose of this dashboard is to aid the strategy team of Mitron Bank in making data-driven decisions to launch a new line of credit cards. We will segment the top three categories of customers most likely to need credit cards and analyze their spending patterns.

View Project
Engagement

View Project
on GitHUB

This dashboard helps us segment our customers based on different categories. The KPI here is the income utilization percentage.

Here we are gauging the spending behavior of our customers. We can look into the spending patterns of various categories of customers.

Project Details

There are 3 screens in this project which help us with the analysis of customers.

1)Demographic Classification & Income Utilization %: We want to analyze the distribution of customers as per various categories in the data.
2)Spending Behavior Analysis: The agenda is to identify the spending patterns of different groups of customers.
3)KPI & Insights: Here we are finding which customer groups give the highest KPI value.

Project video

Live Interactive Dashboard

Excel Project

Marketing Analytics Campaign

This project showcases various metrics used in marketing analytics. We've taken a real-world approach where we have to analyze the data for the last 3 months of a marketing campaign. The question we want to answer is which digital marketing method is performing the best for our company.

View Project
Engagement

View Project
on GitHUB

Here we analyze our PPC data to find the CTR, CPC, and CVR.

We create a dynamic dashboard to understand which marketing campaign is doing the best, and we make some projections.

Project Details

Our company has launched a PPC marketing campaign, and we have 3 months of data around it.
The analysis has been done on the 3 levels:
1) Analysis of PPC data. Here we calculate the click-through rate (CTR), cost per customer (CPC), lead conversion rate (CVR)
2) Customer and survey analysis. We calculate the customer acquisition cost, customer lifetime value (CLV), and net promoter score.
3) Projections and dashboarding. Here we project how things will go if we follow our new strategy, this is done using some basic predictive analytics and data visualization.

Excel Project

Sales Analytics With Descriptive Statistics

The objective is to understand the sales data of a company that produces pizza. We do this using descriptive statistics. These include: 1) Data distribution (frequency distribution, histogram) 2) Central tendency (mean, median, mode) 3) Variability (range, standard deviation, quartiles)

View Project
on GitHUB

Sales Analytics With Descriptive Statistics

Here we are investigating the various distributions and data aggregations in the dataset.

This is a box and whiskers plot that shows us the five-number summary statistics and the outliers.

Project Details

In this project, we go over the sales data of a company that produces pizza.
We need to understand the patterns we can observe in the sales data.
The idea is to understand the central tendency and variability over all the weekdays and the overall data.

SQL Project

Atliq Hardware Ad-Hoc Report

In this project, we answer 10 questions that our manager at Atliq Hardware wants us to find. We do this by writing queries in MySQL database. The idea is to demonstrate various concepts in SQL.

View Project
on GitHUB

Here we are finding the list of markets for a certain set of conditions.

Here we are finding the products with the highest and the lowest manufacturing costs.

Project Details

We use various concepts in SQL to find insight within our data.
The SQL concepts demonstrated are the following:
Data querying using SELECT, FROM, WHERE.
Aggregating data using GROUP BY and HAVING.
Creating views and window functions.

Hello, I am

Arnab Bhor

1

2

1

About

Key

My

Mitron Credit Project

Marketing Analytics Campaign

Sales Analytics With Descriptive Statistics

Atliq Hardware Ad-Hoc Report

Awards

Contact Me

Email

Github

Linkedin

Call

Arnab Bhor

Download Resume