Summary
Overview
Work History
Education
Skills
Certification
Timeline
Achievement
Generic

Prince Katiyar

Data Analyst
Kanpur

Summary

Detail-oriented Data Analyst skilled in SQL, Excel, Python, and Power BI with experience in data cleaning, reporting, and visualization. Strong analytical skills with knowledge of KPIs, statistical analysis, and business intelligence. Passionate about delivering data-driven insights to improve business performance.

Overview

5
5
Certifications

Work History

Retail Data Analysis Project

Tools: Excel
  • Analyzed retail pricing, promotions, advertising ROI, and customer behavior using Excel Pivot Tables and formulas.
  • Identified key drivers influencing customer footfall and return rates through correlation and trend analysis

BMW Used Car Price Analysis

Tools: Python (Pandas, NumPy), Matplotlib, Seaborn
  • Performed EDA and data cleaning on the BMW used car dataset.
  • Applied feature engineering and correlation analysis to identify key price drivers.
  • Built visualizations and KPIs to analyze price trends by year, mileage, and fuel type.
  • Derived data-driven insights on factors affecting resale value.

Education

Bachelor of Computer Applications -

Maharana Pratap College Of Professional Studies
Kanpur, India
04.2001 -

Skills

Data analysis

Data visualization and presentations

SQL

Python programming

Time management

Data storytelling

Certification

Data Analytics Essentials – Cisco Networking Academy

Timeline

Bachelor of Computer Applications -

Maharana Pratap College Of Professional Studies
04.2001 -

Retail Data Analysis Project

Tools: Excel

BMW Used Car Price Analysis

Tools: Python (Pandas, NumPy), Matplotlib, Seaborn

Achievement

  • Qualified Round 1 – Young Turks 2025
Prince KatiyarData Analyst