Geocoding in a Pinch: Power Query and the Google Maps API
Reading Time: 4 minutes A colleague of mine recently asked if I knew of an easy way to get latitude and longitude coordinates from city and state information. Of course I do! There are plenty of ways, and many of…
Read MoreStep by Step: Using Power Query to Replace Text in Table Headers
Reading Time: 4 minutes Recently, I came across a dataset involving traffic accidents that I really liked and wanted to clean up for a demonstration. As with most datasets originally pulled from the web or from text files, there were…
Read MoreTableau 9 – Data Interpreter Put to the Test
Reading Time: 4 minutes While “data preparation”, “in” and “Tableau” have not been words you often see together, Tableau 9 offers some new options, building on recent data preparation advances in 8.2 with features like the data window and better…
Read More