Tableau – Public Edition – Installation

Background

One of the Database Reporting tool we use at work is Tableau.

Wanted to take another look at it.

Found out that since the last time I looked at it, they have added a Free Edition; it is called Public.

Artifacts

The public edition is available for download here.

Installation

Installation is straight forward.

Outline

  1. Welcome Screen
    • Agreed to having read the License Agreement
    • Agreed to sharing usage data
  2. Customizations
    • Said No to “Desktop Shortcut

Screen Shots

Welcome

Welcome – Initial

tableau_install_welcome_01_20190620_0802AM.PNG

Welcome – Post Changes

tableau_install_welcome_02_20190620_0803AM.PNG

Install Customizations

Install Customizations – Post Changes

tableau_install_customization_01_20190620_0804AM.PNG

Usage

Launched Tableau Public edition.

Data Sources

Here are the Data Sources listed.

Image – Connect

usage.01.20190620.0806AM.PNG

Listed

So Tableau Public Edition is only able to access the following types of data sources :-

  1. Files
    • Standardized
      • Text Files
      • JSON Files
      • PDF File
      • Spatial
        • ESRI
        • Geojson
        • MAPInfo
      • Statistical
        • SAS Files ( *.sas7bdat )
        • SPSS Files ( *.sav )
        • R Files ( *.rdata, ,*.rda)
    • Microsoft
      • Microsoft Access
      • Microsoft Excel
  2. OData
  3. Google Sheets
  4. Web Data Connector

Explanation

Big Disappointment.

I am unable to connect to Enterprise Database Platforms; such as Oracle, DB/2, SQL Server, and MySQL.

Data Source – Text

Chose to with a Text Data Source.

Outline

  1. Text file
    • Create Text file
  2. Tableau
    • Access Created Text file

Text file

Create Text file

Here is a sample text file

Text

lastname, firstname, ssn, dob, gender
Coles, Kim, 111-222-8981, 2019-01-01, F
Jones, Kim, 111-222-8982, 2019-01-02, F
Porter, Kim, 111-222-8982, 2019-01-03, F

Image

usage.textfile.01.20190620.1020AM

 

Tableau

Outline

  1. Access Text File
    • Using Menu, File \ Open
  2. In Connect
    • In Connect window, choose to “Connect” \ “Text File”
    • Use File Open Dialog to choose the Text File
  3. Data View
    • Tableau accesses the text file, reads its data, and displays the read data
  4. Metadata View
    • Default View
      • In this case, our read data is text and does contain its own metadata; aside from the top header which bears column name
      • Implication
        • Gender
        • Our last column, Gender, contains F for (F)emale
        • The system thinks “F” means False
    • Revision
      • Please access metadata by clicking the usage.metadata.01.20190620.1043AM.PNGbutton
        • Gender
          • Change the column type for Gender from Boolean to String
  5. Data View ( Post Metadata Changes )
    • Please access data grid by clicking the usage.button.data.01.20190620.1101AM.PNGbutton
    • Review the data
      • Column :- Gender
        • F should no longer read False

 

Images

Image – Connect / To a File

usage.01.20190620.0806AM.PNG

Image – Open

usage.Open.01.20190620.0814AM.PNG

Image – Files – employee.txt
Image – Files – employee.txt – data view

usage.table.employee.01.20190620.0815AM.PNG

Image – Files – employee.txt – metadata
Initial

usage.manageMetadata.employee.01.20190620.0818AM.PNG

Revision

usage.metadata.02.20190620.1049AM

Image – Files – employee.txt – data
Post Metadata Changes

usage.table.data.employee.03.20190620.1059AM.PNG

Summary

Of course, it is a bit disappointing that Tableau Public Edition does not allow one to connect to enterprise data servers.

 

References

  1. Tableau
    • Download
    • DataSets
      • Free Public datasets
        • JACOB OLSUFKA
          DATA VISUALIZATION SPECIALIST AT SPOTIFY
          FEBRUARY 26, 2019
          Link
    • Tableau Community Forums
      • Tableau Public Frequently Asked Questions
        Link
      • What is the difference between Tableau Public and Tableau Desktop Public?
        • Questioner :- John Swimming
          Date Posted :- Oct 20, 2013 2:42 AM
          Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s