Search icon Close icon
Search icon
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
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
Author (1):
Hendrik Kleine Hendrik Kleine
Profile icon Hendrik Kleine
LinkedIn
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

Table of Contents (11) Chapters

Preface Chapter 1: Getting Started with Tableau Prep Chapter 2: Extract and Load Processes Chapter 3: Cleaning Transformations Chapter 4: Data Aggregation Chapter 5: Combining Data Chapter 6: Pivoting Data Chapter 7: Creating Powerful Calculations Chapter 8: Data Science in Tableau Prep Builder Chapter 9: Creating Prep Flows in Various Business Scenarios Other Books You May Enjoy

Using fixed LOD calculations for grouping data

Level of Detail or LOD calculations are calculation expressions that have been available in Tableau Desktop for some time. An LOD calculation allows you to aggregate your data at different levels of granularity within a single dataset.

For example, you might have a dataset with customer orders, where each row represents a single line item in an order. You might want to aggregate revenue by order, or by customer, without losing the granularity of your data. This is where LOD calculations come into play. In this recipe, you'll create an LOD calculation. In doing so, you'll group your data into distinct buckets and aggregate values in a single step.

Getting ready

To follow along with this recipe, download the Sample Files 4.3 folder from this book's GitHub repository. You must have Tableau Prep version 2020.1 or greater to leverage the LOD functionality.

How to do it…

Start by opening Tableau Prep and...

lock icon The rest of the chapter is locked
arrow left Previous Chapter
Chapter 1 of 11
Next Chapter arrow right
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.
Sign up now
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)

Profile icon Hendrik Kleine
LinkedIn
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
Left arrow icon
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
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
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.
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
Right arrow icon