Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Tableau 2019.x Cookbook Over 115 recipes to build end-to-end analytical solutions using Tableau

Product type Paperback

Published in Jan 2019

Publisher Packt

ISBN-13 9781789533385

Length 670 pages

Edition 1st Edition

Languages

Tools

Tableau

Concepts

Business Intelligence

Authors (6):

Tania Lincoln

Slaven Bogdanovic

Teodora Matic

Rintaro Sugimura

Dmitry Anoshin

Dmitrii Shirokov

+2 more

View More author details

Table of Contents (18) Chapters

Preface

1. Getting Started with Tableau Software

2. Data Manipulation FREE CHAPTER

3. Tableau Extracts

4. Tableau Desktop Advanced Calculations

5. Tableau Desktop Advanced Filtering

6. Building Dashboards

7. Telling a Story with Tableau

8. Tableau Visualization

9. Tableau Advanced Visualization

10. Tableau for Big Data

11. Forecasting with Tableau

12. Advanced Analytics with Tableau

13. Deploy Tableau Server

14. Tableau Troubleshooting

15. Preparing Data for Analysis with Tableau Prep

16. ETL Best Practices for Tableau

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Loading sample data into the Redshift cluster

We should load sample data into Redshift to demonstrate how Tableau Desktop will connect to a huge dataset and query it.

How to do it...

To load data into the Redshift cluster, we should use Amazon S3 buckets, which consist of folders with files. We will use AWS samples and utilize the COPY command to load data into a cluster, as follows:

Copy and paste the SQL code from the Create_Statement_Redshift.sql file that is available for this chapter.
Run these statements and the tables should be created, as seen in the following screenshot:

Then, we should load the data using the copy command. We will copy the commands from the COPY data to the Redshift.txt file and insert our ARN...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (6)

Rintaro Sugimura

See other products by Rintaro Sugimura

Dmitry Anoshin

Dmitry Anoshin is a data-centric technologist and a recognized expert in building and implementing big data and analytics solutions. He has a successful track record when it comes to implementing business and digital intelligence projects in numerous industries, including retail, finance, marketing, and e-commerce. Dmitry possesses in-depth knowledge of digital/business intelligence, ETL, data warehousing, and big data technologies. He has extensive experience in the data integration process and is proficient in using various data warehousing methodologies. Dmitry has constantly exceeded project expectations when he has worked in the financial, machine tool, and retail industries. He has completed a number of multinational full BI/DI solution life cycle implementation projects. With expertise in data modeling, Dmitry also has a background and business experience in multiple relation databases, OLAP systems, and NoSQL databases. He is also an active speaker at data conferences and helps people to adopt cloud analytics.

See other products by Dmitry Anoshin

Shirokov

Dmitrii Shirokov has over 11 years of design and development of data-driven solutions. He has been using Tableau since 2011 in the majority of analytics projects. His expertise covers building data warehouses and sophisticated analytical solutions. Currently, he works as a solutions architect at Rock Your Data consulting company. Previously, he was a big data architect at Sberbank and also worked as a professional service consultant at Teradata.

See other products by Shirokov

Lincoln

Tania Lincoln has over 12 years of development experience in BI and data analytics domain. She has a strong SQL, visualization, and analytics skill set, and has demonstrated the ability to mentor others on new technologies and process improvements. She is also experienced in taking a product from inception to launch and managing post-launch growth.

See other products by Lincoln

Bogdanovic

Slaven Bogdanovic has more than 10 years of experience in data analysis and reporting within both business and academic field. His expertise covers complex statistical analysis and insight communication. He has been using Tableau since 2013. Currently, he works as a BI/big data developer at NCR Corporation. Previously, he was a senior research executive at Ipsos. Also, Slaven is a PhD candidate and a member of the Laboratory for Research of Individual Differences at the University of Belgrade. In addition, Slaven is the author of six articles published in academic and professional journals.

See other products by Bogdanovic

Matic

Teodora Matic is a data analyst with a strong background in statistics and more than 5 years of experience in data analytics and reporting. She has been using Tableau since 2014. She has been working as a project manager and data analyst for leading market research companies, such as Ipsos and EyeSee Research, levering the power of Tableau to bring business insights to clients. She currently does data analysis and reporting at the International Committee of the Red Cross.

See other products by Matic