Prithvi Taneja — Data Analyst

About

Aspiring Data Analyst with hands-on internship experience cleaning, validating, and analyzing datasets to generate actionable business insights. Skilled in SQL, Excel, Power BI, and Tableau, with practical experience building dashboards and reports that support data-driven decision-making. Completed 4 real-world analytics projects and a Deloitte virtual internship, demonstrating readiness to contribute from day one. Brings a business development background that adds commercial context to data storytelling and stakeholder communication.

Tools & Technologies

SQLPower BI (DAX)Tableau Excel (Advanced)Python (Pandas, NumPy)PowerPoint

Core Strengths

Data Cleaning & ETLRFM & Segmentation Dashboard DevelopmentBusiness Intelligence Data Storytelling

Projects

Retail Customer Segmentation (End-to-End)

SQL · Python · Power BI · Excel

View Repo ↗

392K+

Transactions

4,338

Unique Customers

RFM Segments

65%

Rev. from Champions

Cleaned 26.6% bad data (cancelled orders, duplicates) before analysis
Built RFM segmentation in SQL identifying 6 customer segments
Applied K-Means clustering in Python to validate business segments
Power BI dashboard revealed Champions drive 65% of ₹8.9M revenue — informed VIP retention and win-back campaigns

Starbucks Sales Analysis Dashboard

SQL · Power BI

View Repo ↗

1M+

Transactions

2 yrs

Data Span

₹10K+

Peak Hourly Revenue

Built interactive Power BI dashboard analyzing transactions across 2 years
Wrote SQL queries for hourly revenue trends and demographic segmentation
Identified peak sales hours (9 AM, 4–6 PM) driving highest hourly revenue

Pizza Sales Analysis

SQL (Advanced)

View Repo ↗

Business Questions Solved

Advanced SQL Techniques

Solved 11 business questions using window functions, CTEs, and subqueries
Calculated RFM metrics and revenue breakdown by category and geography
Demonstrated mastery of NTILE, ROW_NUMBER, and percentage calculations

FNP E-commerce Dashboard

Microsoft Excel (Advanced)

View Repo ↗

Cleaned and analyzed retail transaction data in Excel to uncover customer purchasing patterns
Built an interactive Excel dashboard tracking spending behavior, purchase frequency, and category preferences using Pivot Tables and charts
Identified key customer segments and shopping trends to support targeted marketing and inventory decisions

Experience

Apr 2026 – Jun 2026

Data Analyst

5 Elements Insurance Brokers Pvt. Ltd.

Cleaned and validated raw datasets, reducing inconsistencies prior to analysis
Analyzed business data using SQL and Excel to support management decision-making
Maintained audit-ready, structured datasets and databases
Delivered reports translating findings into clear business recommendations

Jan 2025 – Dec 2025

Business Development Executive

Taskar (India's First Healthcare Mall)

Conducted data mining and research to shortlist relevant VC firms and angel investors
Built and maintained a structured database of investor contacts
Applied data-driven targeting across email, WhatsApp, and LinkedIn outreach

Mar 2023 – Sep 2023

Restaurant Staff

Nirula's

Delivered customer service in a fast-paced environment
Developed communication, multitasking, and problem-solving skills under pressure

Certifications & Education

Power BI for Beginners

Simplilearn, powered by Microsoft — Completed 30 Jul 2026

Data Analytics Virtual Internship

Deloitte Australia (via Forage)

Data Analyst Internship — Certificate of Completion

5 Elements Insurance Brokers Pvt. Ltd., 2026

Data Analytics with AI

PhysicsWallah (PW Skills) — SQL, Python, Power BI, Tableau, Excel, ETL

Bachelor of Business Administration (BBA)

Rukmini Devi Institute of Advanced Studies, GGSIPU, New Delhi — Completed Jun 2026