Portfolio - Jai Shinde | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Jai Shinde

Data Aspirant

Resume

2

PowerBI
Projects

About

Me

I’m a Data Analyst passionate about transforming raw data into clear, actionable business insights.

My core skills include SQL, Power BI, Excel, Python, and BigQuery, with hands-on experience in data cleaning, exploratory analysis, KPI development, data modeling, and dashboard creation. I’ve worked on projects across Supply Chain, BFSI, Hospitality, and Food & Beverage, taking projects from raw data and SQL analysis to interactive dashboards and business insights.

Before moving into analytics, I worked in content and digital marketing, which strengthened my ability to understand business objectives, communicate complex ideas clearly, and think from the audience’s perspective.

Today, I combine analytical thinking, business understanding, and communication to answer the questions behind the numbers and turn data into meaningful insights.

Key

Skills

POWER BI

MYSQL

EXCEL

BIGQUERY

PYTHON

NUMPY

PANDAS

MATPLOTLIB

SEABORN

DATA TRANSFORMATION

DATA MANIPULATION

DATA CLEANING

DATA ANALYSIS

POWER QUERY

DAX

DATA VISUALISATION

My

Projects

Shield Insurance Project

Shield Insurance Project

Domain/Function: BFSI

Built an interactive Power BI dashboard for Shield Insurance to analyze premium revenue, customer demographics, sales channels, policies, and settlements, helping identify key business trends and performance drivers.

QuickBite Express Food Delivery Analytics

QuickBite Express Food Delivery Analytics

Domain/Function: Food & Beverage

Food delivery analytics dashboard analyzing business performance, customer behavior, delivery metrics, and crisis impact using Python, Pandas, and Power BI.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Data Analytics Bootcamp 6.0: Job Placement Support + Your Own AI Analyst Agent

CB Cert

Microsoft Fabric Mini: For Data Analysts

SQL Associate by Datacamp

SQL Associate by Datacamp

Contact Me

Email

[email protected]

Github

https://www.github.com/jaishinde7

Linkedin

https://www.linkedin.com/in/jaishinde7

Call

+91 9156706527

Jai Shinde

Data Aspirant

Download Resume

Resume

PowerBI Project

Shield Insurance Project

Domain/Function: BFSI

Built an interactive Power BI dashboard for Shield Insurance to analyze premium revenue, customer demographics, sales channels, policies, and settlements, helping identify key business trends and performance drivers.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Python

Pandas

Shield Insurance Project

An in-depth look at how we sell. Compare performance across different channels, such as Agents, App, Direct, and Website to identify the most profitable sales routes and optimize distribution strategies.

Shield Insurance Project

A high-level overview of the company's financial health. Track total premium revenue, customer acquisition trends, and key performance indicators (KPIs) to monitor overall business momentum at a glance.

Project Details

Analyzed 26K+ insurance records across 6 relational tables to uncover trends in premium revenue, customer demographics, policy performance, and sales channels.

Built an interactive Power BI dashboard using MySQL for data extraction and Power Query and DAX for data transformation, modeling, and KPI development. Created dynamic measures using functions such as ALLSELECTED and REMOVEFILTERS to ensure accurate calculations across filters.

Developed interactive dashboards with drill-throughs, bookmarks, and demographic-level analysis to help stakeholders explore customer behavior, revenue performance, and policy trends.

Key insights included the 31–40 age group as the largest revenue contributor, Direct–Agents as the leading customer acquisition channel, and POL2005HEL as a widely preferred policy across demographics.

Project video

Live Interactive Dashboard

PowerBI Project

QuickBite Express Food Delivery Analytics

Domain/Function: Food & Beverage

Food delivery analytics dashboard analyzing business performance, customer behavior, delivery metrics, and crisis impact using Python, Pandas, and Power BI.

View Project
Engagement

View Project
on GitHUB

Other Tools

Python

Pandas

QuickBite Express Food Delivery Analytics

Overview: Monitor overall business performance and the impact of the crisis.

QuickBite Express Food Delivery Analytics

Customer & Orders Analysis: Analyze customer behavior, order trends, acquisition, and geographic performance.

Project Details

Analyzed QuickBite Express food-delivery data to evaluate business performance before, during, and after a crisis, focusing on revenue, orders, customers, delivery performance, cancellations, ratings, and customer sentiment.

Used Python and Pandas for data cleaning, transformation, and exploratory analysis, followed by Power BI for data modeling, DAX measures, and interactive dashboard development.

Built a 5-page dashboard covering Executive Overview, Customer & Order Analysis, Delivery Performance, Ratings & Sentiment, and Restaurant & Menu Performance. The analysis revealed a 28.6% decline in revenue, a 25.4% decline in orders, and a 30.2% decline in customers during the crisis period.

Additional analysis covered SLA compliance, cancellation trends, restaurant and cuisine performance, customer segmentation, and review sentiment using a word cloud to identify recurring customer feedback themes.

Live Interactive Dashboard

Already have an account? Sign in

or