Data
Reader small image

You're reading from  Tableau Prep Cookbook

Product typeBook
Published inMar 2021
PublisherPackt
ISBN-139781800563766
Edition1st Edition
Tools
Tableau
Concepts
Business Intelligence
Right arrow
Author (1)
Hendrik Kleine
Hendrik Kleine
author image
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.
Read more about Hendrik Kleine

Right arrow

Expanding datasets using a not inner join

In this chapter, we have assumed in all join-related recipes that there was an overlap between two data sources. However, for analysis purposes, you may be interested in what data is not overlapping, so that you can take action appropriately.

Using the same data as we've used in the Expanding datasets using a full outer join recipe, where we have a data source with projects, and another data source with project staff, we may change our use case to focus solely on data that does not overlap. That is, we are only interested in projects without staff assigned to them, or staff members not currently assigned to work on any project.

Getting ready

To follow along with this recipe, download the Sample Files 5.6 folder from this book's GitHub repository.

How to do it…

Start by opening Tableau Prep and perform the following steps to create a not inner join:

  1. Connect to the Projects.xlsx Excel file in order to create...
lock icon
The rest of the page is locked
Previous Page
Chapter 6 of 11, Page 8
Next Chapter
You have been reading a chapter from
Tableau Prep Cookbook
Published in: Mar 2021Publisher: PacktISBN-13: 9781800563766
© 2021 Packt Publishing Limited All Rights Reserved

Author (1)

author image
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.
Read more about 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.

BookDec 2019370 pages
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.

BookAug 2020576 pages
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.

BookMar 2019504 pages
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.

BookSep 2018396 pages
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.

BookJan 2019670 pages
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.

BookMay 2021792 pages
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.

BookJun 2019260 pages
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

BookFeb 2019558 pages
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.

BookSep 2017384 pages

Personalised recommendations for you

Based on your interests and search pattern

Et al.

Et al.

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.

BookAug 2023230 pages5
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.

BookDec 2023360 pages4
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.

BookDec 2023360 pages5
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.

BookDec 2023360 pages1
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.

BookDec 2023360 pages5
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.

BookAug 2023684 pages
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.

BookSep 2023258 pages5
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.

BookSep 2023258 pages2
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.

BookOct 2023636 pages5
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.

BookAug 2023420 pages5
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.

BookDec 2023240 pages
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.

BookNov 2023664 pages