Microsoft Learn — Power BI Data Analyst Associate | HackerRank SQL Advanced | Deloitte Australia Data Analytics Virtual Experience
- 🎯 Fresher Data Analyst & MIS Executive with hands-on, end-to-end BI project experience
- 📊 Built a multi-page Power BI KPI Dashboard tracking 8 KPIs across 5,000+ retail records
- 🗄️ Performed SQL-driven analysis on 50,000+ transaction rows using CTEs, Window Functions & Joins
- 🐍 Python EDA using Pandas, NumPy & Matplotlib — uncovered a 35% Q4 revenue spike
- 🏢 Completed Deloitte Australia Data Analytics Virtual Experience (Forage)
- 📍 Open to relocation — Gurgaon / Delhi NCR / Noida / Bengaluru
- 📫 Reach me at anmolraj530@gmail.com
📊 BI & Visualization
🗄️ SQL & Databases
📁 Excel & Reporting
🐍 Python & Analytics
⚙️ Tools
Power BI • DAX • Power Query • SQL • Star Schema
- Built multi-page Power BI dashboard tracking 8 KPIs across 5,000+ retail records
- Engineered 15+ DAX measures for dynamic KPI calculations
- Applied star-schema data modeling for sub-second query performance
- Resolved ~8% null values via Power Query ETL
- ✅ Outcome: Reduced manual reporting time by ~3 hours/week
SQL • Python • Pandas • EDA • NumPy • Matplotlib
- Queried 50,000+ transaction rows using CTEs, Window Functions & multi-table Joins
- Identified top 3 product categories driving 60%+ of total revenue
- Python EDA revealed a 35% Q4 revenue spike
- ✅ Outcome: Delivered report with 4 prioritised business recommendations
SQL • Advanced Excel • Tableau • MIS Reporting
- Building end-to-end KPI tracker — resolution time, CSAT, first response time & ticket volume by shift
- Workflow: SQL extraction → Excel pivot analysis → Tableau visualization
- ✅ Goal: Surface operational efficiency gaps for business stakeholders
| Certification | Issuer | Status |
|---|---|---|
| Power BI Data Analyst Associate | Microsoft Learn | ✅ Completed — June 2026 |
| SQL (Advanced) | HackerRank | ✅ Completed |
📍 Open to relocation — Gurgaon / Delhi NCR / Noida / Bengaluru | Available Immediately