Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Tableau 2019.1

You're reading from   Mastering Tableau 2019.1 An expert guide to implementing advanced business intelligence and analytics with Tableau 2019.1

Arrow left icon
Product type Paperback
Published in Feb 2019
Publisher
ISBN-13 9781789533880
Length 558 pages
Edition 2nd Edition
Languages
Tools
Arrow right icon
Authors (2):
Arrow left icon
Marleen Meier Marleen Meier
Author Profile Icon Marleen Meier
Marleen Meier
David Baldwin David Baldwin
Author Profile Icon David Baldwin
David Baldwin
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Preface 1. Section 1: Tableau Concepts, Basics FREE CHAPTER
2. Getting Up to Speed - A Review of the Basics 3. All About Data - Getting Your Data Ready 4. Tableau Prep 5. All About Data - Joins, Blends, and Data Structures 6. All About Data - Data Densification, Cubes, and Big Data 7. Table Calculations 8. Level of Detail Calculations 9. Section 2: Advanced Calculations, Mapping, Visualizations
10. Beyond the Basic Chart Types 11. Mapping 12. Tableau for Presentations 13. Visualization Best Practices and Dashboard Design 14. Advanced Analytics 15. Improving Performance 16. Section 3: Connecting Tableau to R, Python, and Matlab
17. Interacting with Tableau Server 18. Programming Tool Integration 19. Other Books You May Enjoy

Exercise: materialized calculations

Follow along the exercise steps:

  1. In Tableau, select New > New to create a new workbook.
  2. In the new workbook, select Data > New Data Source and connect to the Sample Superstore dataset located in My Tableau Repository/Datasources.
  3. Connect to the Orders worksheet.
  4. Create the following parameters:

Parameter

Name

Select Sufficient Profit Ratio

Data Type

Float

Allowable Values

Range

Min/Max

0.25 - 0.5

Step Size

0.01

  1. Create the following calculated fields:

Name

Calculation

Profit Ratio

SUM([Profit])/SUM([Sales])   

This Year's Profit

IF [Profit Ratio] > [Select   Sufficient Profit Ratio] THEN "Sufficient Profit" END   

Window Sum

WINDOW_SUM(SUM([Sales]))   

Profitable?

[Profit] > 0   
  1. Right-click on the data source and select Extract data.
  2. Click the...
lock icon 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
Renews at €18.99/month. Cancel anytime