Awhile back, I wrote a blog post on how you can read JSON data in Tableau by using an Apache Drill. The old blog post can be found here.
Tableau now supports JSON data out of the box (native) without the need to do data preparation or using Apache Drill. This feature is in Tableau version 10.1.
Further information can be found in this Tableau blog post JSON native connector.