Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 

Repository files navigation

*Superstore Sales Data Analysis

*Objective: This project focuses on analyzing a retail sales dataset using a structured data analysis approach. The objective is to understand business performance by following proper steps such as data inspection, cleaning, feature creation, and exploratory analysis.

*Dataset: Sample Superstore dataset Approximately 10,000 sales records Includes order details, product categories, regions, sales, profit, discounts, and dates

*Tools Used: Python Pandas Matplotlib

*Analysis Includes: -Inspecting the dataset structure and data types -Cleaning and preprocessing data (date conversion, data type correction) -Feature engineering (order year and order month) -Category and sub-category level profit analysis -Discount vs profit relationship analysis -Region-wise profit analysis -Time-based analysis using monthly business trends

*Key Observations -Higher discounts are associated with lower or negative profits -Certain sub-categories contribute consistently to losses -Regional performance varies significantly -Monthly trends help in understanding business growth patterns

*Conclusion

-The analysis demonstrates a step-by-step approach to working with real business data, with emphasis on data preparation, logical analysis flow, and clear interpretation of results.

About

Retail sales data analysis using Python ,Pandas and Matplotlib

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages