Back to Developers
Yashodeep Dhepe

Yashodeep Dhepe

Data Analyst | Power BI Developer

Pune, India
80
Profile Score

About

Data Analyst with 3+ years of experience in Business Intelligence, Data Modeling, ETL, SQL, and Power BI dashboard development. Expertise in building end-to-end BI solutions, optimizing DAX performance, implementing Row-Level Security (RLS), and delivering data-driven insights to stakeholders. Strong background in KPI development, data validation, forecasting, and business analytics.

Skills & Expertise (20)

Power BI Advanced
8.3/10
3
Years Exp
DAX Advanced
8.1/10
3
Years Exp
SQL Advanced
7.9/10
3
Years Exp
Trend Analysis Descriptive Statistics Statistics NumPy Pandas Python Lookups Pivot Tables Excel Data Validation Subqueries Aggregations Joins MySql Reporting Interactive Dashboards KPIs

Work Experience

Research Analyst

The Research Insights

Oct 2022 - Oct 2025

Led end-to-end BI solution development from SQL data integration to Power BI Service deployment. Designed scalable star schema model and developed 15+ optimized DAX measures for operational KPIs. Improved report performance by 50% through advanced DAX optimization and model restructuring. Implemented Row-Level Security (RLS) and automated scheduled refresh via On-Premises Gateway. Conducted SQL-based data reconciliation ensuring 100% KPI accuracy. Enabled dynamic KPI selection using Field Parameters and enhanced UX with bookmarks & drill-through reports.

Research Analyst

The Research Insights

Jul 2023 - Jun 2024

Sales, Pricing & Customer Analytics: Analyzed sales velocity and sell-through data based on business requirements and KPIs across 500+ European retail outlets to identify a 15% whitespace opportunity, supporting commercial decisions that drove 120K+ unit sales in Q1, and designed a customer purchase funnel to track cohort retention, identifying a 65% repeat purchase rate and validating product-market fit. BI Reporting & Stakeholder Enablement: Built a SQL-driven Power BI dashboard (POC → UAT) to track real-time sales, regional performance, and stock availability, performing data validation, reconciliation, and QA checks during UAT, enabling inventory reallocation and reducing stock-outs by ~20%.

Education

MBA – Marketing & Business Analytics - Dr. D.Y. Patil Institute of Technology

2021 - 2023 · Afghanistan

Bachelor of Pharmacy - Sinhgad College of Pharmacy

- 2021 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Availability Details

Relocation

Open to Relocation

Skills (20)

Power BI DAX SQL Trend Analysis Descriptive Statistics Statistics NumPy Pandas Python Lookups +10 more