Global superstore dataset github. GitHub community articles Repositories.

Global superstore dataset github. You signed out in another tab or window.

Global superstore dataset github. Global Store can maintain its position as a global leader in e-commerce by using these data to guide focused strategies in product diversification, market expansion, and logistics optimization. The Power BI report provides detailed visualizations to help stakeholders understand performance trends and optimize business strategies. The software I used is Power BI. 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. 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 Dataset for the Global Superstore. md at main · Ngozikah/Global_superstore_data This repository involves analyzing the Global Superstore dataset, which includes detailed international sales data. The three categories all account for over 30% of sales A comprehensive Power BI dashboard utilizing the Global Superstore dataset, providing robust and dynamic data visualizations. The dataset is often used by data analysts and data scientists to demonstrate data analysis, visualization, and machine learning techniques. This is a practice project which I did to polish up my Excel skills. I have used a little bit of DAX to create conditional columns Eg. Analysis of Global Superstore dataset. You switched accounts on another tab or window. This project is the final project of the 7th course "Advanced Data Modeling" of Meta Database Engineer Professional Certificate on Coursera. The Global Superstore is a retail dataset which contains an excel file with three sheets named as 'Orders', 'People' and 'Returns' over 4 years starting from 2012 till 2015 , covering orders of 147 countries around the world. 25M and loss of 0. In this repository, I have conducted an analysis of the Superstore dataset. It analyzes global sales, profitability & customer segmentation. frame. Aug 11, 2024 · Developed a BI solution to derive meaningful insights from the Global Superstore dataset. - lijesh010/GlobalSuperstoreSalesAnalysis The Global Superstore dataset is a popular sample dataset often used for data analysis and visualization exercises. 𝙆𝙚𝙮 𝙏𝙖𝙠𝙚𝙖𝙬𝙖𝙮𝙨: 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. 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. - GitHub - renjinirv/Global-superstore-analysis-dashboard: Here I have analysed a dataset of Global superstore and created visuals based in some questions related to it. About. You signed out in another tab or window. The Amazon Superstore Report based on the Global Superstore dataset will provide valuable insights into the business operations, sales performance, and market trends. - R_ExploratoryDataAnalysis/Dataset Global Superstore. Order ID: A unique identifier for each order. DataFrame'> RangeIndex: 51290 entries, 0 to 51289 Data columns (total 24 columns): # Column Non-Null Count Dtype --- ----- ----- ----- 0 Row ID 51290 non-null int64 1 Order ID 51290 non-null object 2 Order Date 51290 non-null datetime64[ns] 3 Ship Date 51290 non-null datetime64[ns] 4 Ship Mode 51290 non-null object 5 Customer ID 51290 non-null object 6 Customer Name GitHub is where people build software. Visualizations were created using Original dataset taken from Tableau public dataset website. 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. It is designed to help stakeholders make informed decisions based on the data from the Global Superstore. sql file creates the database and inserts data into the tables. The dashboard should include key metrics such as total sales, sales by product, sales by location, sales by customer segment, and sales by Contribute to gsayani058/Global-Superstore-dataset-analysis_BI development by creating an account on GitHub. 2. JuanDanielMarin / Global-Superstore Performed the data exploration and cleaning using SQL for a dataset about an e The dashboard is based on the Global Superstore Dataset, which contains a comprehensive set of data about the company's sales and operations, including information about sales by region, product category, and customer segment, as well as data on shipping costs, profits, and inventory levels. The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. This project provide a detailed report on sales transactions across branches worldwide. Global-Superstore---PowerBI-Sales-Dashboard. The dataset used in this Power BI project is stored in a spreadsheet and contains sales data from the store's branches worldwide. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. The report is structured into four pages, each focusing on specific aspects of the data to inform strategic business decisions. This Power BI dashboard comprehensively analyses the Global Superstore dataset, offering insights into sales, profits, and other key metrics. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the The Global Superstore Sales Analysis repository showcases a comprehensive Power BI dashboard that provides valuable insights into sales performance. It is an interactive dashboard made on Power BI Desktop using a dataset named Global Superstore 2016, different graphs and charts are used to represent the data to form the visualization - iamhudaib/Global-Superstore-2016 This is the Python version analysis approach, towards the legendary Sample Superstore Dataset with Pandas - leonism/sample-superstore The dataset includes retail store transactions for a global superstore at various levels of granularity- City, Region, Country, Product, Category etc. Available in csv, xlsx and sql format. The Superstore dataset is a collection of sales and customer information from an e-commerce superstore. The Global Superstore dataset consist of 20 columns and 51,281 rows. 🌍 Global Superstore Data Cleaning and Exploration. - Ajcr007/Tableau-Superstore-visualization Saved searches Use saved searches to filter your results more quickly Jul 17, 2024 · Global_SuperStore_Dataset_Analysis using Tableau. Introduction This project aims to analyze sales and consumer behavior using the Global Super Store dataset. Reload to refresh your session. png - PowerBI Dashboard snapshot/screen capture The dashboard is published at the following link on Microsoft PowerBI Workspace: You signed in with another tab or window. The dataset used for this project includes sales transactions from a global superstore, covering metrics like order quantity, sales, profit, and customer demographics. - niketsinghk/Global Data Visualization with Power BI on global superstore 2016 dataset - joadem25/global-superstore-2016. By exploring different aspects of the dataset, users can gain valuable insights into sales patterns, shipping costs, and geographic performance. I have used bar charts, donut charts, cards, column charts, and a few slicers for filtering the data. Categories and sub categories. xlsx at master · saulventura/BTYD Jun 25, 2023 · This is a PowerBI dashboard for visualizing a global superstore dataset. It includes definitions for the following tables: staging_superstore: A staging table we use to initially insert from the unnormalized dataset. 📜 Task: To draw conclusions from the dataset of customer retention and visually present the data analysis of churn. Order Date: The date when the order was placed. xls. com . The global superstore dashboard consists of various visuals to quickly understand the data and highlight vital information to enable users to make This project deals with a global retail store that ships products to various regions. • Data filtering- I The Board needs a hired Analyst to analyze the Global Superstore and draw out meaningful insight from the 15k+ superstore dataset that will aid management in making informed decisions to improve performance and profitability. 17M. Saved searches Use saved searches to filter your results more quickly Global_SuperStore_Dataset_Analysis using Tableau. 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 information such as sales, profit, product category, shipping methods, regions, cities, and more. Oct 2, 2024 · This Power BI report offers an in-depth analysis of the Global Superstore dataset, covering three key areas:. Aug 9, 2024 · This Power BI report analyzes the Global Superstore dataset, providing key insights into sales, profitability, shipping, and regional performance. My aim is to provide analyses that are easy to understand, aiding in making informed decisions and driving success. Crafted an insightful Power BI dashboard for 'GLOBAL-SUPER-STORE-2016' by analyzing e-commerce sales data. Retail dataset of a global superstore for 4 years. The data has 51290 rows, and 24 columns. --> In 2012 it was 2. Building dashboard to show market analysis for Global Superstore (open-sourced dataset) - budds98/PowerBIProject01_GlobalSuperstoreSalesAnalysis EDA is Exploratory and Explanatory Data Analysis. The goal is to provide actionable insights for business decision-making by analyzing global sales, profitability, customer segmentation, and geographical performance. This project involves a comprehensive analysis of the Global Superstore dataset, which includes data on sales, profits, customer demographics, and geographical information. Download and open the Power BI file (Global An Interactive Dashboard using Power Desktop on Global Superstore Dataset collected from Kaggle. The CEO believes that the future success of the company depends on: • An improvement in inventory management focused on products that generate higher profits for the company. The analysis and visualizations provided in this project aim to offer stakeholders a comprehensive understanding of Global Superstore's sales data. pbix - PowerBI Dashboard file Global-Superstore---PowerBI-Sales-Snapshot. This is a detailed analysis on customer behavior analysis. - MmaAdeola/Superstore-sales-analysis The schema. Explore insightful dashboards, charts, and graphs that provide deep insights into sales trends, product performance, regional analysis, and more. 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. Ship Date: The date when the order was About. This report analyzes various aspects of the dataset to The Amazon Superstore Report based on the Global Superstore dataset will provide valuable insights into the business operations, sales performance, and market trends. This analysis was conducted as a task assigned by Vikot Solutions limited. - calfav/GLOBAL-SUPERSTORE-ANALYSIS Using Global Superstore dataset with 5-year data from operational systems, the project is to design a data model using Dimensional Modelling and Bus Matrix Architecture. Before analyzing the data Oct 9, 2022 · You signed in with another tab or window. I downloaded the Global Superstore Orders 2016. 20M. - VysakhM7/Global-Superstore This repository is about designing a database model for Global Super Store. Create Dashboards in Tableau to visualize and analyse a) The sales performance of the store The dashboard is based on the Global Superstore Dataset, which contains a comprehensive set of data about the company's sales and operations, including information about sales by region, product category, and customer segment, as well as data on shipping costs, profits, and inventory levels. It has a large range of products that has been subdivided into categories and subcategories. The Global Superstore dataset is a sample dataset that contains sales and order data for a fictional global retail company that sells office supplies, furniture, and technology products. This rich dataset enables analysts to perform a wide range of analyses, including: Sales Analysis: Analysts can examine Introduction Welcome to the "Global Superstore Data Analysis" project! This repository contains a comprehensive data analysis and visualization project using Power BI, focusing on the Global Superstore dataset. Global Superstore Report. The dataset is in a CSV format with 51,290 observations and 24 features. Global Super Store from Kaggle. Details are given by country, region, and city, as well as by product category and sub-category. This repository contains the Power BI Dashboard project that I created using the Global Superstore dataset. Here is a dashboard I've created for a telecom client as a part of a Virtual Internship on Power BI from PwC Switzerland in the Data Analytics Virtual Case Experience offered by Forage. We are going to perform the following tasks: 1. 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. Saved searches Use saved searches to filter your results more quickly Problem Statement : Global Superstore has been going through loss in the products sold. csv at main · anwarraif/R_ExploratoryDataAnalysis Here is the dataset of a store, which has branches all over the world. Connecting Database with Power BI Desktop; Analyzing the tables and relations Analysis of the Global Superstore dataset using Power BI. 1. GitHub community articles Repositories. . Power BI dashboards can be a helpfull tool to provide insights into sales performance and trends of an organization. Identify Market as well as country wise loss & find products in which sub-category are in loss in those countries. 'Year'. Identify clusters of Customers using Unsupervised Machine Learning Algorithms. The platform allows users to explore sales and profit data across different product categories, filter data by specific categories, and visualize trends. 📊 Project Overview This project involves cleaning and exploring the Global Superstore dataset using SQL to extract key insights. This project provides a detailed report on sales transactions across branches worldwide. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. As issues are created, they’ll appear here in a searchable and filterable list. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the Global Super Store mainly stores data about the orders which have been made by customers. Dive into dynamic visualizations for sales, profit, and quantity across regions, categories, and customer segments. The analysis aims to uncover insights into sales performance, customer behavior, product trends, and other key business metrics using Power BI. Issues are used to track todos, bugs, feature requests, and more. This dataset represents a fictitious retail store with a global footprint, providing This is a practice project which I did to polish up my Excel skills. The SuperStore Dataset 2019-2022 contains 9,994 sales records across 19 fields, detailing orders, customers, products, and financial metrics, providing insights into regional sales, product categories, and customer behavior. - sgr-m/globalsuperstore-data-analytics Global Superstore Power BI. Measuring Customer Lifetime Value through Buy Till You Die (BTYD) model - BTYD/Global Superstore 2018. The objective was to empower small sellers with data-driven insights, facilitating informed business decisions. In this project, I conducted a simple sales analysis by year and region using a global_superstore_2016 dataset Resources Global Superstore is a global online retailer based in New York, boasting a broad product catalog and aiming to be a one-stop-shop for its customers. To get started This is proper analytics of Global Superstore dataset. We all use the online global store for shopping , so i m very curious to In this project, I have analyzed an open-source dataset (Global Superstore Dataset) and build two interactive dashboards one is for sales analysis and another is for profit analysis which shows all Dec 5, 2023 · Global-SuperStore Dataset Analysis Overview. Topics Global Super Store dataset. Superstore Data Analysis and Visualization This project provides an interactive data analysis and visualization platform for the Global Superstore dataset using Streamlit. This project’s data is open source, it is the Global Superstore dataset obtained from Kaggle. I have performed the basic data cleaning Dataset. The project includes descriptive analysis of the products sold along with their visualizations. html in your browser to view the visualization. The dataset is a Global Superstore dataset based on sales and was found on Kaggle. The data can be accessed via this link. Goals: Show the main insights of the company in Brazil. It includes various visualizations to help stakeholders analyze and understand key aspects of the business. Global Superstore SQL Queries. sql. Our main KPI's for this Dataset were that of Total Sales, Profit and Quantity. An analysis of the global superstores dataset. - jamal022/Global-Superstore <class 'pandas. Product-Based Analysis; Customer-Based Analysis; Region-Based Analysis Open the file Global_Superstore_Sales_Story. The dataset comprises records from various countries, focusing on product sales, profitability, and customer behavior - Ngozikah/Global_superstore_data The dataset comprises records from various countries, focusing on product sales, profitability, and customer behavior - Global_superstore_data/README. This Tableau dashboard was created using the Sample Superstore dataset. Global Super Store mainly stores data about the orders which have been made by customers. The objective of this dashboard is to provide the organization with a visual representation of real-time sales data, ultimately enhancing productivity and decision Data Visualization of Global Superstore dataset using Tableau Desktop - rishabhxshukla/Global-Superstore-Data-Analysis Project about data analysis and science of real dataset of Superstore includes techniques of data filtering and cleaning and preprocessing. In this project I will describe the analysis process I conducted using a Global Superstore’s dataset. The visualization is a Tableau Story, so view the story points by clicking on the captions provided at the top of the visualization. This report analyzes various aspects of the dataset to extract meaningful insights. - Vishnup211/SuperStore_DataSet Feb 26, 2024 · Welcome to my journey through the Global Superstore dataset! Here, I delve deep into the data, extracting valuable insights and uncovering trends. The GitHub repository for the Global Store Sale Analysis Report contains files related to the analysis of sales data for Global Superstore. The dashboard is interactive and allows users to filter data by year and region, while dynamically Global_SuperStore_Dataset_Analysis using Tableau. This project focuses on creating interactive data visualizations for the Global Superstore Dataset to provide actionable insights for business decision-making. The dashboard presents detailed insights into business performance metrics, allowing for informed strategic decision-making. The findings provide insights into sales trends, regional performance, and other critical business metrics that can help improve strategic decision-making and business operations. The research, which focuses on significant markets, product performance, and operational efficacy, can help Global Store determine its strategic course. Visualizations and insights are included to aid decision-making. This project focuses on performing network analysis of the Global Superstore Dataset using various network metrics, community detection techniques & visualization tools. 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. 68M with Profit margin of 0. pdf: This file contains report from the analysis. - GitHub - shalusam07/Global-Superstore-Dashboard-PowerBI: Welcome to the Power BI project for the global store dataset! Here 1) Data Cleaning was done 2) Sales Analysis on Regional Basis was done - uttamkumar49438/Global-Superstore-Dataset-in-Power-BI This repository contains a comprehensive analysis of the Global Super Store dataset. Jun 14, 2024 · The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. 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 The dataset is a Global Superstore dataset based on sales and was found on Kaggle. This repository houses a collection of Tableau visualizations created using the Superstore dataset. Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. The dashboard includes key performance indicators (KPIs), interactive visualizations, and filtering options to allow users to explore data at various levels of granularity. - prince989278/Gl Jun 20, 2023 · Developed a comprehensive dashboard using flexdashboard in R programming language to analyse and visualize sales data for Global Superstore dataset. - BismaYB/Global-super-store-Sales-Analysis This project focuses on creating interactive data visualizations for the Global Superstore Dataset. Analysis Dataset. Saved searches Use saved searches to filter your results more quickly This repository contains the Power BI Dashboard project that I created using the Global Superstore dataset. The goal is to uncover insights into product-customer relationships, identify key nodes, & optimize the Global Superstore's operations by leveraging the power of network analytics. Here's a breakdown of each column: Row ID: A unique identifier for each row in the table. The dataset covers sales, customer segments, regional data, and more, allowing for in-depth analysis of store performance and customer trends. 26 M with profit of 0. Contribute to Anneybear/Data-Analysis-of-a-Global-Superstore development by creating an account on GitHub. This project focuses on creating a robust database management system that facilitates efficient handling of various aspects of an online store, from product inventory to customer orders. Tasks- We have a dataset pertaining to the sales of an online global superstore. Nov 5, 2024 · Contribute to LAIJUKL/global-superstore-dataset development by creating an account on GitHub. You signed in with another tab or window. This corporate style viz is a different take on the classic Tableau Superstore data set. Global Superstore Power BI. I am asked as a data analyst to analyze and draw out meaningful insight from the Superstore dataset which would aid management in making informed decisions to improve performance and profitability. columns with information about orders placed in the Amazon Global Superstore. The Retail dataset of a global superstore for 4 years is downloaded from kaggle which sells furniture, office supplies and technology related stuff. Here is the dataset of a store, which has branches all over the world. The objective is to extract actionable insights that can help in strategic decision-making and optimizing business operations. This project gives a detailed insight to the global superstore making it easier to understand. Adopted dimensional modelling principles along with the bus matrix architecture, to allow accuracy and flexibility. pbix: This file contains the data visualization of this project and as seen on the documentation as well. --> In 2013 , Total sales if of worth 2. Saved searches Use saved searches to filter your results more quickly It is used for data analysis, visualization, and predictive modeling. xlsx onto my desktop. The SuperStore Database Management Project (DBMD) is a comprehensive solution designed to streamline and optimize the operations of an e-commerce business. core. The Global Super Store is a retail dataset which contains 51,290 values over 4 years, starting from January 2011 till January 2015, covering orders of 147 countries around the world. Contribute to pgensler/Global-Superstore-Analysis development by creating an account on GitHub. Contribute to myakalrugved20/Global_SuperStore_Dataset- development by creating an account on GitHub. It include various visualizations to help stakeholders analyze and understand key aspects of the business. This README provides a summary of what I did and the purpose behind this analysis. Jul 25, 2024 · This project focuses on building a comprehensive dashboard for the Global SuperStore dataset. The dataset of Global Superstore typically includes information such as customer demographics, product details, sales transactions, shipping details, and geographic information. This project is designed to present key information and trends to stakeholders, enabling informed decision-making. Then, conducting five ETL workflow on SSMS to transfer data to data warehouse. Contribute to azhar2ds/DataSets development by creating an account on GitHub. Superstores industry comprises of companies that operateby having large size spaces which store and supply large amounts of goods. update: SQL file of superstore has been improved with name new_superstore. welcome to the power BI project for the global superstore dataset. Global Superstore Data Visualization Using Tableau - jarrodtky/Superstore-Global_Visualization_Tableau GitHub community articles Superstore-Global_Dataset. - GitHub - Manojrk12/Global-superstore-Dataset: The Global Superstore dataset contains sales transactions from a fictional retail company, featuring attributes like Order ID, Order Date, Customer details, Product information, and financial metrics (Sales and Profit). This repository involves analyzing the Global Superstore dataset, which includes detailed international sales data. Here I have analysed a dataset of Global superstore and created visuals based in some questions related to it. This project aims to understand the purchasing behaviors of customers and different products. I have also included a clear button for removing all the applied filters. Nov 24, 2023 · Let’s dive into the insights that shape the future of global retail! My Dashboard I used a dataset from Kaggle to create a professional and impactful dashboard. Global The superstore's clientele, hailing from 147 different countries, can browse through an endless offering with more than 10,000 products. Personal Project. The Global Superstore Dashboard is a dynamic dashboard design that highlights sales and profits for a global store with multiple sites. Contribute to Naufkg/Global-Superstore-Dataset-Dashboard development by creating an account on GitHub. sample dataset. 31M and loss of 0. It generally includes the following key fields: Order ID: Unique identifier for each order. The stakeholders require the detailed report on their sale transaction. It offers multiple interesting dimensions to explore like order priority, product category, ship mode, location details, product segment and time series information. The visualizations and analysis derived from the report will enable data-driven decision-making and aid in identifying areas for improvement and growth opportunities. sql: This file contains the queries used for this project and as seen on the documentation as well. - ogochukwu/Global-Superstore-Analysis In this I will analyze the global superstore dataset using python - GitHub - ANP-Oxy/Global-Superstore-Exploratory-data-analysis-project: In this I will analyze the global superstore dataset using python Contribute to MunnaDas/Global-Superstore-Dataset- development by creating an account on GitHub. The dashboard provides in-depth analysis and visualizations to gain insights into various aspects of the business. The repository includes a Tableau file with visualizations and dashboards, a python script for cleaning and preprocessing the dataset, and a written report summarizing key findings and recommendations. Contribute to himanshu049/globalsuper_store development by creating an account on GitHub. - GitHub - Shayanyde/Global-Superstore-Sales: This is a PowerBI project which aims to clean and analyze the global superstore dataset from Kaggle and then present all the findings in an insightful dashboard using PowerBI. Global Superstore Dataset Global Store Performance - This dataset is about the global store where they have a list of products, segments, cities, countries, and shipment details. The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. It provides a comprehensive analysis of sales, profit, and order metrics across various categories, regions, and time periods. This project contains sql statements that includes the process of Data Warehousing and Data Mining - yannie28/Global-Superstore Discover actionable insights with this Power BI dashboard on the Global Superstore dataset. jcf mhgfl olgr hcdyt dik vyb rgjfz yliyai xhe slysv