Anshu Kunwar | Data Analyst Portfolio

About Me

I turn complex data into clear stories that drive decisions.

I'm a data analyst with hands-on experience in cleaning, analyzing, and visualizing datasets—and in communicating findings so stakeholders can act on them. I combine Python, SQL, and tools like Power BI and Excel to deliver reports and dashboards that improve clarity and outcomes.

Experience

2025-Present

Junior Data Analyst (Self Projects)

Data Analytics Practice

Completed Harvard CS50 Python and HackerRank Python certifications.
Built end-to-end analytics projects using SQL, Excel, and Power BI.
Performed data cleaning, EDA, and KPI reporting on real-world datasets.
Created dashboards and business insights for decision-making.

2024

Hackathon Winner — Smart College

College Competition

Developed "Smart Catten," a food-ordering system for classrooms, with a full-stack web solution.
Presented to judges and faculty; awarded Best Creative Idea for the campus solution.

Sep 2023 – Oct 2024

Student Support Officer

Maven Consulting Group

Managed and maintained student data records in Excel, ensuring accurate organization, updates, and documentation tracking.
Handled email communication for student applications, coordinating responses between internal team members.
Collaborated with team members to support application processing and resolve documentation or status-related issues.
Supported branch-level operations by organizing and tracking student application workflows in structured folders and spreadsheets.

Technical Skills

Data Processing

Python, Pandas, Excel, SQL

Data Visualization

Power BI, Matplotlib, Charts & Dashboards

Analytics

Statistics, Data Cleaning, Reporting

Basic Frontend

HTML, CSS, JavaScript

Featured Projects

Olist E-commerce Sales Analysis

Problem:Large e-commerce dataset was unstructured and difficult to analyze for business insights.

Solution:Built end-to-end analytics pipeline using Excel, MySQL, and Power BI for cleaning, modeling, and visualization.

Tools: Excel, MySQL, Power BI, DAX · Impact:Revenue trends, customer behavior, and product performance insights.

Code

Sales Data Analysis

Problem: Sales performance across regions and models needed deeper analysis.

Solution: End-to-end analysis with interactive dashboards and clear KPIs for performance and trends.

Tools: Excel, Power BI, DAX · Impact: Data-driven insights for business decisions.

Code

Workout Tracker SAAS

Problem: Users needed a simple way to track workouts and see progress over time.

Solution: Full-stack SaaS app for logging workouts, visualizing progress, and viewing personalized data insights.

Tools: Full-stack (frontend + backend) · Impact: Demonstrates data visualization and user-centric product thinking.

Code

GameHatch

Problem: Gamers needed a clear place to discover and download PC games.

Solution: Interactive PC game download platform with discovery and community features.

Tools: Frontend (HTML, CSS, JS) · Impact: Shows UI/UX and project delivery skills.

Code Live Demo

Data & Dashboard Showcase

A look at the dashboards and analytics work from my projects.

Total Orders Analyzed 96+ Olist E-commerce Dataset

BMW Sales Records 3,000+ 2018 – 2025 Global Data

BEV Adoption Driver Fuel Price Key insight from BMW Analysis

Growth Potential Found 20%+ 3 underperforming markets

Olist E-commerce View Project

BMW Sales Analysis View Project

Olist E-commerce View Project

BMW Sales Analysis View Project

Awards & Certifications

Harvard CS50 Python Certificate

Issued by Harvard University (CS50) · 2026

View Certificate

HackerRank Python Certification

2025

Certified Python programmer with problem-solving skills

Verify Credential

1st Place — College Hackathon

2024

Won "Best Creative Idea" for Smart Cateen

Open to Opportunities

I'm actively looking for internships, remote roles, and freelance projects in data analysis, BI, and analytics. Let's build something data-driven together.

Get in Touch View GitHub