Superstore Sales Analysis

Follow link to have a glance at the complete project Read More

Overview 🕮

In pursue of knowledge and understanding of which products, regions, categories and customer segments a company should target or avoid, I search and selected an appropriate dataset on kaggle which will match a standard superstore requirement. With growing demands and cut-throat competitions in the market, companies are seeking ideas on how to optimize profits. The project is carried out in the following steps. 🛒 🛍️ 🏪

Libraries 🐱‍💻

• numpy for mathematical operations on arrays.
• datetime for date manipulation.
• pandas to perform data manipulation and analysis.
• seaborn for data visualization and exploratory data analysis.
• plotly to create beautiful interactive web-based visualizations.
• plotly express easy-to-use, high-level interface to Plotly.

Languages and Tools 👨‍💻

  Languages

Languages	Usage
Python 3.11.0	Programming Language For data cleaning, manipulation and visualization

  Tools

Tools & Environment	Usage
Jupyter NoteBook	An open-source IDE used to create the Jupyter document.
Power BI (Power Query, DAX)	Data visualization tool.
Kaggle	For downloading training data.
Git	A version control system to manage and keep track source code history.

Problem Statement

• Which mode of shipping is preferable?

• Which customer segment is more profitable ?

• Which Region makes more profit?

• Which Category and sub-category makes the most sales?

• Which city is preferable for business?

Methodology

Data Collection Getting data from Kaggle.

Data Cleaning and Preparation Removing irrelevant and restructuring the dataset for easy analysis.

Exploratory Data Analysis Exploring and analyzing the cleaned data.

Visualization and Reporting visually presenting data in form of charts and graphs.

Insights presenting observations from the analysis.

Project Link

Dont forget to have a glance at the Complete Project Read More

Running the project

To run the (.ipynb) project use Notebook or Google Colab, while Power BI for the (.PBIX) file.

Support

For support, email njimonda.co@gmail.com.

Author

• @njimonda

Badges

Contributing to this project

Contributions are always welcome!

Please adhere to this project's code of conduct.

Acknowledgements

• Awesome Readme Templates
• Awesome README
• How to write a Good readme