Tableau and Google BigQuery allows people to analyze massive amounts of data and get
answers fast using an easy-to-use, visual interface. Using the tools together, you can:
- Put the power of Google BigQuery into the hands of everyday users for fast, interactive
- Analyze billions of rows in seconds using visual analysis tools without writing a single
line of code and with zero server-side management.
- Create stunning dashboards in minutes that connect to your Google BigQuery data and
keep your organization up to speed.
- Share reports and insights on the web using Tableau Server and Tableau Online to
allow anyone to connect from any device.
- Combine the cloud agility of Google BigQuery with the blazing speed of Tableau to
recognize project value faster.
Optimizing the two technologies together will yield significant performance gains, shorten design
cycles, and help users and organizations become more successful. In this paper, we will
discuss techniques to optimize data modeling and query formation to maximize the
responsiveness of visualizations. We will also discuss techniques to get the best cost efficiency
when using Tableau and BigQuery together.
We've also pulled out the first several pages of the whitepaper for you to read. Download the PDF on the right to read the rest.
BigQuery can process petabytes of data in seconds in plain SQL, with no fine-tuning or special
skill set required. Powered by Dremel, Google's revolutionary technology for analyzing massive
data sets, BigQuery provides a level of performance that large businesses previously had to pay
millions to obtain—at a cost of pennies per gigabyte.
BigQuery is a Data Warehouse best suited for running SQL queries against massive, structured,
and semi-structured data sets. Example use cases and data sets include:
- Ad-hoc analytics
- Web logs
- Machine/server logs
- "Internet of Things" data sets
- E-commerce customer behavior
- Mobile app data
- Retail analytics
- Gaming telemetry
- Google Analytics Premium data
- Any data set for which a traditional RDBMS is taking minutes (or hours) to run a batch
BigQuery is completely No-Ops and maintenance-free, and is integrated with the Google Cloud
Platform. Unlike other cloud-based analytics solutions, BigQuery does not require you to
provision a cluster of servers in advance—processing clusters are sized and provisioned by
BigQuery at runtime. As your data size increases, BigQuery will automatically add processing
power—yet you pay the same price per gigabyte.
Want to read more? Download the rest of the whitepaper!