ALTERX
http://downloads.alteryx.com/
https://www.interworks.com/blog/channel/alteryx
https://www.quora.com/Is-there-an-inexpensive-alternative-to-Tableau
https://medium.com/@vizanalytics/tableau-spark-cassandra-d3c447333394#.1cd6hyybm
TABLEAU
https://www.tableau.com/about/blog/2017/5/5-built-stats-functions-you-didnt-know-tableau-had-71047
https://www.tableau.com/about/blog/2017/4/lets-talk-advanced-analytics-68604
https://www.analyticsvidhya.com/blog/2018/01/tableau-for-intermediate-data-science/
https://www.youtube.com/watch?v=gCkg54ftERE
http://dgdataservices.blogspot.com/p/the-world-of-tableau_23.html
http://bensullins.com/tableau-vs-d3-one-use/
http://bensullins.com/category/tableau-tips/
https://www.youtube.com/watch?v=irNGirDOkJU&feature=share
Analytics with Tableau
http://www.datasciencecentral.com/group/announcements/forum/topics/advanced-analytics-with-tableau-whitepaper
Tableau+R
http://interworks.co.uk/blog/linear-regression-interacting-trend-line/
https://3danim8.wordpress.com/2014/07/31/date-aggregations-and-linear-modeling-with-r-in-tableau/
dimensions
text, dates
number may be a dimension, eg. auto incremented PK, orderId
Columns: cycle
Rows: SUM(capacityEnd)
measures
- numeric values which can be used for sum, count, etc
multilple measures on single plot
https://onlinehelp.tableau.com/current/pro/online/mac/en-us/multiplemeasures_blendedaxes.html
Filter
http://onlinehelp.tableau.com/current/pro/online/en-us/help.htm#filtering.html
http://onlinehelp.tableau.com/current/pro/online/en-us/help.htm#filtering_add_quick_options.html
parameters
select C.cycle, C.stateIndex, C.state, C.testId,
C.voltageMin, C.voltageMax, C.voltageBeginning, C.voltageEnd,
C.capacityMin, C.capacityMax, C.capacityBeginning, C.capacityEnd,
C.energyMin, C.energyMax, C.energyBeginning, C.energyEnd,
C.currentMin, C.currentMax, C.currentBeginning, C.currentEnd,
T.name, T.designation, T.sampleId, T.Barcode, T.temperature
from MaccorCycle C, tableau_testrun_view T
where C.testRunId=T.testRunId
and C.testId=<Parameters.TestId>
Example
Data Source: new Custom SQL
Edit custom SQL - inser parameter: TestId
Move to dimensions from measures:
sampleId, cycle, temperature
Columns: cycle, to fit the screen make cycle the continuous (it is discrete by default)
Rows: capacityEnd, VoltageEnd
Add to filters:
temperature, state
Add to color:
sampleId - in order to get rid of SUM(capacityEnd)
Marks:
line
add sampleId to color
Show:
testId, temperature
Add designation and name to Marks/Detail to have them in Title parameters
Project=<designation> Test=<name> TestId=<Parameters.TestId> Temperature=<temperature>C State=<state>
Question: how to fit X-axis to screen?
Answer: set the Columns attribute to continuous (if it is discrete) or choose "Fit Width" on toolbar
Question: how to allow user to select which metric to plot on Y axis?
http://vizwiz.blogspot.com/2012/07/tableau-tip-dynamic-axis-selections.html
http://kb.tableau.com/articles/knowledgebase/creating-sheet-selector-for-dashboard
http://kb.tableau.com/articles/knowledgebase/parameterized-measure
do not forget to add it to the title!
how to use a Calculated Field with a CASE statement in this manner to dynamically select a dimension/measure
CASE [Choose a measure]
WHEN "capacity" THEN [capacityEnd]
WHEN "energy" THEN [energyEnd]
WHEN "voltage" THEN [voltageEnd]
WHEN "current" THEN [currentEnd]
END
How to display Master->Child relation in Tableau
Example: master: Project child: Test, test id
Put them all under Dimensions;
Marks: "ABC Text"
Rows: Project, testId
Marks: add "Test" to "Text" box
https://www.youtube.com/watch?v=yh8g73UEUtw
https://www.youtube.com/watch?v=bK0s3FV9PTA
http://drawingwithnumbers.artisart.org/want-to-learn-table-calculations/
http://michaellynton.com/blog/2015/1/tableau-101
http://www.slideshare.net/TableauSoftware
https://www.interworks.com/blog/channel/tableau
http://padawandojo.tumblr.com/post/118909494969/tableau-js-api-101
dashboard in Tableau is a collection of individual worksheets that you’ve created and gathered into one bigger worksheet.
A shelf is an area on the visualization screen where you can drop pieces of data so that Tableau can act on them. What Tableau does with a pill depends on which shelf you drag it to.
There are four kinds of shelves:
Columns - X axis (dimension)
Rows - Y axis (measure)
Pages
Filters