How can I use web-based data in Tableau?

The Tableau as a BI (Business Intelligence) tool enables a wide visualization of the contents of databases.

Usually Tableau is used to analyze and visualize the data available within the company. What can you do if you want to use other external, web-based data (text content) within Tableau?
The solution is Precognox’s TAS Data Collector service, the process is described below step-by-step:

1. Selecting and downloading a particular web page (as a data source)

 

In the first step, we download the selected web data (in our example, the content of the Keresővilág Blog website) using the Data Collector service. However, in the case of unstructured data (text content) on the web, downloading is accompanied by a number of tasks (data cleaning, validation) that are accomplished by our data specialists. As a result of these workflows, a structured database is created, which will be continuously updated in the future, so that the data is always available and usable.
The user gets access (server data, user name and password) to the structured database through a secured, password-protected channel.

 

2. To load the data in the Tableau interface, click MySQL

Fill in the boxes with the informations that you receive from us

 

3. Press ”Sign in”

 

4. After the data is loaded, the data can be processed and visualized as usual

 

5. Example of completed visualization

 

In addition to providing insight into the content of the web-based data source (chosen website), the visualization is a great business asset as it can be a part of presentations, business reports, evaluations, or even competitive analyzes. In this way, the potential of huge amounts of data on the Internet can be exploited.

Are you also a Tableau user? Do you want to know more about our text analytics solutions?
Contact us!

Péter Hódi
phodi@precognox.com
+36 20/416-74-79

Read more about Data Collector on the TAS Text Analytics System page.

Pictures: Tableau interface and visualization