Hi, I'm Devansh Bhargava
Senior Data Analyst | Turning Data into Actionable Insights
Specializing in Power BI, SQL, Snowflake & Predictive Analytics
Senior Data Analyst | Turning Data into Actionable Insights
Specializing in Power BI, SQL, Snowflake & Predictive Analytics
Building robust analytics solutions with industry-leading tools
Expert in data modeling, ETL pipelines, and database optimization for large-scale analytics.
Creating impactful, interactive dashboards that drive executive decision-making.
Developing machine learning models for forecasting, segmentation, and propensity scoring.
Campaign performance analysis, attribution modeling, and ROI optimization.
Designing and analyzing controlled experiments to optimize conversions, user experience, and business outcomes.
A track record of delivering impactful data solutions
Leading analytics for Americas Marketing team, building predictive models and dashboards that power strategic decisions. Developed churn analysis frameworks, A/B testing methodologies for campaign optimization, and opportunity funnel tools resulting in improved forecasting accuracy.
Oversaw delivery of consolidated acquisition, churn, retention, and revenue dashboards in Looker and Power BI. Built Databricks ETL pipelines using SQL, Python, and Delta Lake. Developed Kafka-driven data models and alerting mechanisms for real-time KPI monitoring and anomaly detection.
Improved Looker dashboard stability and SQL query performance, increasing sales reporting accuracy. Conducted user acceptance testing on sales and distribution datasets, identifying reporting gaps and recommending data model enhancements.
Real-world dashboards driving business decisions
Comprehensive marketing funnel analysis tracking MQLs, SQLs, Opportunities, and Wins by region and campaign type. Features conversion rate metrics and estimated revenue impact for executive reporting.
Customer retention intelligence showing churn rates by quarter using SG2 and FPAA data. Highlights retention patterns and loss trends across respiratory product segments for proactive intervention.
Predictive scoring model identifying high-value account targets. Features opportunity scoring by test type (RESP, MVP, CTNG) and sales territory filters for targeted outreach strategy.
End-to-end experimentation platform for marketing campaigns. Designed statistical frameworks to measure conversion lift, calculated sample sizes, and automated significance testing to optimize email, landing page, and pricing experiments.
Interactive Tableau visualizations for media & subscription analytics
Subscriber churn analysis dashboard built in Tableau, tracking cancellation trends, churn drivers, and retention metrics to support data-driven strategies for reducing customer attrition.
User engagement analytics dashboard visualizing content interaction patterns, session metrics, and audience behavior to inform editorial and marketing strategies.
In-depth explorations leveraging data to address real-world challenges
An investigation into America's healthcare emergency preparedness infrastructure. The US has over 2,500 local health departments responsible for critical services—from food safety inspections at restaurants to emergency response during natural disasters like hurricanes. This project analyzed the readiness and interconnectedness of the healthcare system to handle emergencies at local, state, and national levels, identifying gaps and opportunities for improvement.
A comprehensive transit analytics project for the Chicago Transit Authority, divided into two major components. The first involved GTFS mapping using public and internal train data files. The second focused on analytics, including predictive modeling for bus bunching to improve service reliability. The project demonstrated practical applications of data science in urban transportation systems.
Continuous learning in data science and analytics
Professional Certificate Program
Business Analytics Focus
Interested in discussing data analytics opportunities? I'd love to hear from you.