Dipak Pawar

Data Analyst/Power BI Developer

Pune, Maharashtra-India 0+ yrs exp 86 · Excellent

About

Data Analyst with expertise in SQL, Power BI (including Power BI Service), Excel, Python, and Gen AI, skilled in Data Cleaning, Data Modeling, and Dashboarding. Experienced in designing DAX-driven KPIs, KPI Tracking, and Business Intelligence (BI) solutions using Power query to transform raw data into actionable insights. Strong in Storytelling with Data, Problem-Solving, and Communication Skills to support data-driven decision making.

Skills & Expertise (23)

Power BI Advanced

6.5/10

0.5

Years Exp

Data Modeling Advanced

6.0/10

0.5

Years Exp

Data Visualization Advanced

6.0/10

0.5

Years Exp

DAX Intermediate

5.5/10

0.5

Years Exp

Data Transformation Intermediate

5.5/10

0.5

Years Exp

ETL Intermediate

5.5/10

0.5

Years Exp

Power Query Intermediate

5.5/10

0.5

Years Exp

Data Cleaning Intermediate

5.5/10

0.5

Years Exp

Data Analysis Intermediate

5.5/10

0.5

Years Exp

Power BI Service Intermediate

5.5/10

0.5

Years Exp

SQL Intermediate

5.5/10

0.5

Years Exp

Advanced Excel Intermediate

5.0/10

0.5

Years Exp

Excel Intermediate

5.0/10

0.5

Years Exp

KPI Tracking Intermediate

5.0/10

0.5

Years Exp

Reporting Intermediate

5.0/10

0.5

Years Exp

Problem-solving Intermediate

5.0/10

0.5

Years Exp

Communication Skills Intermediate

5.0/10

0.5

Years Exp

SQL Server Intermediate

4.5/10

0.5

Years Exp

MySql Intermediate

4.5/10

0.5

Years Exp

Google Sheets Intermediate

4.0/10

0.5

Years Exp

Storytelling with Data Intermediate

4.0/10

0.5

Years Exp

Python Beginner

3.5/10

0.5

Years Exp

Gen AI Beginner

2.5/10

0.5

Years Exp

Work Experience

Data Analyst Intern

AI Variant

Mar 2025 - Sep 2025

BANK DEBIT AND CREDIT ANALYSIS | Power BI Desktop, Power Query (ETL), DAX, Data Modeling, Data Visualization. Cleaned and transformed 1 Lakh customer records using Power Query (ETL) and advanced Data Cleaning techniques, ensuring accurate and consistent data for analysis. Designed and implemented Power BI Dashboards & Reports with DAX-based KPIs (Credit-Debit Ratio, Net Trn Amount), enhancing Business Intelligence and decision-making. Built advanced Data Modeling using STAR schema, optimizing relationships and improving query performance in Power BI Desktop. Applied Row-Level Security (RLS), Bookmarks, and Tooltips to improve user experience, delivering secure and interactive Data Visualization. Optimized Power BI performance, reducing dashboard load time and increasing reporting efficiency by 20%. Generated actionable insights from customer Debit-Credit analysis using Power BI dashboards and DAX-based KPIs. HR ANALYTICS | SQL, Excel, Power BI, Data Cleaning, Data Visualization. Processed and analyzed 50K+ Employee records using SQL (CTEs, Window Functions, Aggregates) and Excel, ensuring accurate data exploration. Performed advanced Data Cleaning and normalization, improving overall Data Quality by 16%. Designed and developed HR Analytics dashboards in Power BI to visualize attrition rate, employee lifecycle metrics, and workforce distribution across departments and roles. Derived key HR insights from attrition analysis, identifying 50.21% attrition and 49.79% active employee distribution to support strategic HR decision-making and workforce optimization. Streamlined SQL queries using Joins and Aggregations, enabling faster reporting and better data accuracy.