This repository showcases various data analyses on the popular Superstore dataset using SQL queries. The analyses cover a range of business insights, including sales performance, customer segmentation, and product profitability. Each analysis is documented with the SQL queries used and explanations of the steps involved.

This project involved a comprehensive analysis of a phone sales dataset, performed in Jupyter Notebooks using Python and libraries such as Pandas, NumPy, and Matplotlib. The analysis included data cleaning, handling missing values, and calculating KPIs. Necessary visualization techniques were also employed to illustrate trends and relationships.

Custom visualising business andd perfroamnce data across geo locations using New Relic's custom visualization platform

an interactive excel dashboard to analyze retail transactions data set

Optimized ShopMart's e-commerce sales performance, customer segmentation, inventory management, and quality assurance using advanced SQL techniques such as window functions, CTEs, joins, query optimization, and stored procedures.

This project analyzes ticket sales and redemption patterns for the Toronto Island Ferry, offering insights into usage trends and recommendations for optimal travel times based on historical data.

This project analyzes Walmart's sales data by leveraging Python for data exploration and cleaning, followed by in-depth analysis and KPI creation in Excel. Key sales metrics, such as sales growth rates and average transaction values, were derived using Excel formulas.

An advanced dashboard using Power BI & Advanced Excel, analyzing Kaggle’s automotive dataset. Features KPIs, dynamic visualizations for sales trends, interactive filters, and geographic mapping. Enables strategic insights and decision-making in automotive sales.

Power BI dashboard analyzing sales, orders, and customer trends to provide insights into the food delivery market.

A service sales manager made for freelancers.

Interactive Tableau dashboard providing a detailed sales analysis for 2023, including key KPIs and visual insights into category trends and customer reviews.

This project utilizes Python, employing regression and correlation analysis to optimize marketing campaigns.

Interactive Data Visualization For the Superstore sales dataset, lets built a sales dashboard in Power BI.

This project analyzes Pizza Sales Data to provide insights into customer preferences and sales performance. Key metrics include total revenue, orders, and average order value, with a breakdown by pizza category and size. The dashboard identifies peak sales periods and top-selling items, supporting data-driven business decisions.

This repository contains a Power BI dashboard designed to provide comprehensive insights into sales performance across various regions, segments, and products. The dashboard utilizes a variety of visualizations, including bar charts, line charts, maps, and tables, to effectively communicate key metrics and trends.

This project analyzes sales data for AdventureWorks, focusing on revenue, customer segments, and product performance. The dashboard provides insights into top-selling products, sales by region, and customer trends across multiple years. It helps in identifying sales opportunities and optimizing marketing strategies.

VCE Software development Inventory Software Solution

This is an Excel project that aimed to provide insights into the sales performance of a supermarket's major three branches.

This report analyzes sales trends, highlights key metrics, and offers insights to boost revenue and optimize sales strategy.

Generated a detailed sales report to help a client measure KPIs, providing accurate insights for continuous analysis.