•   over 4 years ago

Yelp JSON -> Tableau

Hey, thought this might be helpful for someone else to get started. I had heard good things about Tableau as a tool for data exploration, so I downloaded the trial.

This page describes how to get the data from the Yelp Academic set (json) into Tableau. Between downloads and setup, it takes about 30 minutes.
https://www.mapr.com/blog/apache-drill-its-drilliant-query-json-files-tableau-desktop

Note that, instead of their example, you can use the following SQL query in Drill Explorer to get all the fields for businesses in Montreal:
CREATE OR REPLACE VIEW dfs.tmp.business
as select *
from dfs.`C:\where_you_store_your_dataset\yelp_academic_dataset_business.json` where city like 'Montr%al'
^ this is on Windows, so ymmv especially for the path.

Comments are closed.