Portfolio - Vishal Agarwal

Python Project

Amazon Sales Analytics

Domain/Function: E-Commere/Retail

E_Commerce-Sale-Analysis analyzes e-commerce sales data using SQL and Python (mainly in Jupyter Notebooks). It covers year-over-year growth, monthly sales trends, cumulative revenue, and customer insights, helping businesses quickly understand performance and customer behavior .

View Project
on GitHUB

Other Tools

SQL

Pandas

This screenshot illustrates an automated CSV-to-MySQL data using Python, with precise data type mapping.

This screenshot illustrates Year-over-Year (YoY) growth and cumulative revenue trends over time, providing valuable insights to management.

Project Details

This project focused on extracting insights from e-commerce sales data using SQL and Python. The main goal is to help businesses understand their performance by analyzing key sales metrics and customer behaviors.

The project features integration between SQL queries and Python, primarily using Jupyter Notebooks (most of the code is in Jupyter Notebook format). It covers several important analyses:

Year-over-Year (YoY) Growth: Tracks how sales figures change from one year to the next, helping to identify trends and measure business growth.
Monthly Trends: Breaks down sales data month by month, revealing seasonal patterns and periods of high or low activity.
Cumulative Revenue: Calculates total revenue over time, allowing for performance benchmarking and forecasting.
Customer Insights: Examines customer activity, such as repeat purchases and purchasing frequency, to help understand customer loyalty and preferences.

Python Project

Atliq Hotel Chain Business

Domain/Function: Hospitality Domain

Atliq operates a prominent hotel chain across all major cities in India. The company seeks to evaluate its performance and identify areas for improvement to boost overall revenue. This analysis also includes a detailed revenue breakdown by city and other relevant parameters.

View Project
on GitHUB

Other Tools

Pandas

This screenshot displays metadata insights extracted from a DataFrame using Pandas methods such as value_counts() and column indexing techniques.

This screenshot demonstrates the use of the Pandas describe() method to generate summary statistics for a DataFrame. It also illustrates how to filter

Project Details

Atliq is a leading hotel chain operating across major cities in India. With a growing footprint and diverse customer base, the company aims to assess its operational performance and uncover strategic opportunities to boost revenue. This project delivers a data-driven analysis of booking trends, city-wise performance, and revenue breakdowns using Python and Pandas.
The goal is to empower Atliq’s leadership with actionable insights that highlight what’s working, what needs improvement, and how to optimize business outcomes across locations.

PowerBI Project

Adventure Works BI Dashboard

Domain/Function: Automotive & Mobility

🚴‍♂️ This Power BI dashboard for Adventure Works, a global sports bike company. 📊 It delivers executive insights on sales, products & customers with dynamic visuals, KPIs, drill‑downs, field parameters & 🌍 map views, enabling smarter, data‑driven decisions.

View Project
on GitHUB

Used star schema with top-level dim/Lookup tables (Date, Product, Customer) and bottom fact table; Cross filter direction is top to bottom.

🚀 This executive view of the Adventure Works Power BI dashboard showcases key metrics like revenue, profit, orders, and return rates.

Project Details

Project Overview:
Built a Power BI dashboard for Adventure Works, a global sports bike company 🏍️. It provides executive-level insights into sales, products, and customer segments, supporting smarter strategic decision-making.

Features:

📊 Dynamic visuals for revenue, product performance & customer behavior

🎯 KPI indicators to track sales, profit & returns

🔍 Drill-down analysis for detailed insights

⚙️ Field parameters for flexible filtering

🌍 Map views for territory performance

Datasets Used: 🛒 Sales | 🔄 Returns | 👥 Customer Info | 📦 Products | 📅 Calendar | 🏷️ Categories | 🌐 Territories
Techniques Applied:

🗂️ Star schema data modeling

➕ DAX formulas & measures

🔖 Bookmarks & buttons for navigation

📑 Excel integration for quick exploration

Outcome: 💡 Enables data-driven decisions, visualizes trends & performance, and empowers executives with clear, actionable insights across the business.

PowerBI Project

Business Insights 360

Domain/Function: Consumer Electronics

AtliQ Hardware struggled with Excel for large-scale data handling 😓. Shifted to Power BI for clearer insights 📊. Uncovered trends in finance 🪙, sales 🧾, and supply chain 🚚 across 1.8M+ records 🧮 using SQL, Excel, Power BI & DAX Studio 🧠.

View Project
on GitHUB

Other Tools

SQL

A well-structured Power BI model connecting 15+ tables, enabling smooth cross-functional analysis across finance, sales, marketing, and supply chain.

Displays unit economics, customer metrics, and product performance using charts and tables for quick business insights.

Project Details

🌟 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰 🌟

🏡 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐋𝐚𝐧𝐝𝐢𝐧𝐠 𝐏𝐚𝐠𝐞: A clean, intuitive entry point that guides users to key business views and insights with ease.

🪙 𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬: Showcases core KPIs, interactive visuals, and dynamic filters to assess financial health and performance.

📊 𝐒𝐚𝐥𝐞𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞: Highlights sales trends using scatter plots, product/customer breakdowns, and donut charts for quick comparisons.

📣 𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬: Offers campaign-level analysis with waterfall charts, segment performance, and flexible tabular views.

🚛 𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧: Tracks logistics and inventory flow through trend charts, key metrics, and detailed breakdowns.

🧑‍💼 𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐒𝐮𝐦𝐦𝐚𝐫𝐲: Tailored for leadership—delivering strategic insights on revenue, growth, and operational efficiency.

SQL Project

Pizza Hut Sales Analysis

Domain/Function: Food & Beverage

This is an end-to-end SQL project focused on analyzing pizza sales data using MySQL. It features advanced SQL techniques like CTEs, window functions, joins, and provides business insights for retail analytics.

View Project
on GitHUB

This screenshot showing SQL queries that answer ad-hoc questions like top-selling and most popular pizza types.

This Screenshot showing SQL queries for cumulative revenue trends and ranking top 3 pizzas by revenue within each category.

Project Details

This SQL script analyzes pizza sales data for a pizza shop using MySQL. It includes:

Database and Table Creation: Creates the main database and a table for orders.
Sales and Order Analysis: Calculates total orders, total sales revenue, and identifies the highest priced pizza.
Pizza Popularity: Finds the most common pizza size, top 5 most ordered pizza types, and quantity ordered by category.
Time Analysis: Shows distribution of orders by hour of the day.
Category and Type Insights: Counts pizza types per category and averages pizzas ordered per day.
Revenue Insights: Lists top 3 pizzas by revenue, percentage revenue contribution by category, and cumulative revenue over time.
Advanced Analytics: Uses CTEs and window functions to rank top pizzas in each category by revenue.

Excel Project

FNP Sales Performance Dashboard

Domain/Function: Gifting and floral retail/E-commerce 🎉✨

📊 This is an Excel Dashboard of FNP (Ferns N Petals) containing Sales Analysis of FNP. It highlights trends in 📈 revenue, 🧑‍🤝‍🧑 customer behavior, and 🚚 delivery performance using dynamic formulas and clear visualizations, providing 💡 strategic business insights.

View Project
on GitHUB

Screenshot of Relationship between tables in Data Model view

Screenshot of Excel dashboard.

Project Details

📊 Excel dashboard analyzing FNP sales data—revealing trends in 📈 revenue, 🧑‍🤝‍🧑 customer behavior, and 🚚 delivery performance. Built for 💡 strategic insights with clean visuals and dynamic formulas.

🔑 Key Topics:

⚙️ ETL-process

📊 Excel-dashboard

🧮 Modelling-tool

📌 Pivot-chart

This dashboard provides a 🧠 strategic, 🎯 visual, and 📈 analytical approach to understanding FNP sales data using Excel.

Hello, I am

Vishal Agarwal

2

2

1

1

About

Key

My

Amazon Sales Analytics

Atliq Hotel Chain Business

Adventure Works BI Dashboard

Business Insights 360

Pizza Hut Sales Analysis

FNP Sales Performance Dashboard

My

Awards

Contact Me

Email

Github

Linkedin

Call

Vishal Agarwal

Download Resume