MEDHAVI AGRAWAL DATA ANALYST
I TURN DATA INTO DECISIONS.
MEDHAVI AGRAWAL
Data Analyst · Power BI · SQL · Python · Excel

Electronics & Telecommunication Engineering student at MITS Gwalior, focused on data analysis, business intelligence, dashboard development and data storytelling.

Medhavi Agrawal — Data Analyst
✦ DRAG ID CARD TO INTERACT
MEDHAVI / 2026
AVAILABLE FOR
DATA ANALYTICS ROLES
9.84 / 10
CGPA
#01
INSTITUTE RANK
TOP 30
KSP DATATHON 2026
3×
DASHBOARD PODIUMS
01

FEATURED PROJECTS

FEATURED CASE STUDIES
AI-Driven Crime Intelligence & Visualization Platform
CASE STUDY 01 · DATA ANALYTICS

AI-Driven Crime Intelligence & Visualization Platform

TOP 30 — KARNATAKA STATE POLICE DATATHON 2026
THE PROBLEM

Law enforcement authorities manage high-volume, multivariable incident records across police stations, creating operational delays in detecting rapid localized hotspots and aligning patrol deployments.

THE APPROACH

Engineered an AI-powered intelligence platform integrating dynamic geospatial crime maps, officer performance metrics, and predictive crime forecasting with bilingual (Kannada/English) executive reporting.

Automotive Sales Performance Dashboard
CASE STUDY 02 · AUTOMOTIVE BENCHMARKING

Automotive Sales Performance Dashboard

1ST PLACE — DASHBOARD MASTERS
THE PROBLEM

Automotive dealership groups needed instant analytical visibility into sales volume swings, average vehicle price elasticity, and fuel-type margin disparities across regional branches.

THE APPROACH

Developed a KPI-driven Power BI dashboard in a live 60-minute competition sprint. Analyzed multi-year transactions, pinpointed top-performing brands and fuel segments, and structured dealership revenue drivers.

Road Accident Trend Analysis Dashboard
CASE STUDY 03 · TRAFFIC SAFETY ANALYTICS

Road Accident Trend Analysis

NATIONAL SAFETY ANALYTICS
ANALYTICAL PURPOSE

Explored nationwide accident records to isolate high-fatality accident types, evaluate severity distributions across diverse weather conditions, and identify temporal clustering.

THE APPROACH

Synthesized complex multivariable safety data into intuitive interactive visual layouts, pinpointing critical risk timeframes and geographic accident clusters to inform preventive highway safety strategies.

02

WHAT I DO

ANALYTICAL WORKFLOW
01
COLLECT
Understand the data and the question. Frame core objectives, audit source integrity, and establish analytical benchmarks.
02
CLEAN
Prepare, transform and validate the dataset. Eliminate anomalies, normalize schemas, reconcile missing attributes, and structure relational tables.
03
ANALYZE
Identify patterns, relationships and trends. Write DAX measures, test statistical correlations, construct aggregations, and compute KPI variances.
04
VISUALIZE
Build dashboards that make findings understandable. Maintain visual hierarchy, intuitive drill-down interactions, and zero-clutter information design.
05
COMMUNICATE
Turn analysis into decisions and recommendations. Deliver executive briefings with crisp, quantitative insights that drive real-world action.
03

ANALYSIS INDEX

EXPLORATORY & BI DASHBOARDS
01

ROAD ACCIDENT TREND ANALYSIS

Power BI · Data Analysis · DAX
Road Accident Analysis
→
02

IPL PLAYER AUCTION ANALYTICS

Power BI · DAX · Data Visualization
IPL Auction Analytics
→
03

ANDHRA PRADESH ELECTION ANALYSIS

Power BI · Data Visualization · Statistical Analysis
AP Election Analysis
→
04

AMAZON SALES & PROFIT ANALYSIS

Power BI · Business Analytics
Amazon Sales Analysis
→
04

TECHNICAL ARCHIVE

ENGINEERING & IOT PROJECTS

IoT-Based Water Quality Monitoring

Embedded Arduino system measuring pH, turbidity, TDS, and temperature for environmental parameter tracking.

Smart Toll Gate Automation

Microcontroller-driven barrier mechanism with ultrasonic vehicle detection for queue mitigation and traffic control.

Reutilization of Fossil Fuels

Research investigation on treatment and reutilization of fossil fuel by-products; awarded State Rank 05 at NCSC.

05

ACHIEVEMENTS

HONORS & AWARDS
TOP 30
Karnataka State Police Datathon 2026
EASTMAN POWERUP SCHOLAR
1 of 32 students selected from 10,000+ applicants nationwide
1ST PLACE
Dashboard Masters Competition (IITM Janakpuri, 2026)
1ST PLACE
DATAVIZ Power BI Competition (MITS Gwalior, 2025)
1ST RUNNER-UP
Dash-It-Up Power BI Contest (MITS Gwalior, 2024)
INSTITUTE RANK 01
Two consecutive academic years (2024–25 & 2025–26) with 9.84 cumulative CGPA
RELIANCE FOUNDATION SCHOLAR
Selected among 5,000 recipients from 125,000+ applicants nationwide
TOP 22 OF 1,800+ TEAMS
Ujjain Simhastha Mahakumbh Hackathon (Government of Madhya Pradesh)
TWO-TIME FINALIST
Hacksagon Hackathon, ABV-IIITM Gwalior (National Level)
06

TOOLKIT

SKILLS & TECHNOLOGIES
ANALYTICS
Power BI
SQL
Excel
DAX
PROGRAMMING
Python
Pandas
NumPy
Scikit-learn
VISUALIZATION
Power BI
Excel
Matplotlib
TOOLS
GitHub
Figma
Canva
ADDITIONAL TECHNICAL
HTML
CSS
Tailwind CSS
React
07

EXPERIENCE

LEADERSHIP & POSITIONS
PRESIDENT
Career Catalyst Club, MITS
Sep 2025 — Present
Leading a 28-member student team and organizing career-focused initiatives, industry analytical webinars, technical aptitude training sessions, and student guidance forums across departments.
ALUMNI COORDINATOR
Department of ETE, MITS
Aug 2025 — Aug 2026
Maintaining the departmental alumni records database, coordinating professional mentorship webinars, and facilitating academic-to-industry transition events.
COMMITTEE MEMBER
Anti-Ragging Committee, MITS
Sep 2024 — Present
Assisting student welfare bodies in maintaining campus standards, peer support mechanisms, and campus monitoring.
MEMBER & DESIGNER
Artistry Club & Innovation DIY Club, MITS
Oct 2024 — Present
Creating visual designs, technical exhibition materials, and interdisciplinary hardware automation projects.
08

EDUCATION

ACADEMIC BACKGROUND

MITS GWALIOR

B.Tech — Electronics & Telecommunication Engineering
2024 — 2028 · Full-time Undergraduate
9.84
CGPA (RANK 1)
10.00
SEM 01 SGPA
93.4%
CLASS XII (CBSE)
92.6%
CLASS X (CBSE)
09

CERTIFICATIONS

PROFESSIONAL CREDENTIALS
Certification 1
Certification 2
Certification 3
Certification 4
VIEW ALL CERTIFICATIONS →
10

DESIGNS

DATA POSTERS & VISUALS
Dash-It-Up Poster
Dash-It-Up Contest POWER BI COMPETITION
Vikasit Bharat Poster
Vikasit Bharat 2047 NATIONAL CAMPAIGN
PROMPT-E-PIC Event Poster
Prompt-E-Pic Contest TECH COMPETITION
CCC Recruitment Poster
CCC Recruitment Drive CLUB CAMPAIGN
VIEW ALL DESIGNS →
LET'S WORK WITH DATA.

I'm currently exploring opportunities in data analytics, business intelligence and dashboard development.