Understanding Tableau Superstore Dataset: 4 Important Points

on BI Tool, Sales Dashboard, Tableau, Tutorials • May 5th, 2021 • Write for Hevo

Most organizations store the data they generate during their daily operations. Analyzing this data to extract crucial information is becoming an important part of the decision making process. Tableau is a perfect tool to leverage Business Intelligence and perform an in-depth and insightful analysis of this data. New users can take advantage of the Sample datasets provided by Tableau to experiment and experience various operations and functionality offered by the platform. Tableau Superstore Dataset is one such sample dataset that can be used to try out functionally pertaining to analysis of Sales data of a business. 

In this article, you will learn about Tableau Superstore Dataset, steps to connect Tableau to the sample dataset, various methods to interact with the elements of the dataset and visualize them in the workspace. You will learn about procedures to create a Geographical Map view and set up a Sales Dashboard using this sample dataset. 

Table of Contents 

Introduction to Tableau 

Tableau Logo - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Tableau is a tool which is used for applications related to Business Intelligence and Data Visualization. This can help you extract important insights by analyzing the data and providing objective measurements to support and help in strategic decision making for a business..

The platform supports as easy to learn user interface and additional functionalities to collaborate with other employees in the organisation. The user can get data from multiple sources and perform analyses on the aggregated data. Tableau is helping industries to reduce the analysis time and provides functionalities while ensuring flexibility, security and reliability.

Official documentation of Tableau can be found here.

Key Features of Tableau 

  • Multiple Integrations: It houses support for numerous integrations and connectors for increased functionality and compatibility with various data sources.
  • Easy User Interface: It hosts an easy to use and easy to learn user interface to perform complex data transformations without programming know-how. 
  • Real-Time Dashboards: It has the ability to create and host interactive real-time dashboards highlighting KPIs and data visualizations. 
  • Gather Insights: It helps users convert their queries and questions into visualizations and objective metrics.
  • Multi-Platform Accessibility: It has a provision to access dashboards and reports on multiple devices such as mobile, web and desktop. 
  • Visual Customisations: There is a huge selection of visual customisations and templates that users can utilize to highlight and analyse critical business data. 

Understanding Tableau Superstore Dataset 

Tableau Superstore Dataset is a sample Dataset provided by Tableau for new users to learn and experiment with different offerings and functionalities available in Tableau. The vast dataset provides a base to interact with Dashboard, drill down in the specifics of Data handling and providing samples for performing Data transformations.

The sample Dataset includes data for the Sales of multiple products sold by a company along with subsequent information related to geography, Product categories and subcategories, sales and profits, segmentation amongst the consumers etc. This sample Dataset presents a common use case for Tableau, in which the users are interested in gathering useful insights from the Sales data in order to improve on the Marketing and Sales strategies. New users can learn regarding various operations and elements in Tableau using this sample Dataset and following the numerous tutorials available online. 

Procedure for Connecting with Sample Tableau Superstore Dataset

Connecting Dataset- Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 1: You can start by opening up a new instance of Tableau or toggling the start page by clicking on the Tableau icon. 

Step 2: You are required to make a selection under the Connect pane. This can be used to connect to databases other than the sample dataset such as Excel files, PDF files, CSV files etc. or connect to the external live connections to the Databases. 

Step 3: Reach out to Sample Workbooks to connect to the Sample Datasets and resources provided by Tableau. 

Step 4: Under the Saved Data Sources, click on the Sample- Superstore to access the sample dataset. The first window with the workspace area will look as follows: 

Workspace - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Interacting 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. Now you can start interacting with this data by first creating a Chart View to visualize various attributes. 

Tableau Superstore Dataset Part 1: Building a View 

Step 1: You can start by dragging the attribute of your choice to the columns shelf in the workspace area to represent it on the X axis on the charts.

Step 2: You can proceed to add the attribute of your choice to the rows shelf on the workspace by dragging it from the left pane to represent it on the Y axis on the charts. 

Line Chart Illustration - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 3: This will create a Line Chart as depicted above, you can modify the details of the chart by changing the setting in the Marks area on the left side of the workspace. 

Tableau Superstore Dataset Part 2: Refining the View

Since you have created your first Chart view using the YEAR and Sales attributes in the dataset, you can further refine this view by including other data and giving more context to the visualised information.

Step 1: You can start by adding additional dimensions and metrics to the Columns Shelf of the workplace. For example you can include both YEAR and Category attributes in the Columns Shelf to categorise the visualised data further. 

Modification of View - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 2: You can also add attributes from the left pane to the View by just Double clicking on the attribute. Tableau automatically makes the assumption of showcasing that data in either Columns or Rows Shelf. This procedure will help you get the right amount of detail in your Data Visualization. 

Subcategories effect - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Simplify your Tableau Data Analysis using Hevo’s No-code Data Pipelines

Hevo Data, a No-code Data Pipeline helps to transfer data from 100+ sources to a Data Warehouse/Destination of your choice and visualize it in your desired BI tool such as Tableau. Hevo is fully managed and completely automates the process of not only loading data from your desired source but also enriching the data and transforming it into an analysis-ready form without having to write a single line of code. Its fault-tolerant architecture ensures that the data is handled in a secure, consistent manner with zero data loss.

It provides a consistent & reliable solution to manage data in real-time and always have analysis-ready data in your desired destination. It allows you to focus on key business needs and perform insightful analysis using a BI tool of your choice.

Check out what makes Hevo amazing:

  • Secure: Hevo has a fault-tolerant architecture that ensures that the data is handled in a secure, consistent manner with zero data loss.
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects schema of incoming data and maps it to the destination schema.
  • Minimal Learning: Hevo, with its simple and interactive UI, is extremely simple for new customers to work on and perform operations.
  • Hevo Is Built To Scale: As the number of sources and the volume of your data grows, Hevo scales horizontally, handling millions of records per minute with very little latency.
  • Incremental Data Load: Hevo allows the transfer of data that has been modified in real-time. This ensures efficient utilization of bandwidth on both ends.
  • Live Support: The Hevo team is available round the clock to extend exceptional support to its customers through chat, email, and support calls.
  • Live Monitoring: Hevo allows you to monitor the data flow and check where your data is at a particular point in time.

Simplify your data analysis with Hevo today! Sign up here for a 14-day free trial!

Understanding Filters using Tableau Superstore Dataset

Filter and Colours can be a useful way to include and exclude crucial information in Big Datasets. For example, showcasing Sales of different products with different colours, including data from a certain location to check for customer trends etc. 

Step 1: You can start by right-clicking on an attribute on the left pane and selecting Show Filter.

Different Filters - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 2: This will showcase the options of various filters on the right side of the workspace and showcase above. You can use the checkboxes to implement your desired filters on the dataset. 

Step 3: Colours can be added into the visualisation by dragging the desired attribute to the Color option in the Marks Card. The desired colours can be selected by clicking on the colors option and the effects will be implemented like the one shown below. 

Different Colours - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Creating Geographical Map View using Tableau Superstore Dataset

The Tableau Superstore Dataset provides information pertaining to Region and Location of the Sales including Country, State, City, Postal Code. With the Sample Dataset, new users can learn about using the Geographical Map View feature offered in Tableau which can help in visualizing the Geographical data, region wise and analyse the data in a granular manner.

Step 1: You are required to start by creating a New Worksheet for the Map View. Firstly, click on the New Worksheet icon at the bottom of the workspace. 

Creation of Map View - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 2: For this sample dataset you can double click on the State attribute and it will automatically be mapped on to the workspace. The Latitude and Longitude conversion from the State attribute will automatically be performed by Tableau. The points will be mapped as shown below: 

Data on Georgraphical View - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 3: You can drag other attributes such as Region to the Filters shelf to implement desired filters. For example, choosing a specific region will zoom the map into that region and showcase more granular data. 

Step 4: You can also introduce various colours and gradients to make the visualisations more attractive and pleasing to look at. You can drag the Sales attribute to Colours on the Marks shelf to differentiate different regions with varying Sales performance.  

Zoomed in Map - Tableau Superstore Dara
Image Source: https://www.tableau.com/about/

Setting Up Sales Dashboard using Tableau Superstore Dataset

Dashboards are required to showcase the visualized data in an organised manner. They help highlight important information pertaining to a certain theme or objective. Dashboards allow interactive data visualizations to be shared between employees and management. Users can leverage the Tableau Superstore Dataset to create such Dashboards and learn to organise the visual elements in a helpful manner. 

Step 1: You are firstly required to click on the New Dashboard button. 

Setting up New Dashboard - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 2: You can select various Worksheets, Views and visualisations that you may have created in the other Worksheets. For this example, you can choose and drag “Sales in South” and “Profit Map” to the empty dashboard. The Dashboard will start displaying the data as follows:  

Adding View to Dashboard - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 3:  Unnecessary information can be removed from the Dashboard by right clicking on the Column area of the desired View and removing the check-box on “Show Header” option. 

Removing Header in Dashboard - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

Step 4: You can implement filters on the data to highlight the required information. For this example, you can click on the Drop Down arrow on the “Year of the Order Date” filer and proceed by selecting “Single Value” (Slider). 

The created Dashboard will look as follows: 

Dashboard with Slider - Tableau Superstore Data
Image Source: https://www.tableau.com/about/

More information regarding setting up Tableau Dashboards can be found here

Conclusion 

In this article, you were introduced to Tableau and its key features. You learned about Tableau Superstore Dataset which is a sample Dataset provided by Tableau, steps to connect Tableau to the sample Dataset, various methods to interact with the elements of the Dataset and visualize them in the workspace. You also learned about procedures to create a Geographical Map View to get a more granular view of the data and set up a Sales Dashboard using this sample Dataset to the interactive visualization with other members of the company. 

Integrating and analyzing data from a huge set of diverse sources can be challenging, this is where Hevo comes into the picture. Hevo Data, a No-code Data Pipeline helps you transfer data from a source of your choice in a fully automated and secure manner without having to write the code repeatedly. Hevo with its strong integration with 100+ sources & BI tools, allows you to not only export & load Data but also transform & enrich your Data & make it analysis-ready in a jiffy.

Get started with Hevo today! Sign up here for a 14-day free trial!

Visualize your Data in Tableau in Real-Time