Tableau – Public Edition – Installation


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.


The public edition is available for download here.


Installation is straight forward.


  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 – Initial


Welcome – Post Changes


Install Customizations

Install Customizations – Post Changes



Launched Tableau Public edition.

Data Sources

Here are the Data Sources listed.

Image – Connect



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


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.


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

Text file

Create Text file

Here is a sample text file


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






  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
    • Review the data
      • Column :- Gender
        • F should no longer read False



Image – Connect / To a File


Image – Open


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


Image – Files – employee.txt – metadata




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


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



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

Google Docs – Filters and Filter Views


Microsoft Excel has a very nice interface that allows the user to show just the data that needs to be projected for different scenarios.

In Microsoft Excel 2010 the functionality is exposed through the “Filter” toolbar.


Google Docs

Let us examine whether Google Docs exposes a similar functionality and if so how and how well it does.


Looked on the Internet for sample Excel Spreadsheets.

Found one from Tableau.

It is called Sample – Superstore Sales (Excel).xls and it is available at

The specific URL is Link.



We downloaded the sample data, accessed Google Docs, and imported the data.


Imported Data

Here is what the imported data looks like.



Filtering Data

There are two types of Filters required.

One is a Filter and the other is a Filter View.

We will touch on how to create each type of Filter and later on the differences between them.



To filter the data, please take the following steps:

  1. Select a range of cells.
  2.  Click Data and then Filter (  )
  3. To see filter options, go to the top of the range and click 
    • Filter by condition: Choose from a list of conditions or write your own.
    • Filter by values: Uncheck any data points that you want to hide and click OK.
  4. To clear Filter
    • Please click the menu items Filter / “Turn off Filter


Access Filter Menu

Filtering By Customer Name – Begin

Filtering By Customer Name – Filtering



Filter Views


To filter the data, please take the following steps:

  1. Create New Filter View
    • Repeat the steps of creating a new Filter
      • Select a range of cells.
      •  Click Data and then Filter (  )
      • To see filter options, go to the top of the range and click 
        • Filter by condition: Choose from a list of conditions or write your own.
        • Filter by values: Uncheck any data points that you want to hide and click OK.
    • Create New Filter View
      • Please choose the menu item Data/Filter Views
      • In the Name Bar, please give a Meaningful and Relevant Name
    • Customize the Filtered View
      • Customize the Filtered View as you see fit
      • In our case, we chose a specific Customer
  2. Capture and Share URL
    • Please capture and share the URL for the customized Filtered View
    • With a customized URL, each user has a specific and tailored view of the data
  3. Close Filter View
    • To close your filter view, go to the top right and click Close.
  4. Delete Filter View
    • To delete or duplicate a filter view go to the top right and click Settings Settings and then Delete or Duplicate.



Filter By Column – Customer Name
Filter By Column – Customer Name – Initiate – Andrew Gjertsen

Filter By Column – Customer Name – Completed – Andrew Gjertsen

Filter Views Maintenance

Filter versus Filter View

Item Filter Filter View
Sharing Mechanism Send URL or List Send URL for List View
Sample URL Link Link
Multiple Instances Supported No Yes
Maintenance Supported Turn off filtering Naming, Rename, Duplicate, and Delete


Screen Shot


Filtered View


I wish I could have explained this far better.

But, nevertheless, if you have need to share Excel Type Sheets within a group and you will like tailored view of data, please consider using Google Docs.

It’s Filtered View functionality offers an accessible, polished, uncluttered, and fluid interface.


    • Sort and Filter your data
    • Working with Data


Google Drive – Google Sheets – Pasting Tables



We all take for granted how seamlessly Microsoft Products work together.

Take for instance, I use Microsoft SQL Server Management Studio to run a query and I will like to prepare a document from the query’s result.

I simply copy the Output Grid’s content, launch Microsoft Word or Excel, and pasted it.

Through the magic of OLE or whatever they call it these days, the data is well received and formatted in the receiving Office App.


Google Drive

These days my main sharing tool is WordPress for public consumption and Google Docs for private data.


Here is the genesis of our Problem

SQL Server Management Studio ( SSMS )


Here is output of a query I ran in SSSM



  1. Nice and visually appealing for an Engineer


Google Drive – Google Docs

Here is what things look like when pasted into Google Docs..



What to do

  1. Looked for Convert to Table
  2. Insert Text as table
  3. Import Text


Nothing helpful.


Solution – 01

Google Drive – Google Sheets

Created a new file, rather than Document went with Sheets




  1. Making progress
    • Kept the grid or columns paradigm
    • That is things are not jumbled well, with text intertwined together


Google Drive – Copy From Google Sheets Into Google Docs

Here we copied the cells from Google Sheets Into our original Google Docs




  1. Thankfully things are kept neatly arranged in a Columns
  2. Need to get rid of some extra columns and that is doable


Google Drive – Google Docs – Table – Delete Extra Columns

Got rid of the extra columns using the menu item Table / Delete Columns.


  1. Inside the Google Doc
  2. Select the extra columns
  3. And, use menu item Table / Delete Columns



Format the Table

One of the great things about these Google Products such as Chrome and Google Drive is that they are extensible and have such a nice and rich 3rd party ecosystem.


Adds On

Table Formatter

I already have Table Formatted installed and so let us initiate it by accessing Google Docs menu items “Add-ons” \ “Table Formatter”.


Google Docs – Menu – Add-Ons



Add-On – Table Formatter – Default Templates

Here are some of the Default Templates available


Customize Table with Add-On – Table Formatter

Select the Google Docs’s tale and choose the one of the Formatting Choices.

Here is our colored layout.




  1. Copy SSMS Grid Data into Clipboard
  2. Create a new Google Sheet ou use existing one
    • Paste copied into Sheet
  3. Create a new Google Doc
    • Select data from Google Sheet
    • Copy into Clipboard
    • And, paste into Google Doc
  4. In Google Docs
    • Using 3rd Party Add Ons such as Table Formatter format Table

Solution – 02


  1. Copy SSMS Grid output into Clipboard
  2. Use Microsoft Excel
    • Launch Microsoft Excel
    • Copy Grid’s data into Excel
    • If you like the way Excel Formats Table, use Excel’s Table Formatting functionality
      • Using F8, make Sheet’s column into actual table
        • Be sure you have Column Headers and all
  3. Create or use New Google Docs
    • Copy Table’s content from MS Excel
    • Paste into Google Doc


In MS SSMS, Copying with Headers




In MS Excel, Pasted SSMS Grid



In MS Excel, Create Table

Here is the panel displayed upon clicking on F8 and thus initiating the “Create Table” options



  1. Please pay attention to the “My table has headers” option


In MS Excel, Formatted Table