If you’re a Tableau user, you know how this powerful tool can help you see and understand your data in ways you were never able to before. Since Tableau version 9.1 was released, it is now possible to connect directly to web data sources through the Web Data Connector. Rather than create your own web data scraper and building a connector to Tableau, thanks to the smart folks at The Information Lab, you can now connect ParseHub projects directly into Tableau. It is easier then ever before to scrape data from the web and visualize it for useful insights.
ParseHub makes it easy for you to scrape data and create an API that gets complex data from websites in a structured format. With ParseHub, you can collect data from any website and download it into an Excel or JSON file. The connector from The Information Lab let’s you access that data through a dashboard within Tableau. The connection is live, all you need to do is run your ParseHub project on a schedule and you will have a fresh set of data consistently. Data from complex websites + Tableau visualizations and analysis = business intelligence joy.
We see some great uses for this scraping + visualizing power combo.
- A pricing analyst can scrape prices of all the shoes from Amazon and quickly analyse pricing trends in Tableau. Since the feed from Amazon can be re-run and refreshed, a live, visual price monitoring tool can be easily created with Tableau.
- A publisher could scrape Mashable for article data and shares. In Tableau they could map correlations between different factors to determine what makes an article shareable e.g number of videos, length of headline, length of article.
- A financial consulting company can scrape financial information directly from Yahoo Finance into Tableau, rather than downloading spreadsheets and importing them into Tableau.
- A recruiter could scrape Glassdoor for job title and salary information and us Tableau to create an interactive visual dashboard of job title keywords and corresponding average salaries. This could help set market rate salaries for jobs.
- A marketer can scrape Yellow Pages for all of the barber shops in your city and then quickly map them in Tableau to understand patterns in geographic distribution. This can help them decide where to focus sales and marketing efforts.
If you’re not using Tableau right now, they offer a free trial so you can try out the product. The product certainly comes with a price tag but the payoff is multi-fold. And now that you can connect ParseHub directly to Tableau, you’ll get even more uses.
Watch a video about the how The Information Lab’s Data Connector works:
Watch this Tableau webinar on the Web Data Connector:
Have thoughts on how you will use the Tableau ParseHub data connector? Share them in the comments!