I am a Data Analyst with hands-on experience through a virtual internship at AI Variant (ExcelR) and multiple self-made projects covering the complete data analytics stack.
- Completed virtual internship at AI Variant through ExcelR's Data Analyst program
- Currently seeking a full-time Data Analyst role
- Passionate about turning raw data into business insights through analysis and visualization
- Based in Amravati, Maharashtra, India
| Category | Tools & Technologies |
|---|---|
| Database | MySQL · SQL Queries · Views · Stored Procedures · Window Functions |
| Visualization | Power BI · Tableau Public · Matplotlib · Seaborn |
| Spreadsheet | Microsoft Excel · Pivot Tables · Pivot Charts · Dashboards |
| Programming | Python · Pandas · NumPy · Matplotlib · Seaborn |
| Concepts | EDA · Data Cleaning · Data Modeling · KPI Design · DAX · Star Schema |
| # | Project | Tools | Description |
|---|---|---|---|
| 01 | Adventure Works Analysis | SQL · Power BI · Tableau · Excel | End-to-end sales analysis of a global bicycle company — $29.4M sales, 60K orders, 2010–2014 |
| 02 | Hospitality Analysis | SQL · Power BI · Tableau · Excel | Hotel booking & revenue analysis for Atliq Hotels — ₹1.71bn revenue, 135K bookings, Apr–Jul 2022 |
| 03 | HR Attrition Analysis | SQL · Power BI · Tableau · Excel | Employee attrition analysis across 50,000 employees — 50.21% attrition rate, 6 departments |
| # | Project | Tools | Description |
|---|---|---|---|
| 04 | Zomato Sales & Rating Analysis | SQL · Tableau | Restaurant analysis across 9,551 restaurants, 15 countries, 141 cities — advanced stored procedures & window functions |
| 05 | Blinkit Sales Dashboard | Excel · Power BI | 5-page executive dashboard — $1.20M sales, 16 item types, decomposition tree analysis |
| # | Project | Tools | Description |
|---|---|---|---|
| 06 | IPL 18-Season Analysis | Python · Pandas · Matplotlib · Seaborn | Complete EDA on 1,169 matches & 2,78,205 deliveries — 44+ charts, 156 cells, zero errors |
| 07 | Bank Loan Analysis | SQL | Financial risk analysis — MASTER_SP returning 4 result tables, StateRanking VIEW with DENSE_RANK |
| 08 | Amravati AQI 2024 | Python · Power BI | Original data from CPCB govt website — Python cleaning → Power BI dashboard — 366 days, avg AQI 85.86 |
| 09 | Swiggy Food Analysis | SQL | 1,97,430 orders, 28 cities — 2 views, 2 stored procedures, window functions, REGEXP |
| 10 | India Sales Dashboard | Power BI | 5-page manager/region/category dashboard — ₹589.65K sales, 3 managers, decomposition tree |
| 11 | Practice Dashboards | Tableau · Power BI | Superstore USA + Finance Dataset — practice dashboards for skill building |
| 12 | Brew Metric Coffee Shop Analysis | Power BI · PowerPoint | 7-page branded dashboard — 5,000 orders, 5 branches, 17 products, Custom PPT background |
| 13 | BMW Sales Analytics | Tableau · PowerPoint | 7-page premium Tableau dashboard — 6 BMW models, 4 regions, $117.28M revenue, 28.03% profit margin, custom PowerPoint background |
| Metric | Value |
|---|---|
| Total Projects | 13 |
| Tools Mastered | SQL · Power BI · Tableau · Excel · Python · PowerPoint |
| Total Dashboards Built | 20+ |
| Total SQL Queries Written | 150+ |
| Python Charts Created | 44+ |
| Largest Dataset Analyzed | 2,78,205 IPL deliveries |
| Original Data Collection | Amravati AQI from CPCB Govt Website |
| Custom Dashboard Design | Brew Metric + BMW — custom PPT backgrounds |
18 seasons · 1,169 matches · 2,78,205 deliveries · 44+ charts · 156 notebook cells · 0 errors
Data personally collected from India's official CPCB government website — not from Kaggle or any third-party source
1,97,430 orders · 2 stored procedures · 2 views · window functions · REGEXP
MASTER_SP returning 4 result tables in 1 CALL · StateRanking VIEW with DENSE_RANK · 25+ queries
| Platform | Link |
|---|---|
| linkedin.com/in/piyush-dave-0980a03a8 | |
| Tableau Public | public.tableau.com/app/profile/piyushdave |
| GitHub | github.com/PiyushDave30 |
"Data is not just numbers — it's the story of every business decision waiting to be told."
⭐ If you find this portfolio helpful, consider giving it a star!