How to transform street data into geocodes

Kommentare : 0

Today I want to share with you some ideas around transforming raw data into something more visual and valuable. The video below is demonstrating:

Copying data containing street names from a PDF
Pasting this into a free online tool (Batch Geocode) to get LAT and LONG
Saving the result as a CSV
Connecting Tableau with this CSV
1. Setting the delimiter right
2. Setting the text qualifier right
3. Explain how to solve “.” and “,” issues when working with flat files
4. How to leverage data source filters
Plotting results on a map
Extract information via SPLIT and RIGHT calculations
Visual grouping
Final interactive dashboard

Links from within the video:

Final Dashboard: On Tableau Public
Data: Speed Cameras Mainz
Geocoding Tool: Batch Geocode
Visual Idea: Brian Halloran

Über den Autor

Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API