The Internet of Things has made collecting data easy. The hard bit has been analyzing that data. The applications bundled with IoT devices don’t allow for freeform exploration, and only the coders of the world can write APIs and build infrastructure to get and store the data.
Tableau 10 is changing that with its Google Sheets connector. Finally, it is possible to build a direct path from IoT devices to the analytical, intuitive power of Tableau. In Tableau 10, you can connect to your Google Sheets. Not only that, if you publish your analysis to Tableau Server, the data can be set to auto-refresh.
Yes, you read that right: Tableau 10 has a refreshing connection to Google Sheets. This has many incredible applications, but today I’m going to focus on my favorite site on the internet, IFTTT.com.
Let’s see how we can use IFTTT and Google Sheets to analyse our IoT data.
All you need are three things:
- One or more connected device. In this example, we’re using a sensor which activates when the front door opens (this is genuine data, but we’ve kept its owner anonymous)
- An IFTTT account and a recipe which, when triggered, saves information to a Google Sheet
- Tableau 10 and its Google Sheets connector
What insights can we find about daily habits?
I began by looking at the number of door openings per day. One day jumped right out as an outlier. What day was that? October 31—of course! Halloween! Trick or treat! I verified that by looking at when the door was opened on that day:
That’s right—the door was opened 41 times between 4 p.m. and 8 p.m.—all those kids, all those treats all generating data!
You could set up a dashboard so you can explore any day’s comings and goings with ease.
Check out this video for a detailed demonstration of how to connect to Google Sheets with Tableau 10.
This is but the simplest of simple explorations of IoT data, but the possibilities for analytics are endless. For some more ideas, check out the channels available on IFTTT.com.
- Maybe you want to explore data from your Fitbit, or bike rides in Strava? You could also track weather in your home city and see if it affects your training.
- You could analyse the temperatures you set on your Nest Thermostat to check home efficiency.
- What if you looked at home security sensors to look for suspicious activity?
- IFTTT has 328 channels you can connect to—an almost-limitless set of ways to track IoT data!
What will YOU do with the Google Sheets connector? Let us know!
Learn more about Tableau 10
Tableau 10 includes a brand new look and feel, and a host of new features to help you prep, analyze, and share your insights even faster. Check out our Coming Soon page for details.
- Uncover patterns in your data with Tableau 10’s clustering feature
- Quickly find marks in context with Tableau 10's new highlighter
- Build your own custom territories in Tableau 10
- Do more with bar charts in Tableau 10
- Tableau 10 includes more maps data, multilingual auto detection
Answers through analytics
- Integrate your data with cross-database joins in Tableau 10
- As requested, you can filter across data sources in Tableau 10
- Do more with APIs in Tableau 10
- Tableau 10 includes even more data-source options
- Connect directly to Google Sheets in Tableau 10
- Connect directly to your QuickBooks online data in Tableau 10
- Favorite your data sources in Tableau 10
- Check out the beautiful look and feel of Tableau 10
- Format your workbook with just a few clicks in Tableau 10
- How we designed the new color palettes
- Tableau 10 includes a new typeface designed for data
Beautiful by design
- Design dashboards that shine on any device in Tableau 10
- Tips for designing device-specific dashboards that make everyone happy
- Manage your Tableau Mobile deployment with AirWatch or MobileIron
- Author dashboards from scratch on the web in Tableau 10
- Do more while publishing workbooks in Tableau 10
- See a history of your revisions in Tableau 10
- What's new in Tableau Online
Do more on the web
- Check out the new enterprise features in Tableau 10
- Extract-refresh fail? Get an email alert in Tableau 10
- Subscribe others to your views and workbooks in Tableau 10