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

نبذة عني

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…

الخبرة

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.

المهارات

إكسل ماي إس كيو إل بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) لوحات المعلومات منصة GitHub للتعاون على تطوير البرمجيات الانحدار اللوجستي نومباي (مكتبة لغة Python) إدارة الوقت التفكير التحليلي تعلم الآلة باور بي آي تابلو 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