Giter Club home page Giter Club logo

storedata's Introduction

SuperStore Data Analysis

In this project, we have aimed to analyse the sales data of the super store and provide useful insight into customer preferences.

About the dataset

The dataset used for this analysis is an excel file containing the following columns:

  • Row ID
  • Order ID
  • Order Date
  • Ship Date
  • Ship Mode
  • Customer ID
  • Customer Name
  • Segment
  • Country
  • City
  • State
  • Postal Code
  • Region
  • Product ID
  • Category
  • Sub-Category
  • Product Name
  • Sales
  • Quantity
  • Discount
  • Profit

Methodology

The analysis was conducted in Python using the following libraries:

  • Pandas
  • Numpy
  • Matplotlib
  • Streamlit (for deployment)

Results

  • The stores makes the most revenue in terms of sales from the state of California, followed by New York, Texas, Washington and Pennsylvania in that order.
  • Over 50% of the store's revenue comes from consumer goods, followed by corporate and home-office in that order.
  • The store offers multiple types of shipping modes, but the standard class is by far the most popular.
  • The store has branches all over the country and the sales distribution is well spread out. The West brings in the most though, at 31.6% followed by East, Central and South.
  • Copiers are the most profitable sub-category of products, whereas tables are the least profitable, actually producing a net loss.
  • Continuing with sub-categories, Phones bring in the most revenue at 14.4% followed closely by Chairs at 14.3%

storedata's People

Contributors

rahulsm20 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.