Updated for 2017!
Google Sheets has a powerful and versatile set of IMPORT formulas that can import data from other websites.
This article looks at importing data from popular social media channels into a Google sheet, for social network analysis or social media management. If you manage a lot of different channels then you could use these techniques to set up a master view (dashboard) to display all your metrics in one place.
The formulas below are generally set up to return the number of followers (or page likes) for a given channel, but you could adapt them to return other metrics (such as follows) with a little extra work.
Caveats: the websites these formulas retrieve data from frequently change, which means the formulas stop working. I will try to keep this post updated with working versions.
Example workbooks: Each example has a link to an associated Google Sheet workbook, so feel free to make your own copy:
File > Make a copy....
Continue reading The Import Cookbook: How to import social media data into Google Sheets with formulas
2015 was a challenging year for humanity. The plight of refugees was never far from the headlines, as multiple catastrophes unfolded across the globe.
This case study has two aims: first, to show facts on the numbers and details of refugees resettled into the U.S. in 2015, and, second, to discuss the methodology to help and inspire others to explore the data.
- Where From?
- Where To?
- What Religious Affiliation?
- Appendix 1: Sourcing the Raw Data
- Appendix 2: Setting up the Data in SQL
- Appendix 3: Analysis in SQL
- Appendix 4: Visualizing in Tableau
Continue reading Refugees resettling in the U.S. in 2015: where from, where to and who?
During the final quarter of 2015, I taught General Assembly’s new Data Analytics course in Washington DC. It’s a 10-week, part-time course, meeting twice a week for 3 hours (60 hours total tuition).
The course focuses on practical data analysis skills using Excel, SQL and Tableau, with no pre-requisites for SQL or Tableau.
Continue reading Data Analytics Resources