Superstore dataset analysis tableau excel The primary objective of this analysis is to delve into the Superstore data and extract meaningful insights that will help us construct a compelling and informative story for all stakeholders involved. If you’re interested to The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8. By analyzing customer data from across the platform, the data store can provide valuable insights into consumer preferences and buying habits. Superstore Sales Analysis with Tableau📊🚀 Melvin Agastin 5mo Nov 29, 2020 · Let’s first build the dataset. I did Exploratory data analysis on Sample Superstore Dataset using Python, Tableau, Excel, SQL and R All the tools will give us same output but we have to know when to use which tool. A list of tasks will be answered followed by the query Nov 11, 2023 · Our analysis in question will be carried with Excel, SQL and finally Tableau. This report analyzes various aspects of the dataset to extract meaningful insights. We look deeper at the state-specific sales by density mapping and identify that the highest sales (in dollars) are in California and New York. The SuperStore dataset comprises a comprehensive sales record from a superstore, containing 9,994 entries across 19 distinct fields. The sample data we’ve provided is designed to be a foundation for building your own healthcare insurance claim datasets. Excel will serve as first repository for our data, SQL will give meaning to our data and Tableau will give a clear face to our data. Understanding the logic : Jan 9, 2023 · I went to Kaggle to find a dataset where I could create the project from start to finish using Excel. For this purpose, we will use the superstore Dataset that we will blend with the polygonic dataset (we will make it polygonic !). Nov 14, 2019 · Here we are analysing the super store excel data set . Jan 11, 2023 · These are only Excel files @Dianne Venable (Member) , you could just as easily update the data in them to suit your needs. The result file is attached. Excel will serve as first repository for our data, SQL will give meaning to our data and Tableau will give a clear Mar 1, 2023 · The first 5 rows and 7 columns of our dataset. Dataset is fairly small and after giving the dataset a quick look in Power Query, I decided to work with Excel and Tableau only for this dataset. Okay, let’s perform an exploratory data analysis with our input on the superstore dataset. This electric blue and black dashboard illustrates sales for each year in the Superstore data set, and the user may select particular years for further investigation. We removed all the data from it that is not required and added the « Link » column in the superstore data table. I’ve analyzed the same dataset in Tableau. A concept related to what makes up a row is the idea of aggregation and granularity, which are opposite ends of a spectrum. I downloaded the Global Superstore Orders 2016. 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. Sample super store The dataset used for this analysis is the Sample Superstore dataset, which includes sales, profit, order, and customer data from 2014 to 2017 across different regions in the United States. The dataset contains three tables: Orders: Detailed transaction data including Sales, Profit, Quantity, and Customer details. A table was created by performing a query (shown in the file SQL query). You signed in with another tab or window. This database can be described by the following ER Diagram:. By thoroughly examining the data, we aim to gain a deeper understanding of the store's performance and identify key areas for improvement and May 26, 2017 · This is my attempt to visualize the Sample Super Store Dataset by Tableau. Feel free to add more rows to suit your specific use case or dataset requirements. In previous article we use the text file . This corporate style viz is a different take on the classic Tableau Superstore data set. there. The following sales performance analysis will follow the 6 steps of Data Analysis which are: Ask, Prepare, Process, Analyze, Share and Act. Please tell the steps The top 10 customers by Sum of Sales represent ___ of the total profits. There are a few different sample data sets offered by Tableau to practice with, and superstore is only one of them :) You can of course fish around on data. The data has 51290 rows, and 24 columns. 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 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. xlsx onto my desktop. This includes the state, region, order date, shipping date, product ordered etc. Tableau's powerful visualization capabilities make it easier to identify trends, patterns, and actionable insights. Analyzing the sales data of a store like Superstore using Tableau can provide valuable insights for decision-making across various operational, marketing, and strategic areas. You switched accounts on another tab or window. Reload to refresh your session. Data Analysis Exercise using SQL, Tableau and Excel. The project analyzes the Superstore sales dataset in Tableau, showcasing key insights through a variety of chart types, custom calculations, and interactive features for an in-depth exploration of data trends and patterns. The Olist Data Store is designed to help businesses make more informed decisions about their products and marketing strategies. Nov 11, 2023 · Our analysis in question will be carried with Excel, SQL and finally Tableau. The dataset includes order details, anonymized customer information, product specifics, and financial metrics. Or at least from this repo here: Datawonders | Superstore Datasources These are all localised versions of Superstore Sales released with Tableau v2022. You signed out in another tab or window. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. And as a special treat, I have also added the localised workbooks created by the Tableau teams ready for you to play with. Right here. Interactive Dashboard 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. Just over 541,000 rows of sales data with the following fields: InvoiceNo — Unique Identifier under which multiple items can be purchased May 15, 2022 · The dataset that I’ve used here is the Superstore dataset that is publicly available and everyone might be aware of. I needed to do a small calculation about product This is a practice project which I did to polish up my Excel skills. world as Steffan mentioned above, however you'll have to create an account/profile, etc. refers to how multiple data values are brought together into a single value, such as counting all the Google searches for Pumpkin Spice or taking the average of all the temperature readings around Seattle on a given day. The dataset of choice was the Superstore Sales dataset. Nov 9, 2023 · Data Set Overview. This project provides an interactive analysis of Superstore sales data using Tableau, offering insights into sales performance, customer behavior, and market trends to help optimize business strategies. The dataset contains customer order details for a superstore over a period of four years, from 2018 to 2021. But, if it is of interest, in October last year, I extracted all the 2022 versions for the different locales and published them to Datawonders . The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the 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. It includes 15 Dashboards story telling about different KPIs. Do you know what is the license of Superstore dataset? Who is the owner, if it allowed to use it in research etc. Aggregation. Apr 18, 2024 · Today I had sometime on my hand and I decided to play around with a publicly available dataset, Superstore Sales, available on Tableau Public website. 1. Regards Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. No harm if you intend to keep using it regularly anyways! Hope this helps, Katie Feb 17, 2023 · The data for this analysis was sourced from the Sample Superstore dataset in tableau. mzfbqw bxq zufai pfsl lagf ucvxb qgp kwwvq xuklt rffqu