Superstore dataset analysis tableau excel. xls dataset, data cleaning and quickly .
Superstore dataset analysis tableau excel AYN superstore is located in the United States of America This project analyzes return data from a fictional Superstore to identify the causes of high return rates. Measures are quantitative values that can be aggregated using sum/averages etc. Sample super store This is a practice project which I did to polish up my Excel skills. May 27, 2023 · LETS GET STARTED!!! You can take a look at the entire visualization here. This article focuses on the 14 Best Tableau Datasets for Practicing Data Visualization, essential for helping you gain valuable experience. You switched accounts on another tab or window. The left plane will feature the… Excel dashboard created with Tableau's superstore dataset - Matt-Mike/Excel-Superstore-Sales-Dashboard Superstore, a fictional retail entity in the U. Data Exploration: Conducted exploratory data analysis (EDA) using Tableau to uncover patterns, trends, and correlations in the data, leveraging interactive visualizations and dashboards. DATA ANALYSIS PROCESS. Each dataset has been explored and visualized to uncover patterns, trends, and key insights. world as Steffan mentioned above, however you'll have to create an account/profile, etc. Using calculated fields, functions & filters in Tableau, performed Exploratory Data Analytics & Data Visualization via 16 Information Dashboards. Lists. The dashboard is interactive and allows users to filter data by year and region, while dynamically About. Jun 27, 2024 · Here is a preview of the inventory records dataset: To practice data analysis with this inventory records dataset in Excel, you can complete the following tasks: Task 1: Calculate the turnover rate (units sold/stock-in) for each product. Open Tableau. A table was created by performing a query (shown in the file SQL query). In this post, I’ll detail a great example of a dashboard built by Jana Barková . This is based on the retail dataset who Oct 30, 2020 · Let’s connect the Superstore dataset into tableau. An interactive dashboard was developed to compare product sales & profits for segments in different European Countries. The Thank you Adam, for some reason the Sample - SuperStore Data in my organizations' Tableau installation does not match up with the data being provided in the tutorials. The following sales performance analysis will follow the 6 steps of Data Analysis which are: Ask, Prepare, Process, Analyze, Share and Act. Netflix Dataset - Viewing Trends and Ratings Feb 1, 2022 · 11. The start page gives you several options to choose from: 1. Try Tableau for free. The sample data we’ve provided is designed to be a foundation for building your own healthcare insurance claim datasets. Superstore Dataset - Sales and Profit Analysis 3. Tableau is one of the most powerful data visualization tools on the market. 4 - Join & Blend - Join = Category & Sales Connect with your customers and boost your bottom line with actionable insights. tds files. Loading Library and Importing Dataset into R Studio. ) and dive in! To go along with this release, we’re launching the Maven Toys Challenge and giving away a free all-access membership to the winner. Color code the chart to identify Categories and Segments that are above or below target. The Global Superstore dataset consist of 20 columns and 51,281 Succeed now with the tools you need to make data actionable. A concept related to what makes up a row is the idea of aggregation and granularity, which are opposite ends of a spectrum. Feb 23, 2023 · The superstore dataset was downloaded from kaggle using phyton, furthermore, library for deep analysis of this project used pandas, matplotlib and seaborn. shape (9994, 13) # Summarised information of data set superstore. Search for workbooks that are on a topic you're interested in, browse for inspiration, then download the workbook to access the data. 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. The first thing you see after you open Tableau Desktop is the Start page (Link opens in a new window). This tutorial video is hands on tableau demo on how to create interactive dashboard on sample superstore dataset. I'm using Tableau Public so I don't have it in the "My Tableau Repository" folder. Open the Tableau Workbook: Double-click on Superstore sales analysis. Product performance. Source: Kaggle: Dataset (xlsx) Eurovision 1998 to 2010 Sep 11, 2023 · And for the analysis as a data analyst, tools such as Tableau, Excel and SQL will be utilize for the sales analysis. 3 - Join & Blend - Category & Sales & Sales Target Book 3. to_excel(‘data_olist_RFM. Just over 541,000 rows of sales data with the following fields: InvoiceNo — Unique Identifier under which multiple items can be purchased 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. g. Processed & cleaned the data-set using Excel formulas & functions. It includes various visualizations to help stakeholders analyze and understand key aspects of the business. Mar 16, 2019 · I actually googled your first question and found this Tableau Sample Questions with Sample Superstore data which looks close. The Superstore dataset has 9994 transitional records and 21 attributes. xls Bird Strikes. Aggregation. A book is a concept with attributes such as author, title, and genre. The following COVID-19 data visualization is representative of the the types of visualizations that can be created using free public data sets. How Whole Foods created a data-driven culture across 460 stores. Understanding the logic : Jan 17, 2021 · The Super Store dataset contains data on order details of customers for orders of a superstore in the US. superstore-sales-analysis Analysis of sales performance using Tableau and the Superstore dataset. This project is on sales analysis of a Brazilian e-commerce platform called Olist Stores. The dataset contains customer order details for a superstore over a period of four years, from 2018 to 2021. Do you know what is the license of Superstore dataset? Who is the owner, if it allowed to use it in research etc. This helps a bunch! Expand Post This is a comprehensive data analysis initiative designed to optimize store operations through advanced data analytics. Data Analysis Exercise using SQL, Tableau and Excel. Dec 16, 2023 · Analyzing sales data from the Superstore Sales Dataset using SQL (MySQL) and Tableau involves several steps. However, I am noticing some discrepancies in terms of what the tutorial is showing verus what I am seeing on screen. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the 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. 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) This is a practice project which I did to polish up my Excel skills. Welcome to Data Analysis with Tableau, the seventh course in the Tableau Business Intelligence Analyst Professional Certificate series. May 15, 2022 · The dataset that I’ve used here is the Superstore dataset that is publicly available and everyone might be aware of. DataFrame'> RangeIndex: 9994 entries, 0 to 9993 Data columns (total - GitHub - owaiz99/Zomato-Restaurants-Analysis-using-Excel-Sql-PowerBI-and-Tableau. - EU-Superstore/Sample - EU Superstore. rfm_df. 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. It includes 15 Dashboards story telling about different KPIs. See how this supermarket chain uses Tableau to create a single source of truth across all stores, transforming and improving the company’s everyday approach to customer experience and operations. Feel free to add more rows to suit your specific use case or dataset requirements. About. Go to /Documents/My Tableau Repository/Datasources/version number/[language]. 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. S. The Superstore This repository contains visualizations and insights derived from three distinct datasets using Tableau. Flow Chart by Kelechi Uzoukwu Apr 3, 2018 · 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. Is it possible to get the version of the superstore dataset that the tutorials SQL Microsoft Excel Microsoft Power Bi Tableau Super store data analysis project. 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. Data Preparation: Preprocessed and cleaned the Sample - EU Superstore dataset to handle missing values, outliers, and data inconsistencies. Tableau icon. For this purpose, we will use the superstore Dataset that we will blend with the polygonic dataset (we will make it polygonic !). Explore it and a catalogue of free data sets across numerous topics below. Feb 17, 2023 · The data for this analysis was sourced from the Sample Superstore dataset in tableau. csv is in the same directory as the Tableau workbook. xls and . Developed a Tableau dashboard utilizing the Sample Superstore dataset. After downloading the dataset, we inspected it to identify any missing or inconsistent Dec 2, 2024 · Sample-Superstore. No harm if you intend to keep using it regularly anyways! Hope this helps, Katie Place the Dataset: Ensure that Superstore sales dataset. Tableau is also capable of connecting to more data sources beyond Excel. It involves a variety of techniques from statistics, computer science and This project focuses on creating interactive data visualizations for the Global Superstore Dataset to provide actionable insights for business decision-making. - rubythedev/superstore-return-analysis Exploratory Data Analysis of a sample Superstore dataset using excel and tableau - sparshmishraa/Retail-Sales-Analysis Sep 29, 2023 · Here are the top 10 data analysis projects in the retail sector, along with source links to free datasets you can use for your analysis: Practice Your Data Analysis Skills as a Superstore Data Analyst Sample Superstore Dataset | Kaggle Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Microsoft SQL Server (SQL) - used as the primary tool for data analysis. During our initial assessment, we observed that the columns “Row ID+O6G3A1:R6”, “Order ID”, “Order Date”, “Ship Date”, “Ship Oct 30, 2023 · Many classes can be followed in this pre-employment program, I joined the class to learn data analysis using Excel and Tableau. xls dataset, data cleaning and quickly All the tools will give us same output but we have to know when to use which tool. twb to open the Tableau workbook. Quickly spot increases or decreases in sales, profit ratio, and shipping time, and switch to the Prescriptive tab to pinpoint the root cause. In this project, I am working with a dataset of Superstore, aiming to answer 30 scenario-based questions through data visualization and analysis using Tableau. Nov 9, 2023 · Data Set Overview. The process for this analysis includes; Business questions Dataset containing Sales & Profits of a Superstore Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Tableau's powerful visualization capabilities make it easier to identify trends, patterns, and actionable insights. Please tell the steps The top 10 customers by Sum of Sales represent ___ of the total profits. Mar 30, 2022 · Analysis from Heatmap. x versions. • olist_sellers_dataset - This dataset includes data about the sellers that fulfilled orders made at Olist. May 18, 2023 · The first chart here shows the city with the highest sales record. You signed in with another tab or window. Blend the data with the Saved Sample - Sales Target data set to bring in the Sales Target measure. Here’s a general guide on how to approach this task: Step 1: Data Import and Database Dived deeply into the overall sales and profitability for the firm and determined crucial areas for enhancement with different plotting methods Book 3. Leverage interactive features for actionable insights and strategic decision-making. Upon examining the dataset, we find fields such as Category, City, Country/Region, Customer ID Nov 9, 2021 · Data Pane: The data shows all the columns in the data source. Regards Nov 14, 2019 · Here we are analysing the super store excel data set . 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. Published: May 26, 2017 Updated: Apr 22, 2023 Apr 13, 2023 · Used Tools: Tableau; Python; Excel; Exploratory Data analysis: I have used Excel and conducted analysis on the dataset. xlsx Data Blending File One. Dimensions and measures can be dropped onto the Filter Pane to filter data based on selection. twbx: The Tableau Workbook containing the work done A multi-table data set for the reality TV show The Great British Bake Off, with data on the contestants, bakes, and episodes. Features: a) Divide the dashboard into two planes. The description of data is as follows: "Global Superstore is a customer-centric dataset, which has the data of all the May 4, 2023 · We downloaded the Superstore dataset from Kaggle, which is a free and open-source platform for data analysis. - WuCandice/Superstore-Sales-Analysis May 23, 2024 · The Global Super Store Analysis project provides a clear understanding of business performance across various dimensions. Multiple analysis tasks are carried out on the dataset, ranging from descriptive analysis to forecasting and predictive analysis. Super Store Sales Analysis. In this first week, we introduce you to the Tableau Data Analysis Process framework. In this project, I analyzed a dataset from Tableau of a retail company. A Tableau Analysis Report of the Olist Store. Before we go ahead into our analysis proper, we would be loading the library, importing the Superstore Sales (Excel). This excel file has three sheets named as Orders, People, Returns. Use the Saved Sample – Superstore dataset. Through these analyses, we aim to empower the Superstore's stakeholders with valuable insights, enabling them to make informed business decisions and drive the store's success to new heights. Sales, profits, shipping modes were analyzed on country, state and regional bases. If this answers your question please mark as Best Answer or if helpful please Upvote. Source: Kaggle: Dataset (xlsx) Eurovision 1998 to 2010 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. One of the assignments in my class was to create an interactive • olist_products_dataset - This dataset includes data about the products sold by Olist. My main goal was to extract some quick insights regarding the company's sales from the dataset using Excel. 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. First, I imported my data into BigQuery. If you’re interested to With the information provided below, you can explore a number of free, accessible data sets and begin to create your own analyses. Try Tableau for Free; Buy Tableau Now I am going through the good tutorials that Tableau has provided with the superstore dataset. com/RavulakolluNarender/EDA-on-Samp Nov 21, 2024 · In the next section, the article delves deeper into setting up RFM Analysis in Tableau. Perform ‘Exploratory Data Analysis’ on dataset ‘SampleSuperstore’ As a business manager, try to find out the weak areas where you can work to make more profit. 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. Explore sales and profit distribution by state, track monthly sales by segment, and assess total sales by location and manager. A top 10 ranking What is Data Analysis?Data Analysis is the process of inspecting, cleaning, transforming and modeling data to discover useful information, draw conclusions and support decision making. Data sources: Data is sourced from the Superstore dataset, which includes information on sales, profits, and customer segments. This is the second tableau project for practice that you can use to prepare for your interview, resume, and profiles. Dataset (zip) Data dictionary (pdf) Netflix Movies and TV Shows: Tv shows and movies available on Netflix as of 2019. xlsx Olympic Athletes. The data has 51290 rows, and 24 columns. The result file is attached. analysis project focusing on a dataset from a fictional superstore. This database can be described by the following ER Diagram:. info() <class 'pandas. 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. https://bit. See its possibilities in a demo presentation we have put together using European Superstore Data. It provides a comprehensive analysis of sales, profit, and order metrics across various categories, regions, and time periods. Buy Tableau today Open Tableau Desktop and begin. Nov 28, 2019 · Download Power BI Sample Data Set for practice purpose, Power BI SuperStore, Map & Time Series Data Set excel sheet are available. This corporate style viz is a different take on the classic Tableau Superstore data set. Find and fix vulnerabilities Codespaces. 2 - Join & Blend - Category & Sales Book 3. The Technology category and Phones subcategory lead in sales, while This Tableau Superstore Sales Dashboard provides a detailed analysis of sales dynamics. The dataset, containing information about 27k games, was downloaded from Kaggle and was added by Nik Davis in 2019. Mar 23, 2022 · => 4 Sale datasets (I am going to split them into 5 different dataset like 2014–2015–2016–2017 sales data) the reason why we are working like this is that every year we are going to have 1 This example shows how to connect to Sample - Superstore data in Tableau Desktop. Sample - Superstore for Tableau 9. The superstore dataset is a great learning tool for any Tableau user. Reload to refresh your session. Understanding RFM Analysis in Tableau. Personally, I don't like posting answers to questions like this because then if someone is doing an exam or certification then it's not a test of Tableau knowledge, but how to use Google properly Using Tableau, Story has been created to solve the global superstore case study. The dataset of choice was the Superstore Sales 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. Overall sales. Create a bullet chart with Category and Segment dimensions and Sales measures. xlsx onto my desktop. Sales and Profit are Moderately Correlated; Discount and Profit are Negatively Correlated; Overall Analysis. This is the flow in flow chart. 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. By analyzing customer data from across the platform, the data store can provide valuable insights into consumer preferences and buying habits. Weekday Vs Weekend (order_purchase_timestamp) Payment Statistics Number of Orders with review score 5 Jun 9, 2023 · Link to access the Excel file for the dashboard: Excel — Superstore Analysis Sales Performance Dashboard From the dashboard above, we can gain a clear understanding of several key insights: Oct 29, 2023 · Cleaning the Columns. Export data to excel, so we can move forward to the EDA and Visualization process by using Tableau. Tableau Public (Link opens in a new window): Tableau Public is an amazing resource for Tableau-friendly data sets. Nov 8, 2024 · As I browsed through Tableau Public dashboards using the Superstore dataset, I noticed that many focus solely on providing an executive snapshot — highlighting top-level metrics like sales Analysis Tasks. This project enhanced my skill development and proficiency in excel. For this project, I used Google BigQuery. I used SQL to clean the data. Here, you select the connector (how you will connect to your data) that you want to use. This corporate style viz is a different take on the classic Tableau Superstore data set. 1. xls Sample - Superstore for Tableau 8. As a part of EDA, I have used the replace feature that exist in Excel and This is a sample superstore dataset, a kind of a simulation where you perform extensive data analysis to deliver insights on how the company can increase its profits while minimizing the losses. 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. xls • Dataset Type: Excel Data • Dataset Size: 20k Jan 9, 2023 · I went to Kaggle to find a dataset where I could create the project from start to finish using Excel. Zomato Dataset - Bengaluru Restaurants Analysis 2. 1 Dataset Details:- • Domain: Retail • Datasets: Superstore. - Power BI Docs Jan 9, 2024 · This data set is a spreadsheet in Excel with three tables: orders, returns, and people. Starting with raw Excel data, we used Tableau to make four great-looking dashboards on. We removed all the data from it that is not required and added the « Link » column in the superstore data table. Identify Market as well as country wise loss & find products in which sub-category are in loss in those countries. core. 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. 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. Superstore Sales Analysis with Tableau📊🚀 Melvin Agastin 5mo Nov 29, 2020 · Let’s first build the dataset. ly/3i4rbWlLink for dataset Mar 12, 2023 · Tableau is a data analysis and visualization tool that enables users to connect, visualize and share data in an easy-to-understand and meaningful way. Tutorial: Get Started with Tableau Desktop - Tableau . This report provides an in-depth analysis of the company's performance from 2019 to 2022, highlighting key areas of strength and potential opportunities for growth. xlsx : The dataset used for this project. Then apply conditional formatting to highlight products with the highest and lowest turnover rates. She uses a simple an effective color palate to convey KPI performance over an array of dimensionalities. EU Superstore data was analyzed and visualized. It's a Business ready Dashboard that allows employees to make data-driven decisions by evaluating each Metric. I then removed the Postal_Code column because it had mostly Null values and it is irrelevant to my analysis. Learn more About the data set. May 12, 2023 · Excel is a spreadsheet business application used to store, organize, and track data sets, whereas Tableau is a business intelligence software that leverages visual analytics to help users analyze data for insights beyond the data volume limits of Excel. If you are reading this, hopefully you will find this to be helpfu Hi everyone, does enyone know where to find (or can provide me) the dataset "Sample - Superstore Sales" that comes with the Version 7 of Tableau?. xls World Bank Indicators. I imported the global superstore dataset into Tableau. Total Transaction Gap between States is Very High and Avg Freight Value is more Expensive outside Sao Paulo Consumer and product Analytics on Global Super Store Data. I needed to do a small calculation about product 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. : This project involved analyzing Zomato restaurant data using advanced Excel functions and SQL queries, and creating interactive dashboards using Power BI and Tableau. xlsx Data Blending File Two. xlsx’, index=False ) Exploratory Data Analysis and Visualization. Mar 1, 2023 · The first 5 rows and 7 columns of our dataset. Or at least from this repo here: Datawonders | Superstore Datasources These are all localised versions of Superstore Sales released with Tableau v2022. python data-science machine-learning anaconda numpy excel office pandas data-visualization data-analysis matplotlib arima furniture prophet statsmodels spyder itertools time-series-analysis time-series-forecasting superstore Performed Data Analysis on a UK-based online retail store data-set. A Tableau Project. To accomplish this project, Tableau‘s Superstore sample dataset is utilized. 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. Tableau will automatically connect to the dataset and load the visualizations. The analysis and visualizations provided in this project aim to offer stakeholders a comprehensive understanding of Global Superstore's sales data. I downloaded the Global Superstore Orders 2016. In previous article we use the text file . xlsx Orders-With Nulls. 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 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. xls at master · ARAPIL/EU-Superstore Dec 11, 2022 · The dataset used in this project was downloaded from the tableau community. 1. On the start page, under Connect, click Microsoft Excel. 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. By exploring different aspects of the dataset, users can gain valuable insights into sales patterns, shipping costs, and geographic performance. , specializes in furniture, office supplies, and technology products. You signed out in another tab or window. Tools Used: Tableau Public 2023. E-commerce analysis in Tableau: A Practical Jul 9, 2021 · # Shape of data set superstore. Using Tableau, visualizations highlight patterns in returns by product category, region, and season, leading to actionable recommendations for minimizing returns and enhancing operational efficiency. Okay, let’s perform an exploratory data analysis with our input on the superstore dataset. Developed Walmart Retail Data Dashboard which tracks the Profit, Sales and Discount in different categories. there. Which contains the . 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. - Nrj27/Sample-Superstore-Dataset-Analysis This Tableau dashboard was created using the Sample Superstore dataset. 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. xlsx May 26, 2017 · This is my attempt to visualize the Sample Super Store Dataset by Tableau. The questions below use the dataset Sample - Superstore Subset (Excel), which is included in Desktop 8. In 2012 Q4 with $510 was the highest quarterly A multi-table data set for the reality TV show The Great British Bake Off, with data on the contestants, bakes, and episodes. Identify Profit Centre. 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. The dataset contains three tables: Orders: Detailed transaction data including Sales, Profit, Quantity, and Customer details. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Azure Data Studio - used to host MSSQL; Microsoft Excel - Data cleaning, Data Analysis; Tableau - Create Dashboard Report A Time Series Analysis and Forecasting, using ARIMA and Prophet models, on a superstore dataset. It is a sample dataset for the United State Superstore Sales. Bookshop consists of 13 tables, combined in the following manner: Note: A central concept for this data set is the idea of a book versus an edition. Problem Statement : Global Superstore has been going through loss in the products sold. This includes the state, region, order date, shipping date, product ordered etc. It is a dynamic dashboard. The data pane has dimensions which are qualitative and descriptive data for example – Customer name, Segment etc. SQL queries were written and executed to extract, manipulate, and analyze the data stored in the "Superstore" table (database). 3 e. Links:GitHub Repository: https://github. 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. This GitHub repo showcases my analysis of Valve's Steam game store using Tableau for viz, MS Excel for cleaning, & MySQL. Right here. It was observed that as at the time of publishing this data set New York City has the highest total number of sales record with May 6, 2021 · This dataset is perfect for applying your data exploration, analysis, and visualization skills to a real world business scenario, so fire up your favorite BI tools (Excel, MySQL, Power BI, Tableau, etc. . In the Open dialog box, navigate to the Sample - Superstore Excel file on your computer. The main objective is to find insights and patterns in data that can help with operations, corporate decisions and scientific research. Learn more Nov 18, 2023 · This visualization project aims to analyze a fictitious superstore’s sales performance between 2016 and 2019 using Microsoft Power BI. 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 . )-->en_US-US. frame. Instant dev environments For Superstore data, the actual file can be found in the folder My Tableau Repository --> Datasources-->Folder Version (2020. The left plane will feature the company logo, interaction controls, and Jun 7, 2023 · Excel, which is a versatile and widely tool was used to carryout this analysis. Superstor_Analysis_project. The Olist Data Store is designed to help businesses make more informed decisions about their products and marketing strategies. Using Microsoft Excel, Power BI, Tableau, and SQL, this project aims to enhance decision-making by providing valuable insights into sales trends, customer behavior, and inventory levels. And as a special treat, I have also added the localised workbooks created by the Tableau teams ready for you to play with Super Sample Superstore. I’ve analyzed the same dataset in Tableau. In this project I have selected the best chart for visualizing each question and explain each question based on the chart selection and its visualization. To analyze and derive insights to answer crucial questions and help the store make data driven decisions. Not Another Superstore! Tired of Superstores and Tables in the East? Looking for other cool & interesting datasets? Look no further! Below is a compilation of all of the cool and interesting datasets that I have found since joining Tableau. Jul 28. It analyzes global sales, profitability & customer segmentation. This comprehensive guide is essential for effectively preparing, analyzing, interpreting, and communicating data. ecv sacexi fvauwo skpwz rvfcoyr xsmn ucwhiq ngurrc lldoz slsbhdm