About Skills Experience Projects Education Certifications Contact
Available for opportunities

Hi, I'm
Vaibhavi Chavan

Data Analyst

Transforming raw data into actionable insights โ€” through clean pipelines, compelling dashboards, and data-driven storytelling.

5+

Data Projects

3

Months Internship

2+

Certifications

About Me

๐Ÿ“ Location

Pune, Maharashtra, India

๐ŸŽฏ Focus Areas

Data Analysis EDA Data Visualisation Dashboard Development Data Cleaning

๐Ÿ›  Core Stack

Python SQL Power BI Excel Pandas

I'm an aspiring Data Analyst with a B.Tech in Electronics & Telecommunication from Shivaji University Kolhapur, and hands-on experience turning messy, real-world datasets into clean, decision-ready insights.

My toolkit spans Python (Pandas, NumPy, Seaborn), SQL for efficient querying, and Power BI for interactive dashboards โ€” allowing me to cover the full analytics pipeline, from raw data preprocessing to executive-level reporting.

โšก

Fast Learner

Picks up tools and frameworks quickly

๐Ÿ“Š

Insight-Driven

Always asks "so what?" of the data

๐Ÿงน

Clean Data

Meticulous about data quality

๐ŸŽฏ

Impact-Focused

Aligned to business objectives

Technical Skills

๐Ÿ

Python

๐Ÿ—„๏ธ

SQL

๐Ÿ“Š

Power BI

๐Ÿ“—

Excel

๐Ÿ“‰

Statistics

๐Ÿค–

Machine Learning Basics

Work Experience

Data Analyst Intern

UnlockDiscount ยท Remote ยท Bengaluru, KA

Jul 2025 โ€“ Sep 2025
  • Collected, cleaned, and processed large datasets, significantly improving data accuracy and consistency for downstream analysis workflows.
  • Automated Excel reporting workflows using Power Query and Pivot Tables, reducing manual effort by 30%.
  • Developed and optimised SQL queries for efficient data extraction, analysis, and reporting across business functions.

Featured Projects

01 Nov 2025

Digital Marketing Sales Analysis

End-to-end analysis of cross-channel digital marketing performance across Google Ads, Facebook Ads, and YouTube Ads. Built interactive Power BI dashboards to track key performance indicators and guide budget allocation.

Power BI DAX Data Modelling

Impact: Identified high-performing channels and enabled data-driven budget optimisation decisions through KPI tracking of CTR, ROI, and conversions.

02 Oct 2025

E-Commerce Data Preprocessing

Comprehensive preprocessing pipeline for a synthetic e-commerce dataset of 2,000+ transactions. Identified and resolved data quality issues including duplicates, missing values, outliers, and inconsistent formatting using industry-standard techniques.

Python Pandas NumPy Scikit-learn

Impact: Delivered a clean, analysis-ready dataset with 100% completeness through imputation, outlier treatment, encoding, and feature engineering.

03 Jan 2026

Customer Shopping Behavior Analysis

Deep-dive analysis of 3,900+ customer transactions combining Python, SQL, and Power BI to uncover purchase drivers, customer segments, and revenue trends โ€” delivering actionable insights for marketing and sales strategy.

Python SQL Power BI Excel

Impact: Identified key purchase drivers and built a KPI dashboard tracking revenue and customer segments for data-driven business decisions.

04 July 2025

Amazon Sales Analysis

Analyzes 89,000+ Amazon product orders across 8 categories to uncover sales performance trends, seasonal patterns, and top-performing products by revenue and reviews. The dashboard turns raw transactional order data into clear, visual business intelligence.

Power Bi Excel Power Query DAX

Impact: Delivered interactive dashboard enabling real-time YTD and QTD tracking, revealing trends, top products, and category performance insights

Academic Background

๐ŸŽ“

Bachelor of Technology

Electronics & Telecommunication Engineering

Shivaji University Kolhapur

CGPA: 7.2

Dec 2021 โ€“ May 2025
๐ŸŽ“

HSC

Major In Science

Devchand College Arjunanagar, Kolhapur

Marks: 75%

Jul 2019 โ€“ Mar 2021

Professional Certifications

๐Ÿ…

Data Analytics Professional Certificate

Arbor Academy, Pune

Jun 2025 โ€“ Sep 2025

๐Ÿ“Š

Power BI Training

LinkedIn Learning

Dec 2025 โ€“ Jan 2026

Let's Connect

โœ… Thanks for reaching out! I'll get back to you soon.