Global superstore dataset The Global Superstore dataset consist of 20 columns and 51,281 rows. xlxs; Time Series sample data. The dataset is in a CSV format with 51,290 observations and 24 features. Category, City, Country, Customer The Amazon Superstore Report based on the Global Superstore dataset will provide valuable insights into the business operations, sales performance, and market trends. You signed in with another tab or window. The columns Using the Order worksheet from the Global Superstore dataset, design a dashboard with the following 4 components. OK, Got it. The data comprises sales data for three product categories: Furniture, Office Supplies, and Technology Analyzing the Global Superstore 2016 dataset, including steps like data cleaning, data preparation and finally visualizing the data using various charts and graphs displaying an interactive PowerBI dashboard. Sep 11, 2022 · The Global Superstore dataset is data from a global retail chain that sells office supplies, Furniture and Technology Stuff. Top. The Dashboard provides actionable insights on sales by country, category and sub-category. "Global Superstore is a customer-centric dataset, which has the data of all the orders that have been placed through different locations all around the world, starting from 2012 till 2015" We will use the follwing process-flow to guide us through the project: 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,’ and This project uses the Global Superstore dataset, which is open source and available on Kaggle. Understanding the logic : The Global SuperStore Dashboard is a comprehensive business intelligence tool that provides valuable insights into sales performance and customer behaviour. I've created an impactful dashboard using the Global Superstore dataset. Focus sur les USA. Long-Term-Unemployment-Statistics. superstore_df. Nov 19, 2023 · The next step in performing EDA on the Superstore dataset using Power BI is to connect to your data source. 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. To view the statistical description of the dataset, use the describe() method. The order of the components indicates their importance, which should be reflected in the emphasis they are given by their placement on the dashboard. The “Sample-Superstore” file (excel) needs to be linked with the “Global Superstore Returns” file (a text file). Although this dataset is primarily for 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. You can try searching for the "Global Superstore 2017. Blame. The report includes product-based, customer-based, and region-based analyses. The dataset is in CSV format, comprising 51,290 observations and 24 features. Nov 23, 2023 · Introduction: Welcome to the Global Superstore Dashboard! H ere, I uncovered the symphony of global commerce through data analysis. Oct 30, 2022 · "Retail dataset of a global superstore for 4 years" and "easy to understand and is self-explanatory. Join me on a journey through 72 countries, 359 orders, and a About. Ship Date: Date when the order was shipped. Nov 28, 2019 · Global Super Store Dataset. describe() Mar 23, 2022 · This is how my dataset looks like. In the real world, you will most likely be connecting to databases; however, working with Excel files is similar – sheets in Excel are treated similarly to tables in a database. update: SQL file of superstore has been improved with name new_superstore. It provides a comprehensive analysis of sales, profit, and order metrics across various categories, regions, and time periods. Exploratory Data Analysis(EDA) Exploratory Data Analysis (EDA) is a crucial step in our approach to the Global Superstore dataset. The dataset It equips the leadership of Global Superstore with the insights necessary to make informed decisions with the goal of enhancing overall performance and profitability. 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). It includes details about orders This repository houses a collection of Tableau visualizations created using the Superstore dataset. Becoming really familiar with the structure and content of the superstore dataset is like learning the Rosetta Stone of Tableau. 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. Description contains the count of features, mean of them, Standard deviation, minimum and maximum values in that particular attribute, 25%, 50%, 75% of the values in the dataset. This is a detailed analysis on customer behavior analysis. You switched accounts on another tab or window. sql: This file contains the queries used for this project and as seen on the documentation as well. As I browsed through Tableau Public dashboards using the Superstore dataset, I noticed that many focus solely on providing an executive snapshot — highlighting top In the “Getting Started” tutorial. Mar 30, 2022 · View the statistical description of the Dataframe. 1. - yy Feb 6, 2024 · The global superstore sales dataset used for this project is publicly available on Kaggle. The document appears to be an order data table containing order details like order ID, date, ship date, ship mode, and customer ID for various orders. This project provide report of sales transactions, shipping trends, and market analysis . I downloaded the Global Superstore Orders 2016. This project focuses on identifying profitable and unprofitable products and regions, assessing shipping costs and discounts, and generating actionable insights for management. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. The platform allows users to explore sales and profit data across different product categories, filter data by specific categories, and visualize trends. The data has 51290 rows, and 24 columns. Import and… Problem Statement : Global Superstore has been going through loss in the products sold. The dataset is a Global Superstore dataset based on sales and was found on Kaggle. Where can I find the global super store. Oct 2, 2024 · This report provides a general overview of Global Superstore's sales, profitability, and customer performance. - Ajcr007/Tableau-Superstore-visualization Superstore Data Analysis and Visualization This project provides an interactive data analysis and visualization platform for the Global Superstore dataset using Streamlit. This project provide a detailed report on sales transactions across branches worldwide. Dataset and use case presentation Data analysis : 1. I need this for the purpose of learning This project is about designing a database model for Global Super Store to store their data and do some data analysis in order to achieve business goals. Before analyzing the data The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. It has a large range of products that has been subdivided into categories and subcategories. The Power BI report provides detailed visualizations to help stakeholders understand performance trends and optimize business strategies. Consumer and product Analytics on Global Super Store Data. From this screen, we can select which tables (in this case, sheets) that we want to use in our analysis: This project deals with a global retail store that ships products to various regions. The three categories all account for over 30% of sales This notebook is a processed version of the Global SuperStore dataset. Learn more Aug 26, 2024 · The Global Superstore Dashboard provides a 360-degree view of overall store sales performance. Exploring Worldwide Retail Trends: Global Superstore Dataset. The objective of this dashboard is to provide the organization with a visual representation of real-time sales data, ultimately enhancing productivity and decision Performed the data exploration and cleaning using SQL for a dataset about an e-commerce store to provide answers for smart business questions. For this project, we will utilize a superstore dataset which can be downloaded from here. Code. From where to Download "Global Superstore 2016. The Global Superstore dataset is data from a fictional global retail chain that sells office supplies. Here is the dataset of a store, which has branches all over the world. In this Case-Study we have seen the top 4 markets, In my role as a Data Analyst for Global SuperStore, a prominent multinational online retailer serving customers worldwide, I was tasked with creating a Sales Dashboard in Excel. Power Bi project showcasing for global superstore dataset. It analyzes global sales, profitability & customer segmentation. The software I used is Power BI. It include various visualizations to help stakeholders analyze and understand key aspects of the business. The software I used are SQL server and Power BI. shape (9994, 13) # Summarised information of data set superstore. This dataset contains information about an online store that sells furniture, office supplies, and tech items. - Releases · AnjanaAbY/Global-Supersore-PowerBI The primary objective of this POWER BI project is to gain valuable insights into Global Superstore’s performance. Zero to Data Viz dashboard example using the 2016 Global Superstore dataset from Tableau. The dashboard should include key metrics such as total sales, sales by product, sales by location, sales by customer segment, and sales by Join me live as I take you through a detailed tutorial on how to prepare charts in PowerBI. It includes various visualizations to help stakeholders analyze and understand key aspects of the business. This article is structured in 4 main parts. Some possible sources include data repository websites, academic institutions' databases, and platforms that provide sample datasets for learning and practice. May 15, 2022 · The dataset that I’ve used here is the Superstore dataset that is publicly available and everyone might be aware of. The dashboard is interactive and allows users to filter data by year and region, while dynamically Kaggle is the world’s largest data science community with powerful tools and resources to help you achieve your data science goals. Power BI dashboards can be a helpfull tool to provide insights into sales performance and trends of an organization. All the material can be found here. It include various visualization helps to stakehol Dec 14, 2024 · How to Interact with the Workspace Elements in Tableau Superstore Dataset? After the Workspace for Tableau Superstore Dataset opens up, you can view various attributes included in the Dataset, such as Location information, Product Category information, Profits, Discounts, Sales, Profit Ratio, Region, Quantity, etc. The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. Apr 8, 2019 · Topic: Data Analytics and Business IntelligenceCourse: Management Information System (MIS)Adjunct Professor: Sultan M ShahedData Source: TableauDashboard: ht #PowerBI #DataVisualization #DashboardDesign #BusinessIntelligence #RetailAnalytics #GlobalSuperstore #DataAnalysis #PowerBITutorial #DataInsights #Interacti The Global Superstore dataset. To ensure data accuracy and Dataset for the Global Superstore. Visualizations and insights are included to aid decision-making. Data Cleaning Process: The dataset was downloaded from the Kaggle website into an excel spreadsheet for analysis. frame. The Global Superstore data set has around 50000 records, and it is a customer-driven informational dataset that contains comparative data of orders placed through various sellers and markets from 2011 to 2014. Nov 29, 2020 · 2)Using Global Superstore, identify the Sub-Categories where Top 20 Customers that have Sales more than the other Sub-Categories in the same Region. File metadata and controls. The project includes descriptive analysis of the products sold along with their visualizations. " I found that to not always be the case. Nov 29, 2020 · Let’s first build the dataset. From sales trends to geographical patterns, this Power BI dashboard brings data to life, offering a dynamic and The dataset of Global Superstore typically includes information such as customer demographics, product details, sales transactions, shipping details, and geographic information. JuanDanielMarin Jul 9, 2021 · # Shape of data set superstore. This project contains sql statements that includes the process of Data Warehousing and Data Mining - yannie28/Global-Superstore Nov 27, 2023 · Product Categories and Sales Distribution: The Global SuperStore dataset highlights three primary product categories — Furniture, Office Supplies, and Technology. In this project I will describe the analysis process I conducted using a Global Superstore’s dataset. There's information about the order itself such as the customer who made the order, the product requested by the customer and its quantity, the cost which the customer have to pay, and information about shipping. Saved searches Use saved searches to filter your results more quickly This repository contains a comprehensive data analysis project on the Global Superstore dataset. Available in csv, xlsx and sql format. This rich dataset enables analysts to perform a wide range of analyses, including: Sales Analysis: Analysts can examine Oct 23, 2023 · In this article I will describe the analysis process I conducted using a Global Superstore’s dataset. Explore and run machine learning code with Kaggle Notebooks | Using data from Global Super Store Dataset Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Kaggle is the world’s largest data science community with powerful tools and resources to help you achieve your data science goals. Global Superstore. Here's an overview of the steps I covered:1️⃣ Connected the database with Power BI De global super store analysis & prediction. I need this for the purpose of learning See full list on github. Welcome to our exciting new video, where we unveil an awe-inspiring Global Superstore dashboard created in Power BI. xl spread sheet to download . The data had 18 columns and 9800 rows. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. This is because it is a mimic of a real-life Store dataset. Consumer and product Analytics on Global Super Store Data. The dataset includes retail store transactions for a global superstore at various levels of granularity- City, Region, Country, Product, Category etc. It is designed to help stakeholders make informed decisions based on the data from the Global Superstore. The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. Dataset d'environ 50000 lignes sur les commandes passées auprès de différents fournisseurs et marchés mondiaux entre 2011 à 2015. We are going to create 7 datasets from this one big dataset. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. This project involves several stages, including ETL (Extract, Transform, Load) using Power Query, data modelling, DAX calculations, and data visualization. Discover actionable insights with this Power BI dashboard on the Global Superstore dataset. For this purpose, we will use the superstore Dataset that we will blend with the polygonic dataset (we will make it polygonic !). 17. The visualization is a Tableau Story, so view the story points by clicking on the captions provided at the top of the visualization. Reload to refresh your session. - BismaYB/Global-super-store-Sales-Analysis global super store analysis & prediction. Published: Dec 22, 2019 Kaggle is the world’s largest data science community with powerful tools and resources to help you achieve your data science goals. xls / . xlxs; Global Super Store Dataset; Global Super Store Dataset 2016; Map sample Data. This dataset contains the below columns. This tutorial video is hands on tableau demo on how to create interactive dashboard on sample superstore dataset. 4 MB. - niketsinghk/Global The Global Superstore Dataset for Power BI | Community | Dataset #1In this video, I'm giving a full tutorial on how connect to the The Global Superstore Data The dataset used for this project includes sales transactions from a global superstore, covering metrics like order quantity, sales, profit, and customer demographics. I have attached the data set below for the above questions This Power BI dashboard comprehensively analyses the Global Superstore dataset, offering insights into sales, profits, and other key metrics. Explore insightful dashboards, charts, and graphs that provide deep insights into sales trends, product performance, regional analysis, and more. This corporate style viz is a different take on the classic Tableau Superstore data set. - lijesh010/GlobalSuperstoreSalesAnalysis Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. This interactive masterpiece allows you Mar 16, 2019 · 3. Published: Jan 14, 2019 Updated: Nov 21, 2022 Aug 2, 2023 · The global superstore is a fictitious company that specializes in the sales of office supplies, furniture, and products of technology. It's the final project of the 7th course Advanced Data Modeling of Meta Database Engineer Professional Certificate on Coursera. The dashboard presents detailed insights into business performance metrics, allowing for informed strategic decision-making. Explore and run machine learning code with Kaggle Notebooks | Using data from Superstore Dataset Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Our main KPI's for this Dataset were that of Total Sales, Profit and Quantity. Navigate to and open the Global Superstore Orders 2016 Excel file: After connecting to the data source, you will be taken to the Data Source screen. It operates as an online marketplace and delivers products This is a practice project which I did to polish up my Excel skills. Notably, the Technology Global Superstore Dataset. It generally includes the following key fields: Order ID: Unique identifier for each order. Using Global Superstore, identify the Sub-Categories where Top 20 Customers that have Sales more than the other Sub-Categories in the same Region. xlsx at master · saulventura/BTYD Global Superstore Dataset - Data - Free ebook download as Excel Spreadsheet (. Global Superstore SQL Queries. xls. 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 is the Python version analysis approach, towards the legendary Sample Superstore Dataset with Pandas - leonism/sample-superstore Click to share on Twitter (Opens in new window) Click to share on Facebook (Opens in new window) Click to share on WhatsApp (Opens in new window) Mar 18, 2022 · In this article, we will use the superstore dataset, to analyze sales performance throughout the years and business growth opportunities both from the company and customer perspective. It enables businesses to make data-driven… Dec 20, 2022 · This research used the global superstore dataset of Tableau community that is a publicly available open dataset. "Global Superstore is a customer-centric dataset, which has the data of all the orders that have been placed through different locations all around the world, starting from 2012 till 2015" We will use the follwing process-flow to guide us through the project: 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,’ and. Jun 9, 2022 · The Global Superstore dataset is quite popular for newbies. 3)Using Global Superstore, identify the Regions where Top 20 Customers that have overall Profit Ratio (Profit as % of Sales) which is double the Profit Ratio of other Customers in the Region. The document contains sales data with categories, cities, countries, customer names, and markets for various sales. Measuring Customer Lifetime Value through Buy Till You Die (BTYD) model - BTYD/Global Superstore 2018. sql. xlsx" file on websites that offer datasets and resources for analysis or research purposes. Explore and run machine learning code with Kaggle Notebooks | Using data from Global Superstore Dataset Global Superstore Dataset | Kaggle Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Order Date: Date when the order was placed. The Super Store dataset contains data on order details of customers for orders of a superstore ie; chain of multiregional stores under a brand globally. This report analyzes various aspects of the dataset to extract meaningful insights. A US Map showing Profit by State. xlsx), PDF File (. We removed all the data from it that is not required and added the « Link » column in the superstore data table. This dataset provides information related to sales orders. Open the file Global_Superstore_Sales_Story. html in your browser to view the visualization. This project aims to understand the purchasing behaviors of customers and different products. The result file is attached. You signed out in another tab or window. A comprehensive Power BI dashboard utilizing the Global Superstore dataset, providing robust and dynamic data visualizations. xlxs; Quick start with below links. info() <class 'pandas. Its users can view both hig This project focuses on creating interactive data visualizations for the Global Superstore Dataset to provide actionable insights for business decision-making. The project includes data cleaning, transformation, and exploratory data analysis (EDA) using MySQL Mar 24, 2023 · GLOBAL SUPERSTORE EXCEL SPREEDSHEET. View raw (Sorry about that, but we can’t show files that are this big right now Explore and run machine learning code with Kaggle Notebooks | Using data from Global Superstore Dataset Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. The data can be accessed via this link. Dec 8, 2023 · Overview: The Global Superstore dataset serves as the canvas for our exploration. Raw. Apr 27, 2022 · At the menu, connection to the dataset, data cleaning with Power Queries, Exploratory data analysis, then a bit of dashboard design. You can access the dataset here. pdf: This file contains report from the analysis. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the Dec 4, 2022 · Kali ini saya akan menjelaskan sebuah visualisasi data dan analisis data terhadap dataset Global Superstore tahun 2012-2015. Dive into dynamic visualizations for sales, profit, and quantity across regions, categories, and customer segments. Power BI Desktop/ Service tutorial; DAX functions; Power BI Visualizations; Hope you enjoyed the Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. This project’s data is open source, it is the Global Superstore dataset obtained from Kaggle. txt) or read book online for free. Apr 17, 2022 · Or copy & paste this link into an email or IM: You signed in with another tab or window. Nov 15, 2024 · This project performs a data analysis on a global store dataset containing sales details across various branches worldwide. A Line Chart showing the sales by month. This includes the state, region, order date, shipping date, product ordered etc. - ogochukwu/Global-Superstore-Analysis welcome to the power BI project for the global superstore dataset. But the provided and downloadable Superstore Returns file only generates a red exclamation point once connected, and does not link to the “Sample-Superstore” file like in the training. Global Superstore Report. Hypothetically headquartered in Memphis TN, Global Super Stores (GSS Jun 20, 2023 · Developed a comprehensive dashboard using flexdashboard in R programming language to analyse and visualize sales data for Global Superstore dataset. pbix - PowerBI Dashboard file Global-Superstore---PowerBI-Sales-Snapshot. Identify Market as well as country wise loss & find products in which sub-category are in loss in those countries. Dataset tersebut tersedia secara gratis dan dapat diunduh pada link ini… The Global Superstore dataset is a popular sample dataset often used for data analysis and visualization exercises. An Interactive Dashboard using Power Desktop on Global Superstore Dataset collected from Kaggle. We also wrote a homework assignment with detailed solutions. => 4 Sale datasets (I am going to split them into 5 different dataset like 2014–2015–2016–2017 This project’s data is open source, it is the Global Superstore dataset obtained from Kaggle. All the official Tableau help guides are based on this as it’s of of the most common data sources structures, works with every function in the tool, and is the cleanest you’ll ever see. pbix: This file contains the data visualization of this project and as seen on the documentation as well. xlsx - Free ebook download as Excel Spreadsheet (. 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. xlsx onto my desktop. pdf), Text File (. AmazingMartEU2Geo. Dataset containing Sales & Profits of a Superstore. Oct 29, 2023 · We thought that the best place to start answering these questions would be the dataset of superstore. png - PowerBI Dashboard snapshot/screen capture The dashboard is published at the following link on Microsoft PowerBI Workspace: Original dataset taken from Tableau public dataset website. Learn more. This project is designed to present key information and trends to stakeholders, enabling informed decision-making. The aim is to provide a detailed report of the sales data, segmenting by location (country, region, market) and analyzing various aspects like shipping mode, sales by city, state, region, and market. xlsx" data source file to work on tableau desktop ? Data Source The dataset used in this project, Global Superstore, is a popular open dataset often used for retail analysis, containing information on sales, products, customers, and shipping across different geographies. Dec 22, 2019 · Superstore Specialist - Dashboarding Details . Global Superstore Power BI. From setting up your data sources to creating visually appealing Saved searches Use saved searches to filter your results more quickly Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. core. DataFrame'> RangeIndex: 9994 entries, 0 to 9993 Data columns (total Analysis of the Global Superstore dataset using Power BI. • Data filtering- I Global Super Store mainly stores data about the orders which have been made by customers. Nov 8, 2024 · My own Superstore Dashboard. com 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. SuperStoreUS-2015. Categories and sub categories. The visualizations and analysis derived from the report will enable data-driven decision-making and aid in identifying areas for improvement and growth opportunities. It offers multiple interesting dimensions to explore like order priority, product category, ship mode, location details, product segment and time series information. 2. This Tableau dashboard was created using the Sample Superstore dataset. Strategic users can use it to quickly check KPIs with respect to different attributes. Connecting Database with Power BI Desktop; Analyzing the tables and relations Global Superstore Data Visualization Using Tableau - jarrodtky/Superstore-Global_Visualization_Tableau Global-Superstore---PowerBI-Sales-Dashboard. zwo kwd shx jcx ndqw zbwiax dpue nbmbzqiv kpodecd mgtyby