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