Portfolio - Vedangi Vinay Pathre

Vedangi Vinay Pathre

Data Aspirant

Resume

2

Excel Projects

2

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Hi, I’m Vedangi Pathre — an aspiring Data Analyst with a background in Bio-Tech and a passion for turning data into insights. While pursuing my B.Tech in Artificial Intelligence and Data Science, I discovered my strength in working with tools like Excel, Power BI, SQL, and Python.

Though I haven’t worked in a company yet, I’ve completed several real-world business analytics projects that demonstrate my ability to analyze data, uncover trends, and build impactful dashboards. From financial reports to COVID-19 trends and stock data visualization, each project reflects my growing expertise and commitment to learning.

I’m excited to bring analytical thinking, strong visualization skills, and a data-driven mindset to real-world challenges. Let’s connect!

Key Skills

Power BI

Excel

SQL

Python

DAX

MySQL

Microsoft SQL Server

Exploratory Data Analysis (EDA)

Business Insight Generation

Data Cleaning & Transformation

ETL

Strong Communication

Leadership (as CR, Club Lead)

Team Collaboration

My Projects

Business Insights 360

Domain/Function: Finance, Sales, Marketing, and Supply Chain

Sales & Finance Reports Dashboard

Domain/Function: Finance and Sales

Plant Co. Quantity Performance Dashboard

Domain/Function: Supply Chain and Operations

Stock Data Extraction & Visualization

Domain/Function: Finance / Stock Market Analytics

COVID-19 Data Analysis

Domain/Function: Public Health / Data Analysis

Coffee Sales Analysis Project

Domain/Function: Sales and Retail Analytics

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Data Science Methodology

Python Project for Data Science

Python for Data Science, AI & Development

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/vedangipathre/

GitHub

https://github.com/Vedangipathre

PowerBI Project

Business Insights 360

Domain/Function: Finance, Sales, Marketing, and Supply Chain

Developed a dynamic Power BI dashboard for AtliQ Hardware, offering deep insights across Finance, Sales, Marketing, and Supply Chain using SQL, Excel, and Power BI.

Overview of AtliQ’s cross-functional BI dashboard in Power BI

Finance performance KPIs with filters by time and region

Project Details

Built an end-to-end BI solution for AtliQ Hardware to support data-driven decision-making across Finance, Sales, Marketing, and Supply Chain functions. Integrated MySQL data into Power BI using advanced ETL and DAX techniques. Designed custom KPIs, visualizations, and reports deployed via Power BI Service. Focused on data modeling, dashboard usability, and performance optimization to derive actionable insights.

Live Interactive Dashboard

Excel Project

Sales & Finance Reports Dashboard

Domain/Function: Finance and Sales

Built interactive Excel dashboards using Power Query and Pivot Tables to analyze Sales and Profit & Loss data. Delivered insights by market, customer segment, and timeline using slicers, filters, and conditional formatting for better decision-making.

View Project
Engagement

View Project
on GitHUB

Customer-wise Net Sales dashboard with YoY growth % using slicers and conditional formatting

Market-wise Performance vs Target dashboard with variance and % deviation using Excel conditional formatting

Project Details

Created end-to-end Excel dashboards for visualizing Sales and P&L data using Power Query and DAX formulas. Used advanced Excel features for ETL, data cleaning, and KPI tracking. Built dynamic reports with filters by market, date, and customer type to support business insights. Delivered strategic analysis of revenue trends, customer profitability, and time-based performance across multiple categories.

PowerBI Project

Plant Co. Quantity Performance Dashboard

Domain/Function: Supply Chain and Operations

Built a Power BI dashboard to track quantity performance by product size, type, and region. Visualized growth metrics, GP%, and account-level trends using DAX and drill-through features.

Interactive dashboard showing YTD vs PYTD quantity trends, GP%, and product-level segmentation using drill-through and DAX in Power BI.

Visual breakdown of monthly quantity changes, product size trends, and account-level profitability using advanced Power BI visuals and metrics.

Project Details

Designed a Power BI dashboard for a plant-based company to monitor product quantity trends by type, size, and region. Applied custom DAX measures to calculate growth percentages, gross profit margins (GP%), and track account performance. Leveraged drill-through features for in-depth regional analysis. This helped identify high-growth areas, optimize product mix, and support strategic decision-making.

Live Interactive Dashboard

Python Project

Stock Data Extraction & Visualization

Domain/Function: Finance / Stock Market Analytics

Built an interactive Python dashboard to analyze stock performance using yfinance and BeautifulSoup. Visualized revenue and price trends using Plotly.

View Project
on GitHUB

Extracted Tesla stock data using yfinance API, reset index, and displayed historical Open, Close, and Volume values using pandas.

Scraped Tesla’s quarterly revenue from a website using BeautifulSoup, parsed HTML tables, and cleaned revenue data using pandas.

Project Details

Developed a Python project to extract and analyze stock market data. Utilized the yfinance API to fetch historical stock prices and BeautifulSoup to scrape company financials from the web. Cleaned and structured the data for analysis. Created interactive visualizations using Plotly to explore trends in share price and revenue over time. This project demonstrates web scraping, financial analysis, and data visualization skills using Python.

SQL Project

COVID-19 Data Analysis

Domain/Function: Public Health / Data Analysis

Performed an in-depth SQL analysis on global COVID-19 data using joins, CTEs, temp tables, and window functions. Derived insights on infection rates, death percentages, and vaccination trends across countries for better public health understanding.

View Project
on GitHUB

SQL queries analyzing COVID-19 death rates, infection percentages, and country-wise comparisons using joins and calculated fields

Used CTEs, temp tables, and window functions to calculate rolling vaccination totals and population coverage for COVID-19 across countries.

Project Details

Analyzed global COVID-19 trends using SQL. Applied advanced techniques like Common Table Expressions (CTEs), window functions, and subqueries to calculate death rates, recovery rates, and vaccination progress. Created views and temporary tables for reusable insights. The project showcases strong SQL logic and the ability to derive critical public health insights from large datasets.

Excel Project

Coffee Sales Analysis Project

Domain/Function: Sales and Retail Analytics

Built an Excel dashboard using pivot tables to analyze coffee sales by type, region, and customer segment. Identified top customers, high-profit items, and loyalty patterns.

View Project
on GitHUB

Interactive dashboard with slicers, charts by coffee type, size, roast, country, and loyalty to track sales trends over time.

Monthly coffee sales table with dynamic filters and chart showing trends by coffee type across different months and years.

Project Details

Conducted a comprehensive sales analysis on coffee data across multiple Excel sheets. Used pivot tables, slicers, and filters to explore metrics like revenue, quantity sold, and customer behavior by product type and region. The dashboard revealed key customer trends, top-performing products, and loyalty indicators. This project highlights data cleaning, report building, and business insight generation using Excel.