piyush_dave = {
"role" : "Data Analyst",
"location" : "Amravati, Maharashtra, India",
"experience" : "Virtual Internship @ AI Variant (ExcelR)",
"status" : "Open to full-time Data Analyst opportunities",
"tools" : ["SQL", "Power BI", "Tableau", "Excel", "Python"],
"strengths" : ["EDA", "Dashboard Design", "SQL Optimization",
"Data Cleaning", "Business Insights"],
"fun_fact" : "I collected real AQI data from India's CPCB govt website
for my Amravati air quality project — not from Kaggle!"
}
|
Complete EDA on 18 seasons of IPL cricket — 1,169 matches, 2,78,205 deliveries, 44+ charts, 156 notebook cells with zero errors
|
Original data collected from India's official CPCB government website — Python cleaning → Power BI dashboard. 366 days, Avg AQI 85.86, Q3 monsoon best at 38.95
|
|
Advanced SQL analysis on 1,97,430 orders across 28 cities — 2 views, 2 stored procedures, window functions, REGEXP, CASE WHEN
|
7-page branded Power BI dashboard — 5,000 orders, 5 branches, 17 products, custom PowerPoint background. Iced Latte top product, Banjara Hills top branch, dynamic Quick Analysis page.
|
| SQL Projects | Adventure Works · Hospitality · HR Attrition · Zomato · Bank Loan · Swiggy |
| Power BI Dashboards | Adventure Works · Hospitality · HR Attrition · Blinkit · India Sales · AQI · Coffee Shop Analysis |
| Tableau Dashboards | Adventure Works · Hospitality · HR Attrition · Zomato · BMW Sales Analytics |
| Python Projects | IPL 18-Season EDA · Amravati AQI Cleaning |
| Excel Dashboards | Adventure Works · Hospitality · HR Attrition · Blinkit |
13 Projects | 15+ Dashboards | 150+ SQL Queries | 44+ Python Charts
2,78,205 IPL deliveries analyzed | 1,97,430 Swiggy orders analyzed
Real AQI data from CPCB Government Website | 0 errors in IPL notebook
I am actively looking for full-time Data Analyst opportunities. If you are hiring or know someone who is, I would love to connect!
Open to full-time Data Analyst roles — Amravati, Maharashtra or Remote