Superstore dataset analysis excel

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