Free Tools for Data
Google Analytics
- Enhanced Google Analytics Firefox add-on—A Firefox plugin that allows analysts to see more about what has changed in the Referring Sites and Keyword Reports. Read more in this post.
- Google Trends API—A Python API that simplifies access to Google Trends data.
Excel and charting
- DTP-An Excel reporting framework—A description of our approach to creating dynamic reporting in Excel by cleanly separating data, transformation and reporting views.
- Chart Cleaner—An Excel 2003 add-on that applies charting defaults with a single click.
Mapping
- Excel Geocoding Tool—Uses the Google geocoding API to look up latitude and longitude from US addresses in a spreadsheet.
- Census heatmaps in Google Earth—Very detailed census block-level visualizations for Google Earth using the 2000 US Census data.