Skip to content

In this project i have analysed sales data of various branches of an American supermarket. I have used various python libraries for this task.

Notifications You must be signed in to change notification settings

Sandeep19531/BusinessAnalysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

Motivation : Data Scientists spends most of their time performing Data Wrangling and Analysis, having an interest in finance I opted for this task during my internship at The Sparks Foundation.


Libraries Used: Pandas, NumPy, Seaborn, Matplotlib


Language Used: Python


Explanation : In this project i performed Exploratory Data Analysis over the provided Sample Super Store Dataset.
Being a Financial data the key motive of my analysis was to analyse the ways to improve Profit so After loading the data in a dataframe,i checked for inconsitencies and plotted the profit and loss values to get an idea of variance of the data.
Profitandlose
I then one by one analyse all the features of the dataset and plotted it against profit.


Conclusion:
1.In doing all that i figured out that people mostly use Standard Ship Mode for delivery and Technology Category provides the maximum returns.
Boxplot

Category_Boxplot

2.I also figured out that Bookcases and Tables in the Furniture category are the ones that causes massive loses.
Category_sum

3.Texas's SuperStore has the worst performance among all the Stores.
Texas_items

About

In this project i have analysed sales data of various branches of an American supermarket. I have used various python libraries for this task.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published