I am a data-driven professional with experience in creating MIS reports, dashboards, and performing payment reconciliation. I convert raw data into meaningful insights to support business decisions.
- 📊 Excel (Advanced, Pivot, Formulas, Automation)
- 📈 Power BI (Dashboard & DAX)
- 📉 Google Sheets (QUERY, IMPORTRANGE)
- 📊 Looker Studio (Interactive Dashboards)
- 🛒 E-commerce MIS (Myntra, IndiaMART)
This dashboard analyzes candidate data collected through Google Forms and provides insights into hiring performance.
- Google Forms (Candidate Entry)
- Google Sheets (Auto Data Collection)
- Vacancy vs Hiring Tracking
- Candidate Interview Analysis
- Gender & Qualification Distribution
- Experience Analysis
- Position-wise Applications
This dashboard tracks sales performance, revenue trends, and KPIs.
- Daily & Monthly Sales
- KPI Tracking
- Region-wise Performance
- Product Analysis
This dashboard monitors purchase activity and vendor performance.
- Purchase Trends
- Vendor Analysis
- Cost Tracking
- Order Summary
This dashboard tracks employee leave data and attendance patterns.
- Leave Tracking
- Employee Attendance
- Monthly Reports
- Department-wise Analysis
- Built using real business use cases
- Automated reporting systems
- Interactive dashboards for decision-making
- 👤 Name: Ashish Ranjan
- 📧 Email: ashishranjan11211@gmail.com
- 🔗 LinkedIn: https://linkedin.com/in/ashishranjanji09
- 🌐 Website: https://ranjanstudy.blogspot.com
⭐ Always learning and improving in Data Analytics