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