Hi, I'm Vineet — a data analyst, passionate about turning data into insights.
Welcome to my GitHub page, where I showcase real-world projects.
I'm a data analyst passionate about transforming raw data into actionable insights. My expertise lies in Excel, SQL, and Power BI, and I enjoy creating interactive dashboards and analytical reports that drive informed decision-making.
- Sales - over 10 years of experience as BDM
- Retail - over 10 years of experience as Category Manager
- Pursuing a Postgraduate Program in Data Analytics from Purdue University
- Diploma in Retail Management
- Bachelor's in Computer Science
- Excel, Python & SQL
- Data Visualisation
- Business Intelligence
- Machine Learning
- Artificial Intelligence
Project 1: Build an e-commerce sales dashboard
This project was part of the PG program, in which I used Excel to create an e-commerce sales dashboard. The dashboard displays the KPIs and insights for management.
- Created User Control Combo boxes for Product Category and Regions
- Created tables and pivot tables, and created links with the combo boxes
- Build visualisations to display sales trends
Project 2: Restaurant Tips Prediction
This project was also part of the PG program, in which I used advanced analytics (linear regression) to predict the restaurant tips. Tasks performed:
- Data cleaning and handling missing values
- Standardised the categorical variables
- Used linear regression to predict the restaurant tips
Project 3: NYC Traffic Safety Analysis
Analysed New York City's traffic accident data to identify key factors contributing to collisions. The project involved:
- Data cleaning
- Exploratory data analysis
- Visualisation to uncover trends and provide actionable recommendations for improving road safety.
Project 4: Air Cargo SQL Project
This project was part of the PG program, in which passenger and flight data were analysed. Some key objectives were to:
- Identify regular customers
- Find the busiest routes
- categorise flights in 3 categories - short distance travel (SDT), intermediate distance travel (IDT), and long-distance travel (LDT)
- and many more
Project 5: ScienceQtech Employee Performance
This project was part of the PG program, in which employees' ratings, performance and projects undertaken were analysed. Some key objectives were to:
- Identify employees based on department
- Assign ranks based on experience
- Calculate bonuses for employees based on ratings and salary
Project 6: Advanced SQL Major League Baseball (MLB)
This project required the use of advanced SQL queries such as subqueries, CTEs, and window functions. Some key objectives were to:
- What schools do MLB players attend?
- How much do teams spend on player salaries?
- What does each player’s career look like?
- How do player attributes compare?
Project 7: Maven Toys Store KPI Report
This was the first Power BI project I undertook. It involved:
- Profiled and cleaned the data
- Built a relational model
- Defined KPI's
- Created measures using DAX
- Built an interactive report
Project 8: Pixar Films - Storytelling with visualisation
This project was done as part of the Maven monthly challenge. It involved:
- Analysing Pixar films released from 1995 and 2024
- Define KPIs and create measures using DAX
- Build visualisations to share the insights
- Provide key findings
Project 9: Customer Loyalty dashboard - dataDNA_July2025_Challenge
This project was done as part of the dataDNA July, 2025 challenge. It involved:
- Define KPIs and create measures using DAX
- Build visualisations to share the insights
- Provide key findings
- Provide strategic recommendations
Project 10: Ace_Superstore Sales Dashboard - RDAMP Mentorship Program
This project was done as part of the RDAMP mentorship program. It involved:
- Perform ETL
- Define KPIs and create measures using DAX
- Build visualisations to share the insights
- Provide key findings
- Provide strategic recommendations
Project 11: Sports Injuries Analysis - FP20 Analytics Challenge 29
This project was completed as part of the FP20 Analytics Challenge 29. It involved:
- Exploring the data
- Creating the date table
- Create a data model
- Define KPIs and create measures using DAX
- Build Visualisations to share the insights
- Share the key insights
- Share recommendations
Project 12: Ace_Superstore_SQLView_Data_modeling_Dashboard - RDAMP Mentorship Program
This project was done as part of the RDAMP mentorship program. It involved working with SQL and PowerBI:
- Create the database and tables in SQL
- Create Views in SQL
- Create a schema in SQL
- Connect PowerBI with SQL to import Views
- Build visualisations
Project 13: Rychtenshane_Community_Housing_Group_LMS_Analytics
This group project was done as part of the RDAMP mentorship program. It involved working with Excel, Python and PowerBI:
- Perform Data Cleaning
- Perform EDA
- Create a data model in PowerBI - Snowflake
- Define KPIs and create measures
- Perform statistical analysis in python
- Create PowerBI report to present key insights
- Propose strategic recommendations
- Propose future KPIs
Feel free to explore my repositories for more projects and insights into my work.