Us superstore data
Us superstore data. Nov 25, 2023 · A superstore wants insights on their data. You switched accounts on another tab or window. 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. This dataset gives insights on online orders of a superstore in 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. 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. 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. 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. Now View it. Oct 1, 2024 · Directly accessible data for 170 industries from 150+ countries and over 1 Mio. The data can be accessed via this link. info() <class 'pandas. INSPIRATION So,what questions can be answered looking at this data? How much profit Oct 29, 2023 · data of superstore in south region. 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. facts. 1 percent of total food sales (purple line). This includes the state, region, order date, shipping date, product ordered etc. 4 billion U. core. 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. Create a new Dataframe, where profit is negative which means loss, and concentrate on these areas to improve. Sep 14, 2020 · The online sector, referred to as “clicks,” has been slowly eating up market share in the past two decades. At the national level, sales by the 20 largest food retailers totaled $410. E-commerce platform allows people to buy products from books, toys, clothes, and shoes to food, furniture, and other household items. 92M and 224. supermarket and other grocery store sales amounted to about 846. The trends and patterns derived will give insight and insights will lead to recommendations help in business to strategies for growth. Dataset and use case presentation Data analysis : 1. Feb 16, 2024 · Supermarkets and other grocery stores sales in the United States exceeded 810 billion U. dollars in 2022, more than double the amount generated in 1992. 4 billion in 2019, accounting for 65. Reload to refresh your session. You signed out in another tab or window. . The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. shape (9994, 13) # Summarised information of data set superstore. 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. 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. Feb 18, 2024 · To wrap things up, our Superstore Data Analysis journey has given us a closer look at how the business is doing. S. 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. 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. This corporate style viz is a different take on the classic Tableau Superstore data set. dollars. Mar 18, 2022 · throughout the years (2014–2017), Store sales showed significant growth for Sales Quantity and Total Profit. The dataset is in a CSV format with 51,290 observations and 24 features. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. Jul 9, 2021 · # Shape of data set superstore. However, I would like to focus on the analyses in the United States market. , specializes in furniture, office supplies, and technology products. We started by digging into the data, making sure it’s clean and ready for analysis. Apr 21, 2023 · Dashboard for US superstore data. In Power BI, I summarized my findings in five reports. The project includes an interactive dashboard and a detailed story that provide insights into sales trends, product performance, and regional analysis. 1 Tableau Superstore data set - includes MFG group This project’s data is open source, it is the Global Superstore dataset obtained from Kaggle. 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. 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. This is more than double the sales amounts that were generated back in 1992. group, count, total or average data stored in a table. food sales at supermarkets, other grocery (except convenience) stores, warehouse clubs, and supercenters reached $653 billion in 2019 (gray bars). This suffices to say that, · SuperstoreUS had a total of 1130 Customers during the business year · Total Revenue and Profit was 1. Superstore, a fictional retail entity in the U. 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. frame. 08K respectively Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. CONTENT This is simple data set of US superstore from 2014-2018. Learn more. Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. This constituted the majority of sales Mar 19, 2024 · In 2023, U. This corporate style viz is a different take on the classic Tableau Superstore data set. Nov 14, 2023 · Total U. Import and… US-SuperStore-Dashboard I analyzed the sales and profit of a Supermarket in the United States during a four-year period. Hey everyone, This is an EDA project analyzing super store data set and visualizing it. You signed in with another tab or window. 2019. They wants to know the total revenue generated by the store. A comprehensive Tableau project visualizing the US Superstore sales data. rld zeuroc mdcg cnesd yzlku ynkvsbz irwqp svxpvbn ppaumov qofljk