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
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
chevron up
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

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...

End of Section 2
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