Global superstore dataset analysis. The data has 51290 rows, and 24 columns. core. Ship . This dataset represents a fictitious retail store with a global footprint, providing insights into various aspects of its business operations, such as sales, profits, customer demographics, and regional The data analysis was divided into sales performance analysis, product analysis, customer analysis, and region analysis. Reload to refresh your session. This rich dataset enables analysts to perform a wide range of analyses, including: Sales Analysis: Analysts can examine Jan 9, 2024 · Global Superstore is a global online retailer based in New York, boasting a broad product catalogue and aiming to be a one-stop-shop for its customers. This article is structured in 4 main parts. We also wrote a homework assignment with detailed solutions. 36% of the total profit, followed by This repository showcases the Superstore Sales Analysis project, which aims to analyze and visualize the sales data of a fictional superstore. Dataset and use case presentation Data analysis : 1. A comprehensive Power BI dashboard utilizing the Global Superstore dataset, providing robust and dynamic data visualizations. The dataset of Global Superstore typically includes information such as customer demographics, product details, sales transactions, shipping details, and geographic information. You signed out in another tab or window. Import and… Data set Analysis using MS Excel and built-in functions and features of Excel. The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. See full list on github. The three categories all account for over 30% of sales Mar 30, 2022 · Analysis from Heatmap. You switched accounts on another tab or window. Feb 10, 2024 · As part of a comprehensive data analysis project, I embarked on the exploration of a Global Superstore dataset from the year 2016. 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. frame. Learn more. It generally includes the following key fields: Order ID: Unique identifier for each order. The analysis includes data cleaning, segmentation of visuals by country, region, and market, shipping analysis, and comprehensive sales reports by geography. Sales and Profit are Moderately Correlated; Discount and Profit are Negatively Correlated; Overall Analysis. I downloaded the Global Superstore Orders 2016. The Global Superstore dataset is a popular sample dataset often used for data analysis and visualization exercises. This includes the state, region, order date, shipping date, product ordered etc. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. - kashyapjagwani/Global-Superstore-dataset-Analysis-using-Excel Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. Global Superstore’s clientele, hailing This repository contains a comprehensive data analysis and visualization project using Power BI, focusing on the Global Superstore dataset. The project utilizes a combination of Python, SQL, and Power BI to clean the data, perform exploratory analysis, and create interactive reports. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. global super store analysis & prediction. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. May 23, 2024 · The Global Super Store Analysis project provides a clear understanding of business performance across various dimensions. The dataset consisted of three key tables: order (51,290 records)… Jul 11, 2024 · Tableau is a perfect tool to leverage Business Intelligence and perform an in-depth and insightful analysis of this data. Using DAX and calculated columns, these analyses provided insights into various aspects of the superstore's operations. The Technology category and Phones subcategory lead in sales, while Dec 21, 2023 · Welcome to the Power BI project for the global store dataset! This project provides a detailed report on sales transactions across branches worldwide. info() <class 'pandas. DataFrame'> RangeIndex: 9994 entries, 0 to 9993 Data columns (total The Superstore Data Analysis Project is a data analysis initiative that focuses on understanding and extracting meaningful information from the Superstore dataset. Jan 3, 2024 · In your role as a Data Analyst, you have been enlisted to support Global Superstore in unraveling valuable insights from its dataset. The software I used are SQL server and Power BI. Categories and sub categories. It analyzes global sales, profitability & customer segmentation. 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. All the material can be found here. Notably, the United States contributed 52. Ship Date: Date when the order was shipped. Order Date: Date when the order was placed. Each segment has a dedicated dashboard page that addresses the business intelligence questions raised. xlsx onto my desktop. New users can take advantage of the Sample datasets provided by Tableau to experiment and experience various operations and functionality offered by the platform. python data-science jupyter-notebook data-analysis superstore-data-analysis Oct 23, 2023 · In this article I will describe the analysis process I conducted using a Global Superstore’s dataset. It includes various visualizations to help stakeholders analyze and understand key aspects of the business. Once you've signed in or filled out the form to watch a video, click "Watch Now" and the download links will appear under the video. com Nov 19, 2023 · The Global Superstore dataset provides a comprehensive glimpse into the retail landscape, encapsulated within an extensive Excel file featuring three distinct sheets: ‘Orders,’ ‘People The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. - lijesh010/GlobalSuperstoreSalesAnalysis The Global Superstore 2016 files are available for download under the training videos themselves, either as a data set or a workbook with starting state sheets build out. These insights will play a crucial role in guiding Consumer and product Analytics on Global Super Store Data. Feb 10, 2024 · In 2014, the Global Superstore experienced its most substantial profits from the United States, China, and India. This project is designed to present key information and trends to stakeholders, enabling informed decision-making. The dashboard presents detailed insights into business performance metrics, allowing for informed strategic decision-making. This is a practice project which I did to polish up my Excel skills. You signed in with another tab or window. Jul 9, 2021 · # Shape of data set superstore. Given the insights gained from the EDA, the superstore can choose to remove non-profitable products or invest in marketing efforts for products, segments and geographical areas that are driving their profit. The repository contains the following components: Global Superstore Data Visualization Using Tableau - jarrodtky/Superstore-Global_Visualization_Tableau The case includes three detailed tutorials that can be used by instructors in the classroom to introduce students to Tableau in the context of retail strategy and operations (using the Global Superstore dataset that is made available with Tableau). This project analyzes sales data from a global superstore to provide stakeholders with detailed insights into sales transactions. shape (9994, 13) # Summarised information of data set superstore. The final Nov 20, 2023 · Here are a few of the prerequisites for undertaking the Data Analysis on the Superstore Dataset using the Power BI project. This project focuses on creating interactive data visualizations for the Global Superstore Dataset to provide actionable insights for business decision-making. mnypwo zcmfj nrvdm vbixrmr zklr ugqeuu tjygh kdqfl byuhq kvhwix