Tableau web data connectors is one of the biggest shortcuts I’ve seen in a while. It was just added in Tableau 9.1 and it’s a game changer if you work with data found on the web.
I’m a big fan of short cuts. Most people are.
Here’s the thing
Taking a shortcut can save you lots of time, but can also hurt you in the long run if you aren’t smart about it. I did a bunch of research and have compiled all of my notes to show you the short cuts and still giving some background information so you know what’s going on behind the scenes (which is important!)
In this guide, you’ll learn:
- How to get started with Tableau Web Data Connectors
- How to share your Tableau Web Data Connectors with the world
- A short cut to get data from pretty much any website into Tableau
Tableau Web Data Connectors
Think about something that’s important to you. Maybe it’s related to your work, or your family, or a hobby. For example, perhaps you’re interested in sports.
Let’s face it
These days there’s data floating around for just about every hobby or interest under the sun. For example, I’m a big fan of football and love digging into the data and statistics behind the game.
Here’s the problem: that data is a real pain to work with.
But good news! Tableau figured out a super easy way to get that data into any dashboard you can imagine with no coding required.
In this step-by-step tutorial, I’ll show you the background info you need to understand how it all works PLUS a super smart shortcut that will save you time and tons of frustration.
Part 1 Tableau WDC SDK Installation
One of the great things that Tableau offers is an easy way to connect to your data. A new feature in Tableau 9.1 are web data connectors. Web data connectors are an easy way to import your data from an existing API directly into Tableau so that you can create dashboards very easily.
How Tableau Web Data Connectors work
- Find (or create) a web data connector that you need
- Connect to the data in Tableau 9.1
- Build your dashboard
How to get started with Tableau Web Data Connectors
Warning: building a web data connector from scratch is not all that easy. You’ll need to know:
- How REST APIs work
- Other web programming skills
Watch a 2 minute overview of how to get started with Tableau Web Data Connectors
Part 2 Free hosting with GitHub
Why use Github?
- Automatically store all of your data with full backups
- Used by millions of people to collaborate with others on coding projects
- Most importantly … free hosting
How to create and host your Tableau Web Data connector on Github for free
- Create a free Github account
- Create a repository named username.github.io and clone it to your computer
- Add an index.html file (download my example copy here)
- Copy the MadMoneyScraper.html from the Tableau SDK to your new repository
- Sync the files from your computer back up to Github
- Visit username.github.io to view your index file and username.github.io/MadMoneyScraper.html to view the Tableau WDC SDK
Watch this step-by-step tutorial to create your first Github repository and add your Web Data Connector files
Part 3 Import data from any website into Tableau
Okay, Part 1 and Part 2 really help you understand what Tableau Web Data Connectors are and why you’d want to use them.
Part 3 will show you how to bypass all of the technical challenges and just get the data you need without any coding at all using a tool called import.io
Why use Import.io?
- You get a free account to collect data from pretty much any website.
- Lots of options to automate your data collection as needed
- Most importantly… there’s a Tableau Web Data Connector already built!
Here’s the thing
The hardest part now will be finding the data you want. But if the data is on a public website (not behind a firewall or login screen) then you can use import.io to collect that data.
How to use import.io to get data into Tableau with no coding
- Create a free import.io account
- Add the web address of the page you want to scrape (NFL stats for example)
- Configure each of the columns as needed (this could take some trial and error)
- Use the import.io Tableau Web Data Connector created by Robert Rouse at Interworks
- Build your dashboard in a fraction of the time.
Watch this step-by-step tutorial to get data from any web page into Tableau in less than 10 minutes with no coding.