Apoorva vilas Dodwad – Data Analyst with hands-on experience in SQL, Excel, Python, and Power

About Me

Data Analyst with hands-on experience in SQL, Excel, Python, and Power BI, delivering business-focused analysis, KPI reporting, and interactive dashboards. Experienced in sales, churn, and operations analytics with a str…

Experience

Sales Analysis Dashboard

Blinkit

Analyzed 10,000+ transactions to track sales KPIs, product performance, and outlet trends.
Used SQL queries and Python EDA to identify revenue drivers and growth patterns.
Built Power BI dashboards and Excel MIS reports, reducing manual reporting by 30%.

Customer Churn Analysis & Prediction

Analyzed 64,000+ customer records to identify churn drivers contributing to 65% of churn.
Designed KPI dashboards in Power BI to monitor churn risk and customer segments.
Built Logistic Regression model achieving 82% accuracy to support retention strategies.

Employee Attrition Analysis

Analyzed 18,000+ employee records to identify key attrition factors.
Improved minority-class recall by 18% using SMOTE and feature engineering.

Skills

Excel MySQL Python Structured Query Language (SQL) Dashboards GitHub Logistic Regression NumPy Time Management Analytical Thinking Machine Learning Power BI Tableau Joins Subqueries Window Functions Aggregations Pivot Tables XLOOKUP IF COUNTIFS MIS Reporting BI & Visualization KPIs Matplotlib Pandas Exploratory Data Analysis Databases & Tools Jupyter Notebook VS Code Random Forest Clustering Smote Business Understanding Clear Communication Attention to Detail Cross-Functional Collaboration SMOTE