tableau alterx

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/

http://www.analyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/tableau-learning-path/

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

http://public.tableau.com/profile/jen.underwood#!/vizhome/PredictiveDataVisualizationwithSSASDataMining/Classification

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://stackoverflow.com/questions/26532316/tableau-8-1-linking-dashboard-with-url-to-open-in-the-same-explorer-page

http://michaellynton.com/blog/2015/1/tableau-101

http://www.slideshare.net/21_venkat/learning-tableau-data-graphs-filters-dashboards-and-advanced-features

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