Skip to content
View bharathmurugan's full-sized avatar

Highlights

  • Pro

Block or report bharathmurugan

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
bharathmurugan/README.md

Bharath M

Data Analyst Workspace

Data Analyst | SQL | Python | Power BI | Excel

Turning raw data into meaningful insights, interactive dashboards, and data-driven business decisions.

Portfolio LinkedIn Medium


๐Ÿ‘จโ€๐Ÿ’ป About Me

I am a Graduated B.Tech Information Technology student aspiring to build a career as a Data Analyst.

I enjoy working with data to identify patterns, generate insights, create dashboards, and support data-driven decision-making.

My Primary Areas of Interest

  • ๐Ÿ“Š Data Analysis & Visualization
  • ๐Ÿงฎ SQL & Database Management
  • ๐Ÿ Python for Data Analysis
  • ๐Ÿ“ˆ Power BI & Dashboard Development
  • ๐Ÿ“— Advanced Excel
  • ๐Ÿ” Exploratory Data Analysis
  • ๐Ÿ“ Statistical Analysis
  • ๐Ÿ’ก Business Intelligence & KPI Reporting
  • ๐Ÿงน Data Cleaning & Preprocessing

๐ŸŽฏ Data Analyst Profile

Raw Data
    โ†“
Data Collection
    โ†“
Data Cleaning
    โ†“
Data Transformation
    โ†“
Exploratory Data Analysis
    โ†“
Statistical Analysis
    โ†“
Visualization & Dashboard
    โ†“
Business Insights
    โ†“
Data-Driven Decisions

๐Ÿ› ๏ธ Technical Skills

๐Ÿ“Š Data Analysis

  • Data Cleaning
  • Data Transformation
  • Exploratory Data Analysis (EDA)
  • Descriptive Statistics
  • Correlation Analysis
  • Trend Analysis
  • KPI Analysis
  • Data Interpretation
  • Business Insights

๐Ÿ Programming & Querying

  • Python
  • SQL
  • R

๐Ÿ“ˆ Data Visualization

  • Power BI
  • Tableau
  • Excel Dashboards
  • Matplotlib
  • Seaborn

๐Ÿ—„๏ธ Databases

  • MySQL
  • Oracle
  • MongoDB

๐Ÿ“— Excel

  • Advanced Excel
  • Pivot Tables
  • Pivot Charts
  • XLOOKUP
  • VLOOKUP
  • INDEX & MATCH
  • IF / IFS
  • SUMIFS / COUNTIFS
  • Conditional Formatting
  • Data Validation
  • Data Cleaning
  • Dashboard Creation

๐Ÿ”ง Tools & Platforms

  • Git
  • GitHub
  • VS Code
  • Jupyter Notebook
  • Microsoft Excel

Technical Skills


๐Ÿ“Œ Core Data Analyst Competencies

Area Skills
๐Ÿ“Š Data Analysis EDA, Trend Analysis, KPI Analysis
๐Ÿ—„๏ธ SQL Joins, Subqueries, CTEs, Window Functions, Aggregations
๐Ÿ Python Pandas, NumPy, Matplotlib, Seaborn
๐Ÿ“— Excel Pivot Tables, Lookups, Formulas, Dashboards
๐Ÿ“ˆ Power BI Data Modeling, DAX, Interactive Dashboards
๐Ÿ“ Statistics Mean, Median, Correlation, Hypothesis Testing
๐Ÿงน Data Cleaning Missing Values, Duplicates, Outliers
๐Ÿ“Š Visualization Charts, Reports, Business Dashboards
๐Ÿ’ผ Business Intelligence KPIs, Reporting, Decision Support

๐Ÿ“Š Featured Data Analytics Projects

1. ๐Ÿ“ˆ Sales Analytics Dashboard

An interactive sales analytics dashboard designed to monitor business performance and identify important sales trends.

Key Analysis

  • ๐Ÿ’ฐ Total Sales & Revenue
  • ๐Ÿ“ˆ Total Profit
  • ๐Ÿ“Š Profit Margin
  • ๐ŸŒ Region-wise Sales
  • ๐Ÿ™๏ธ City-wise Sales
  • ๐Ÿ“ฆ Product-wise Sales
  • ๐Ÿ—‚๏ธ Category-wise Sales
  • ๐Ÿ‘ค Sales Representative Performance
  • ๐Ÿ“… Monthly Sales Trends
  • ๐ŸŽฏ KPI Monitoring

Tools

Power BI Excel SQL


2. ๐ŸŽ“ Student Performance Analysis

A data analysis project focused on understanding factors affecting student academic performance.

Key Analysis

  • ๐Ÿงน Data Cleaning
  • ๐Ÿ”Ž Missing Value Handling
  • ๐Ÿ“Š Exploratory Data Analysis
  • ๐Ÿ“š Subject-wise Performance
  • ๐Ÿ“ˆ Student Performance Trends
  • ๐Ÿ”— Correlation Analysis
  • ๐Ÿ“ Statistical Analysis
  • ๐Ÿ“Š Visualization of Academic Metrics

Tools

Python Pandas NumPy Matplotlib Seaborn


3. ๐Ÿ’ฐ Expense Tracker Analysis

A data-driven financial analysis project for understanding spending patterns and improving budgeting decisions.

Key Analysis

  • ๐Ÿ’ณ Expense Categorization
  • ๐Ÿ“… Monthly Spending Analysis
  • ๐Ÿ—‚๏ธ Category-wise Expenses
  • ๐Ÿ“ˆ Spending Trends
  • ๐Ÿ”Ž Transaction Analysis
  • ๐ŸŽฏ Budget Monitoring
  • ๐Ÿ—„๏ธ SQL-based Data Analysis
  • ๐Ÿ“Š Expense Visualization

Tools

SQL Python Excel


๐Ÿ“Š Data Analytics Workflow

                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚   DATA SOURCE   โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ DATA COLLECTION โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ DATA CLEANING   โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ TRANSFORMATION  โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚      EDA        โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚   STATISTICS    โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ VISUALIZATION   โ”‚
                 โ”‚    / BI         โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ BUSINESS        โ”‚
                 โ”‚ INSIGHTS        โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜
                          โ†“
                 โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”
                 โ”‚ DATA-DRIVEN     โ”‚
                 โ”‚ DECISIONS       โ”‚
                 โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”˜


๐Ÿ“ˆ GitHub Analytics

Bharath M GitHub Streak

Profile Views GitHub Followers GitHub Stars


๐Ÿ“Š GitHub Contribution Activity

๐Ÿ GitHub Contribution Activity

Bharath M GitHub Contribution Activity

---

๐Ÿง‘โ€๐Ÿ’ป GitHub Profile

GitHub Profile

---

๐Ÿ” Current Focus

  • ๐Ÿ“Š Data Analytics
  • ๐Ÿ Python for Data Analysis
  • ๐Ÿ—„๏ธ Advanced SQL
  • ๐Ÿ“— Advanced Excel
  • ๐Ÿ“ˆ Power BI
  • ๐Ÿ“ Statistics
  • ๐Ÿ”Ž Exploratory Data Analysis
  • ๐Ÿ’ผ Business Intelligence
  • ๐Ÿค– Machine Learning Fundamentals

๐Ÿš€ Career Goal

My goal is to start my career as a Data Analyst and use data to solve real-world business problems.

I am continuously improving my skills in:

SQL
  +
Excel
  +
Python
  +
Power BI
  +
Statistics
  +
Business Understanding
       โ†“
  Data Analyst

๐Ÿ“ซ Contact

๐ŸŒ Portfolio

https://bharath2005.vercel.app/



๐Ÿ’ผ LinkedIn

https://www.linkedin.com/in/bharath-m-87a569259/



โœ๏ธ Medium

https://medium.com/@bharathm


Turning Data into Insights โ€ข Insights into Decisions โ€ข Decisions into Impact ๐Ÿ“Š

โญ Thanks for visiting my profile!

Pinned Loading

  1. Bharath-portfolio Bharath-portfolio Public

    TypeScript

  2. atm_application atm_application Public

    ๐Ÿง A simple web-based ATM application built with Python and Flask, featuring login, balance checking, deposits, withdrawals, and logout functionality.

    Python

  3. Sep_Quiz_App Sep_Quiz_App Public

    A Python-based interactive quiz application that allows users to answer multiple-choice questions, track their scores, and test their knowledge through a simple web interface.

    Python