Featured Project
SQL
Data Processing
ETL
Comprehensive data cleaning pipeline for housing data using SQL Window Functions, CTEs, and Advanced Joins.
Transformed messy real-world data into analysis-ready datasets.
Key Features:
- Removed duplicates using ROW_NUMBER()
- Standardized inconsistent fields and formats
- Handled NULL values with smart defaults
- Documented entire ETL process
SQL Analysis
Healthcare Data
Exploratory data analysis of global COVID-19 dataset using SQL Server. Uncovered infection trends, recovery rates, and regional impacts.
JOINS
CTEs
Aggregations
Trend Analysis
Tableau
Data Visualization
Interactive Tableau dashboard analyzing Airbnb market trends, pricing strategies, and occupancy rates with drill-down capabilities.
Interactive Viz
Business Insights
Dashboard Design
Power BI
DAX
KPI Tracking
Collection of Power BI dashboards for sales performance, inventory management, and operational KPIs with advanced DAX calculations.
Data Modeling
DAX Formulas
Report Publishing
Expertise
Tools & Technologies
Core Technologies
SQL Expert
Python (Pandas)
Power BI
Tableau
Excel Advanced
Specializations
- Data Cleaning & Preparation
- Dashboard Development
- Automated Reporting
- Workflow Optimization