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