Shilpi Pandit

Data Analyst | Business Analyst

Pune, Maharashtra 0+ yrs exp 81 · Excellent

About

Detail-oriented Data Analyst and Business Analyst, currently pursuing MCA, with hands-on experience in data cleaning, analysis, visualization, dashboard development, and KPI reporting. Proficient in Power BI, SQL, Excel, and Python, with knowledge of Power Query, DAX, data modeling, EDA, and business insights.

Skills & Expertise (59)

Power BI Advanced

8.0/10

0.3

Years Exp

SQL Queries Intermediate

7.5/10

0.3

Years Exp

Data Visualization Intermediate

7.5/10

0.3

Years Exp

Python for Data Analysis Intermediate

7.0/10

0.3

Years Exp

Advanced Excel Intermediate

7.0/10

0.3

Years Exp

Ifs Excel Reporting Data Validation Conditional Formatting Countifs SUMIFS NumPy If Index-match HLOOKUP VLOOKUP XLOOKUP Pandas Data Cleaning Matplotlib Seaborn Plotly Exploratory data analysis Data Transformation Statistical Analysis KPI Analysis Trend Analysis Comparative Analysis Business Reporting Data Interpretation Insight Generation Business Intelligence WHERE Power Query Data Modeling DAX Measures Calculated Columns KPI Dashboards Slicers Filters Drill-through Bookmarks RLS Power BI Service Select Pivot Charts GROUP BY ORDER BY Aggregate Functions HAVING CASE Statements Joins Subqueries CTEs Window Functions Data Extraction Data Analysis Pivot Tables

Work Experience

Data Analyst Intern

Bharat Software Solutions

Jul 2026 - Oct 2026

Analyzed business data using SQL, Excel, and Power BI for reporting, KPI tracking, and business insights. Performed data cleaning, transformation, validation, and EDA using Python, Pandas, and NumPy to improve data quality. Developed interactive Power BI dashboards, KPI reports, data visualizations to monitor business performance and trends. Created SQL queries using Joins, Aggregate Functions, Subqueries, CTEs, and Window Functions for data extraction and analysis.