book

Tableau 10 Business Intelligence Cookbook

Name: Tableau 10 Business Intelligence Cookbook
ISBN: 9781786465634

by Donabel Santos, Paul Banoub

November 2016

Beginner to intermediate

476 pages

9h 2m

English

Packt Publishing

Read now

Unlock full access

Tableau 10 Business Intelligence Cookbook
Table of Contents
Tableau 10 Business Intelligence Cookbook
Credits
About the Author
Acknowledgements
About the Reviewer
www.PacktPub.com
eBooks, discount offers, and moreWhy Subscribe?
Preface
What this book covers
What you need for this book

Who this book is for
Sections
Getting readyHow to do it…How it works…There's more…See also
Conventions
Reader feedback
Customer support
Downloading the workbook startersErrataPiracyQuestions
1. Basic Charts
Introduction
Creating a bar chart
Getting readyHow to do it...How it works...There's more...See also
Creating a stacked bar chart
Getting readyHow to do it...How it works...There's more...See also
Creating a line chart
Getting readyHow to do it...How it works...There's more...See also
Creating a scatter plot
Getting readyHow to do it...How it works...
Creating a heat map
Getting readyHow to do it...How it works...There's more...See also
Creating a text table (crosstab)
Getting readyHow to do it...How it works...There's more...See also
Creating a highlight table
Getting readyHow to do it...How it works...See also
Creating an area chart
Getting readyHow to do it...How it works...There's more...See also
Creating a pie chart
Getting readyHow to do it...How it works...There's more...See also
Creating a bubble chart
Getting readyHow to do it...How it works...There's more...See also
Creating a word cloud
Getting readyHow to do it...How it works...There's more...See also
Creating a tree map
Getting readyHow to do it...How it works...There's more...See also
2. Advanced Charts
Introduction
Creating a histogram
Getting readyHow to do it...How it works...There's more...
Creating a small multiple chart
Getting readyHow to do it...How it works...There's more...See also
Creating a shared axis chart
Getting readyHow to do it...How it works...There's more...See also
Creating a combo chart (dual axis chart)
Getting readyHow to do it...How it works...There's more...See also
Creating a bullet chart
Getting readyHow to do it...How it works...There's more...See also
Creating a bar in bar chart
Getting readyHow to do it...How it works...There's more...See also
Creating a donut chart
Getting readyHow to do it...How it works...There's more...See also
Creating a unit chart
Getting readyHow to do it...How it works...There's more...
Creating a box and whisker chart
Getting readyHow to do it...How it works...There's more...See also
Creating a sparkline with indicators
Getting readyHow to do it...How it works...There's more...See also
Creating a KPI text table
Getting readyHow to do it...How it works...There's more...See also
Creating a waterfall chart
Getting readyHow to do it...How it works...There's more...
Creating a population pyramid
Getting readyHow to do it...How it works...There's more...See also
3. Interactivity
Introduction
Creating a motion chart
Getting readyHow to do it…How it works…There's more…See also
Creating a dynamic column/row trellis chart
Getting readyHow to do it…How it works…See also
Creating a top/bottom N filter
Getting readyHow to do it…How it works…See also
Comparing one to everything else
Getting readyHow to do it...How it works…There's more...See also
Dynamically displaying dimensions
Getting readyHow to do it...How it works…See also
Dynamically displaying and sorting measures
Getting readyHow to do it…How it works…There's more…See also
Creating a custom date period filter
Getting readyHow to do it…How it works…See also
4. Dashboards and Story Points
Introduction
Creating a filter action
Getting readyHow to do it...How it works...There's more...
Creating a highlight action
Getting readyHow to do it...How it works...There's more...
Creating a URL action
Getting readyHow to do it...How it works...There's more...See also
Creating an Infographic-like dashboard
Getting readyHow to do it...How it works...There's more...See also
Creating story points
Getting readyHow to do it...How it works...There's more...
5. Maps and Geospatial Visualization
Introduction
Adding data layers to map
Getting readyHow to do it...How it works...There's more...
Creating custom territories
Getting readyHow to do it...How it works...There's more...See Also
Working with Web Map Service (WMS)
Getting readyHow to do it...How it works...There's more...
Using path to display movement in map
Getting readyHow to do it...How it works...There's more...See also
Mapping custom polygons
Getting readyHow to do it...How it works...
Importing custom geocoding
Getting readyHow to do it...How it works...
Using a custom image background
Getting readyHow to do it...How it works...There's more...
6. Analytics
Introduction
Adding a constant line
Getting readyHow to do it...How it works...See also
Adding a trend line
Getting readyHow to do it...How it works...There's more...See also
Using a reference line
Getting readyHow to do it...How it works...There's more...See also
Adding a reference band
Getting readyHow to do it...How it works...See also
Performing cluster analysis
Getting readyHow to do it...How it works...There's more...See also
Visualizing forecast
Getting readyHow to do it...How it works...There's more...See also
Performing linear regression with R
Getting readyHow to do it...How it works...See also
7. Data Preparation
Introduction
Using the Data Interpreter and pivot
Getting readyHow to do it...How it works...There's more...See also
Using the legacy Jet driver
Getting readyHow to do it...How it works...There's more...See also
Using schema.ini to resolve data type issues
Getting readyHow to do it...How it works...There's more...
Pivoting columns
Getting readyHow to do it...How it works...See also
Using union
Getting readyHow to do it...How it works...There's more...See also
Using join
Getting readyHow to do it...How it works...There's more...See also
Using blend
Getting readyHow to do it...How it works...There's more...See also
A. Calculated Fields Primer
Different ways to create calculated fields
Calculated field window
Functions in Tableau
Function syntax
Word of caution
Different types of calculated fields
Regular calculated fieldsRow levelGroup level (or aggregation)Row level versus aggregationsTable calculationsLevel of detail expressionsFIXEDINCLUDEEXCLUDESignificance of LODsOrder of operationsDeep dive
Dealing with NULLs
Tidbits
Cannot mix aggregate and non-aggregate argumentsDiscrete fields in measuresHow ATTR works
Conclusion
B. Resources
Data sources for recipes in this book
Articles and white papers
Blogs and additional resources
Index

Content preview from Tableau 10 Business Intelligence Cookbook

Tidbits

Here are a few tidbits/tricks that you may find helpful as you venture into the world of calculated fields in Tableau (Conversion error):

Cannot mix aggregate and non-aggregate arguments

One of the most common calculation errors you may encounter will be related to mixing aggregate and non-aggregate arguments in functions:

What this simply states is that if one part of the calculation is an aggregation (such as SUM, AVG, MAX, and MIN), all other parts should also be aggregations.

This becomes tricky when working with level of detail calculations. For example, we may have an LOD expression that gets a FIXED sum of sales:

What if we need to use ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

CFO Techniques: A Hands-On Guide to Keeping Your Business Solvent and Successful

Publisher Resources

ISBN: 9781786465634

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Tableau 10 Business Intelligence Cookbook

by Donabel Santos, Paul Banoub

Tidbits

Cannot mix aggregate and non-aggregate arguments

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.