tableau public tutorial n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Tableau Public Tutorial PowerPoint Presentation
Download Presentation
Tableau Public Tutorial

Loading in 2 Seconds...

play fullscreen
1 / 13

Tableau Public Tutorial - PowerPoint PPT Presentation


  • 9 Views
  • Uploaded on

Learn the basics for creating visualizations with Tableau Public.No programming skills are required to do this. It is mostly useful for Journalists, writers, bloggers, students, professors, hobbyists, critics, citizens and more..\nLearn Tableau Today\nhttp://professional-guru.com/courses/tableau-online-training/

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Tableau Public Tutorial' - professionalguru


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
tableau public tutorial
TableauPublic tutorial

PROFESSIONAL G UR U

before you start
Before youstart:

Download Tableau Public from: http://www.tableausoftware.com/public/download-steps

Create a Tableau Public account at: https://public.tableausoftware.com/auth/signup

Download the dataset from: http://www.peteraldhous.com/Data/USDA_activity_dataset.xls

PROFESSIONAL G UR U

the data
TheData:

OpenUSDA_activity_dataset.xlsandexaminethecontents.

Thedatadetailsphysicalactivity,obesity,andotherhealthdatain nearly100columns,formorethan3000rows,oneforeachcountyin theUS.

Connect to thedata

DraganddropUSDA_activity_dataset.xlsontopoftheTableauPublicicon onyourdesktoptoopen.

Atthedialogbox,clickOKtoconnect.

Tableauautomaticallyrecognizescategoricalfields,like“State,”and numericalmeasureslike“Adultobesityrate.”

PROFESSIONAL G UR U

create the first view a map for each state showing obesity rates at the county level
Createthefirstview(amapforeachstate showingobesityratesatthecountylevel):

Doubleclickon“State”and“County.”TableauPublicrecognizestheyare geographicalfieldsandgeocodesthemaccordingly.

Youmaygetawarningmessage;ifso,checksothatyoudon’tseeitagain. Noticethereisapointat0degreeslatitudeandlongitude.Thesearenull values.

Selectthembyclickingtoonesideofthepoint,keepthemousebutton depressedtodrawarectangleoverit,thenrelease.

RightclickontheselectednullvaluesandselectExclude.

RightclickontheExclusionsinFilterandselectMakeGlobal,so thatthiswillapplytoallsubsequentviews.

Nowyouhaveamapshowingadotforeverycounty

whereyouhavearecord:

PROFESSIONAL G UR U

drag adult obesity rate from the measures panel

Drag“Adultobesityrate”fromtheMeasurespanelintoColor,andcopyit intoSizeshelftoencodecountiesbythosevalues.

ChangetheColortoRed–White-GreenDiverging,andreverseit:

PROFESSIONAL G UR U

now add a filter to enable the selection

Nowaddafiltertoenabletheselectionofindividualstates.Click anddrag“State”intotheFiltersshelf,clickOKatthedialogbox.

Rightclickon“State”intheFiltersshelfandselectShowQuick Filter.DeselectAllandthenselectAlabama.

Renametheworksheet“MapView”byrightclickingonthetabat thebottom.

Finishedstateoffirstview:

PROFESSIONAL G UR U

add a second view scatter plots showing

Addasecondview(scatterplotsshowingtherelationshipbetween obesityandhealth-relatedbehaviorsatthecountylevel):

PROFESSIONAL G UR U

add new worksheet

Add newworksheet:

Drag“Adultobesityrate”ontoRowsand“%smokers,”“%eatingfew fruitsandvegetables”and“%whodonotexercise”intoColumns.

Drag “County” and “State” into Level of Detail. Without this step, Tableau’s default behavior is to sum the values across all the counties andstates,whichwillgiveyouasingledatapointforeachgraph,andnot thedesiredscatterplots.

PROFESSIONAL G UR U

the view look like this
Theviewlooklikethis

ChangeColortopurple,opentheDropdownmenunextto“Automatic” and select circle, then move the slider below to the left to increase transparencyofthepoints.

SelectAnalysisinthetopmenuandcheckTrendLines.

Renametheworksheet“ScatterplotView”byrightclickingonthetabat thebottom.

PROFESSIONAL G UR U

finished state of second view

Finishedstateofsecondview:

CreateaDashboardwithbothviews:

Adddashboard:

PROFESSIONAL G UR U

double click on each view to bring both out onto

Double click on each view to bring both out onto the dashboard.RightclickontheStatefilter,selectCompact list.

Rightclickonthisfilteragain,andselectMakeGlobal. Thiswillensurethatselectingastatealtersbothviews simultaneously.

Rightclickonthisfilterforathirdtime,selectCustomize anduncheckShow“All”Value.

Thispreventsusersfromseeingtheentiredataforallthe US.

RightclickonthetitlesofeachviewandselectHideTitle.

Renamethedashboard“Obesitybystateandcounty”by rightclickingonthetabatthebottom.

DoubleclickonTitleunderObjects

PROFESSIONAL G UR U

save to the web under size click edit and select

Save to theweb:

UnderSize,clickEditandselectthesizeandlayoutbestforyourwebsite.

ClickFileonthetopmenuandselectSavetoWeb.Youwill beaskedforyouraccountloginatthispoint.c

PROFESSIONAL G UR U

embed on your website blog
Embedonyourwebsite/blog:

IntheSaveToWebResultswindowthathasopenedup,scrolldown beneaththevisualizationandclickonShare.

Copyandpastetheembedcodeintothehtmlofyourwebpage.

You should now have this online visualization: http://www.peteraldhous.com/tableau_demo.html

You can also download a PDF of this handout from: http://www.peteraldhous.com/CAR/tableau_demo.pdf

PROFESSIONAL G UR U