SQL • Python • Power BI • Excel

Data Analyst — SQL · Python · Power BI
Building Dashboards & Pipelines That Drive Decisions

Built 4 end-to-end projects using SQL, Python, and Power BI — from data cleaning to dashboard delivery. Developed automated pipelines and analytical solutions to extract insights and support data-driven strategy. Seeking a data analyst role to solve real business problems.

View My Projects → GitHub ↗

End-to-End Data Projects

Dashboards · Pipelines · Analysis

Core Tools

SQL · Python · Power BI · Excel

∞

Data Processed

Multiple sources & formats

01 — About

Turning Raw Data into Business Insights

I build end-to-end analytics solutions that solve real business problems. My projects cover the full workflow — data extraction, cleaning, modeling, and dashboard delivery — using SQL, Python, Power BI, and Excel.

I focus on practical outcomes: defining clear business questions, working with real datasets, and delivering insights that accelerate decision-making. My work emphasizes accuracy, clarity, and measurable impact.

SQL Python Power BI Excel

🧹

Data Cleaning

Transforming messy raw data into reliable, analysis-ready datasets

📊

Data Visualization

Designing dashboards that surface insights and reduce decision time

💡

Business Thinking

Connecting data patterns to actionable business outcomes

02 — My Toolkit

Core Tools & Technical Skills

Technologies I use to extract, analyze, and visualize data

🐍 Python

Pandas, NumPy, Matplotlib, Seaborn, Streamlit — Data cleaning, statistical analysis, visualization, small app deployment

Pandas NumPy Matplotlib Seaborn Streamlit

🗄️ SQL

MySQL, PostgreSQL — Complex queries, JOINs, CTEs, window functions, query optimization

MySQL PostgreSQL CTEs Window Functions

📈 Power BI

DAX, data modeling, KPI tracking, interactive dashboards, drill-through — Executive-ready visualizations

DAX Data Modeling KPIs Drill-through

📊 Excel

Power Query, Pivot Tables, XLOOKUP, data cleaning, automated dashboards

Power Query Pivot Tables XLOOKUP

☁️ APIs & ETL

REST APIs, JSON extraction, Python-based data pipeline automation

REST APIs JSON ETL Pipelines

📋 Core Analyst Skills

EDA, data validation, business problem framing, stakeholder communication — Focus: Actionable outcomes

EDA Data Validation Business Framing

03 — Projects

Real-World Projects Demonstrating
End-to-End Data Analysis

Each project solves a specific business problem with measurable outcomes

Automated ETL Pipeline for YouTube Analytics

YouTube API Python (ETL) MongoDB (Raw) SQL (Structured) Streamlit

YouTube Data Warehouse

❓ Business Problem

Content creators lack a centralized system to track and analyze performance across multiple data sources.

🔧 Solution

Extracted data using YouTube Data API with Python
Designed normalized SQL database schema
Built automated ETL pipeline for scheduled data updates
Developed Power BI dashboard with KPI tracking and trend analysis

📊 Impact

Centralized fragmented data into a single source of truth
Enabled consistent performance tracking across videos and time
Reduced manual data collection effort through automation

View Code → Live Demo ↗

Live App

MongoDB Python Pandas EDA Plotly Streamlit Power BI

Airbnb Pricing Analytics Dashboard

❓ Business Problem

Hosts struggle to determine optimal pricing due to multiple influencing factors.

🔧 Solution

Cleaned and analyzed Airbnb dataset using Pandas
Identified pricing drivers using correlation and segmentation
Built interactive Streamlit app with dynamic filters
Visualized seasonal trends and location-based pricing patterns

📊 Impact

Highlighted key factors influencing listing prices
Enabled users to explore pricing strategies interactively
Transformed static analysis into a usable decision-making tool

View Code → Live App ↗

Geospatial Analytics

Python GeoJSON Plotly Streamlit

PhonePe Transaction Analytics

❓ Business Problem

Understanding regional digital payment adoption patterns across India.

🔧 Solution

Processed large-scale transaction datasets using Python
Integrated GeoJSON data for geospatial mapping
Built choropleth maps and time-series visualizations
Analyzed trends across states and time periods

📊 Impact

Identified regional variations in digital payment usage
Revealed growth trends across different states
Simplified complex datasets into intuitive visual insights

View Code → Live Demo ↗

OCR Automation

Python EasyOCR MySQL Streamlit

BizCard OCR System

❓ Business Problem

Businesses need to eliminate manual data entry from business cards and maintain a searchable contact database.

🔧 Solution

Built OCR pipeline using EasyOCR to extract text from images
Used regex to parse structured contact data from raw text
Designed MySQL database with CRUD operations
Created Streamlit interface for upload, edit, and delete

📊 Impact

Eliminated manual business card data entry
Created searchable, structured contact database
Reduced data entry errors through automation

View Code → Live Demo ↗

04 — Professional Development

Professional Development & Readiness

Building expertise through structured learning and applied practice

✓ Foundation: Python & SQL

Built analytical solutions using Pandas, NumPy, and SQL. Applied in EDA, data cleaning, and structured database design.

✓ Certification: GUVI × HCL

Completed Data Analytics certification covering SQL, Python, data visualization, and business intelligence concepts.

✓ 4 End-to-End Projects

Delivered ETL pipelines, interactive dashboards, geospatial analysis, and automation workflows — all documented and reproducible.

→ Method: Build-First Approach

Every skill validated through real datasets, business problem framing, and deployed solutions.

Data Analyst — SQL · Python · Power BI
Building Dashboards & Pipelines That Drive Decisions

Turning Raw Data into Business Insights

Core Tools & Technical Skills