How to Create Dashboards and Data Visualizations in Tableau

Tableau is an industry-leading business intelligence (BI) tool that focuses on data visualization, dashboarding, and data discovery. It connects to a wide range of data sources and enables users to gain valuable insights, show trends quickly, and create reports. Establishing a data-driven foundation can help organizations discover insights and trends through data visualization. Here's how simple it can be:

 

1. How To Connect to Your Data to Tableau

Your data can come from a PDF or text file but using a Microsoft Excel file offers the smoothest data transition. Tableau creates a direct connection to the file. There is no importing or storing of the data, meaning that any changes you make to the spreadsheet will be directly tied to your Workbook.

Select the Spreadsheet you want your data to be sourced from and drag it into your Workbook.

 

You will be able to see all the columns in your spreadsheet as well as the first 1000 rows. Once you have connected to your data and have Selected the spreadsheet you want to work with, it's time to create your first Worksheet.

 

2. How to Create a Tableau Visualization to Analyze Data

Select Sheet 1 and Go to Worksheet. First, look over the Data Pane to make sure you have selected the correct Excel Spreadsheet.

Next, change any of the properties or formatting you would like in your Dashboard ($, decimals, numbers, etc.).

 

Since Tableau is a drag-and-drop application, go ahead and drag whichever data field you want to be represented in the Column shelf. Once on the shelf, you can format the Pill to show specific data.

             

 Next, take a corresponding value and drag it over to the Rows shelf. You will now be able to visualize and interact with the data you have created.

If you would like to make the data set more interactive for an end-user, add some data sets to the Filter panel and edit what you would want to see. Try and change the Color, Size, and Label in the Marks panel as well!