9. Making Data Work for You | Learning Tableau

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Tableau

By : Joshua N. Milligan

3.8 (22)

Learning Tableau

3.8 (22)

By: Joshua N. Milligan

Overview of this book

If you want to understand your data using data visualization and don't know where to start, then this is the book for you. Whether you are a beginner or have years of experience, this book will help you to quickly acquire the skills and techniques used to discover, analyze, and communicate data visually. Some familiarity with databases and data structures is helpful, but not required.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Creating Your First Visualizations and Dashboard

1. Creating Your First Visualizations and Dashboard

Connecting to data in Access

Foundations for building visualizations

Visualizing data

Bringing everything together in a dashboard

Summary

2. Working with Data in Tableau

2. Working with Data in Tableau

The Tableau paradigm

Connecting to data

Working with extracts instead of live connections

Metadata and sharing data source connections

Joins and blends

Filtering data

Summary

3. Moving from Foundational to Advanced Visualizations

3. Moving from Foundational to Advanced Visualizations

Comparing values across different dimensions

Visualizing dates and times

Relating parts of the data to the whole

Visualizing distributions

Visualizing multiple axes to compare different measures

Summary

4. Using Row-level and Aggregate Calculations

4. Using Row-level and Aggregate Calculations

Creating and editing calculations

Three levels of calculation

Parameters

Practical examples of calculations and parameters

Ad hoc calculations

Performance considerations

Summary

5. Table Calculations

5. Table Calculations

An overview of table calculations

Quick table calculations

Scope and direction

Addressing and partitioning

Advanced table calculations

Practical examples

Summary

6. Formatting a Visualization to Look Great and Work Well

6. Formatting a Visualization to Look Great and Work Well

Formatting considerations

How formatting works in Tableau

Adding value to visualizations

Summary

7. Telling a Data Story with Dashboards

7. Telling a Data Story with Dashboards

Dashboard objectives

Example – is least profitable always unprofitable?

How actions work

Example – a regional scorecard

Story points

Summary

8. Adding Value to Analysis – Trends, Distributions, and Forecasting

8. Adding Value to Analysis – Trends, Distributions, and Forecasting

Trends

Distributions

Forecasting

Summary

9. Making Data Work for You

9. Making Data Work for You

Structuring data for Tableau

Dealing with data structure issues

An overview of advanced fixes for data problems

Summary

10. Advanced Techniques, Tips, and Tricks

10. Advanced Techniques, Tips, and Tricks

Sheet swapping and dynamic dashboards

Leveraging sets to answer complex questions

Mapping techniques

Using background images

Summary

11. Sharing Your Data Story

11. Sharing Your Data Story

Presenting, printing, and exporting

Sharing a workbook with users of Tableau Desktop or Tableau Reader

Sharing data with users of Tableau Server, Tableau Online, and Tableau Public

Summary

Index

Index

An overview of advanced fixes for data problems

In addition to the techniques shown in the previous sections, there are some additional possibilities for dealing with data structure issues. It is outside the scope of this book to develop these concepts fully. However, given some familiarity with these approaches, you broaden your ability to deal with challenges as they arise:

Custom SQL: This can be used in data connection to resolve some data problems. Custom SQL is not an option for all data sources but is for many relational databases and for legacy JET driver connections. Consider a custom SQL script that takes the wide table of country populations mentioned earlier in this chapter and restructures it into a tall table:
```
SELECT [Country Name],[1960] AS Population, 1960 AS Year
FROM Countries

UNION ALL

SELECT [Country Name],[1961] AS Population, 1961 AS Year
FROM Countries

UNION ALL 

SELECT [Country Name],[1962] AS Population, 1962 AS Year
FROM Countries
...
...
```
It might be a little...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Tableau

Search

Your notes and bookmarks