HubHacks 2 Tableau Session

good morning everybody my name is Rick cooler I wouldn’t have loved i’m joined by darren fingering his head low account manager with a blow and damages solution consultant and we’ll be here all day we’re we decided to break this segment institute of three parts and the first part will be some basic enablement go into tableau desktop open it up cactus data build some things and hopefully give you enough information to to get you started and and become a couple of the initial steps to to simply getting into visualization and also released direction is to just general functionality because senior technology the second part we will focus a bit on ableman there is ton of materials tutorials information available at our website the hyperlink to that is up here on the wall tableau calm / learn / training so we’ll we’ll just take a bow and walk through that so you know what you can get to and in the last part which we hope you find really interesting is the call tableau public we provide a platform free of charge to people over the world who wish to create visualizations publish them and share them online or embed them in their public websites and that content resides on a site called tableau public it’s great people love it but I think for the purposes of this discussion this session is this whole event I would say and check it out because it’s great visualization is up there there are great ideas there’s terrific inspiration they’re not all disappointment that were sports related things like that and you can pull it down and you see an idea is to employ a light that visualization I would like to replicate that for this exercise will show you how you pull that down and you can see how it was built and I hope over the course of this exercise with my man to be a great resource for ideas so those are the three parts and with that I will turn it over Dan thank you okay good morning everyone so we’re going to start off with tableau desktop so just here we’re just looking at a couple of things on top of public and we’ll come back to this at the end is Rick said so tableau desktop is is the tool what could use to alter the content put it together explore the data breach types of data and then also potentially save it out to tableau public or other people to see and understand what you’ve been doing when we want to connect to data we’re going to talk a little bit about connecting to data what we see from a data point of view putting together a couple of different visualizations different ways looking at it you’re kind of categorically some of the graphically with maps and things of that and then we put it all together a dash how we didn’t have it all interact together and then we’re going to publish it out to public as part of the process so as we start off the first thing we want to do I’m just going to do a new one here just so we start from scratch we’re going to connect to data and this is the first screen you see you connect to data and you know this is a book somewhere you can use against your local data as well as if you got stuff in sequel and if it anything a data source out there you can use but in this case here we’re going to go and connect to excel so I’d let my excel data here and here are some of the different data files and different sources and want to choose here is the parking tickets one just going to open it up and what now has happened is we’ve opened up and we’ll actually see that there’s actually two two sheets in here we got our parking tickets one and I’m going to do the Parkland status when i’ll come back to this little while i am i actually added this into it to enrich the data and we’ll talk about a little bit later on but i’m just going to join on gate here Oh status we’re going to join our gang here and we see all the data down here about the parking did it end up in your typical Excel like format when we go in and do go to worksheet we now will break it up a little bit and what you’re seeing is the kind of categorical data license plate type you know the location of the ticket location the common information this is going to be a lot of the kind of descriptive or categorical data around what you see in all these different data sets this is going to be information about location so the information potentially about the type of activity that’s in it from a from the city’s point of view and then down here there’s going to be information about the actual kind of categorical

information this will be a fine amount and this quantum of the number of records are available right here we also have in here we’re kind of making we pulling the data we look and say are these are you beric some of this stuff may not be numeric and you may find that hey you know what this is not a number like it’s a it’s a code in this case here so the vehicle code we can just drag it up here just drop it up here now and it’s now available for us to use up there and you can play around with the data like that but really you’re not affecting the data in the back end you’re not changing the excel file and also this is very easy if you can work with so when we go and look at this now and we drop it out here to say it for example the fine amount we can see by double clicking that is four hundred fifty eight thousand dollars in fines and parking fines put together if we want to do from a look at we can actually change little on the format sides so that actually we get some dollars and different paths and currency so now you’ve gotten your ad and the dollar information different things like that you can do it we can see here we’ve broken this out and maybe what we want to do with this is going to break out some information about the actual state itself where the license states come from a lot of care from Massachusetts this is kind of a bar graph looking at maybe I want to look at this from a little bit more little differently I want to look it on a map I’m just going to pull this off you’ll see this little guide is telling me that this is a string I’m actually going to convert this over to a geographic item called a skate a lot of times pulled us in automatically if you see state because they said st you didn’t know what even street or what what exactly was but you can easily go and take this data and make this into a a a state now so if we go and drop this out here now we’re now going to see this information beginning short on an app automatically and as we see this information show on the map we can actually look and see where are the license day so the car plates came from all these different states we’re going to drag the number of records on the color here and now we’re beginning to see visually where where some of the people are coming from we’re looking at we didn’t have anyone in this period from West Virginia Kansas Iowa all these other states are represented in the actually a week’s work the data here of parking fines so when today verse area you may also know if it doesn’t go from a color point of view I’m not really you know a big fan of the green so maybe I want to change it over to something else to get blue and there’s also some good reasons to do that ten percent the population of the red-green colorblind so when you’re actually putting data when you’re putting them visualizations together it’s always something to bear in mind you’re all who’s better look at it and someone who’s when you look at the green like that and your red you’ve got red-green colorblindness it’s all going to look Brown you’re not gonna see a lot coming out of it so blue and orange there are actually clip colors to use so now we have this you know showing up the states and we can actually begin to a little bit more information let’s go and put the fine amount down there you can see all right now we’re being to see where all the different states the fines are coming from maybe want to put the number of records out there so we can actually see how many different parking fines so we can see 14 parking fines came from California and indeed if we want to go a little further with Mexico and edit this and in the tooltip the others you know we can actually edit the label so we got like fine amount here and just go and actually edit the label because in here into the logo and we’ll just put some of fine amount and there you can go and edit is to make it a little you know make more you know easy to understand you may notice that I’ve got a quite a big overhang for Massachusetts as you’d expect and you may see that a lot more data being that we’re going to see a lot of false and data so what you can do easily with this is I can just come along and exclude this guy and now I’m beginning to see something a little bit more interesting now I see the New Hampshire is showing up here because the overhang of Massachusetts is kind of taken out of the picture I can now see you know that your pencil New York Connecticut New Hampshire really begin to show up and don’t worry if you’ve actually got us at our it did that didn’t mean to do it there’s a nice little back button I can just go back very easily and I can go many levels back if I want you two to very quickly get it for you’ll notice when Darren pulled that out by excluding interviewed what it actually did mechanically on tableau was it moved it into the filter shell so when you set up filters to filter down your views you may achieve the same thing by dragging back to the filter shell selecting it what if you do in the few it’ll automatically do that just so

you know what’s happening not concerned that you don’t what happened just click on the filter shelf do things tableau is on backward place isn’t open their basis what you did yes so exactly so yeah this is an example of filtering as requested and indeed you may want to be more explicit with this from a social point of view yourself so we’ve got different things in here like the or the vehicle make we can actually bizzle out on this but we can actually do a quick filter on this and you can see here acura’s Audi’s so for if you have if you wanted to just basically look at this little bit differently maybe the question what ask is many aldi drivers are getting parking tickets I’m now seeing the many Audi drivers in the state very quickly very easily have been getting their parking tickets so you can use that to do analysis and there’s a number of things you can do with this with the filters them for certain things are upset you can fit sexy data around like I do drivers four-wheel drive e yeah so I was actually going to the next thing that’s going to do is this is kind of at the state level as Ralph but I mentioned there there’s actually that along here and that’s actually specifically down to the city levels so I’m going to do another visualization but you’re going to see the actual locations of the individual parking parking events so I’m going to move on now on to that here so we’ve got a nice little map showing up of where where our kind of lines are coming from and we’ll just kind of call it our state map and we’re going to look here and at last year and long and long kind of commune is a number i think because just similar for milling i can actually change this again over to longitude and one of the things I can do with this is I actually hold down both of these I hold down the control key I can actually highlight both of these and over here I’ve got something called show me and what show me is is actually kind of says given what you’re looking to do what kind of visualizations make sense and one of them you’ll see based on laughter longest it’s this woman through it’s a little bit dark but the ones are kind of got some color associated with them are the ones that are that are going to work for this data so for example a bar chart would work for this day have one of the things would work for it here is a map so if I look at this now because we’re looking at City information we’re looking actually gets the average Latin long for every event and not surprisingly is right in the middle of Boston but now if I take this information and I begin to put simply crowded on here now we’re drilling down to the actual route information and if I look at this when you look at the data just to kind of give you an idea of what we’re talking about here in the actual data itself data set itself the routes like a 10 these are all at City designations of route you’ve got the street name on here too so what we can do with this is we can actually construct a hierarchy with this data so i can actually take the street name and put under route and very easy I could have just easy dropped it on there but I can drill down so certainly to the street name will drill down the moment to the actual street number so if I actually put the what the actual location which is a physical location I put this on here i can actually drill down to each individual thing so one thing you’ll notice here is like got a lot of a lot of concentration of data air so what I may want to do with this is an able to look at the color a little bit and change the transparency level it’s a nice tip to use you have to go maybe bring it down to about a fifty percent transparency maybe look yeah and then I may what a little border around stuff so now beginning to kind of be able to see stuff a little bit more but i’m going to use something else they’re going to use size to actually begin to see about where some of this is happening so maybe i want to look at the number of records and put that on to size and what we’re going to do is now we’re beginning to see a concentration of where the funds are occurring and you know you can see that there’s small amount of fines going on down here back in a mattapan area you can see the city is getting a lot South Boston’s got some lot right here so I don’t know if any other cars that on the street you may want to check them but you can actually see the the number of records that actually occur in this area the other thing you can do with this is because we actually had that route information there and now we’ve kind of lost it because we’ve actually drove down we can also take this route

information again and I can just bring it out here on to color and you can actually begin to see all the different routes and now on the map itself you can see the different routes in the different areas and in different colors as this data the other thing you can do with this is I can actually go and if I actually didn’t want to see what’s going on down here I can drill right into it now and I can see you know ok where these are occurring in the city and I could actually go down further you know you know look at it basically down at the city level you know the the individual parking locations oh he only me know the map the map background here yeah so yeah so other map options here there’s actually some layers that you can add and this can kind of their background is worth enrichment of the day head so you can actually look at the streets and highways that it can be added on here there we go these legs are integrated to the software it’s you can’t quite as many ways as you can somewhere layers yeah and the other thing just again depending on what we want to do at this this is not necessarily going to be applicable because you know we can see exactly where the streets are there’s this is kind of explicitly what you want to show as an option there’s also data layers depending on the source or you may have social tech socio-economic data that could be available so there’s lots of different things like that in layers that you could actually add on that it shows income levels and things like that potentially as layers that may be available for the data set to so you know now we have your nice little visualization you can see exactly where support of some of the fines are occurring we may want to look at the final okay so yeah we got I’m going to do two more things from a two more visualizations we have fines here so if I actually go and I can go put all the fines out here and put them in the continuous so if I actually tell something like the worst we’ll just take it was a vehicle state so it will take vehicle scared drop it out there and we did find them out before our vehicle plus to type of vehicle so i will preserve do that you can see it’s showing the sum of all the fines there are for these different types and like four doors are actually getting a lot of lines I mean I want to look at this a little bit I may want to look at the fines and buckets so what I can do in kind of a histogram is if I go back here I can take my fines and I can bend them and I’m going to create basically kind of twenty dollar bins because i knows numeric so it’s just saying the size that then so now i’ve got this this fine bin here and i can actually bring this out and then if i come along and that might add my number of Records here number records and I just walked around a little bit now you can actually see in the various bins where the actual fines and the preponderance of fines are between the twenty and forty dollar there’s lots of information in there about it the other thing you can do with this is we have this license state we can create a calculated field and there’s lots of like in Excel there’s lots of calculations you can create and you can get very very complicated to line causes all this kind of stuff but there’s a lot of this I’ve actually you know it’s going to chefs do a red one earlier but basically it’s a it’s all I’m doing what this is I’m actually taking the states and grouping them up a little bit so in the editor itself it tells you whether your weather is valid this is going to say what actual state the drivers from and I’ve actually said everyone the Massachusetts never Massachusetts everyone is not in Massachusetts is New England so I’m going to put that on to color and now what you’re seeing is here’s the master chooses be people here’s the other New England herbs and here’s people from outside of New England so again you’re enriching the data it just by doing a couple of calculations on it and obviously you can take this and do something very easy by adding on here there on two labels you can actually get the fines for each group the total amount to begin to look at it that way one other final thing is we’ve date here so we treat dates a couple of different

ways dates can be bottles you can look at every Monday maybe you want it down the road with the park advice how do they compare Monday to Monday how do we compare chooses or weekends to weekdays so you can look at gates and head of buckets or it can actually look at gates continuously and that’s over time and because i know this data actually has got a very short gap I actually have in here defines coming across all these days I can see a trend so the parking fines the number of records issued going up here and I can see well we can have dropped off there going on I can’t have an idea so one of the things I did earlier on was that join so I’m actually going to take the date here i’m going to add it out here and i actually going to do something similar again and make this a date and this is kind of a parking ban piece of did I actually this was not part of it I actually went down line and just found this out so I have a to charge side by side what I’m going to do with this guy though is I’m not going to I’m not going to i’m not going to do it as their as a line i’m actually going to do something all shapes so i’m going to do as a shape file and I’m going to take my parking ban for Falls and put it onto on here out of my shape so you’ll see you got false and true which is kind of nice and this is great and I can turn around and I can what I can do with this is called jewel axis so i can actually overlay them on top of each other but will do my shared file at that a little handy thing and little all these different shapes and one of them is whether so i can actually say well let’s go make this sunny evo probably wasn’t but we probably the good idea what was happening this day so we can apply this to both of them and then as we go on size now we have actually you know what was going on it up to sunshine showing up here and and the snow you can look at the shapefiles image today head do a lot of things like that with it you know to add something to it from from that end if i want to put this together here’s my skin map so the interaction here is is each one of these sheets you can think of like a sheet in itself you create a visualization design when you click here that’s a yeah right here she and this one right here that you created as a dashboard so the interaction changes a little value menu of sheets so on the sheets manulife menu data the dashboard mandate she’s just got this this case two types of attack so on this here now I’ve got a couple of different damn things showing up I can actually relate these together so I remember my eyelid loudly one we can actually come along here and apply this to every worksheet so now we can actually look at a rally driver drivers not just where they came from also where the cart and many fines they actually contributed so very not very quickly you can look at that or I can go down another path with this and I can say you know what this map is lovely let’s just use as a filter and let’s look at these Florida people they probably should have been done already but they were here and think they gave a little bit of that information to a little bit so you can actually see how that all plays together so we’ve got a nice little dashboard put together and I can say you know you know we’re not to just call it where we’re not to park and I’ve got mine I’ve got this in my heart on my desktop right now save it out just for me to go it back into it again but one of the things that they want to do from server you’ll see you’ve got this option called tableau public and I can save to Wed so now we’re going to go out and I’ve got my own login here and you can just go online and get yourself a free log on to to tableau public and then you can publish this as and it’s going of the day hair by the way its local here because Excel in order to publish it out it says I need it in a little in a package size so it’s actually it’s called an extract so just take a little button to extract the data is going to create an in-memory version of the data and send it on with the with the whole thing so now when I go and publish save to web you know now is publishing this out tell me all the stuff is going to publish and you know it’s going to send it up to to the website I don’t have to do anything and then I’ll be able to go in to open up my own world around here and as this is going up i’m going to go over to their public and this is tableau public and in a moment my earpiece will show up as rick said

there is a lots of different things out there when you go up to public I actually have a link to it here there’s an actual gallery in here of all this my mind coming up here now but there there’s a gallery there’s our map you know here’s all our LD drivers gives all the stuff we looked at before on public the same kind of interaction is available but in public you have here all the different does real estate information so there’s actually some people don’t let heat index with zillow data you’ve got social media sports travel health government data so some great ideas up here there’s lots of lots of different things about diabetes does Paris fires there’s also for a wrap April probably in this room is and you know interested in some interesting sports stuff so you’ve got stuff in here about how did the this is the talking at the odds of you making the actual Super Bowl so the pictures you can kind of see by the third quarter the odds is making the super bowl in the championship game we’re pretty high because ever remembers in the Seahawks game those odds were getting pretty low before they went into the into the overtime with the with the Packers and as you go on each one of these it’ll actually click into your video this is another example of just someone who has done some nice cool stuff so you know you actually did actually gone and taken some graphics and used and enrich the data a little bit with some graphics to do some stuff that’s pretty nice this one here is we really like this one because it’s actually a really good type of visualization these use of gray as saying there’s lot of good data here but the Reds what I care about it’s kind of a bit of a morbid thing it’s all about the actual deaths and incident in axis close to us things this kind of jumps out here is you know generally first is a bad time to be on the road especially late at night like around forward to July is not really good either so you can actually see kind of the fatalities of the Kurds so there’s just this is just a good example of good visualization because the information is very quickly visible if you look at this and within five seconds like yep I get it Venable do that this is a good example again because his nanoha story the time to tell them it’s really easy to create there that make certain colors the shapes that very hard to discern what you’re trying to tell it just happens to be a really great example of the use of annotation it talks actually about you know the overall reduction in fatalities with an enticing your annotation certain legislative events that to actually going to cause the graph this v-neck of a lot about that detail my name is Graham so and again obviously we’ve been easy to choose shades of bread here but really the shades of red really tell the story when when we don’t care about legarreta brandy undresses is generally not important so just a good example really good use of visualization techniques cell story implants and this one here this is an example of something else whole story points and this is something that you can actually create too yeah and what this is is actually it’s got some visualizations on here but you actually explicitly this is kind of giving your blow your color commentary on the data you can actually go through leg line by a lot bit by bit and actually build a story explain stuff in here so again with some of the data you have there you know you may want to actually take this and you’ll build a story around the waves data maybe you want to build a state data around the parking data all the different kind of things you can do this with it you can even look and we didn’t really get to it from from our data set new scatter plots so you can do a lot of different things so your look at correlations between events you can easily do that just just to emphasize to this sure so this was actually a story there’s file data worksheet story if if you choose to walk them together a narrative where the visualizations operate little presentation and you annotate if you tell a story you can create dashboards that’s fine but you also can go up and create something called story and then we’ll get another option so when you decide to drag in those individuals sheets grab it and drag it into the dashboard you’ll drag them in in essence like slides in a story in to be able to relate so that’s that’s a third option or second option but what you can do with your sheets a story that’s my language now will be outside you can ask us so two things that are actually three thing but they’re quick one is on public download

any of these you can take them apart you can actually figure out what’s in them and kind of say that was kind of cool how do you do it so the download option you can just take it down with the stuff you do create please put it up there because people love seeing this stuff there’s a lot of great stuff out there and you know contributing to it it kind of riches everybody a couple of things am the public we said here was the actual site itself it’s a Cal com public gallery our public over there you see the link up on the board and then the other thing is we actually have a lot of online free online training so this videos is YouTube clips as a whole lot of stuff actually step by step and how to do stuff so if you go there you’ll actually find a lot of different ways of if you kind of say I’d like to do that how does someone do that you can actually see that on these videos they broke it down so they’re all designed to be five minutes of economies so you got some questions just go check out the tutorials and check out the community if you get stuck the community is really really imagine you got such antiquated calculation X Y or Z chances are pretty good but he’s actually going to jump on so great here but over the course of the next few weeks the people and resources who else a little too high but they answer my questions yeah on by the way the other thing is that at some point if you’re interested there’s a Boston temple user group I do on our website you can actually find out about that too and as local as meeting from once a month that you can also attend the community just hear a lot of time to open Cambridge Kendall Square but that’s a good community also so with that okay thank you very much for listening to me on a Saturday morning and be attentive before lunch and we’re right on target be two minutes to spare get back to get out for lunch so thank you