How to transform street data into geocodes

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

1. Copying data containing street names from a PDF
2. Pasting this into a free online tool (Batch Geocode) to get LAT and LONG
3. Saving the result as a CSV
4. 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
5. Plotting results on a map
6. Extract information via SPLIT and RIGHT calculations
7. Visual grouping
8. 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