Skip to content
View himanshigautam-rgb's full-sized avatar

Block or report himanshigautam-rgb

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.

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

πŸ‘‹ Hi, I'm Himanshi Gautam

🎯 Aspiring Data Analyst | Passionate about storytelling through data | Skilled in Power BI, Python, SQL, and Excel
βœ… B.Tech in Computer Science (2021–2025), MIET, Meerut


πŸ” About Me

I'm a detail-oriented data analyst with hands-on experience in real-world projects involving data wrangling, visualization, and predictive analytics. I enjoy using tools like Power BI, Python, and SQL to uncover insights and help drive data-driven decisions.


πŸš€ Career Goal

I aim to work as a Data Analyst, helping companies make data-driven decisions through actionable dashboards, powerful analysis, and storytelling through data.


πŸ’Ό Featured Projects

  • Explored Amazon sales data to uncover trends in revenue, customer behavior, and product performance.
  • Built interactive dashboards using Power BI with custom visuals and slicers.
  • Applied DAX functions and created data models to enhance report usability and insights.

Tools: Power BI, DAX, Data Modeling, Data Visualization

Amazon Dashboard Amazon Dashboard Amazon Dashboard


  • Developed a computer vision-based invisibility cloak using Python and OpenCV to simulate an invisibility effect.
  • Captured the static background and applied color detection to mask the red cloak.
  • Replaced the masked region with the background to create a real-time cloak effect.

Tools: Python, Matplotlib, NumPy, OpenCV

Invisibility Cloak Invisibility Cloak


  • Explored agricultural datasets to analyze sugarcane production trends across regions.
  • Conducted data analysis in Jupyter Notebook, visualized patterns using Matplotlib and Seaborn.
  • Focused on identifying top-performing states and yield improvements.

Tools: Python, Pandas, Matplotlib, Seaborn

SugarcaneAnalysis SugarcaneAnalysis SugarcaneAnalysis SugarcaneAnalysis


  • Analyzed music store data to uncover top-selling artists and revenue by genre.
  • Wrote optimized SQL queries to clean and analyze transactional data.
  • Suggested improvements for stock and inventory management.

Tools: SQL, Data Cleaning, Joins, Subqueries

MuiscImg1 MuiscImg2 MuiscImg3


  • Performed EDA on large-scale sales data to identify purchase behavior by customer segments.
  • Built machine learning models to predict user purchases for better targeting.
  • Used pandas, NumPy, and scikit-learn for analysis and prediction.

Tools: Python, Pandas, NumPy, Machine Learning

BlackFridaySales1 BlackFridaySales2


  • πŸ“ˆ Analyzed daily sales data of a bakery to identify peak hours, popular products, and seasonal trends
  • Used Pivot Tables, VLOOKUP, and conditional formatting for clean insights
  • Built a clean dashboard to display total sales, top 5 products, and hourly performance

Tools: Microsoft Excel, Pivot Tables, Charts, Data Cleaning

BakeryImg1 BakeryImg2


  • πŸ“¦ Analyzed online sales data to track performance metrics like revenue, order volume, and customer retention
  • Wrote SQL queries using joins, aggregations, and window functions to extract KPIs
  • Identified best-selling products, top customer regions, and monthly sales trends

Tools: SQL, PostgreSQL, Data Cleaning, Analytics Queries

Ecommercesales3 Ecommercesales2 Ecommercesales1


πŸ§ͺ Hackathons & Job Simulations

🏒 Quantium Data Analytics Job Simulation – Forage

Ecommercesales3

πŸ“Š PwC Switzerland Power BI Simulation – Forage

Ecommercesales3

Tata

Ecommercesales3

πŸ” Deloitte Australia Data Analytics Simulation – Forage

Ecommercesales3

Google Data Analytics Professional Certificate – Coursera, June 2025 – July 2025

Ecommercesales3


πŸ›  Skills

Category Tools & Tech
🐍 Programming Python (pandas, NumPy, matplotlib), SQL
πŸ“Š Visualization Power BI, Tableau, Matplotlib,
πŸ“ Data Tools Excel (Pivot, VLOOKUP), Power Query
βš™οΈ Data Techniques Data Cleaning, EDA, Regression, Forecasting
πŸ’‘ Soft Skills Problem-Solving, Communication, Teamwork, Presentation

πŸ“œ Certifications

  • βœ… AWS Cloud Practitioner
  • πŸ“Š Data Analytics Course – ICT Academy & Infosys (Aug–Sep 2024)
  • πŸ€– AI & Machine Learning Internship – EduSkills (Jul–Sep 2024)

πŸ“« Let’s Connect!


✨ Thanks for visiting! I’m always learning and open to collaboration on exciting data projects!

Popular repositories Loading

  1. AMAZON-PowerBI-movie-sales-analysis- AMAZON-PowerBI-movie-sales-analysis- Public

    This Amazon Movie Sales Analysis in Power BI provides key insights into sales trends, top-performing movies, and customer demographics. It highlights total revenue, sales by genre and region, and c…

  2. E-commerce_Sales E-commerce_Sales Public

    An E-commerce Sales App project using Power BI analyzes sales data to track performance, identify trends, and optimize decision-making. It features interactive dashboards showcasing metrics like re…

  3. Sugarcane-production-analysis Sugarcane-production-analysis Public

    This repository contains a Jupyter Notebook that performs an analysis of sugarcane production data using Python and popular data analysis libraries such as Pandas, Seaborn, and Matplotlib. The data…

    Jupyter Notebook

  4. Black-Friday-Sales-Analysis Black-Friday-Sales-Analysis Public

    Black Friday is a shopping holiday that takes place on the day after Thanksgiving. It is known for its deep discounts and special deals on a wide range of products, including electronics, home good…

    Jupyter Notebook

  5. BakerySalesAnalysis_Excel BakerySalesAnalysis_Excel Public

    This project analyzes bakery sales data using Excel to identify key sales trends, revenue distribution, and customer purchasing behavior. The dataset includes transaction-level details such as prod…

  6. Python_libraries Python_libraries Public

    This repository contains operations in Matplotlib for data visualization, NumPy for numerical computations, and Pandas for data manipulation and analysis. These libraries work together to efficient…

    Jupyter Notebook