Superstore dataset analysis excel
| Superstore dataset analysis excel. Sample data that appears in the December Tableau User Group presentation. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the Jul 1, 2024 · Thank you for your comment! We provide sample datasets to help you get started, and you can easily extend or modify them as needed. DataFrame'> RangeIndex: 9994 entries, 0 to 9993 Data columns (total Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. By meeting these prerequisites, you'll be well-prepared to dive into the project and extract meaningful insights from the Superstore dataset using Power BI. Nov 25, 2023 · From the get data, under the data ribbon. Select all data > Ctrl + G > ‘Special’ > ‘Blanks’. Note: Geographic locations have been altered to include Canadian locations (provinces / regions). Data set Analysis using MS Excel and built-in functions and features of Excel. Feb 6, 2024 · According to the analysis results, the Superstore received a total profit of 2,389,392, a total loss of 920,357, and a net profit of 1,469,035 over the period 2011–2014. shape (9994, 13) # Summarised information of data set superstore. frame. Then she moves on to talk a Nov 20, 2023 · Here are a few of the prerequisites for undertaking the Data Analysis on the Superstore Dataset using the Power BI project. I wanted to create an interactive dashboard with the stakeholder in mind. I arrived at this by summing up sales for the entire year using a pivot Mar 19, 2023 · With these Excel datasets covering topics like financial analysis, market analysis and time series analysis, beginners can practice data analysis techniques such as data cleaning, pivot tables and charts while gaining insights into real-world scenarios. Jun 27, 2024 · Here is a preview of the inventory records dataset: To practice data analysis with this inventory records dataset in Excel, you can complete the following tasks: Task 1: Calculate the turnover rate (units sold/stock-in) for each product. 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. It was a fun experience to see the complete dashboard Practice Your Data Analysis Skills as a Superstore Data Analyst Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Sales and Profit are Moderately Correlated; Discount and Profit are Negatively Correlated; Overall Analysis. xls. The data has 51290 rows, and 24 columns. - femitech/Londoner-Superstore-Dataset-Analysis-Using-Excel 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. Interactive Dashboard Jul 3, 2023 · Data Analysis. The dataset comprises 31,047 rows of sales data for Vrinda Store for the year 2022. - Nrj27/Sample-Superstore-Dataset-Analysis In this video, one of our students named Sreya Basak gives an introduction to the topic "Analyzing Superstone Sales Using Excel". Dataset and use case presentation Data analysis : 1. Sample - Superstore Sales (Excel). I downloaded the Global Superstore Orders 2016. Global Super Store Dataset. Nov 28, 2019 · Download various types of Power BI Excel Sample Data for Practice purpose. info() <class 'pandas. Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. Import and… May 18, 2023 · RowID column duplicates the default excel rowID for each attribute in the dataset, while the country column was removed because all data in the superstore dataset are from the same country namely May 17, 2023 · Excel is a useful tool for data analysis and visualization. Nov 27, 2023 · Key Insights Unveiled: Product Categories and Sales Distribution: The Global SuperStore dataset highlights three primary product categories — Furniture, Office Supplies, and Technology. By exploring different aspects of the dataset, users can gain valuable insights into sales patterns, shipping costs, and geographic performance. 1. Regards Mar 23, 2022 · => 4 Sale datasets (I am going to split them into 5 different dataset like 2014–2015–2016–2017 sales data) the reason why we are working like this is that every year we are going to have 1 Jul 9, 2021 · # Shape of data set superstore. core. Jan 9, 2023 · The dataset of choice was the Superstore Sales dataset. The primary aim is to identify sales trends, customer preferences, and performance metrics to support strategic decision-making. - kashyapjagwani/Global-Superstore-dataset-Analysis-using-Excel The analysis and visualizations provided in this project aim to offer stakeholders a comprehensive understanding of Global Superstore's sales data. The dashboard needed to present findings about sales, and in a way This is a sample superstore dataset, a kind of a simulation where you perform extensive data analysis to deliver insights on how the company can increase its profits while minimizing the losses. Notably Using the Superstore dataset, the goal of this machine learning project is to perform Exploratory Data Analysis (EDA) and implement clustering techniques to gain insights into customer behavior and optimize the store's operations. We needed multiple table, so we selected the three tables we need and click on transform. (To remove rows if null values exist) Ctrl + Minus > Entire row. xlsx onto my desktop. . Using DAX and calculated columns, these analyses provided insights into various aspects of the superstore's operations. 🖊 There are no null values in this dataset. Updated Superstore Excel file to the version shipping with 10. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. Superstore Sales; Iris; Titanic Mar 30, 2022 · Analysis from Heatmap. Total Revenue Analysis: Over the year, the Superstore achieved a commendable total revenue of $1,924,338. Learn more. This is a practice project which I did to polish up my Excel skills. We select the excel file we want to import. Each segment has a dedicated dashboard page that addresses the business intelligence questions raised. SuperStoreUS-2015. This report analyzes various aspects of the dataset to extract meaningful insights. Remove This project involves analyzing sales data for the Londoner Superstore using Microsoft Excel. Nov 19, 2023 · Introduction. Throughout the data cleaning phase, a concerted effort was made to ensure accuracy and consistency, including the checking & removal of duplicate entries, missing values, and standardization of data formats. The sample data we’ve provided is designed to be a foundation for building your own healthcare insurance claim datasets. xlxs; Global Super Store Dataset The data analysis was divided into sales performance analysis, product analysis, customer analysis, and region analysis. The Global Superstore dataset provides a comprehensive glimpse into the retail landscape, encapsulated within an extensive Excel file featuring three distinct sheets: ‘Orders Oct 26, 2023 · I built a dynamic sales dashboard using the Superstore Sales Dataset (Source: Kaggle) with dynamic functions and visualizations last weekend. This includes the state, region, order date, shipping date, product ordered etc. The main reason which leads to loss is Discount as if some areas lead to loss due to more discounts, and some areas lead to fewer sales due to fewer discounts, hence it needs to be improved. Jun 9, 2023 · Check null values. Then apply conditional formatting to highlight products with the highest and lowest turnover rates. Feel free to add more rows to suit your specific use case or dataset requirements. Creating a power The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. It provides a variety of options for importing data from many sources, including databases, text files, excel, and the web. List of the Excel Datasets for Data Analytics Beginners. 4 - 11/28/2017. Oct 29, 2023 · According to the box plot, American consumption patterns are consistent across regions, with the most popular product categories being office supplies, furniture, and technology, respectively. Microsoft Excel has been employed for this project. xntu rxvgnf haehzq yigc mqivb feaqud mlln xwltxd iddop ajkb |