Skip to content

πŸ“Š A project analyzing superstore data using Excel. Includes dashboards and pivot tables to show sales, profits, shipping, and returns. Easy to understand and useful for improving business decisions

License

Notifications You must be signed in to change notification settings

Sydney205/Super-store

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

9 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Super Store Data Analysis Project

This project involves analyzing sales, shipping, and profitability data from a fictional superstore. The insights derived from this analysis aim to help optimize operations, identify profitable areas, and understand customer trends.

Table of Contents

Project Overview

This project uses real-world-style datasets to analyze key metrics, including:

  • Sales performance across different regions and product categories.
  • Profitability trends to identify profitable and unprofitable products.
  • Shipping analysis to improve logistics and reduce costs.

Interactive dashboards and pivot tables are included to make it easy to explore insights visually.

Features

  • Orders Dataset: Analyze sales, discounts, shipping costs, and profits.
  • Returns Dataset: Review and understand return patterns.
  • Interactive Dashboards: Visualize sales and profitability trends.
  • Pivot Tables: Summarize data for quick insights.

Technologies Used

  • Microsoft Excel: Data cleaning, pivot tables, and dashboards.

Screenshots

Below are some screenshots of the dashboards included in the project:

Sales & Profit Dashboard

Sales & Profit Dashboard.PNG

Shipping Dashboard

Shipping Dashboard

License

This project is licensed under the MIT License. See the LICENSE file for details.

About

πŸ“Š A project analyzing superstore data using Excel. Includes dashboards and pivot tables to show sales, profits, shipping, and returns. Easy to understand and useful for improving business decisions

Topics

Resources

License

Stars

Watchers

Forks