MY PORTFOLIO

Hi, I'm Gaurav Kondane

Data Analyst & BI Developer

Gaurav Kondane - Data Analyst

Based in Pune, India

Available for Opportunities


Gaurav Kondane - Data Analyst

ABOUT ME

Turning Data Into

Actionable Insights


I'm a Data Analyst and Business Intelligence Developer skilled in SQL, Python, and Power BI. As a fresher with strong academic training and hands‑on project experience, I enjoy building solutions that connect technical detail with business impact.

What Drives Me

Technical Skills

SQL, Python, Power BI, Tableau, Excel, Data Modeling

Education

B.E. Computer Engineering, Pune University (2025) — CGPA: 7.04

Projects

Built 5+ analytics dashboards including PhonePe, Amazon Logistics, and USA Regional Sales Analysis.

Gaurav Kondane - Data Analyst

PROJECTS

Featured Work


A showcase of my analytics projects demonstrating expertise in SQL, Python, Power BI & Excel.

PhonePe Transaction Analytics

OLA-Data-Analysis-SQL-PowerBi-Excel

Developed a comprehensive analytics dashboard for OLA, visualizing key metrics such as booking volume, revenue breakdown, vehicle performance, cancellation reasons, and customer satisfaction..

PhonePe Transaction Analytics

PhonePe Transaction Analytics

Interactive Power BI dashboard analyzing ₹3,474M+ transactions across multiple services.

USA Regional Sales Analysis

USA Regional Sales Analysis

3-page Power BI dashboard analyzing $1B U.S. sales across KPIs, products, and regions.

Amazon Sales Dashboard

Amazon Sales Analysis

Power BI dashboard analyzing $78.5M sales with courier tracking and top-category insights.

Customer Behavior Analysis

Customer Behavior Analysis

Dashboard analyzing customer trends, sales, and revenue by category, age, and subscription.

Hotel Booking Cancellations

Hotel Booking Cancellations

Excel dashboard revealing cancellation trends, reducing booking risk by 15%.

Coffee Shop Sales Analysis

Coffee Shop Sales Analysis

Excel dashboard analyzing ₹698K sales & 149K footfall for inventory and staffing insights.

SQL Data Cleaning

SQL Data Cleaning – Layoffs Dataset

Cleaned layoffs data in MySQL using window functions, improving dataset reliability.

CERTIFICATIONS

My Achievements


Career Essentials in Data Analysis

Career Essentials in Data Analysis

Microsoft and LinkedIn

View Certificate
Deloitte Australia Data Analytics

Deloitte Australia Data Analytics

By Forage

View Certificate
Tata Group Data Analytics

Tata Group Data Analytics

By Forage

View Certificate
Quantium Data Analytics

Quantium Data Analytics

By Forage

View Certificate

CONTACT

Get in Touch with Us

As a fresher passionate about analytics and dashboards, I’m excited to start my journey with forward‑thinking companies. Let’s explore how I can contribute to your success!