Portfolio - Shivani Patidar

Excel Project

EXCEL ATLIQ HARDWARE PROJECT

Domain/Function: Hardware Sales /Sales Analysis.

Created an Excel dashboard for Atiq Hardware, analyzing sales, inventory, and revenue trends. Used pivot tables, VLOOKUP, and charts to visualize key metrics, providing actionable insights to optimize business decisions and improve operational efficiency.

View Project
Engagement

View Project
on GitHUB

Net Sales Performance dashboard for Atiq Hardware, showing sales trends (2019-2021), target deviations, and percentages by country.

P&L dashboard for Atiq Hardware, showing fiscal year metrics (2019-2021), including Net Sales, COGS, Gross Margin, and GM% with year-over-year growth.

Project Details

Excel Atiq Hardware Project

Created a comprehensive Excel-based analysis for Atiq Hardware to evaluate sales trends, inventory efficiency, and revenue growth. The project involved cleaning large datasets, organizing records, and performing advanced calculations using functions like INDEX-MATCH, VLOOKUP, and SUMIFS. Designed dynamic pivot tables and visually engaging dashboards with charts to track KPIs, including product performance, seasonal demand, and inventory turnover. Implemented conditional formatting to highlight critical issues such as low stock levels or declining sales. This project provided actionable insights that helped streamline operations, enhance inventory management, and support data-driven business strategies.

Excel Project

SALES E- COMMERCE EXCEL PROJECT

Domain/Function: E-commerce/Sales Analysis and Reporting

Analyzed e-commerce sales data using Excel to create an interactive dashboard. Highlighted key metrics such as revenue, sales trends, and top-performing products. Applied advanced Excel features like pivot tables, charts, and data validation to provide actionable insights.

View Project
Engagement

View Project
on GitHUB

Sales Dashboard for Supermarket Shop" showcasing insights on total sales, profit, monthly trends, product performance, and sales distribution.

Supermarket Sales Dashboard displaying key metrics such as total sales, profit, monthly trends, product performance, payment modes, and sales categori

Project Details

Developed an interactive Excel dashboard to analyze e-commerce sales data, focusing on revenue generation, sales trends, and top-performing products. Utilized advanced Excel functionalities, including pivot tables, conditional formatting, charts, and slicers, to present data insights effectively. Automated data cleaning and sorting processes to ensure accuracy and consistency. The dashboard provided comprehensive insights into customer behavior, seasonal trends, and product performance, enabling data-driven decision-making. This project demonstrated expertise in data visualization, analysis, and Excel's advanced features for business applications.

SQL Project

ATLIQ HARDWARE SQL PROJECT

Domain/Function: Hardware Sales /Sales Analysis.

Developed a SQL-based project to analyze Atliq Hardware's sales and inventory data. Designed and executed queries to extract key insights on sales trends, product performance, and inventory management. Optimized data retrieval for efficient reporting and business decision-making.

View Project
Engagement

View Project
on GitHUB

SQL Query Results from Atliq Hardware Dataset" showcasing sales data, including product codes, variants, sold quantities, gross price, and total reven

"Atliq Hardware SQL Dataset Output" displaying product details, variants, sold quantities, and revenue insights for data analysis and reporting.

Project Details

The Atliq Hardware SQL project focuses on analyzing sales and inventory data to support data-driven decision-making. Using advanced SQL queries, insights were derived on sales trends, top-performing products, and inventory optimization. Key tasks included data cleaning, creating complex joins, aggregations, and window functions to analyze customer behavior and revenue patterns. Designed interactive reports to visualize metrics such as monthly sales growth, product profitability, and stock levels

PowerBI Project

FLIPMART SALES POWER BI PROJECT

Domain/Function: Sales Analytics and Business Intelligence

The FlipMart Sales Power BI Project analyzes key performance metrics, including sales, customer behavior, and product analytics. It provides interactive dashboards to visualize sales trends, identify top-performing products, and understand customer preferences for business insights.

View Project
Engagement

View Project
on GitHUB

The screenshot displays an interactive Power BI dashboard showcasing sales trends, top products, and customer insights for FlipMart's performance anal

The second screenshot highlights key sales metrics, including shipping mode, product category, sub-category performance, and regional sales insights i

Project Details

The FlipMart Sales Power BI Project is designed to provide an in-depth analysis of sales performance, customer behavior, and product trends for FlipMart. Using Power BI, I created interactive dashboards that visualize data on sales over time, top-selling products, customer demographics, and purchasing patterns. The project includes various metrics such as sales growth, product category performance, and regional sales distribution. The visualizations aim to help stakeholders make data-driven decisions to optimize sales strategies and improve customer engagement. By leveraging Power BI’s advanced features, the dashboard provides actionable insights for enhancing business performance, identifying key opportunities, and monitoring sales targets.

PowerBI Project

SUPER STORE SALES POWERBI PROJECT

Domain/Function: Sales Performance Analysis and Business Intelligence

The Superstore Power BI Project focuses on analyzing sales, profit, and product performance across multiple regions. It features interactive dashboards to visualize trends, customer behavior, and performance metrics, providing insights for better decision-making and business growth.

View Project
Engagement

View Project
on GitHUB

The screenshot highlights an interactive Power BI dashboard displaying sales, revenue trends, and total profit across various product categories and r

The screenshot displays an interactive Power BI dashboard analyzing sales and performance at the region and state levels, providing detailed insights

Project Details

The Superstore Power BI Project is an analytical dashboard designed to visualize sales, profit, and product performance across different regions. The project includes various interactive elements such as sales trends over time, category performance, and regional comparisons. Key metrics like total sales, profit margins, and top-selling products are highlighted to identify growth opportunities. By incorporating Power BI’s filtering and drill-down features, the dashboard enables users to explore data based on product categories, sub-categories, and shipping methods. The insights provided through this project aim to help decision-makers optimize inventory management, improve sales strategies, and drive business growth.

Python Project

SUPERSTORE SALE PYTHON PROJECT

Domain/Function: Retail Analytics and Data Visualization

The Superstore Python Project analyzes sales data to extract valuable insights using Python libraries like Pandas, Matplotlib, and Seaborn. It includes data cleaning, transformation, and visualization of key metrics like sales trends, profit margins, and product performance.

View Project
Engagement

View Project
on GitHUB

The screenshot features a Python-generated visualization comparing ship modes and product categories, analyzing their impact on sales and profit trend

The screenshot displays a Python-generated visualization showcasing profit analysis across different product categories, highlighting key performance

Project Details

The Superstore Python Project is a data analytics project that leverages Python to analyze and visualize sales data. The project involves data cleaning, transformation, and exploratory data analysis using libraries like Pandas, NumPy, Matplotlib, and Seaborn. Key metrics such as sales trends, profit margins, and product performance are analyzed to uncover insights. The project also includes region-wise and category-wise performance comparisons to identify growth opportunities and optimize business strategies. Interactive visualizations like bar charts, line graphs, and heatmaps help in understanding patterns and trends. This project demonstrates how Python can be used for effective data analysis and decision-making in a retail business context.

Hello, I am

Shivani Patidar

2

1

2

1

About

Key

My

EXCEL ATLIQ HARDWARE PROJECT

SALES E- COMMERCE EXCEL PROJECT

ATLIQ HARDWARE SQL PROJECT

FLIPMART SALES POWER BI PROJECT

SUPER STORE SALES POWERBI PROJECT

SUPERSTORE SALE PYTHON PROJECT

My

Awards

Contact Me

Github

Linkedin

Call

Shivani Patidar

Download Resume