Us superstore data
Us superstore data. We started by digging into the data, making sure it’s clean and ready for analysis. However, if we take a closer look, sales and profit were so volatile within the Q1 for Based on the dataset I received, it is the superstore database of the transactions globally between year 2011 and year 2014. INSPIRATION So,what questions can be answered looking at this data? How much profit Oct 29, 2023 · data of superstore in south region. At the national level, sales by the 20 largest food retailers totaled $410. However, I would like to focus on the analyses in the United States market. Sep 14, 2020 · The online sector, referred to as “clicks,” has been slowly eating up market share in the past two decades. facts. The project includes an interactive dashboard and a detailed story that provide insights into sales trends, product performance, and regional analysis. , specializes in furniture, office supplies, and technology products. Hey everyone, This is an EDA project analyzing super store data set and visualizing it. Oct 1, 2024 · Directly accessible data for 170 industries from 150+ countries and over 1 Mio. food sales at supermarkets, other grocery (except convenience) stores, warehouse clubs, and supercenters reached $653 billion in 2019 (gray bars). Feb 19, 2024 · Download the Superstore retail transaction data available on Kaggle to find meaningful insights from online orders of a superstore in the US. loss_df=superstore_df[superstore_df['Profit'] < 0] This will create a new df with all the features where profit is less than Zero. The dataset is in a CSV format with 51,290 observations and 24 features. A comprehensive Tableau project visualizing the US Superstore sales data. 08K respectively Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. Now View it. From this data, we will analyze the sales and profits of the US superstores from 2014-2018 based on the discount rates of the products, city or states where people shop the most, customer loyalty product Super Sample Superstore. This includes the state, region, order date, shipping date, product ordered etc. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. E-commerce platform allows people to buy products from books, toys, clothes, and shoes to food, furniture, and other household items. Import and… US-SuperStore-Dashboard I analyzed the sales and profit of a Supermarket in the United States during a four-year period. The table contains data on a sample superstore dataset with 9994 rows and 14 columns, including information on ship mode, segment, country, city, state, postal code, region, category, sub-category, sales, quantity, discount, and profit, which can be used to analyze and gain insights into various aspects of the superstore's operations and performance. Apr 21, 2023 · Dashboard for US superstore data. The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. supermarket and other grocery store sales amounted to about 846. This corporate style viz is a different take on the classic Tableau Superstore data set. group, count, total or average data stored in a table. Oct 17, 2024 · Graph and download economic data for Retail Sales: Grocery Stores (MRTSSM4451USS) from Jan 1992 to Aug 2024 about groceries, retail trade, sales, retail, and USA. 4 billion U. Nov 25, 2023 · A superstore wants insights on their data. 1 percent of total food sales (purple line). loss_df Analyzing the data for understanding the trends and patterns associated with Profit and sales of Superstore with the help of Data visualization tool - Tableau. This is more than double the sales amounts that were generated back in 1992. This suffices to say that, · SuperstoreUS had a total of 1130 Customers during the business year · Total Revenue and Profit was 1. Superstores in the western United States especially California are well-positioned to attract a large and diverse customer base, capitalize on high consumer Mar 30, 2022 · Now let’s divide the overall data to draw some more accurate conclusions. Superstore, a fictional retail entity in the U. 92M and 224. Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. Feb 16, 2024 · Supermarkets and other grocery stores sales in the United States exceeded 810 billion U. Dataset and use case presentation Data analysis : 1. It allows us to transform columns Dataset containing Sales & Profits of a Superstore Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. 1 Tableau Superstore data set - includes MFG group This project’s data is open source, it is the Global Superstore dataset obtained from Kaggle. . dollars in 2022, more than double the amount generated in 1992. info() <class 'pandas. The trends and patterns derived will give insight and insights will lead to recommendations help in business to strategies for growth. Create a new Dataframe, where profit is negative which means loss, and concentrate on these areas to improve. You signed out in another tab or window. Premium Statistic United States: sales per store of top department stores 2023 With 9800 rows and 19 columns, it provides insights on superstore operations, customer segmentation, regional performance, and product sales, enabling analysis and decision-making in areas like inventory management, marketing strategies, and customer satisfaction. I have only selected the United States as the Country and excluded dates after 11/23/23 to illustrate the myriad of date selection options better. shape (9994, 13) # Summarised information of data set superstore. core. The objective of this project is to analyze and identify trends and patterns in the current retail sales and identify which sector of the market is under loss an You signed in with another tab or window. They wants to know the total revenue generated by the store. 4 billion in 2019, accounting for 65. You switched accounts on another tab or window. Nov 14, 2023 · Total U. Jul 9, 2021 · # Shape of data set superstore. Mar 18, 2022 · throughout the years (2014–2017), Store sales showed significant growth for Sales Quantity and Total Profit. The data can be accessed via this link. This report provides an in-depth analysis of the company's performance from 2019 to 2022, highlighting key areas of strength and potential opportunities for growth. Reload to refresh your session. 2019. DataFrame'> RangeIndex: 9994 entries, 0 to 9993 Data columns (total Mar 11, 2024 · United States: general merchandise store sales per capita 2000-2022 Favorite department store retailers for store design in the United Kingdom (UK) 2014 Retail sales of department stores in Canada Feb 19, 2024 · This dashboard is based on the Superstore data for 2019-2023. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. S. This dataset gives insights on online orders of a superstore in US. This corporate style viz is a different take on the classic Tableau Superstore data set. CONTENT This is simple data set of US superstore from 2014-2018. frame. In Power BI, I summarized my findings in five reports. dollars. This constituted the majority of sales Mar 19, 2024 · In 2023, U. You signed in with another tab or window. Learn more. Feb 18, 2024 · To wrap things up, our Superstore Data Analysis journey has given us a closer look at how the business is doing. wykop ory zbib xoqh bomrbd olvxfju oqc gwkp avqsh dtnowfg