👋 Welcome to my portfolio

Hi, I'm Pratham

|

I transform raw data into actionable insights — building dashboards, uncovering trends, and helping organizations make smarter, data-driven decisions.

View Projects Download Resume
Revenue Insights
+24.7%
YoY Growth
Customers
12,450
Active Users
Risk Score
Low
Credit Risk
Scroll Down
Projects

Featured Work

Credit Risk Analysis Dashboard
View on GitHub
Power BI Excel DAX

Credit Risk Analysis Dashboard

Analyzed retail loan data to identify high-risk borrowers and default patterns. Built an interactive dashboard surfacing credit score distributions, default rates, and risk segments.

GitHub Repository
E-commerce Sales Dashboard
View on GitHub
Power BI CSV DAX

E-commerce Sales & Revenue Analysis

Sales performance dashboard analyzing revenue trends, top customers, and product performance. Tracked monthly KPIs and highlighted growth opportunities across segments.

GitHub Repository
Prime Video Analytics Dashboard
View on GitHub
Power BI Excel

Prime Video Analytics

Analyzed streaming content data to study genre distribution, ratings, and release trends. Visualized content diversity and audience preference patterns across thousands of titles.

GitHub Repository
About Me

Who I Am

3+Projects
5+Tools
2Certs

I'm Pratham Nagekar, an aspiring Data Analyst with a strong foundation in electronics engineering and a passion for turning complex datasets into meaningful stories.

My expertise spans SQL, Python, Excel, Power BI, and Tableau — tools I use to clean, model, and visualize data. I've worked with financial and sales datasets, building interactive dashboards that surface key KPIs and business trends at a glance.

I'm deeply interested in business analytics — understanding what drives performance, identifying risk patterns, and communicating findings clearly to stakeholders. I believe great analysis isn't just about numbers; it's about the story they tell.

Power BI SQL Python Data Storytelling DAX Excel
Skills

What I Work With

Data Analysis
SQL
Python
Excel
Power BI
Tableau
Databases
MySQL
PostgreSQL
Analytics Skills
Data Cleaning
Dashboard Design
KPI Analysis
Trend Analysis
Data Visualization
Journey

Experience & Education

Experience

Intern — Systems Engineering

Pantech Prolabs India Pvt Ltd

Analyzed system performance data using SQL and Excel across 1000+ test cases, identified validation issues and error patterns, and supported engineering teams with structured reports and visualizations.

Experience

Coordinator — Rotary Club

Bangalore Institute of Technology

Coordinated community service programs, managed teams of 20+ students, and collaborated with faculty and external stakeholders to improve program execution.

Education

Bachelor of Engineering — Electronics Engineering

VLSI Design & Technology | BIT

2022 – 2026

Bangalore Institute of Technology. Focused on VLSI design, analytical thinking, and technical problem-solving.

Education

Pre-University (PCMB — Science)

Government PU College, Karwar

2020 – 2022

Completed higher secondary education with a focus on Physics, Chemistry, Mathematics, and Biology.

Education

Secondary School (CBSE)

Amrita Vidyalayam

Completed 2020

Foundation in core academic subjects and early development of analytical skills.

Certifications

Industry Recognition

Verified credentials from global programs and industry simulations

Tata GenAI Data Analytics Job Simulation

Completed Tata's GenAI-powered data analytics simulation, applying AI-assisted analysis to real business scenarios.

Tata Group View

McKinsey Forward Program

Completed McKinsey's Forward Program, developing skills in problem-solving, data-driven decision-making, and business strategy.

McKinsey & Company View

Certificate of Internship

Successfully completed a 30-day internship on Embedded System Design at Pantech Prolabs India Pvt Ltd.

Pantech Prolabs View

ESG Job Simulation

Completed an ESG-focused job simulation covering Environmental, Social & Governance analytics and responsible investment frameworks.

ESG Program View

Dubai One Million Prompts

Participated in the Dubai One Million Prompts AI challenge, developing practical skills in generative AI and prompt engineering.

AI & GenAI View
FAQ

Frequently Asked Questions

Common questions about my approach to data and analytics

My primary stack is SQL for querying and transforming data, Excel for quick exploration and pivot analysis, and Power BI for building interactive dashboards. I'm also building proficiency in Python (Pandas, Matplotlib) for more complex data wrangling tasks.

I follow a structured data cleaning process — checking for nulls, duplicates, inconsistent formats, and outliers before any analysis. I also cross-validate results against known benchmarks or alternative queries to confirm findings are consistent.

I start by understanding the business question — what decision needs to be made and what does success look like. Then I identify the relevant data, clean and analyse it, and translate findings into clear, actionable recommendations rather than just numbers.

I focus on the "so what" — not the methodology, but the business implication. I use clear visual dashboards in Power BI, avoid jargon, and lead with the key finding before diving into supporting details. The goal is a decision, not a data lecture.

Contact

Let's Connect

Open to data analyst roles, freelance projects, and collaborations. Feel free to reach out!

Email

prathamnagekar06@gmail.com

LinkedIn

linkedin.com/in/prathamnagekar06

GitHub

github.com/Pratham06-12