Skip to content
View GauravRawat1's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report GauravRawat1

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
GauravRawat1/README.md








πŸ‘¨β€πŸ’» About Me

Hi, I'm Gaurav Rawat, an aspiring Data Analyst passionate about transforming raw data into meaningful stories that help businesses make informed decisions.

I enjoy working across the complete analytics workflowβ€”from cleaning and exploring datasets to building dashboards and communicating actionable insights. My goal is to develop practical analytics solutions that create measurable business impact.


πŸ“Œ Professional Snapshot

πŸ’Ό Role Data Analytics & Business Intelligence
πŸ“ Location Dehradun, Uttarakhand, India
🎯 Open To Data Analytics Internship Opportunities
🌐 Portfolio Visit Portfolio
πŸ’Ό LinkedIn Connect on LinkedIn
πŸ“§ Email gauravrawatwd@gmail.com

🎯 Areas of Expertise

  • πŸ“Š Data Analytics
  • πŸ“ˆ Business Intelligence
  • πŸ“‰ Data Visualization
  • 🧹 Data Cleaning & Transformation
  • πŸ” Exploratory Data Analysis (EDA)
  • πŸ—„ SQL Analytics
  • πŸ“Š Dashboard Development
  • πŸ“– Data Storytelling


"Without data, you're just another person with an opinion." β€” W. Edwards Deming

🧰 Analytics Toolbox

πŸ’» Programming Languages

πŸ“š Python Libraries

πŸ“Š Data Visualization



πŸ—„ Database

βš™οΈ Development Tools

🧠 Core Skills

  • πŸ“Š Data Analytics
  • πŸ“ˆ Business Intelligence
  • 🧹 Data Cleaning
  • πŸ“‰ Exploratory Data Analysis
  • πŸ“Š Dashboard Development
  • πŸ“– Data Storytelling
  • πŸ“ Statistics

🎯 Analytics Focus

πŸ“Š GitHub Analytics


🧠Development Activity



πŸ“Œ GitHub Overview

Metric Value
πŸ“‚ Featured Projects 5
πŸ† Professional Certifications 4
πŸ“ˆ 100 Days of Data Analytics Active
🎯 Current Goal Data Analytics Internship
πŸ’» Primary Stack Python β€’ SQL β€’ Power BI β€’ Excel

πŸ“Œ Project Highlights

πŸ“‚ Featured Projects 5
πŸ’» Technologies Python β€’ SQL β€’ MySQL β€’ Power BI β€’ Excel
πŸ“Š Dashboards Built 5+
πŸ“ˆ Business Problems Solved 15+

πŸš€ Featured Projects

Showcasing practical analytics solutions built using Python, SQL, MySQL, Excel and Business Intelligence tools to solve real-world business problems.


Employee HR Analytics

πŸ“Š Employee HR Analytics

Workforce analytics project using SQL to uncover insights into employee attrition, departmental performance, salary distribution, and workforce demographics.

Tech Stack

SQL MySQL

Key Insights

  • πŸ“‰ Employee Attrition Analysis
  • 🏒 Department Performance
  • πŸ’° Salary Trend Analysis
  • πŸ‘₯ Workforce Distribution

E-Commerce SQL Analytics

πŸ›’ E-Commerce SQL Analytics

Business-focused SQL analytics project exploring customer behaviour, revenue trends, order patterns, and product performance.

Tech Stack

SQL

Key Insights

  • πŸ’΅ Revenue Analysis
  • πŸ‘€ Customer Behaviour
  • πŸ“¦ Product Performance
  • πŸ“ˆ Sales Trends


Online Store Sales Analysis

πŸ“ˆ Online Store Sales Analysis

Business analytics project focused on understanding revenue growth, customer purchasing behaviour, and sales performance through data analysis.

Tech Stack

Python Pandas Matplotlib

Key Insights

  • 🧹 Data Cleaning
  • πŸ“Š Exploratory Data Analysis
  • πŸ“ˆ Revenue Trends
  • πŸ“‰ Visual Reporting

Netflix Data Analysis

🎬 Netflix Data Analysis

Exploratory analysis of Netflix content to identify genre popularity, release trends, content distribution, and country-wise insights.

Tech Stack

Python Pandas Matplotlib

Key Insights

  • 🎭 Genre Analysis
  • 🌍 Country Analysis
  • πŸ“… Release Trends
  • 🎬 Content Distribution


Employee Performance Analysis

πŸ‘¨β€πŸ’Ό Employee Performance Analysis

Analytics project evaluating employee productivity, ratings, departmental KPIs, and performance indicators for business decision-making.

Tech Stack

Python SQL

Key Insights

  • πŸ“ˆ KPI Analysis
  • ⭐ Performance Ratings
  • 🏒 Department Comparison
  • πŸ’‘ Business Insights

πŸ“Š Portfolio Summary

5

Analytics Projects


15+

Business Problems Solved


Python β€’ SQL

Primary Technologies


Business Intelligence

Real-world Analytics

πŸ† Professional Certifications

Industry-recognized certifications and virtual job simulations that validate my practical knowledge in Data Analytics, SQL, Python, Business Intelligence, and real-world problem solving.

Commonwealth Bank Certificate

🏦 Commonwealth Bank

Introduction to Data Science Job Simulation

Platform

Forage

Skills Gained

  • Data Analysis
  • Data Cleaning
  • Business Insights
  • Data Interpretation

Deloitte Data Analytics

🌏 Deloitte Australia

Data Analytics Job Simulation

Platform

Forage

Skills Gained

  • Business Analytics
  • Dashboard Thinking
  • Data Visualization
  • Business Reporting


SQL Relational Databases

πŸ—„ SQL & Relational Databases 101

Platform

Cognitive Class

Skills Gained

  • SQL
  • Database Design
  • Relational Databases
  • Query Writing

Python Libraries

🐍 Python Libraries for Data Science

Platform

Simplilearn

Skills Gained

  • Pandas
  • NumPy
  • Matplotlib
  • Data Analysis


πŸ“ˆ Certification Summary

Category Count
πŸŽ“ Professional Certifications 4
🏒 Industry Job Simulations 2
πŸ“Š Analytics Certifications 4
🧠 Skills Covered SQL β€’ Python β€’ BI β€’ Data Analytics

πŸ“ˆ 100 Days of Data Analytics

Building practical analytics skills through consistent hands-on projects, business case studies, dashboards, SQL challenges, and data storytelling.


🎯 Challenge Overview

πŸš€ Goal Build a professional Data Analytics Portfolio
πŸ“… Duration 100 Days
🟒 Status Active
πŸ’» Focus SQL β€’ Python β€’ Excel β€’ Power BI β€’ Business Intelligence
πŸ“‚ Repository Add your repository link here

πŸ“Š Progress Dashboard

Category Progress
πŸ“… Days Completed 23 / 100
πŸ“‚ Analytics Projects 9
πŸ“Š Dashboards 5+
πŸ—„ SQL Practice Ongoing
πŸ“ˆ GitHub Activity Consistent

πŸ›  Technologies Used






πŸ† Major Milestones

βœ… Completed 🚧 Upcoming
Day 10 β€” SQL Fundamentals Day 30 β€” Power BI Dashboards
Day 20 β€” Advanced Excel Day 40 β€” Statistics
Day 23 β€” Excel Data Analysis Day 50 β€” Business Intelligence
Python Libraries Day 60 β€” Advanced SQL
Data Analysis Projects Day 70 β€” Python Automation
SQL Projects Day 80 β€” Portfolio Dashboard
GitHub Portfolio Day 90 β€” Capstone Project
Continuous Learning Day 100 β€” Analytics Portfolio Complete

πŸ“‚ Featured Challenge Projects

  • πŸ“Š Employee HR Analytics
  • πŸ›’ E-Commerce SQL Analytics
  • πŸ“ˆ Online Store Sales Analysis
  • 🎬 Netflix Data Analysis
  • πŸ‘¨β€πŸ’Ό Employee Performance Analysis

🎯 Expected Outcomes

βœ” End-to-End Analytics Projects

βœ” Business-Oriented Problem Solving

βœ” Interactive Dashboards

βœ” SQL Proficiency

βœ” Python for Data Analysis

βœ” Data Storytelling

βœ” Professional Portfolio Development

🀝 Connect With Me

I'm always open to connecting with fellow data enthusiasts, collaborating on analytics projects, discussing business intelligence, or exploring internship opportunities.

Let's connect and build data-driven solutions together.


πŸ’Ό Professional Snapshot

πŸ‘€ Name Gaurav Rawat
πŸ’Ό Role Data Analytics & Business Intelligence
πŸ“ Location Dehradun, Uttarakhand, India
🎯 Looking For Data Analytics Internship Opportunities
🌐 Portfolio https://gaurav-portfolio-sandy-ten.vercel.app/
πŸ’Ό LinkedIn linkedin.com/in/gaurav-rawat-bca
πŸ“§ Email gauravrawatwd@gmail.com

πŸ’¬ Let's Build Something Meaningful

Whether it's analyzing data, building dashboards, solving business problems, or collaborating on analytics projects, I'm always excited to connect with professionals and learners who share a passion for transforming data into actionable insights.

⭐ If you like my work, consider giving a star to my repositories! ⭐

πŸ“ˆ GitHub Contribution Snake

GitHub Contribution Snake

πŸ’™ Thanks for Visiting

⭐ Turning Data into Decisions ⭐

⬆️ Back to Top

Footer

Popular repositories Loading

  1. Laboratory-ManagementSystem Laboratory-ManagementSystem Public

    Console-based Chemistry Lab System using C

    C

  2. Auditorium-BookingSystem Auditorium-BookingSystem Public

    C++ console app for managing auditorium bookings. Includes user login, password system, and file handling.

    C++

  3. Student-Records-Analysis Student-Records-Analysis Public

    Student Records Analysis using Python, Pandas and Matplotlib

    Python

  4. employee-performance-analysis employee-performance-analysis Public

    Employee Performance Analysis using Python, Pandas, NumPy and Matplotlib

    Python

  5. Library-Management-Data-Analysis Library-Management-Data-Analysis Public

    Library Management Data Analysis using Python, Pandas, NumPy and Matplotlib

    Python

  6. online-store-sales-analysis online-store-sales-analysis Public

    Online Store Sales Analysis project using Python, Pandas, NumPy, and Matplotlib. Performed data cleaning, feature engineering, exploratory data analysis (EDA), KPI analysis, and business-focused vi…

    Python