Superstore dataset analysis excel. . I downloaded the Global Superstore Orders 2016. Using DAX and calculated columns, these analyses provided insights into various aspects of the superstore's operations. The sample data we’ve provided is designed to be a foundation for building your own healthcare insurance claim datasets. We select the excel file we want to import. Total Revenue Analysis: Over the year, the Superstore achieved a commendable total revenue of $1,924,338. 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. 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. core. frame. SuperStoreUS-2015. Each segment has a dedicated dashboard page that addresses the business intelligence questions raised. Nov 25, 2023 · From the get data, under the data ribbon. 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. Superstore Sales; Iris; Titanic Mar 30, 2022 · Analysis from Heatmap. 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. - 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". Remove This project involves analyzing sales data for the Londoner Superstore using Microsoft Excel. 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. - 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. Sample - Superstore Sales (Excel). Select all data > Ctrl + G > ‘Special’ > ‘Blanks’. It provides a variety of options for importing data from many sources, including databases, text files, excel, and the web. 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. xlsx onto my desktop. Nov 19, 2023 · Introduction. 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. Note: Geographic locations have been altered to include Canadian locations (provinces / regions). 1. 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. xlxs; Global Super Store Dataset The data analysis was divided into sales performance analysis, product analysis, customer analysis, and region analysis. Jan 9, 2023 · The dataset of choice was the Superstore Sales dataset. Global Super Store Dataset. Jun 9, 2023 · Check null values. This is a practice project which I did to polish up my Excel skills. Microsoft Excel has been employed for this project. This report analyzes various aspects of the dataset to extract meaningful insights. Nov 28, 2019 · Download various types of Power BI Excel Sample Data for Practice purpose. Data set Analysis using MS Excel and built-in functions and features of Excel. The data has 51290 rows, and 24 columns. The dataset comprises 31,047 rows of sales data for Vrinda Store for the year 2022. This includes the state, region, order date, shipping date, product ordered etc. shape (9994, 13) # Summarised information of data set superstore. Dataset and use case presentation Data analysis : 1. I wanted to create an interactive dashboard with the stakeholder in mind. xls. Interactive Dashboard Jul 3, 2023 · Data Analysis. We needed multiple table, so we selected the three tables we need and click on transform. 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. 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. (To remove rows if null values exist) Ctrl + Minus > Entire row. Learn more. 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. List of the Excel Datasets for Data Analytics Beginners. 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. By exploring different aspects of the dataset, users can gain valuable insights into sales patterns, shipping costs, and geographic performance. 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. info() <class 'pandas. Feel free to add more rows to suit your specific use case or dataset requirements. 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. The primary aim is to identify sales trends, customer preferences, and performance metrics to support strategic decision-making. 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. 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. Sample data that appears in the December Tableau User Group presentation. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. 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. Then apply conditional formatting to highlight products with the highest and lowest turnover rates. 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. Updated Superstore Excel file to the version shipping with 10. - 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. Sales and Profit are Moderately Correlated; Discount and Profit are Negatively Correlated; Overall Analysis. 🖊 There are no null values in this dataset. Creating a power The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. 4 - 11/28/2017. Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. alllngrvsofqbmaisnhgkzkfudhnsnyovzebtfetldhivzlf