Hi, I'm Harsha HR

Data Analyst

Transforming data into actionable insights

View Projects Contact Me

About Me

Harsha HR

Data Analyst (Fresher)

I recently completed my BSc in Computer Science & Mathematics and am passionate about analyzing data, creating insightful dashboards, and solving complex business problems using data-driven approaches.

With a strong foundation in statistical analysis and programming, I'm eager to apply my skills to real-world challenges and help organizations make informed decisions through data.

Skills

SQL

Database querying and management

Python

Data analysis with Pandas & NumPy

Power BI

Interactive dashboards & reports

Tableau

Data visualization & storytelling

Excel

Advanced formulas & pivot tables

Data Cleaning

Data preprocessing & transformation

Data Visualization

Creating compelling visual stories

Statistical Analysis

Hypothesis testing & modeling

Projects

Sales Performance Dashboard

Developed an interactive sales dashboard analyzing revenue trends, product performance, and regional sales distribution across multiple quarters.

Power BI Excel

Key Insights:

  • Identified top 20% products generating 80% revenue
  • Discovered seasonal trends with 35% Q4 sales spike
  • Highlighted underperforming regions for strategic focus

Customer Purchase Analysis

Analyzed customer purchasing patterns using SQL queries to segment customers, identify buying behaviors, and calculate key metrics like CLV and retention rates.

SQL MySQL

Key Insights:

  • Segmented 10,000+ customers into 5 distinct groups
  • Found 25% of customers contribute to 60% of revenue
  • Identified optimal time windows for marketing campaigns

Data Cleaning & EDA Project

Performed comprehensive data cleaning and exploratory data analysis on a messy dataset, handling missing values, outliers, and creating visualizations to uncover patterns.

Python Pandas Matplotlib Seaborn

Key Insights:

  • Cleaned dataset with 15% missing values and duplicates
  • Discovered strong correlations between key variables
  • Created 10+ visualizations revealing hidden patterns

HR Analytics Dashboard

Built an HR analytics dashboard to track employee attrition, performance metrics, and department-wise statistics to support HR decision-making.

Tableau Excel

Key Insights:

  • Attrition rate of 18% highest in first 2 years
  • Identified departments with low satisfaction scores
  • Analyzed salary vs performance correlation patterns

Financial Analysis Dashboard

Created a comprehensive financial dashboard tracking revenue, expenses, profit margins, and cash flow trends to support financial planning and forecasting.

Power BI SQL Excel

Key Insights:

  • Tracked monthly profit margins averaging 22%
  • Identified cost-saving opportunities worth 15%
  • Forecasted revenue growth trends for next quarter

Experience

Data Analytics Intern

Academic Project | University

Jan 2024 - May 2024

  • Analyzed student performance data using Python and SQL to identify trends and patterns
  • Created interactive dashboards in Power BI for faculty to track course outcomes
  • Cleaned and preprocessed datasets with 5000+ records for analysis
  • Collaborated with team of 4 to deliver insights presentation to department heads

Research Assistant - Data Analysis

Academic Project | Mathematics Department

Aug 2023 - Dec 2023

  • Conducted statistical analysis on research data using Python and R
  • Performed hypothesis testing and regression analysis for research papers
  • Visualized complex mathematical data using Matplotlib and Seaborn
  • Documented analysis methodology and findings in detailed reports

Capstone Project - Business Analytics

Final Year Project

Jun 2023 - Apr 2024

  • Developed end-to-end analytics solution for local retail business
  • Designed and implemented SQL database for inventory management
  • Built Tableau dashboards for sales tracking and inventory optimization
  • Presented actionable recommendations resulting in 12% efficiency improvement

Education

Bachelor of Science (BSc)

Computer Science & Mathematics

University Name

2021 - 2024

Relevant Coursework:

  • Database Management Systems
  • Statistical Methods & Probability
  • Data Structures & Algorithms
  • Machine Learning Fundamentals
  • Business Analytics
  • Linear Algebra & Calculus

Get In Touch

Location

Bangalore, India