Dhanashree Jagdale

Certified Data Analyst

Pune, IndiaHealthcare
1roles
23skills
3education
1credentials

About

Certified Data Analyst skilled in SQL, Python, Power BI, Tableau, and Advanced Excel, with four end-to-end analytics projects covering dashboarding, KPI tracking, data cleaning, and trend analysis.

Experience

Front Office Executive

Asian Heart Institute

Aug 2024 – Nov 2024 · BKC, Mumbai

Served as primary point of contact for 1,000+ patient admissions, handling daily cash transactions and billing with full accuracy. Coordinated across departments to resolve inquiries and streamline operations, building communication and cross-functional coordination skills in a fast-paced, data-driven environment.

Education

IMED, Bharati Vidyapeeth, Pune

Bachelor of Business Administration, IB

2021 – 2024

Score: 88.3%

Sinhagad College of Arts, Science and Commerce, Pune

HSC

2019 – 2021

Score: 91%

Lokmanya Vidya Mandir High School, Mumbai

SSC

2019

Score: 84%

Skills

PythonPandasNumPySQLJoinsSubqueriesCTEsWindow FunctionsPower BITableauAdvanced ExcelPivot TablesVLOOKUPXLOOKUPINDEX-MATCHChartsDashboardsData CleaningMIS ReportingKPI TrackingTrend AnalysisData VisualizationPower Query

Projects

Shark Tank India Dashboard

Built an interactive Power BI dashboard analyzing 200+ startup pitches, surfacing funding trends, investor behaviour, and deal-conversion patterns across sectors. Used Power Query to clean and reshape raw data, then designed KPI cards, slicers, and drill-down visuals for filtering by industry, investor, and deal outcome.

Streaming Platform Analysis

Wrote SQL queries using joins, subqueries, CTEs, and window functions to analyze content performance and user viewing trends across a multi-table dataset. Identified top-performing content categories by viewership and engagement and delivered content strategy recommendations.

Employee Data Analysis

Cleaned and analyzed an HR dataset with Python and Pandas to surface salary trends, department-wise distribution, and experience-band patterns. Presented pay-gap and headcount findings across departments and experience bands for further HR review.

E-Commerce Performance Analysis

Analyzed sales data with Excel Pivot Tables and charts, building an Excel dashboard to track sales, profit margin, and trend KPIs. Flagged top-performing product categories and seasonal demand patterns to support inventory and pricing decisions.