All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Tableau Prep Cookbook

You're reading from Tableau Prep Cookbook

Product type Book

Published in Mar 2021

Publisher Packt

ISBN-13 9781800563766

Pages 288 pages

Edition 1st Edition

Languages

Concepts

Business Intelligence

Author (1):

Hendrik Kleine

Table of Contents (11) Chapters

Preface

1. Chapter 1: Getting Started with Tableau Prep

2. Chapter 2: Extract and Load Processes

3. Chapter 3: Cleaning Transformations

4. Chapter 4: Data Aggregation

5. Chapter 5: Combining Data

6. Chapter 6: Pivoting Data

7. Chapter 7: Creating Powerful Calculations

8. Chapter 8: Data Science in Tableau Prep Builder

9. Chapter 9: Creating Prep Flows in Various Business Scenarios

10. Other Books You May Enjoy

Creating relative temporal calculations

There are many analytics scenarios where you may want to calculate a date-related field based on a relative date, such as today or this year. Such calculations can make your Tableau Prep flow more dynamic and each time the flow is run, Tableau Prep will evaluate the data against the current date or time period. In this recipe, we'll perform a calculation using today's date as a relative anchor. That is, if you execute the flow on July 4, our calculation will use July 4 as a relative point in time. If you execute the same flow the next day, Tableau Prep will automatically adjust to July 5. In this recipe, we'll calculate the age of support tickets for a company's helpdesk, relative to today, that is, how long a support ticket has been open.

Getting ready

To follow along with this recipe, download the Sample Files 7.5 folder from this book's GitHub repository. There, you'll find the Support Requests Extract.csv...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

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 $15.99/month. Cancel anytime}

Authors (1)

Hendrik Kleine

Hendrik Kleine is an advanced analytics leader with 15 years of experience in the analytics space, including in data architecture, engineering, and visualization. He specializes in translating vast amounts of data into easy-to-understand visual communications that provide actionable intelligence. He is an avid innovator and a listed author of multiple data-related inventions. Before COVID-19, he was a speaker at the most recent Tableau conference in San Francisco.

See other products by Hendrik Kleine

Other recommended products

Related to this chapter

Tableau Desktop Certified Associate: Exam Guide

Tableau Desktop Certified Associate: Exam Guide

Tableau Desktop Certified Associate: Exam Guide is a practical book full of exercises and examples that help you master Tableau Desktop and successfully pass the certification with ease. This book includes complete, up-to-date coverage of the exam so you can take them with confidence, fully equipped to pass the first time.

Dec 2019 12 hours 20 minutes

Learning Tableau 2020

Learning Tableau 2020

Thousands of enterprises worldwide use Tableau as the solution for their data issues, big and small. With this updated edition, you will develop a firm grip on data visualization using Tableau 2020 and master all of the core features that enable you to explore, prepare, fix, and present data quickly and easily.

Aug 2020 19 hours 12 minutes

Learning Tableau 2019

Learning Tableau 2019

Tableau 2019 is the gold standard of business intelligence and visual analytics. It empowers rapid data visualization and advanced analytics with charts, graphs, dashboards, and powerful analytic tools. This book lays a strong foundation of the Tableau paradigm and builds to advanced topics, including Tableau Prep, to make you an expert.

Mar 2019 16 hours 48 minutes

Getting Started with Tableau 2018.x

Getting Started with Tableau 2018.x

Tableau is one of the leading data visualization tools and regularly adds new functionalities to the product. This book will help you understand these new features with clear examples, and is also an excellent beginner's guide to start using Tableau in the most efficient way.

Sep 2018 13 hours 12 minutes

Tableau 2019.x Cookbook

Tableau 2019.x Cookbook

Explore recipes for analysis, visualization, and more with the Tableau 2019.x Cookbook. You’ll cover more than 115 recipes, discover best practices, and expert techniques as you progress through the book.

Jan 2019 22 hours 20 minutes

Mastering Tableau 2021

Mastering Tableau 2021

A comprehensive resource to mastering your Tableau skills and becoming a BI expert. This guide will teach you how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

May 2021 26 hours 24 minutes

Getting Started with Tableau 2019.2

Getting Started with Tableau 2019.2

This book will help you understand the new features of Tableau with clear examples, and is also an excellent beginner's guide to start using Tableau in the most efficient way. Furthermore, this book is a guide that will help you through all the steps to perform powerful analysis using Tableau.

Jun 2019 8 hours 40 minutes

Mastering Tableau 2019.1

Mastering Tableau 2019.1

The perfect guide to master your Tableau skills to become a proficient BI expert. You will learn to build advanced dashboards and storytelling to derive key business insights. An all in one resource to get well versed with advanced functionalities of Tableau in business intelligence domain

Feb 2019 18 hours 36 minutes

Tableau 10 Bootcamp

Tableau 10 Bootcamp

Tableau is a leading visual analytics software that can uncover insights for better and smarter decision making. Tableau has an uncanny ability to beautify your data, compared to other BI tools, which makes it an ideal choice for performing fast and easy visual analysis. This book will be a guide for anyone who wants to have practical knowledge and exercises and get up to speed with Tableau in no time.

Sep 2017 12 hours 48 minutes

Personalised recommendations for you

Based on your interests and search pattern

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

Aug 2023 7 hours 40 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Mastering Tableau 2023

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

Aug 2023 22 hours 48 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Data Engineering with AWS

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

Oct 2023 21 hours 12 minutes

Modern Data Architecture on AWS

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

Aug 2023 14 hours 0 minutes

Practical Guide to Applied Conformal Prediction in Python

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

Dec 2023 8 hours 0 minutes

TinyML Cookbook

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

Nov 2023 22 hours 8 minutes