Data Analyst — Bengaluru, India

Turning raw data
into decisions that
hold up.

I'm Rishav Kumar Singh. I build SQL pipelines, Power BI dashboards, and clean datasets that teams can actually trust — currently focused on operational and financial analytics.

View projects ↓ Contact details ↓
Rishav Kumar Singh
● Rishav Kumar Singh  ·  Bengaluru, IN
live_dashboard.pbix● refreshed
18%
REVENUE EFFICIENCY GAIN
40%
FASTER DASHBOARD REFRESH
15%
PATIENT RETENTION LIFT
12%
CHURN RATE IDENTIFIED
01 / Experience
May 2026 – Present
current
Data Analyst Intern
at Billions United, Bengaluru
  • Managed large-scale salaried employee, mart, and vehicle databases used for marketing and lead-generation campaigns.
  • Developed and optimized SQL queries for extraction, transformation, and validation across datasets from 100K to 1M+ rows.
  • Built multi-stage data deduplication pipelines using business-defined rules, reducing duplicate records.
  • Cleaned and standardized salary, experience, DOB, and customer data across heterogeneous sources.
  • Imported and integrated high-volume data into MySQL databases to support downstream analytics and campaigns.
Aug 2025 – Apr 2026
Data Analyst Intern
at Analytixlabs, Bengaluru
  • Built Customer360, Order360, and Product360 models integrating transactional datasets.
  • Ran exploratory data analysis to surface revenue drivers, customer segmentation, and delivery-delay impact.
  • Evaluated AOV, repeat purchase behavior, churn risk, and operational performance metrics.
  • Developed KPI-driven Power BI dashboards and KPI–KRA–KRI monitoring frameworks.
02 / Projects
healthcare-clinical-retention-analytics2026
Healthcare Clinical Retention Analytics Power BI dashboard
Healthcare Clinical Retention Analytics
Advanced SQL with window functions (LEAD, LAG, RANK) to track patient visit intervals, identifying a 12% churn rate in chronic care. Built a Power BI dashboard with DAX measures for revenue, patient-to-doctor ratio, and ICU utilization — improved refresh rate by 40% and patient retention by 15%.
SQL Window FunctionsPower BI / DAXHealthcare
View Project →
rapido-dead-mileage-revenue2026
Rapido Dead Mileage and Revenue Optimization Power BI dashboard
Rapido — Dead Mileage & Revenue Optimization
Power BI dashboard with time-intelligence DAX measures tracking average fare (₹129.97) and ride status trends. Used DENSE_RANK, LEAD/LAG, and CTEs to identify "stress hours" vs "golden hours," pinpointing dead-mileage zones and improving revenue efficiency by 18%.
SQL / CTEsPower BIMobility analytics
View Project →
03 / Skills
Languages & Tools
Python (Pandas, NumPy), SQL, Excel, Excel VBA (Macros)
Visualization
Power BI, Excel, Matplotlib, Seaborn
Databases
MySQL, MS SQL Server
Core Competencies
ETL, Query Optimization, Data Modeling, Data Cleaning & Transformation, EDA, KPI Reporting, Business Intelligence
04 / Education
May 2022 – Jun 2025
Bachelor of Computer Application (BCA)
Aryabhatta Knowledge University
7.88 CGPA
Expected Aug 2026
Advanced Certification in Data Science & AI
IIT Guwahati
in progress