I've been exploring some of Geotab's open datasets for transportation. These data collections are available through Google Big Query, but I didn't really had to get deep into technical details since the instances are already built and ready to use. So, I only had to make a simple SQL query to filter the results for Mexico which resulted in a table representing 92 thousand incidents of harsh braking and probable accidents.
To visualize this I first used Excel's 3D Maps:
I also discovered Google's Data Studio and although I haven't played much with it, I really liked how easy it was to put together some reports. In this example, charts are interactive and data can be filtered by simply clicking a value in the table or the map. To to select multiple values, use Ctrl + click.
