Pallavi Avhale

MBA (Business Analytics) candidate and Data Analytics Intern with hands-on experience in Python, SQL, Power BI, DAX, Excel, Tableau, Pandas, and NumPy. Experienced in data cleaning, data transformation, ETL, EDA, statistical analysis, data modeling, KPI reporting, dashboard development, and business intelligence. Skilled in analyzing customer, transaction, survey, and business data to identify trends, patterns, churn drivers, customer segments, and performance indicators and generate actionable insights for data-driven decision-making.

Data Analytics Intern at Test Yantra Software Solutions Pvt. Ltd. (2026-01 – 2026-03)

• Cleaned, transformed, and analyzed business datasets using Python, Pandas, SQL, and Excel, handling missing values, duplicates, and data inconsistencies.
• Developed interactive Power BI dashboards using DAX measures, KPI cards, filters, slicers, and visualizations to monitor business performance.
• Wrote SQL queries using JOINs, aggregations, GROUP BY, filtering, and subqueries to extract and summarize data for reporting and analysis.
• Applied data preparation, EDA, data modeling, visualization, and reporting workflows to support business analysis and decision-making.
• Identified trends, patterns, and performance indicators through data analysis and dashboard visualization.

Master of Business Administration in Business Analytics – Savitribai Phule Pune University, Pune (2024 – 2026)

Bachelor of Pharmacy – Dr. Babasaheb Ambedkar Technological University (DBATU), Aurangabad (2023)