Book Image

Tableau 2019.x Cookbook

By : Dmitry Anoshin, Teodora Matic, Slaven Bogdanovic, Tania Lincoln, Dmitrii Shirokov
Book Image

Tableau 2019.x Cookbook

By: Dmitry Anoshin, Teodora Matic, Slaven Bogdanovic, Tania Lincoln, Dmitrii Shirokov

Overview of this book

Tableau has been one of the most popular business intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. Tableau 2019.x Cookbook is full of useful recipes from industry experts, who will help you master Tableau skills and learn each aspect of Tableau's ecosystem. This book is enriched with features such as Tableau extracts, Tableau advanced calculations, geospatial analysis, and building dashboards. It will guide you with exciting data manipulation, storytelling, advanced filtering, expert visualization, and forecasting techniques using real-world examples. From basic functionalities of Tableau to complex deployment on Linux, you will cover it all. Moreover, you will learn advanced features of Tableau using R, Python, and various APIs. You will learn how to prepare data for analysis using the latest Tableau Prep. In the concluding chapters, you will learn how Tableau fits the modern world of analytics and works with modern data platforms such as Snowflake and Redshift. In addition, you will learn about the best practices of integrating Tableau with ETL using Matillion ETL. By the end of the book, you will be ready to tackle business intelligence challenges using Tableau's features.
Table of Contents (18 chapters)

Connecting to Amazon Redshift Spectrum

In this section, we will upgrade our Redshift data warehouse by enabling Redshift Spectrum, which plays the role of a data lake and compliments our data warehouse. It gives us a powerful and serverless architecture and can handle a tremendous volume of data, which is true big data.

Amazon Spectrum extends Redshift data warehouse out to the Exabytes website. You can get all the benefits of open data formats and inexpensive storage, and we can easily scale out to thousands of nodes. Another benefit is the cost; we pay only for usage and storage using S3, which is fairly small in comparison with an analytical data warehouse.

Getting ready

We should update our IAM roles for Redshift by adding...