Eric Demers • 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.
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.