RONAK PAWAR PAWAR PAWAR

DATA ANALYST · BI DEVELOPER · MUMBAI AVAILABLE

Your spreadsheet has 50,000 rows and zero answers. That's where I come in — SQL, Python, Power BI, and an obsession with making data actually useful.

View My Work GitHub

DASHBOARDS

10K+

ROWS PROCESSED

TOOLS

PROJECTS

⚡ Power BI — ACTIVE

🐍 Python · Pandas

🗄️ SQL · DAX

revenue_dashboard.pbix — MONTHLY KPI LIVE

JAN FEB MAR APR MAY JUN JUL AUG

↑ REVENUE GROWTH +18%

◎ MODEL ACCURACY 94%

⬡ RECORDS PROCESSED 8,800+

⬡ STAKEHOLDER REPORTS WEEKLY

01 — ABOUT ME

DETAIL
DRIVEN.

Hi, I'm Ronak — a B.Sc. IT graduate (April 2026) from Navi Mumbai. Music producer in my spare time, badminton player on weekends, data analyst by passion.

I got into analytics because I've always been wired to find the pattern nobody else noticed — in a song, in a game, in a spreadsheet. Turns out that instinct translates pretty well to data.

My friends would say I'm the guy who finds the plot twist in everything — movies, conversations, data. Some call it overthinking. I call it pattern recognition.

Proficient in EDA, KPI tracking, and cross-tool reporting across Power BI, Tableau, Python, SQL, and Excel.

🎯 Detail-Oriented

📐 Structured Thinker

🔍 Curious Analyst

💬 Clear Communicator

⚡ Fast Learner

BI DASHBOARDS BUILT 5+

ROWS PROCESSED 10K+

CUMULATIVE GPA 8.40

TOOLS MASTERED 8

LOCATION MUMBAI 🇮🇳

02 — TOOLKIT

TOOLS &
TECH

// hover each cell

📊

Power BI

ADVANCED

5+ interactive dashboards with DAX measures, drill-through reports, published weekly to stakeholders.

MASTERY · 85%

🗄️

SQL

INTERMEDIATE

JOINs, GROUP BY, WHERE, subqueries & window functions — querying and slicing 10K+ row datasets to pull exactly what the business needs.

MASTERY · 70%

🐍

Python

INTERMEDIATE

Pandas, NumPy, Matplotlib, Seaborn for EDA on 8,800+ records.

MASTERY · 68%

📈

Tableau

INTERMEDIATE

Visual stories, trend-line analyses, geographic maps for regional comparisons.

MASTERY · 65%

📋

Excel

ADVANCED

PivotTables, VLOOKUP, INDEX-MATCH, conditional formatting — rapid business dashboards for stakeholder presentations.

MASTERY · 82%

🔍

EDA

INTERMEDIATE

Bar charts, pie charts, line charts & scatter plots — uncovering distributions, outliers & correlations to shape every downstream report.

MASTERY · 72%

🧹

Data Cleaning

INTERMEDIATE

Removing nulls, duplicates & inconsistencies — standardizing formats, fixing data types, and transforming raw messy data into analysis-ready datasets.

MASTERY · 75%

📐

DAX

PROFICIENT

Measures, calculated columns, time-intelligence (YTD, MoM) inside Power BI.

MASTERY · 60%

🧠

BI Strategy

ADVANCED

Translating raw data into strategic decisions. Bridging data teams and non-technical stakeholders through visual reporting.

MASTERY · 80%

03 — EXPERIENCE

MY
JOURNEY.

UNIFIED MENTOR — REMOTE

DATA ANALYST
INTERN

Jan 2026 – Apr 2026

Designed and maintained 3+ interactive Power BI and Excel dashboards tracking business KPIs, customer trends, and operational metrics used by stakeholders weekly.

Cleaned and transformed multi-source datasets (10,000+ rows), significantly improving data quality and report accuracy.

Analyzed campaign and operational data to identify performance gaps and optimization opportunities across business units.

Presented insights to non-technical stakeholders through visual reports and executive summaries, bridging data and decision-making.

Power BI Excel Python SQL KPI Reporting Stakeholder Communication

04 — WORK

FEATURED
PROJECTS.

// 3 selected works

PROJECT 01

Netflix Data: Cleaning, Analysis & Visualization

Power BI Excel Python Pandas

End-to-end analysis of 8,800+ Netflix titles — cleaned raw data (nulls, duplicates, inconsistent formats), ran full EDA with bar, pie, line & scatter charts, then built an interactive Power BI dashboard with KPI cards, Movies vs TV Shows split, country-wise distribution, genre popularity & year-on-year content growth. Built for stakeholders who don't read code.

View on GitHub

PROJECT 02

Retail Sales Analysis SQL Project

SQL Excel Data Modeling

Built a retail sales database from scratch — cleaned nulls & bad records with SQL, then answered 10 real business questions: top 5 customers by revenue, best-selling month per year, gender-wise category breakdown, shift-based order patterns (Morning / Afternoon / Evening) & more using GROUP BY, RANK(), CTEs & window functions.

View on GitHub

PROJECT 03

Product Sales Analysis System

Python Excel Power BI DAX

Full BI system for retail chains — branch managers get a secure Streamlit dashboard with KPIs, top & least selling products, expiry alerts & smart stock recommendations. Executives get a Power BI dashboard with revenue, profit, monthly trends & multi-branch comparison. Built on a 3-layer architecture: CSV data → Pandas logic → live dashboard.

View on GitHub