Summary
Overview
Work History
Education
Skills
Additional Information
Certification
Timeline
Generic

Harshal Badhekar

Power Bi Developer
Pune

Summary

Results-driven Business Analyst Intern at Outlook Group with expertise in Data Modeling and analytical thinking. Developed impactful dashboards in Power BI, enhancing sales performance insights and optimizing customer engagement strategies. Proficient in SQL and DAX, I excel at transforming complex data into actionable insights, driving informed decision-making and business growth.

Overview

1
1
Certification
3
3
Languages

Work History

Business Analyst Intern

Outlook Group
06.2023 - 07.2023
  • Collected and analyzed sales data, focusing on conversion rates and responses from different prospect segments
  • Used Power BI to analyze conversion rates, customer segments, and sales patterns.
  • Created visual reports to identify high-performing customer segments and peak engagement times.
  • Applied business analysis skills to assess customer behavior and trends, identifying key factors influencing customer decision-making.
  • Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
  • Designed and developed forward-thinking systems that meet user needs and improve productivity.
  • Performed direct sales for 1 month, promoting subscription-based magazine services to potential clients


Education

MBA - Business Analytics

MIT-ADT University
Loni Kalbhor
04.2001 -

MBA - Business Analytics

SPPU University Pune
Loni Kalbhor
04.2001 -

HSC -

S.S.V
Pune
04.2001 -

SSC -

S.S.V
04.2001 -

Skills

Data Modeling

Dax

SQL

Power query

Data Relationship

Excel

Additional Information

Dashboard Portfolio

1. Sales Performance Dashboard

  • Concepts Used: Data Import (Excel), Power Query for data cleaning, DAX Measures (Total Sales, Profit %), Slicers, Cards, Bar & Line Charts, Drill-Through, Filters

2. HR Attrition Analysis Dashboard

  • Concepts Used: Relationships, Conditional Formatting, DAX Columns (Attrition Flag), Matrix Visual, Filters, Hierarchies (Department → Role), Tooltips

3. Financial Summary Dashboard

  • Concepts Used: Time Intelligence DAX (YTD, MTD), Donut Chart, KPI Visuals, Slicers by Month/Quarter, Trend Analysis, Page Navigation

4. Inventory Management Dashboard

  • Concepts Used: Gauge Chart, Map Visual, Grouping, Parameters, Data Modeling (One-to-Many), Measures for Stock Level %, Alert Flags (IF logic)

Certification

[Data Analytics], IT Education

Timeline

Business Analyst Intern

Outlook Group
06.2023 - 07.2023

MBA - Business Analytics

MIT-ADT University
04.2001 -

MBA - Business Analytics

SPPU University Pune
04.2001 -

HSC -

S.S.V
04.2001 -

SSC -

S.S.V
04.2001 -
Harshal BadhekarPower Bi Developer