Skip to content
View harshbrar03's full-sized avatar
0 followers · 5 following

Block or report harshbrar03

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.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
harshbrar03/README.md

Harshdeep Singh

Aspiring Data Analyst | MSc. IT Student (Specializing in Data Analytics)

🛠️ Skills & Tools

  • Languages: SQL, Python
  • Libraries: Pandas, NumPy, Matplotlib, Seaborn
  • Data Visualization Tools: PowerBI, Tableau
  • Databases: MySQL, PostgreSQL
  • Other Tools: Google Colab, Jupyter Notebook, Git & GitHub

📈 Projects

1. Retail Store Sales Analysis:

  • TechStack: SQL, Python and PostgreSQL
  • Project Description: End-to-end sales analysis pipeline with ETL using Python and PostgreSQL, also features SQL-based business insights and data visualizations.

2. Diwali Sales Analysis:

  • TechStack: Python and Tableau
  • Project Description: Analyzed Diwali sales data to uncover customer trends, purchasing behaviors, and product performance.

3. Superstore Dashboard:

  • TechStack: Power BI
  • Project Description: Analyzed sales, profit, customer behavior and sales managers performance.

4. Coffee Sales Dashboard:

  • TechStack: Excel
  • Project Description: An interactive coffee sales dashboard built in Excel using PivotTables, slicers and XLOOKUP.

5. Spam Detection Model:

  • TechStack: Python
  • Project Description: Spam detection project using Naive-Bayes Classifier with a Tkinter GUI.

6. SQL Sales Insights:

  • TechStack: SQL
  • Project Description: Analyzed sales data using advanced SQL techniques like CTEs, window functions, and views to derive insights on salesperson performance, product sales, and customer spending.

7. Spotify Song Analysis (in progress).

📊 GitHub Stats

Top Languages

Pinned Loading

  1. retail-store-sales-analysis retail-store-sales-analysis Public

    A beginner-friendly data analytics project demonstrating the complete ETL workflow using a retail dataset. It involves data cleaning with Python, storing in PostgreSQL, querying with advanced SQL, …

    Jupyter Notebook

  2. Diwali-Sales-Analysis Diwali-Sales-Analysis Public

    A Diwali Sales Analysis of a retail store using jupyter notebook and python libraries like pandas, matplotlib and seaborn

    Jupyter Notebook

  3. Superstore-Dashboard Superstore-Dashboard Public

    This repository contains a collection of interactive Power BI dashboards designed to provide valuable insights into sales, profit, customer behavior, and sales managers performance.

  4. Coffee-Sales-Dashboard Coffee-Sales-Dashboard Public

    An interactive coffee sales dashboard built in Excel using PivotTables, slicers and XLOOKUP.

  5. SQL-Sales-Insights SQL-Sales-Insights Public

    A comprehensive SQL project analyzing sales performance with advanced techniques like CTEs, window functions, and views. Explore insights into customers, products, and sales trends.

    SQL

  6. Spam-Detection Spam-Detection Public

    A machine learning-based spam detection system that classifies emails as spam or ham. Also includes a user-friendly Tkinter GUI for real-time predictions.

    Jupyter Notebook