After creating the visualisations or while creating the visualisations if you want to look at the data in a worksheet, then, in that case, you need to follow some steps that we will see in this article.
Steps to perform:
- In the Tableau, connect to the databases.
- The data source has three data files – Product, OrderDetails, PropertyInfo. These are three different excel sheet present in one data file.
- Open Product data file.
- Add OrderDetails data file, it contains the information about each order.
- Now you can see there is a join in the two data files.
- If you’ll hover on the join then you can see that there is a inner join using the common key i.e. Product ID. Inner join simply means that there are two files have a field in common and it can be combined easily.
- Next, add the PropertyInfo file and it can be see that it is also joined.
- If you’ll hover the mouse pointer then it can be clearly seen that OrderDetails and PropertyInfo are inner joined using the key – PropertyID.
- Now, that data is completely ready for data visualisation.
- Click Quantity and then at the top right corner of the screen, at the right edge of the toolbar, there is the Show Me button. Visualisation can be obtained using the Show Me option.
- Now, go to the Data menu. Go down to the bottom of the menu and click the last item. And the specific item that appears here will depend on the name of the data source.
- Then from the submenu that appears, click view data. Doing so displays the data. You can see up to 5000 rows or if you want to see more you can edit the value in the box. And also because there are more columns you can either expand this window by dragging it to the side or drag the horizontal slider.
- This data source combines data from several different tables. So you have my order date and order ID here and then if I go over I’ll see property ID, property state and so on. Even though you have those data points, or those values, in different tables within the source excel file.
- To copy any data, drag across the data and once it’s selected you can click copy and select those values. When you’re done you can click the close box to close that window. Looking at the data behind the visualization can be very helpful.
- Displaying the coordinates of the points clicked on the image using Python-OpenCV
- Python - Displaying real time FPS at which webcam/video file is processed using OpenCV
- MoviePy – Displaying a Frame of Video Clip using inbuilt display method
- PyCairo - Displaying Text
- Django project - Creating a Basic E-commerce Website for Displaying Products
- Tableau - Connect to a data source
- Difference Between Google Data Studio vs Tableau
- Tableau - Joining data files with inconsistent labels
- Data Cleaning in Tableau
- Sorting by Data Source order in Visualization in Tableau
- Tableau - Data Terminology
- How to change Data type in Tableau?
- Tableau - Data Types
- Tableau Drivers - Download and Connect
- Tableau Installation Guide
- Tableau - File System
- Tableau - Join databases
- Tableau - Create Visualization
- Tableau - Adding, Renaming and duplicating worksheets
- Tableau - Building up a storyline
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.My Personal Notes arrow_drop_up
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.