Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Learning Tableau
  • Toc
  • feedback
Learning Tableau

Learning Tableau

By : Joshua N. Milligan
3.8 (22)
close
Learning Tableau

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.
Table of Contents (13 chapters)
close
close
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
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
2. Working with Data in Tableau
chevron up
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
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
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
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
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
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
8. Adding Value to Analysis – Trends, Distributions, and Forecasting
8. Adding Value to Analysis – Trends, Distributions, and Forecasting
Trends
Distributions
Forecasting
Summary
9
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
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
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
12
Index
Index

Joins and blends

Joining tables and blending data sources are two different ways to link related data together in Tableau. Joins are performed to link tables of data together within a single data source. Blends are performed to link together multiple data sources.

Joining tables

Most databases have multiple tables of data that are related in some way. Imagine you have been asked to analyze data in a simple database at a hospital with four main tables, related like this:

Joining tables

The primary table is the Visit table that has a record for every visit of a patient to the hospital and includes details such as the start and end dates and the type of visit (for example, inpatient, outpatient, ER). It also contains key fields that link a visit to a patient, a treatment, and a physician. You have confirmed that every visit has a patient and a physician, but some visits do not necessarily result in a treatment.

When you connect to the database in Tableau, you'll see the four tables listed on the left....

End of Section 6
Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete