Mahad Khan

I’m a Data Analyst with hands-on experience building end-to-end pipelines across crypto markets, e-commerce, and retail operations. I deliver analytics that move from raw data to clear, decision-ready dashboards—fast, reliable, and production-minded.

I’ve completed 5+ projects spanning API data collection, SQL analysis, and interactive Power BI reporting. In Market Basket Analysis, I cleaned 541,909 real transactions, mapped 3,877 products into 8 categories, mined 56 FP-Growth association rules, and delivered a Power BI dashboard with actionable business recommendations.

In Crypto Market Analysis, I built a full pipeline from CoinGecko API to pandas, MySQL, and Power BI to track 100+ coins. I engineered volatility metrics (ATH/ATL distance and price momentum) and created a 5-panel dashboard covering market cap, volume, gainers, and volatility for portfolio risk monitoring.

I also focus on data quality and robust transformation. In my Retail Data Cleaning Pipeline, I produced a production-ready workflow that resulted in zero missing values and reconstructed 609 missing price values using logic-based imputation, with a mathematical audit confirming 0.0 variance across records. Alongside analytics, I’ve strengthened my front-end and dashboard delivery skills through web development experience (HTML/CSS/JavaScript, React, WordPress), so my work is both insightful and easy to use.