I'm Akash Suvarnkar, a data analyst who transforms messy datasets into clear, compelling stories that help teams move faster and smarter.
Projects
Certifications
I'm Akash Suvarnkar, a B.E. Computer Engineering student at PGMCOE, Pune (Expected 2026), with a strong focus on data analytics and business intelligence. I discovered my passion for data when I realised that numbers, when properly analysed, tell the most honest stories about how the world works.
I've worked on projects ranging from customer segmentation of 1M+ e-commerce records and India's decade-long trade data to statistical sales dashboards — blending SQL, Python, and Power BI to extract insights that drive real decisions.
Outside of projects I'm always exploring new datasets, sharpening my SQL and Python skills, and building end-to-end analytics pipelines from raw data to executive-ready dashboards.
End-to-end analytics projects — from raw data to actionable insight.
Segmented 5,360 customers from a 1M+ row UK e-commerce dataset using RFM methodology in PostgreSQL. Used window functions (NTILE) and CTEs to score customers 1–5, identifying Champions (24%) with avg spend of ~£9,000.
View Details →
Identified revenue drivers through high-value transaction analysis. Built a Power BI dashboard with KPI metrics (avg sales ≈ 4,136; 95% CI: 3,781–4,491) to support data-driven decisions.
View Details →
Dynamic P&L Excel dashboard on 9,994 Kaggle Superstore rows — SUMIF income statement, YoY analysis, PivotTables, and Business 360-style navigation dashboard.
View Details →
Processed 10+ years of trade data across 50+ commodities. Improved query speed by 25% and identified key partner countries driving India's trade performance.
View Details →Where I publish and share projects, dashboards, and notebooks.
Certifications and milestones that have shaped my analytical skill set.
Demonstrated proficiency in complex SQL queries, joins, subqueries, and window functions through a hands-on timed assessment on the HackerRank platform.
View Certificate →Completed Kaggle Pandas course — worked with Series and DataFrames, data cleaning, filtering, grouping, and real-world dataset analysis.
View Certificate →Have a project idea or opportunity? I'd love to hear from you.
Whether you need a freelance analyst, want to collaborate on a dataset, or are curious about my work — drop a message and I'll get back within 24 hours.