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 -
Similar Profiles
Mattipa Sarovar SathvikaMattipa Sarovar Sathvika
Business Analyst at Outlook GroupBusiness Analyst at Outlook Group
Dhruv KhannaDhruv Khanna
Internship at Outlook GroupInternship at Outlook Group
Aayush BansalAayush Bansal
Intern at Outlook GroupIntern at Outlook Group
Indranil AinIndranil Ain
DIGITAL PRODUCTS & STRATEGY LEAD AMEA at SYNGENTA GLOBAL CAPABILITY CENTER PVT. LTD.DIGITAL PRODUCTS & STRATEGY LEAD AMEA at SYNGENTA GLOBAL CAPABILITY CENTER PVT. LTD.
Vibhav TripathiVibhav Tripathi
Lead Technology at SynechronLead Technology at Synechron