Importing data into Tableau

As we fire up our Tableau Public application for the first time, we are introduced to the different ways that we can bring data in, as seen in the following screenshot:

Importing data into Tableau

Unfortunately, there is no direct means to connect to a SQL Server query. Those connections are only available on the licensed version of Tableau that is available for a two-week trial period. Our best option to visualize query results from MS SQL Server is to export the data into a Text file and then connect to Tableau.

Exporting to a text file

Exporting from SQL Server is quite straightforward. All that is required is to right-click on the result set ...

Get Practical Business Intelligence now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.