See all 4 dimensions (time) in Tableau visualizations
Understanding the trend of numbers over time is a fundamental skill. That’s why it’s taught in elementary school. Why?
“Those who don’t know history are doomed to repeat it.” – Edmund Burke
Below are vizualizations that have the following traits:
Dynamic data - update visualizations (in “live mode”) as data changes in sources such as databases.
Visual querying - change the query by selecting or clicking on a portion of the graph or chart (to drill down, for example).
Linked multi-dimensional visualization - selections made in one chart are reflected as you navigate into other charts.
PROTIP: Dynamic (movie mode) is available only within the Tableau Public client, not when viewed on websites (as of 2016-01-05).
Personalization - give power users an in-depth view and newbies a simpler view, and also control access to data based on user- and role-based access privileges.
Actionable alerts - thresholds and parameters that trigger messages whether you’re interacting with reports or not.
Fortune 500 in the US
Select an industry and mouse over a line to see each company’s ranking change over the last 20 years. The higher each line appears, the higher the company is on Fortune magazine’s 500 largest public companies.
Companies that have a rising trajectory include:
- Whole Foods Market
- Alphabet (Google)
- CVS Health
- Dollar General
- Gilead Sciences
- Master Card
Illustrates the fast growth across industries in China.
Nicolas Rapp also created for Fortune 500 this graphic:
Since 2007 at http://www.gapminder.org/videos/ Hans Roling, a professor of health statistics in Sweden, is an internet legend for his “Joy of Stats” video shown on BBC Nov 10, 2010 and Ted Talks. In them he shows his Gapminder web app which presents multiple dimensions dynamically over time (nearly 300).
Jeffrey Shaffer (@HighVizAbility, co-author of bigbookofdashboards.com) created a time lapse video of his viz showing a trail of dots which grow in size and get darker over time (as the legend notes):
Here, different colors represent different countries, with the United States in red. Most other countries saw a decrease in fertility rate over time while life expectantcy increased.
The trails is a recreation of (@moritz_stefaner) “Remixing Rosling” in @tableau.
- Percent of value-add time vs. total time. For example: In the case of physician visits, time interacting with physician vs. waiting and other activities.
Time Series databases
KDB proprietary runs in-memory within a single machine.
Graphite - legacy invented by Expedia - does automatic roll-ups of data (losing irregular values)
RiakTS from Basho is built for scale
Promethius for DevOps (highly available with scaleout?)
OpenTSDB is a layer on top of HBase.
TimescaleDB, an open source time-series database engineered from PostgreSQL,
InfluxDB, open-source (MIT)
- No external dependencies (written in Go)
- SQL-like query language
- Input data “Line Format” (not JSON)
- Stores data in compressed format
Horizontally scaleable (across several servers)
- Kapacitor collects anomalies
See video “How to Manage TensorFlow with InfluxData” (The TensorFlow Jupyter notebook for weather prediction is shown from 17:24)
Microsoft Azure introduced in 2017 their Time Series Insights.
You need to add your account to it so you can view the Time Series portal at https://insights.timeseries.azure.com for an Environment you define.
More on front-end styling
This is one of several topics:
- Text Editors
- Markdown text for GitHub from HTML
- JAM Stack Website Project Plan
- HTTP/2 Transition Project Plan
- Static websites
- Website styles
- Email from website
- Search within Hyde format Jekyll websites
- Data Visualization using Tableau