Additional resources:•
- Tableau e-Learning https://www.tableau.com/learn/training/elearning
- Tableau Starter Kits https://www.tableau.com/learn/starter-kits
...
- Free How-To Training Videos https://www.tableau.com/learn/training
...
- Tableau Product Support https://www.tableau.com/support
...
- Tableau Product Help https://www.tableau.com/support/help
- Tableau desktop online help https://onlinehelp.tableau.com/current/pro/desktop/en-us/default.htm
- Visual Best Practices https://www.tableau.com/learn/whitepapers/tableau-visual-guidebook?signin=c6cf87638b3864d1c393ffafb79ae10c
- Tableau
...
- e-learning http://elearning-samples.tableau.com/?signin=3edb332f2aeed9950ec3f411d54a66f9
- Tableau tutorials http://www.science.smith.edu/~jcrouser/SDS136/labs/
- Using R and Tableau
- Learning Tableau Notes
- Tableau Qualified Associated Exam https://www.linkedintableau.com/learn/pulsewhitepapers/iusing-r-got-tableau-certified-you-can-too-saahithi-jyothy-surapaneni/
- https://biztory.com/2017/02/17/ace-tableau-desktop-qualified-associate-exam/
- Tableau Qualified Associate Certification Quizzes https://learningtableau.com/
- Equations of Trend Line: https://www.khanacademy.org/math/probability/scatterplots-a1/estimating-trend-lines/a/equations-of-trend-lines-phone-data
- The slope of the trend line represents the predicted change in the vertical variable that's associated with a one-unit change in the horizontal variable.
- e.g. y = −0.75x + 9, x, time spent on phone, y, battery life remaining. For each additional 1 hour of time spent on the phone, the predicted battery life remaining decreases by 0.75 hours.
- The y-intercept of the model describes the predicted y value when x = 0.
- When the time spent on her phone is 0 hours, the predicted battery life remaining is 9 hours.
- Use the trend line to predict the battery life remaining after 20 hours of phone use. The predicted battery life is -6 hours.
- The slope of the trend line represents the predicted change in the vertical variable that's associated with a one-unit change in the horizontal variable.
- and-tableau
- Data Psientist http://datapsientist.blogspot.com/2014/10/tableau-trick-for-work-min1.html
- Tableau Chart Catalog https://www.kevinflerlage.com/
- Hear from Tableau community members about their favorite tips and tricks on the blog
- Participate in community-led projects like #MakeoverMonday or #WorkoutWednesday
- Visual Analytics with Tableau by Alexander Loth https://www.amazon.com/Visual-Analytics-Tableau-Alexander-Loth-ebook-dp-B07QH5V2HR/dp/B07QH5V2HR/ref=mt_other?_encoding=UTF8&me=&qid=1611589401
- Which chart or graph is right for you https://www.tableau.com/sites/default/files/media/which_chart_v6_final_0.pdf
- Filter data from your views https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
- Set Up Data Sources https://help.tableau.com/v10.5/pro/desktop/en-us/datasource_prepare.html?TocPath=Connect%20to%20and%20Prepare%20Data|Set%20Up%20Data%20Sources|_____0
- Makeovermonday https://www.makeovermonday.co.uk/
- Tableau public FAQ https://community.tableau.com/s/tableau-public-faq#subhead19
Data sources
- Data sets for students https://www.tableau.com/data-sets-students
- Tableau sample data sources https://public.tableau.com/s/resources
- Texas Education Agency https://schoolsdata2-tea-texas.opendata.arcgis.com/
Tableau Viz Examples
- TC20 Viz Gallery https://vizgallery.tableaupublic.com/
- Rice Office of Institutional Research https://public.tableau.com/profile/rice.oir#!/
- Enrolled Students at Rice https://oir.rice.edu/students-scholars/enrollment/enrolled-students
- Tableau Viz Gallery https://www.tableau.com/solutions/gallery
- Data is beautiful: 10 of the best data visualization examples from history to today Tableau Online tips: Extracts, live connections, & cloud data
Read more at https://www.tableau.com/about/blog/2016/4/tableau-online-tips-extracts-live/learn/articles/best-beautiful-data-visualization-examples - Tableau Viz examples https://www.tableau.com/trial/tableau-examples?utm_campaign_id=2017049&utm_campaign=Prospecting-CORE-ALL-ALL-ALL-ALL&utm_medium=Paid+Search&utm_source=Google+Search&utm_language=EN&utm_country=USCA&kw=%2Btableau%20%2Bexamples&adgroup=CTX-Brand-Examples-B&adused=329493725742&matchtype=b&placement=&gclid=EAIaIQobChMI5-yk48qC4wIVGp7ACh3VTAGTEAAYASAAEgJDcfD_BwE&gclsrc=aw.ds
- Education data analytics https://www.tableau.com/solutions/education-analytics
- Student Viz Assignments Contest -connections-cloud-data-53351#mBSZbbl3ib5KM0W2.99LOD
top 15 LOD expressions https://www.tableau.com/about/blog/LOD-expressionsacademic/student-viz-assignment-contest
Tableau Certification
- Desktop Desktop Specialist How Level of Detail Expressions Work in Tableau https://onlinehelpwww.tableau.com/currentlearn/procertification/desktop/en-us/calculations_calculatedfields_lod_overview.htm
For example, if you attempt to save the following expression, Tableau displays the error message: “Cannot mix aggregate and non-aggregate arguments with this function”:
[Sales] – AVG([Sales]). In this expression, [Sales] is a row level expression, whereas AVG([Sales]) is an aggregate function.
The user’s intent in this case was to compare store sales for each individual store to the average of sales for all stores. This can now be accomplished with a level of detail expression:
[Sales] - {AVG([Sales])}. So the Table-scoped LOD is a row level expression.
This is what is known as a table-scoped level of detail expression. See Table-Scoped.
Table-Scoped
It is possible to define a level of detail expression at the table level without using any of the scoping keywords. For example, the following expression returns the minimum (earliest) order date for the entire table:{MIN([Order Date])}
This is equivalent to a FIXED level of detail expression with no dimension declaration:
{FIXED : MIN([Order Date])}
- Exam Prep Guide: Download Here
- The tds_sample_data_all.xlsx file, which can be downloaded here.
- Tableau Desktop Associate https://www.tableau.com/learn/certification/desktop-certified-associate
- Exam Prep Guide: Download Here
- The dataset Sample-Superstore Subset (Excel), which can be downloaded here.
- Tableau Desktop Professional https://www.tableau.com/learn/certification/desktop-certified-professional
- Exam Prep Guide: Download Here
NLSY sample data
- link to data NLSY-TableauIII-JZ.zip
- link to online Viz https://public.tableau.com/views/NLSY-TableauIII-JZ/NLSY?:display_count=y&:origin=viz_share_link
Access and analyze trusted COVID-19 (Coronavirus) global data with Tableau
- COVID-19 Starter Workbook https://www.tableau.com/covid-19-coronavirus-data-resources
- COVID-19 DATA HUBhttps://www.tableau.com/covid-19-coronavirus-data-resources
- COVID-19 Coronavirus Cases & Deaths by Country https://www.kff.org/global-health-policy/fact-sheet/coronavirus-tracker/
- The New York Times: Every Case in the United States https://www.nytimes.com/interactive/2020/us/coronavirus-us-cases.html
Data visualization
- Data visualization 'chart chooser' quick-reference guide http://experception.net/
Mapping with Tableau
- Tableau supported map data https://www.tableau.com/mapdata
- Maps in Tableau https://blogs.library.duke.edu/data/2020/03/06/maps-in-tableau/
- Build maps in Tableau https://help.tableau.com/current/pro/desktop/en-us/maps_build2.htm
Find or enter latitude & longitude using Google maps https://support.google.com/maps/answer/18539?co=GENIE.Platform=Desktop&hl=en
- Plotting Geographic Data Using Custom Longitude and Latitude Values https://kb.tableau.com/articles/HowTo/plotting-geographic-data-using-custom-longitude-and-latitude?_ga=2.217608596.307437626.1617026316-759512344.1589412945&_gac=1.3395460.1614219672.EAIaIQobChMI5-yk48qC4wIVGp7ACh3VTAGTEAAYASAAEgJDcfD_BwE
Where to find spatial files
- Tableau help https://help.tableau.com/v2020.1
Standard deviation 5 built-in stats functions you didn’t know Tableau had
Read more at https://www.tableau.com/about/blog/2017/5/5-built-stats-functions-you-didnt-know-tableau-had-71047#Ie7YC370KgmItK3q.99Q&A
Which type of connection support Extract ? Select all that apply (all four choices)
1. Join
2. Blend
2. Cross Database Join
4. Union
- Which file type supports live connection https://onlinehelp.tableau.com/current/pro/desktop/en-us/exampleconnectionsmaps_overviewshapefiles.htm supported conectors
- Microsoft Excel
- text file (delimited text files (*.txt, *.csv, *.tab, *.tsv)
- JSON PDF
- Fondren Library has a Libguide on Data Resources at https://libguides.rice.edu/data_resources/introduction_guide_scope
- Here is Open source data libguide at UC Santa Cruz https://guides.library.ucsc.edu/opensourcegis
Advanced help tips
- Pointing Tableau to a Named Range https://interworks.com/blog/2021/01/26/advance-with-assist-pointing-tableau-to-a-named-range/
- What is VizQL https://www.tableau.com/drive/what-is-vizql
- Plan the data source https://help.tableau.com/current/pro/desktop/en-us/datasource_plan.htm