All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletters

Free Learning

You're reading from Tableau 2019.x Cookbook

Product type Book

Published in Jan 2019

Publisher Packt

ISBN-13 9781789533385

Pages 670 pages

Edition 1st Edition

Languages

Concepts

Business Intelligence

Authors (5):

Dmitry Anoshin

Teodora Matic

Slaven Bogdanovic

Tania Lincoln

Dmitrii Shirokov

View More author details

Table of Contents (18) Chapters

Preface

1. Getting Started with Tableau Software

2. Data Manipulation

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

Using SnowSQL CLI

One of the common ways of interacting with the database is CLI. Let's do a quick exercise to load data into the Snowflake and then connect Tableau.

How to do it...

At the GUI, you can click on Help and choose Download.
Download the CLI client (snowsql) for your OS. In my case, I am using macOS.
Install the file.
Connect the Snowflake instance. In our case, we are using macOS. Open a command line and run the following command:

/Users/anoshind/Applications/SnowSQL.app/Contents/MacOS/snowsql -a <account name> -u <user name>

In our case, we have -a DZ27900 -u tableaucookbook. It will ask for a password. After successful authentication, we connected to Snowflake.

Now, we can start to create...

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 €14.99/month. Cancel anytime

Authors (5)

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

Teodora 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 Teodora Matic

Slaven 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 Slaven Bogdanovic

Tania 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 Tania Lincoln

Dmitrii 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 Dmitrii Shirokov