Available for opportunities

Hi, I'm Kenil Patel

Data Analyst · Python · SQL · Power BI

// about me

Who I Am

I'm a Data Analyst based in Gujarat, India, passionate about transforming raw data into actionable insights. With hands-on experience in Python, SQL, and Power BI, I've delivered dashboards on 200K+ IPL records and 50K+ retail transactions. Currently interning at TechReale, building real-time analytics pipelines.

0K+

Records Analyzed

Industry Certificates

Query Latency Reduced

// what I work with

My Toolkit

Data Analytics

EDA
Data Cleaning
Statistical Analysis
KPI Reporting
ETL

Languages & Libraries

Python
Java
Pandas
NumPy
Matplotlib
Seaborn

Database

MongoDB
MySQL
SQL
Query Optimisation

BI & Visualization

Power BI
DAX
Power Query
Excel
Pivot Tables

Tools

Git
Jupyter Notebook
VS Code
Google Colab
MS Excel

Web (Bonus)

React
TypeScript
JWT
REST APIs

PythonSQLPower BIPandasNumPyMongoDBMySQLExcelDAXMatplotlibSeabornJupyterGitReactTypeScriptPythonSQLPower BIPandasNumPyMongoDBMySQLExcelDAXMatplotlibSeabornJupyterGitReactTypeScript

// selected work

Featured Projects

IPL Match Intelligence & Performance Analytics

Python
SQL
Power BI
Pandas

End-to-end analytics dashboard analyzing 200K+ ball-by-ball IPL records. Reduced null values by 94% and built interactive KPI dashboards for player and match trend analysis.

200K+ Records · 94% Data Quality Improvement

GitHub

Global Superstore Sales Analysis

SQL
Excel
Power BI
DAX

Retail analytics on 50K+ transactions using SQL, Pivot Tables, and Power BI. Revealed 12 loss-making sub-categories causing 35% profit leakage.

50K+ Transactions · 35% Profit Leakage Identified

GitHub

Hotel Cancellation Analysis

Excel
Pivot Tables
Data Visualization

Excel dashboard analyzing hotel booking cancellations, uncovering 3 peak cancellation periods responsible for 62% of revenue loss.

62% Revenue Loss Attributed · 3 Peak Periods Found

GitHub

Bonus · Full-Stack

Digital Menu – SaaS Platform

React
TypeScript
MongoDB
JWT

Full-stack SaaS digital menu platform with QR-based access, multi-tenant architecture, and role-based auth across 5+ client databases.

GitHub Live Demo

View All Projects

// my journey

Experience

Data Analyst Intern · TechReale

Dec 2025 – Present

Valsad, Gujarat

Designed and maintained MongoDB collections powering real-time analytics features.
Built ETL pipelines to ingest, clean, and transform multi-source data.
Developed and consumed REST APIs to serve analytics data to internal tools.
Optimised queries and indexing to reduce query latency by 30%.