Suhail Khan

Data Analyst — SQL, Python & Power BI

I turn raw, messy data into business decisions — cleaning and modeling data in SQL and Python, then building Power BI dashboards that answer a specific question rather than just displaying numbers.

Download Resume GitHub

3,900+

Customer records analyzed end-to-end

SQL → BI

Full pipeline: cleaning, querying, dashboarding

Analytics Case Studies

Every project below follows the same loop: a business question, what I did with the data, and what I'd tell a stakeholder.

Customer Shopping Behavior Analysis

View Code

Tech: Python • Pandas • SQL • PostgreSQL • Power BI • Excel

Business Question

Business-focused analysis and actionable recommendations based on project results.

Approach

  • Cleaned and validated 3,900+ purchase records (deduplication, type correction, missing-value handling)
  • Loaded structured data into PostgreSQL and wrote SQL queries for segment, category, and revenue breakdowns
  • Used Pandas for cohort-level trend analysis
  • Built an interactive Power BI dashboard with drill-down filters by segment and time period

Key Finding

Business-focused analysis and actionable recommendations based on project results.

Recommendation

Business-focused analysis and actionable recommendations based on project results.

Dashboard Screenshot

OLA Ride Analytics Dashboard

View Code

Tech: Python • MySQL • SQL • Power BI

Business Question

Business-focused analysis and actionable recommendations based on project results.

Approach

  • Cleaned and transformed raw ride booking data in MySQL
  • Wrote SQL queries to analyze cancellations, revenue, and rating trends
  • Built a Power BI dashboard visualizing booking trends and payment method mix

Key Finding

Business-focused analysis and actionable recommendations based on project results.

Recommendation

Business-focused analysis and actionable recommendations based on project results.

Dashboard Screenshot

Technical Stack

Python

SQL

Power BI

Excel

MySQL

PostgreSQL

Java

Spring Boot

HTML

CSS

End-to-End Data Analytics Process

Raw Data

Collected data from CSV, Excel files, SQL databases, and business datasets.

Data Cleaning

Removed duplicates, handled missing values, corrected data types, and prepared clean datasets.

Database

Stored structured data in MySQL/PostgreSQL and performed SQL queries for analysis.

Data Analysis

Used Python, Pandas, NumPy, and SQL to analyze trends, KPIs, and business metrics.

Visualization

Created interactive Power BI dashboards to communicate insights effectively.

Business Insights

Delivered actionable insights to support strategic business decisions.

Raw Data Data Cleaning SQL Database Data Analysis Power BI Dashboard Business Insights

Data Collection

Gathered structured and unstructured business data from multiple sources.

Data Preparation

Transformed raw data into analysis-ready datasets using Python and Excel.

SQL Processing

Performed filtering, joins, aggregations, and KPI calculations with SQL.

Exploratory Analysis

Identified trends, customer behavior, revenue patterns, and business opportunities.

Dashboard Development

Designed interactive Power BI dashboards with dynamic filters and visual reports.

Decision Making

Converted analytical findings into actionable business recommendations.

Experience

Java Developer Intern – Oasis Infobyte

2025

  • Built core Java applications, including a number guessing game and an ATM interface simulation
  • Applied OOP principles and control flow to solve structured programming tasks
  • Practiced debugging and writing clean, modular Java code

SmartInternz – Cloud & AI Labs

2024

  • Completed Google Cloud labs
  • Worked with Gemini & Vertex AI
  • Understood cloud deployment
  • Built backend learning foundation

Also Built: Backend Engineering

Outside of analytics, I also build the systems that generate data — useful context, kept separate from the analyst work above.

URL Shortener

Java • Spring Boot • MySQL • REST API

Full-stack URL shortening service with redirect handling and usage tracking on a relational backend.

View Code

MediFlow System

Spring Boot • Hibernate • MySQL • JWT

Layered REST backend (Controller → Service → Repository) with JWT auth and role-based access control.

View Code

Let's Connect

Contact Information

suhailkhan6669@gmail.com
Ghaziabad, Uttar Pradesh, India
Data Analyst — Python, SQL, Power BI

Connect Online