Portfolio - Nikhil Pakhale

PowerBI Project

Sample SuperStore Analysis (Retail Business)

A project from my recent internship with The Sparks Foundation on Exploratory Data Analysis of Sample Superstore, a retail business in USA. As a data and business analyst, I had to identify business problems and try to find out the weak areas where we (the company) can improve our profits.

View Project
Engagement

Sample SuperStore Analysis (Retail Business)

This is the report that I generated in Power BI, which contains different visualizations like Cards for KPIs, Table for state-wise metrics, etc.

This shows the cleaned dataset that was used to extract the information required for analysis and creating the report.

Project Details

After exploring and analyzing the data, I gathered few key insights in order to improve the business profits and work on improvement areas. The Key insights were based on Profits, Sales, Category and Sub-category of Products, Shipment Methods, Regions and Customer Segmentation.

Project video

Live Interactive Dashboard

Wavecon Telecom Analysis Presentation

Wavecon Telecom (imaginary company) has launched their 5G services recently and wants to analyze the impact of it on their business so that they can improve or continue to be a competitive leader in the market.

View Project
Engagement

This is the first page of the dashboard provided for the presentation.

This is one of the PPT slide about the objectives which were discussed in the presentation.

Project Details

As a data analyst intern, I was given a task by my team lead to go through the dashboard and create a presentation highlighting the key insights and answering the stakeholders' questions. This helped me to learn business KPIs of telecom industry such as Active Users, Recharge Plans' Performance, Average Revenue per user and Unsubscribed users. Also, I learned about the concept of Market Share and how to keep the Visualization and Presentation minimal yet informative.

Project video

PowerBI Project

Analyse Growth and Present Insights to the Telangana Government

This is my project for the participation in the Codebasics resume project challenge #7 in collaboration with Telangana Government in which I had to analyse Telangana’s growth among different sectors quantitatively and provide useful insights.

View Project
Engagement

View Project
on GitHUB

Analyse Growth and Present Insights to the Telangana Government

Dashboard created using the Stamp Registration data focusing on the revenue and count of E-stamps and Document Registration.

Dashboard created using the Transportation data focusing on the Vehicles sales by Fuel Type and Vehicle Class (MotorCycles, MotorCars, etc.)

Project Details

The dataset used was of 3 different departments viz. Stamp Registration (E-stamps and Document Registration Revenue), Transportation (Vehicle Sales) and Ts-Ipass (Investments in various sectors). Analysis was conducted using the key questions asked by the stakeholders and top insights and recommendations were provided in the form of video presentation.
Key Insights included:
1. Top districts in overall revenue
2. Growing districts showing YoY revenue growth
3. Growth in Electric Vehicles
4. Top sectors that received highest investments
5. Effect on revenue after implementation of E-stamps
6. Distribution of Vehicle Class

Project video

Live Interactive Dashboard

PowerBI Project

Shield Insurance Report and Analysis

Stakeholders at Shield Insurance wants to make data-driven decisions using the business insights from the available data, and proposes to look at an easy and interactive dashboard for the same.

View Project
Engagement

This shows the General View Report Page of the Dashboard which showcases the Key metrics like Revenue and Customer base.

This is the Data Model created in Power BI, which helps to connect values from different tables and getting correct results in visualizations.

Project Details

As a data analyst, I was given a task by my team lead to coordinate with the client and create a dashboard as per their requirements. While working on this project, I learned Data Cleaning, Data Transformation, Data Modeling, Visualization, DAX functions, Client Coordination, Stakeholder Management, Communication, Presentation and Teamwork.

Few of the key insights extracted were:
1. Highest revenue generated and customers acquired are in March 2023.
2. City and Age Group with highest revenue and customers is Delhi NCR and 31-40.
3. Most of the customers acquired and the highest revenue generated are from the Offline-Agent sales mode.
4. Online App and Website sales mode has shown increase in revenue from Feb 2023 whereas the Offline-Direct mode has declined from the same period.
5. Top preferred/sold policy is POL4321HEL which has a base premium of ₹5,000/- and has a customer base above 4000.
6. 31-40 age group has contributed the most in all of our policies.

Hello, I am

Nikhil Pakhale

3

About

Key

My

Sample SuperStore Analysis (Retail Business)

Wavecon Telecom Analysis Presentation

Analyse Growth and Present Insights to the Telangana Government

Shield Insurance Report and Analysis

Awards

Contact Me

Email

Github

Linkedin

Nikhil Pakhale

Download Resume