Global superstore dataset analysis

Global superstore dataset analysis. shape (9994, 13) # Summarised information of data set superstore. Notably, the United States contributed 52. The dataset of Global Superstore typically includes information such as customer demographics, product details, sales transactions, shipping details, and geographic information. Using DAX and calculated columns, these analyses provided insights into various aspects of the superstore's operations. Sales and Profit are Moderately Correlated; Discount and Profit are Negatively Correlated; Overall Analysis. Learn more. Import and… Data set Analysis using MS Excel and built-in functions and features of Excel. Ship Date: Date when the order was shipped. xlsx onto my desktop. Global Superstore’s clientele, hailing This repository contains a comprehensive data analysis and visualization project using Power BI, focusing on the Global Superstore dataset. This project analyzes sales data from a global superstore to provide stakeholders with detailed insights into sales transactions. 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. New users can take advantage of the Sample datasets provided by Tableau to experiment and experience various operations and functionality offered by the platform. Categories and sub categories. May 23, 2024 · The Global Super Store Analysis project provides a clear understanding of business performance across various dimensions. 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 analyzes global sales, profitability & customer segmentation. 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. 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. You signed in with another tab or window. - 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. This is a practice project which I did to polish up my Excel skills. global super store analysis & prediction. This article is structured in 4 main parts. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. 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 includes the state, region, order date, shipping date, product ordered etc. The project utilizes a combination of Python, SQL, and Power BI to clean the data, perform exploratory analysis, and create interactive reports. A comprehensive Power BI dashboard utilizing the Global Superstore dataset, providing robust and dynamic data visualizations. frame. 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. Ship . Reload to refresh your session. All the material can be found here. We also wrote a homework assignment with detailed solutions. The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. The Global Superstore dataset is a popular sample dataset often used for data analysis and visualization exercises. info() <class 'pandas. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. The three categories all account for over 30% of sales Mar 30, 2022 · Analysis from Heatmap. 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. This project focuses on creating interactive data visualizations for the Global Superstore Dataset to provide actionable insights for business decision-making. It generally includes the following key fields: Order ID: Unique identifier for each order. I downloaded the Global Superstore Orders 2016. You switched accounts on another tab or window. The analysis includes data cleaning, segmentation of visuals by country, region, and market, shipping analysis, and comprehensive sales reports by geography. It includes various visualizations to help stakeholders analyze and understand key aspects of the business. 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. Jul 9, 2021 · # Shape of data set superstore. 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. You signed out in another tab or window. Dataset and use case presentation Data analysis : 1. Each segment has a dedicated dashboard page that addresses the business intelligence questions raised. core. - 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 · As part of a comprehensive data analysis project, I embarked on the exploration of a Global Superstore dataset from the year 2016. This project is designed to present key information and trends to stakeholders, enabling informed decision-making. 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. 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. Order Date: Date when the order was placed. The dashboard presents detailed insights into business performance metrics, allowing for informed strategic decision-making. The software I used are SQL server and Power BI. 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. See full list on github. 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. The data has 51290 rows, and 24 columns. 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. 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. Feb 10, 2024 · In 2014, the Global Superstore experienced its most substantial profits from the United States, China, and India. 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). avhx wumjy lrm bojmcl vumn cnt ommk inpyzb ocdkg uaz