Tutorial: Preparing Data in FME for Tableau

Introduction

This six part tutorial will show you how to clean up data and write it to Tableau, import multiple spreadsheets and write it to single or multiple Tableau files, how to reproject and overlay data, and then finally, use the newly created Tableau datasets to create density maps and spider diagrams in Tableau. For a better overall understanding of how FME and Tableau work together, follow the tutorials in order as they increase in complexity with each tutorial.

Exercises

How to Write Spatial Data into Tableau with FME

Work through a simple translation to familiarize yourself with FME and Tableau

How to Prepare Data for Tableau with FME (Processing Spreadsheets)

Learn to extract coordinate data from a spreadsheet and then clean up the data before loading it into Tableau

How to Prepare Data for Tableau with FME (Multiple Spreadsheets)

Multiple spreadsheets? No problem. Using the workspace from the previous tutorial, add multiple spreadsheets and write to a single Tableau file or multiple Tableau files.

Reprojection and Spatial Overlay with FME

Datasets can come in any coordinate system, learn to reproject them to the same coordinate system and then overlay them on top of each other.

Creating Density Maps for Tableau

With the data cleaned up, we can now create impactful maps to share with others inside of Tableau. This tutorial you will create three different types of density maps; HexBin, Grid and Dot Grid maps.

Creating Spider Diagrams for Tableau

Spider diagrams are a great way to visualize the distance between multiples points to a single point. Learn what a Voronoi Diagram is and how to create a spider diagram both in FME and Tableau.