Bhavya Kapil

Transforming Raw Data into Strategic Business Intelligence

About Me

Hi, I'm Bhavya Kapil

A Data Analyst with a background in Business Administration (BBA, TIMT College). I bridge business strategy with data insights to craft impactful solutions.

I specialize in turning raw, scattered data into interactive Power BI dashboards that don’t just show numbers—but tell stories, uncover patterns, and guide smarter decisions.

Business Analytics Data Visualization Strategic Insights

Skills & Expertise

Power BI

Dashboards 95%
DAX 90%
Data Modeling 88%

Excel & Analysis

Advanced Excel 92%
Data Analysis 94%
Statistical Analysis 85%

Business Intelligence

Analytics & Reporting 91%
Data Visualization 93%
Strategic Planning 87%

Technical Proficiency

Power BI

Excel

SQL

Tableau

Python

R

Featured Projects

Explore my portfolio of data analytics projects that have delivered measurable business impact through insightful visualizations and strategic recommendations.

Comprehensive HR Analytics Dashboard showing employee distribution, salary analysis, and performance metrics

Comprehensive HR Analytics Dashboard

Developed an enterprise-level HR analytics dashboard that provides comprehensive insights into workforce dynamics across multiple departments. This interactive dashboard tracks 102 employees across 7 departments, analyzing key metrics including salary distributions, performance ratings, and employee joining patterns.

Key Features & Insights:

  • Real-time tracking of 102+ employees across Operations, HR, Engineering, Finance, IT Support, Sales, and Marketing
  • Salary analysis revealing average compensation of $0.13M across departments
  • Performance rating distribution with detailed departmental breakdowns
  • Employee joining trends with peak hiring periods identification
  • Top performer identification with salary benchmarking
Power BI DAX HR Analytics Data Modeling

Employee Attrition Analysis Dashboard

Created a specialized attrition analysis dashboard that identifies key factors contributing to employee turnover. This strategic tool analyzes 446 employees with a 20.6% attrition rate, providing actionable insights for HR retention strategies and workforce planning.

Strategic Insights Delivered:

  • Attrition rate analysis: 20.6% overall with 92 departures from 446 employees
  • Age demographics: Average age of 37 years with targeted retention strategies
  • Education impact: Marketing (38%) and Life Sciences (32%) showing highest attrition
  • Salary correlation: Average $7.0K salary with 7.3 years average tenure
  • Job role analysis: Sales Representatives (33) and Sales Executives (57) most affected
Predictive Analytics Attrition Analysis Tableau Statistical Modeling
Employee Attrition Analysis Dashboard with education breakdown, age demographics, and job role statistics
Attendance and Performance Correlation Dashboard showing monthly trends and salary correlations

Attendance & Performance Correlation Dashboard

Engineered an advanced correlation analysis dashboard that reveals the relationship between employee attendance patterns and salary performance across departments. This innovative visualization combines temporal analysis with compensation data to identify productivity patterns and optimize workforce management.

Advanced Analytics Features:

  • Monthly attendance tracking across 7 departments with seasonal trend analysis
  • Peak attendance periods: August (101%) and December (89%) performance metrics
  • Salary vs. attendance correlation scatter plot revealing performance patterns
  • Department-wise attendance distribution with color-coded visualization
  • Compensation range analysis: $50K-$120K with attendance correlation insights
Correlation Analysis Time Series Advanced Visualization Performance Analytics

Ready to transform your data into actionable insights?

Start Your Project Today

What I Do

Interactive Dashboards

Build interactive dashboards in Power BI that provide actionable insights and real-time data visualization.

  • • Real-time data monitoring
  • • Custom KPI tracking
  • • Interactive filters & slicers
  • • Mobile-responsive design

Data Modeling & DAX

Use DAX and data modeling to transform raw data into meaningful reports and calculations.

  • • Advanced DAX formulas
  • • Data relationship modeling
  • • Performance optimization
  • • Complex calculations

Business Intelligence

Translate complex business data into simple, visual stories for decision-makers.

  • • Strategic insights
  • • Trend analysis
  • • Predictive analytics
  • • Executive reporting

Advanced Analytics

Perform deep data analysis to uncover hidden patterns and business opportunities.

  • • Statistical analysis
  • • Data mining
  • • Pattern recognition
  • • Forecasting models

Continuous Innovation

Continuously learn and adapt to modern business intelligence tools and techniques.

  • • Latest BI trends
  • • Tool mastery
  • • Best practices
  • • Industry standards

Strategic Consulting

Bridge the gap between business needs and data insights for smarter decision-making.

  • • Business strategy
  • • Data-driven decisions
  • • Process optimization
  • • Growth planning

Why Choose Me?

Business + Analytics

Strong mix of business knowledge and analytical mindset, ensuring solutions that align with business goals.

Hands-on Experience

Hands-on projects that showcase real-world problem solving and practical implementation skills.

Strategic Vision

Ability to see data not just as numbers, but as a roadmap to business growth and success.

My Vision

I aim to bridge the gap between business needs and data insights helping companies make smarter decisions with clarity, speed, and confidence.

Let's Connect