 And Eli, I'm just going to send it to you and you figure out where you put that. I don't have a YouTube channel. Yes. How did non-Houston people, Eli is asking, find the event. If anyone wants to chime in. Oh, text of email. It was on a meetup group. Okay. So you're in the Houston meetup group? Yes. Gotcha. Are you in Houston? I'm in Houston. Okay. Awesome. Good stuff. Maybe just go ahead and chat your answers. I know Tablo retweeted one of your tweets. Eli, I'm terrible at social media. I almost don't even try anymore. So I really appreciated y'all's efforts in, in kind of sharing today's session. Okay. Awesome. So my introduction to Tablo was in 2013. I was interning at, you know, a behemoth e-commerce company that everyone's familiar and reliant on. And that's where I got to know of the platform. I was in business school, so I went back to business school. I tried to take it back with me. Then there were a couple of years I was working at a nonprofit. I tried to bring it back. I really, my main work is in the Salesforce ecosystem. That's what I do all the time working with nonprofits, higher education institutions in Salesforce implementations. I also sit right now as the director of a nonprofit that is very Salesforce built, but they had a need for analytics mapping, you know, their large reservoirs of data that they've been collecting over the last, two years and finding a way to put that information out to the public, you know, not just information, not just boring numbers and insights, but information that one could play around with interact with in a very visual way and easy for people to understand. So just taking large amounts of data and presenting it in a way that's kind of more easy to digest. I will point y'all at some point, if I don't forget, to the thing that I built, but that kind of rekindled my passion for Tableau. It introduced me to Tableau public because that's kind of what we had to rely on to be able to, you know, kind of put our data out in a way that was publicly accessible without spending an insane amount of money on licensing. And it just helped me kind of rediscover Tableau. So for today's kind of walkthrough, I don't know what to call it. Again, I'm really not coming from a position of tremendous experience knowledge. Like I have learned a decent amount in these last couple of months or relearned. But I'm hoping to approach a topic that I guess has been a lot of our minds, you know, with everything with George Floyd, the social justice, it's not really about that. It's kind of parallel to it in a way. So I, for preparing for this demo, I just went out searching for like a data set that I could get hands on, that I could, you know, use in Tableau, that I could use to build some kind of visuals and analytics in Tableau. So I went ahead and found from some nonprofit that works with incarceration in people's prisons, just kind of find the information, find like an Excel file with data. And as I use this data, let's pull it into Tableau public and let's kind of walk through what it looks like to interact with it. And that's what we're going to be working on and then overlaid it with some other data around, and this is broken down by the 50 continental, 49 continental US states in Hawaii. And then I overlaid that with data around education levels in different states as well as employment level just literally one column of data, just to in spirit show what it feels like or looks like to overlay different kinds of data. So that's some of the data that I have created, well, created this element of data about, you know, our organizations work in those states completely fictitious. The data that I'm pulling in around education and employment might be from different years. So this is not a scientific demo. This is just a kind of walkthrough to get a sense of what the capacity of the platform is how it could be used right So let's not take away any insights from the data I'm using. I think the incarceration data is from 2010 the employment data is more recent. I didn't find anything more recent, but just really how the platform works and how we could potentially use it to tell a story with the data and how this potentially free platform could help us to work with that. I'm going to go ahead and share my screen at this point. This is Tableau public that I have installed over here. And honestly anyone please feel free to interrupt with a question at any point in time. I'm bored of just talking nonstop for a long amount of time so I actually appreciate the interruptions to figure out where to get Tableau public if you just search Tableau public I don't know what the URL is Tableau public. Google usually helps out with the most relevant link, and there's a little button to download the app just enter an email address you can enter a fake email address if you don't want to be spammed. You can also start the download right away. So that that'll download the app to your desktop, whether you're on Windows or Mac both should work. And you can go ahead and install it no licensing nothing required. The second thing okay so once we get into Tableau. This is what we see. And then on the left side you can see it says connect like hey where is your data live connect to your data and I'm going to pull it in. The options that we see here in Tableau public are very limited. So you could have an Excel file that you can pull into it. I haven't played with the rest of them I don't know how it works. I'm going to rely on Google sheets and I'll tell you all in a bit why. And then there's a few other options of like, I guess connecting to customer applications, a little bit over my head. I work with the Salesforce ecosystem I leaned towards Tableau because it directly natively integrates with Salesforce I'll be using the paid version of Tableau Salesforce and bought Tableau does happen much later. No, what did happen sooner, but it's not like they work that well to get running at this point in time. It will get better with time. But yeah, the number of apps that Tableau integrates with is extensive. So you can easily go ahead and explore what all connectors they have and you can just directly connect your system and start pulling to them. I for my demo I'm going to use Google sheets. So when I say hey I want to use Google sheets it's going to have me authenticate a specific account that I want to use it's going to ask for permission. It's going to say okay, you're all set, you're done. And then it gives me a list of all the different spreadsheets that I have sitting in my goal sheets. I choose the sheet that I created with the sample data set I hit connect. Now I mentioned I'm using Google sheets for a particular reason. The cool thing about Tableau the way it works with Google sheets Tableau public sorry, and only with Google sheets is that it actually I believe theoretically and auto refreshes. Let's say we pull in data we build a workbook and then we publish it to Tableau public because we want to share it with the world. That it maintains that connection with Google sheets and it's supposed to auto refresh it. So if your data changed over time and you just go ahead and update it in Google sheets, your visuals your workbook everything auto update in Tableau by itself on that. I have a really quick question about that. Yeah. Um, so this is amazing because I didn't know that you could connect Google sheets but so theoretically if you had like a Google form populate the Google sheet then it would update that as well right. Yes. Okay. I haven't experienced it myself because again I rely on the Salesforce connector and doesn't work with the auto because I blended data between Google sheets and Salesforce and because the Salesforce involved it doesn't do that auto refresh. And I also asked like the sales reps at Tableau like hey does that work. She got me answers I haven't validated it, but I have seen discussions online that says yeah it runs on some sort of schedule and once a day, it will go in and pull the new information from Google sheets. That's so exciting. Thanks. Awesome. So it's showing me the four different tabs I have on my spreadsheet this one is just, and I can take a sneak peek at what that data is. This one is irrelevant it was just me figuring out the headers on my sheet this is the one with all of the primary data so to speak. Right that's kind of all in here that I kind of blended three different data sources. I created another sheet of fictitious information of like organization like information bridging my organization. And the premise is hey I'm operating my nonprofit working with social justice or just helping you know people are incarcerated in many different states and how have I staffed those states and how much I intended to add more columns but I was like it's fictitious anyways let's just roll with something. But how much am I spending in each of those states. And the idea was let's correlate what the kind of observation is is what I'm seeing on the field or like what the statistics say, and am I rightly investing. You know, in the different states where the need is where I'm getting the biggest bang for my box to speak. We may or may not can get to that. Okay, so I've got four sheets of data I have to decide hey how do I pull that data into Tableau to start working with it. So my primary data is going to be the incarceration data that's what I want to kind of do storytelling around. I'm going to pull that sheet and let's say I want to blend this with another source of data or another yeah another source of data that could be from a different system it could be your different Google sheet because I can always say hey I want to add, you know, another source of data I want to add another Google sheet I don't really have anything so I'm not going to do that, but I could potentially re authenticate it's going to give me the list of sheets again and I can pull in another one. I can even pull in a whole different source like platform, or I can of course I multiple sheets in the same kind of Google sheet and kind of join them together. So when I try joining it is going to say okay how does it, how do the as a data in one sheet relate with the other sheet. In my case it's the state about the 50 US states spelled out exactly the same. And a couple of advanced options I'm not going to kind of talk about but essentially there's one row for each state. And that's what I'm telling it. And that just improves the performance a bit which with this it's very efficient because it's a small amount of data, you're got larger amounts of data you want to blend that data correctly so it's performance. So I set up my data source and now I'm ready to start trying to figure out hey how do I visualize this data. So on the left, I see all the headers in my spreadsheet and might be helpful to kind of keep them open side by side you can see the Google sheet at this point right. Awesome. So I've got all the headers for that specific tab that I had across the top, all the data is kind of down here. And on the left side I have of course the 50 states, you know data from the 50 states. Oh, it's got District of Columbia gotcha. Okay, so I've got all my data here and over here I see on the left side and gotten essentially all the data so just to give you a rundown what the data is. I've got numbers of how many people are incarcerated broken down by ethnicity across all genders. I've got the total population. You know, again broken down by ethnicity. I've also got the numbers of female incarcerated as well as a population and the male incarcerated as well as their population. So as you noticed I blended two different sheets. So I had this metric of how many staff members I have in each state. So that also kind of shows up over here. And then I also had a computer like what's a compensate what's what am I spending on staffing these offices, right. So that also kind of shows up over here, and that's coming from a different sheet altogether that's what's in a different tab. So the, sorry, in the first sheet I also had information around education and employment just to say hey, can we see a correlation between how you know good education is and how, you know, or how high education is an estate and does that correlate with what the incarceration looks like. So let's jump into our first kind of visualization so to speak the first thing I might want to do is I just want to see all the I need to minimize all of our faces. I'm just going to drop in a list of all the states right so I throw that in my roles I can even throw in my columns and it kind of creates it in this way. And over here I have just a list of all the states that are coming in from the spreadsheet. So let's say I want to grab all the incarceration numbers I'm going to leave out all ethnicities because that theoretically ought to be the sum of it, which it's not don't ask me why, but I'm going to drag in the right hand side of the list and I can break down for all genders by their, by their ethnicity. So I can, it's as easy as kind of drag and drop, and you see the numbers just kind of show up from there, right. So easy simple straightforward. But this is just numbers I mean this is literally the same thing as seeing it in the spreadsheet so what's the point of that. Well, if you look at this little menu on the upper right it says, so show me. So it shows different ways in which you want to visualize that same data. It's a little bit intelligent so to give you choices that are relevant to how your data is currently laid out. You know, in your spreadsheet. So over here I have a choice of like bar grab graphs right I click on bar graphs and boom, it changes that look to now have kind of bar graphs. So this doesn't kind of make sense to me or maybe I want to try a different one I want to try these little bubbles right. First, you know, tabloids always going to give like an attempt at something and might not make sense. Like, hey, this is not exactly how I want it laid out. So you can kind of play around with it like no I actually want to broken down by state and see the numbers stacked. So now I essentially have all the states as columns, you know, along the bottom and then I have all these rows, one for each of the ethnicities, sorry, of the incarceration rate by each ethnicity. Again, just two clicks and it adapts automatically. Say I want to say I don't want like individual roles I just want a single chart with like these little bubbles one bubble for each ethnicity. So in my search for these things, you know that over here they're called measure values. So in my search if I type in measure values is actually an option for just measure values, and I can drag and drop this right here in the columns. And then I can actually remove all of them because they're at this point redundant. Okay, now I have a single chart. I'm going to go along the columns as we saw before. And then there's these individual bubbles, you hover on each of these bubbles you will see what that metric is, and you know what state corresponds to etc etc. Now Tableau did kind of overestimate what all measures I wanted and it threw in a lot of stuff that I didn't want so I don't want all ethnicities I don't want staff members right now I just want incarceration broken down by ethnicity. Anything else and remove it. And now this just leaves me with information around incarcerated incarceration broken down by the ethnicity. Again broken down by state. So I can say ooh, what am I seeing, you know really high numbers of in Texas. I'm looking at white alone. So this is again just a breakdown for people that are just why incarcerated that number is really high. What's the number over here oh in California, again white alone is really high. Right so that kind of makes sense. That's probably the largest share of the population, and therefore it also reflects. That kind of breaks down. Now this information might not be super helpful like of course of the population of certain ethnicity is high. That's going to be, you know, over represented. When I'm looking at that also the population of the state itself is high. It's even more over represented so to speak. So, what is a way of, you know, kind of modulating that data or like bring it down to the same standard, so to speak. I could say hey instead of just showing me total incarcerated, give me incarcerated for every 100,000 or, you know, or maybe you would just start with something simple. Just show me the percentage of the population. So what I can, with a feature I can use in Tableau that does that is called formulas. So let's say I want to calculate a formula that takes the total incarcerated that are white alone divided by the population, the total population that's white alone. I would say hey, I want to create a calculated field. So this is like percentage incarcerated white alone all genders. Call it what you need to. I would say I want all genders incarcerated white alone divided by all genders population white alone. So it's really snazzy just works really well. It auto populates etc for you. And to make it a percentage let's say I'm going to make that a percentage. So I'm just going to create a different tab. I'm going to throw this over here. Instead of a sum at this point I probably want the average and I'm going to take the state and throw that in the columns as I have for right. I don't want to see it as a decimal actually want to see it as a percentage. So I'm going to say I want to format this differently. And it's a couple of clicks figure out what exactly that lives. But once you know where you're going I want to show this percentage and it shows me percentage incarceration for white people alone in these different states. So at this point, you'll see with the way it's currently laid out I think that more kinds of visualizations about what to mean. And, you know, you can actually kind of explore what these visualizations are and figure out hey what will look nicer in whatever visual I'm going to build. I could do kind of a this chart it's called a highlights table the higher the number the darker it is, I could do these kind of bubbles that actually size the bubbles based on, you know the size of the size of the network itself. I could do some heat maps etc that, yeah, as easy as that it recognizes the name of the state, and then every kind of plotted on the in the middle of the state. Awesome. I'm going to go back here and show off a couple of the other, like the user experience kind of benefits of that. Let's say this is TMI like I don't know there are so many dotted points like this is useless to me I don't know how to start processing this. It would be nice if I could just like look at one ethnicity at a time. So we do know that each of these things are individual measures that we have plotted. Right, and each of them have a measure name. So if I search for something called measure names it's right here. What I can do is I can create a page for each of these measures. I can do one at a time so I take measure names. I drag it into the pages. And what it does is if you create on the right side, this little selector, where I can see the measure name itself, and I can actually flip through it, and see how the data adapts based on what measure I take it with black or African American only. I'm seeing more of a spread now this is interesting, which state has higher, you know populations of incarceration office specific ethnicity. Again, I think we kind of discuss that this seems a little misleading because population was likely to skew it. So let's actually go back here and do state along the top, we have a bottom and then I want to do a bubble chart. That's for state right there. Okay. So this might be a little bit. Now this is actually kind of modulated to, you know, it's number incarcerated upon population. Or it gives us slightly better spread than the other one and it's kind of a little bit more relatable than the other metric that would be less reliable just because the size of the state would skew that. Okay. So let's, I wanted to, what's not okay let's say 50 states are 51 states at 50 states and DC is, you know, too much. I actually want to look at maybe groupings of states are like really look at that data based on region. I can use a feature called grouping, so I can say hey I'm take the states and I want to create a group of states. And sorry this might take a little while y'all and y'all can help me out but what are some groupings we can create with states we can say hey I'm going to call it region I'm going to do Alabama, Arkansas, Florida, Georgia. I'm going to miss something, Kentucky, Louisiana, Mississippi. I should have done this before Oklahoma but I did want to do it in front of y'all so Oklahoma what else am I, let's throw Texas in there. I'm going to call this the south. And I'm going to do California, Arizona. So, let's include one in Utah, I want to Nevada, I want to New Mexico. Let's call this Southwest. So, Delaware, DC, Connecticut, Maryland, Massachusetts, Michigan, New Hampshire, New Jersey, New York, Pennsylvania, Rhode Island, Vermont. I'm going to call this Northeast. And maybe like a Midwest, Midwest would be Idaho, and I'm sure these will vary depending on who's creating it but in different organizations. We're just demoing here, Kansas, New England, we can do Minnesota, Missouri, Montana, Nebraska, North Dakota, Ohio, South Dakota. I'm going to call this for West Virginia in there, Wisconsin, Wyoming, into the Midwest. Then we have Maine can go into Northeast, North Carolina, South Carolina, Tennessee, and go into the south. Virginia is tricky. I'm going to call that in the south. And then Washington, Oregon, I actually meant to do West Coast. So, whoops, no. You're going to create a West group. And let's actually pull California out of the West and throw that in the West Coast. Awesome. So I've created groupings of states and as soon as I do that. I call it region, region appears. Now I instead of breaking it down by, it could break it down by states. And this way I actually see, okay, this is the Midwest. You know, and all these midwest states, how do they compare against each other? How do the Northeast states compare against each other? Oh, New York is high, believably so. How do the southern states compare against each other or I can just drop state altogether. And now I'm just looking at that data by the region. Right, so this is regionally it's summing up all those individual metrics. I think I'm looking at just one specific measure or so. Okay, so it's summing up all those metrics for within those regions and it's kind of giving me that vision. So if your organization works in different regions and you want to look at different regional data differently, you can create your own groupings with the, you know, very finite data, and you can see how quickly I'm doing this, right? With Excel is probably some amount of formulas, some amount of, you know, pivot tables, etc. that goes into doing that. Everything is happening super quickly and super fast over here. Now let's say this is, I do want all the ethnicities but maybe they're a little bit, it's hard to distinguish them. I can do things like, hey, for the different measure values, I just want different colors and instead of, oops, no, not the measure value, so the different measure names, I want different colors. So now it's going to give me different colors for the different metrics. And then we say, okay, you know what, that naming is just not working out for me, I just want simpler and easier to understand names. I can say I want to rename these metrics and I can do that right here itself. I can say, drop all genders, I want to drop, and I know there's a faster way to doing this, I can find it. Editing ADSes, names, filter, edit ADSes, there we go, wonderful. I decided to give different names to different metrics and the ADS will show so I can just say, hey, I don't want all genders shown to make it easier to process. Or let's say we don't even need the word incarcerated because that's essentially what the entire data set is. I'm sorry, y'all, I know I'm going like really fast through this because there's like so many things I want to show in a matter of one hour, but please slow me down, stop me with any questions that you have. So I went ahead and I renamed those metrics, now I can see the measure names on the left side, and I can see, you know, the numbers correspond differently to the different metrics. And this is giving me kind of a breakdown by the region, it's adding up the numbers, tableaus during the calculation, it's visualizing and it's giving it to me in intuitive fashion. Now let's say I actually want to see one region at a time. So again, we can use that the pages functionality. And maybe at this point we don't want this kind of a chart, we just want too much. Maybe I don't need regions of my pages, maybe I don't need regions of the columns anymore. Because I have that in the page, and that's a single metric, it's not going where I wanted it to. But okay, I'm going to throw the regions back there. Let's try different ways. Now let's say this is again too much data and I want to give people the ability to control hey I just want to look at this specific region at a time and what not we had pages as an option. So create what's called filters. So I can say I want to use region as a filter here. I'm going to include all the options to start with because I want to filter anything out. Oh it's already there. I just need to click drop down here and say hey I want to show this filter. And now where my bad. I'm going to go to region filter include all of them. And then show that as a filter. Okay, now I can actually give users the ability to choose one filter at a time. So filters at a time, you know through a nice drop down list and they can say I just want to see Alaska, or I just want to see, you know, all the southern states of the Southwest States, and at that point maybe it makes sense to actually give the breakdown of the states, there as well, and give people the control of, you know, choosing a specific region and then the data renders accordingly. This filter. Pretty cool huh. Okay, questions. I know I just can't be there I apologize, but I'm going to give you all as much of the capability and again as you can see I'm doing this, all in front of you, you know none of those pre prepared. That's really how quickly and how fast you can get visuals from the numbers and hopefully draw insights when you're working with meaningful data. So let's take these sheets and put them into things like PowerPoint, etc. Okay, perfect question. So let's say we've gotten, you know, visuals that we, you know, are exactly what we need. And we want to capture that so a couple of ways, one of course you can go to worksheet and export. And there are a couple of options over there. I wasn't giving me a menu. Usually it expands and says it gives me the ability to me one quick second I'm going to stop sharing and start sharing I want to make sure there isn't anything monkey happening here. One thing that's a limitation, but normally I know with the paid version I had the ability of saying, I want to export or I want to copy and it gives me different choices of, you know, do I want to copy just the data do I want to copy this specific with itself. And that allows me to then copy it into a PowerPoint. If all of that fails you can always use the tried and tested you know whatever works in your keyboard so you're using the Mac, you know, command ship for, and you can kind of snip, you know whatever you want to grab and put into your PowerPoint, or you know with Windows, you have the snipping tools you can always just generate it and then grab a screenshot right there. So a cooler thing I would say if you want to share this data is if where is that. Is that also not available. That might require. Okay, yes, perfect. You can create an account with Tableau public again free of cost. You create an account you create your own profile you essentially become a table public professional. And if your data is not too sensitive, you know the insights are not sensitive and you want to share them with the world, you can actually publish it online. Right so I say I want to publish the Tableau public it's going to ask you to sign in, you can create your own free account. I'm going to log into my existing account. Hopefully remember my password. I'm just asking for that incarceration insights. And it tells me hey I want to embed my Google Sheets credentials so that if I change data in there I wanted to change in Tableau public. It's going to have me log in one more time to give it access to my Google credentials and confirm that I have, you know, given access to it. At this point, start saving that sending that data to the server, and should take a couple of seconds since the data set is small and then we'll take a look at what that looks like once it's published. And ultimately the goal is I publish it on the server, people can search and find visuals, and we'll maybe take a quick look I know we're coming up on time but you can search Tableau public for, you know, materials and things that other people have put out there. So really it's a community of visualizations from, you know, different professionals working within the Tableau ecosystem. It might be people who are doing it from a work perspective and might just be people who are doing it out of passion. Just coming up with different visits putting it out there, and, you know, go out there find something to inspire you and then use that inspiration to create your own visuals. And that's one thing it's building this community of people who are out there, you know, sharing their expertise their passion their work, and so on and so forth. Additionally, whatever I publish on Tableau public I have the ability to get an embed link. I can get an embed link and I can embed it in my own website, or in any other web hosted platform that, you know, people. So imagine you build a visual that speaks to the impact of your organization, you put that on Tableau public you get an embed link put on your website, and then people come to your website and they can see, based on your actual organization data. You know, what your impact might look like so this is, it's a successfully safe to Tableau public is going to navigate me to the specific sheet that I just published, and it'll also include all the other sheets. I'm going to take a second and it's going to render that. And while it renders that I can show you all that I can say hey I want to access the download option not to be a share option as well to do. What happens if I click download. Let me download the workbook itself you can limit what people can and cannot do with your visualizations. And there's the option of keeping it updated every day. Okay I think the share icon shows up over here so it's probably just going to take a second. I don't think all of these are necessarily visible yet but I've created a bunch of different visualizations for kind of one of the organizations I work with. This is essentially very Houston centered so on my visualization they're technically private on my profile because we share it selectively through other websites. But this is again data from a Google Sheets document that's laid out on a map of the city of Houston, broken out by the neighborhoods mapping out essentially all the different schools, you know that exists in the city of Houston. As you can see over here I have the ability to say hey I want to share it will give you either link or an embed code, give that to your web developer and your web developer can actually share just the specific visual into your website itself. So that's individual sheets any other questions at this point before I dive deeper. I had one really fast question so you can share it through Tableau public but then on the export drop down menu that wasn't working earlier is there usually a code section there as well. On the export. Yeah, if you export it from from the Tableau app. So then, so then you can embed it without sharing is that usually an option on that. You know I, again, because I worked so much with the paid version I don't know if this is a, I don't know why they have in the menu if it didn't work. I don't know what's happening over here. But yes usually it gives you maybe I can open the paid version and just show you all what that looks like over there. But it gives you the ability to have exporting multiple different, you know, aspects of it so to speak. I can just quickly open a workbook. I wonder if there's like a bug in a specific like version of time, although I installed it just today so I think it would be working. Let's open a worksheet and see what that looks like. There is some other cool stuff if I can squeeze in. Okay, so usually if I go to worksheet and export gives me the ability to export the image, the data or cross tab would export, I believe just the data itself. Let's take a look at what that looks like. Exporting the. I'm not sure what that means, but I think exporting the image would be relatively easy. It gives you a bunch of different options of where you want the legend to be etc and so on and so forth. So let's say I want the legend below and I want to take that way. Let's take a look at what that looks like. Give me a quick second here. Yeah, because then if that one's the PNG, then usually if you want to have like the interactive embedded thing on your site, you'd want to do the tablet public. Right. Yeah. Okay, that makes sense. Well, I don't know if it was that's the highest resolution, but this is the PNG. That's exporting. Okay, that's good. It's something it's worth looking into I don't know why they wouldn't let you. Maybe it's because I'm not saved it. I wonder if that's the reasoning. No, I did say it on tablet public. Okay, I don't know. I think that's something worth looking into. You can always just I think it's easier to just kind of screen capture it because then exporting it because you can choose whatever part of it you want to capture anyway, then the export function so that's always there with you whether or not the feature is there. Okay, I'm going to just cancel this for now so we can keep looking at a few other features so we looked at creating groupings from data we looked at creating probably not maybe reliable formula. But like overlaying data. So let's say I want to see, you know, incarceration, but maybe a particular ethnicity, maybe the overall population, etc. And I want to overlay it but say something like how many employees do I have or employment rate, right, I want to see the employment rate and incarceration together so I can see if there's any correlation between high unemployment and high incarceration. That's something of that sort. So I could set that up again. I'm going to do measure values and the columns instead of having it separate out. And then over here I can do incarceration, not unemployment rate, and probably drop everything else for now. Okay, all gender is incarcerated, incarcerated all ethnicities. Okay. And maybe this is a little confusing because both of them are bubbles I can say hey I want one of them to be a different shape for instance. So let's say unemployment, I can say I want to make that a different shape all together. Nope, that's wrong. I want different names. I want different shapes or different measure names and I can say I want my unemployment rate to be a circle and my incarcerated to be a circle of square and then I can also do hey let's do education. What was the exact name of the metric percent higher. Okay, there you go I can drop these in here. And those are different now you probably not seeing them because the unemployment. The scale was very different. So I might need to like scale it down so that they're, you know, in the similar range. So again, instead of percent. I'm going to make that percent total incarcerated across all genders, I'm going to say hey I want all genders incarcerated no all ethnicities. Let's create all ethnicities divided by all ethnicities population. Okay, so then that'll make it into more of a percentage, and they can be all within the same range and I can crop the sum of incarcerated, and then it becomes a little bit more, you know, on the same level. I probably need to convert some of these into percentages. I'm not really mattering if it's a sum or average because there's one metric but otherwise you have to be careful for like formulaically what you're using. But let's see this is okay this is a percentage and then that is a percentage. Let's instead of state let's do region. I wonder if there is kind of a difference there. Okay. Percent incarcerated. What was this metric. This was incarcerated you need to multiply it by 100 guess the same scale. Did that help. Okay. Then I probably need to format that. Actually this seems more right right because percent incarcerated 41% I think I know what's happening. You need to do an extra hundred just because the scale is off. Yeah, that's more like it. So you all probably want to encounter these issues with your kind of more better quality data. I'm just grabbing it stuff from different places. But that's what it's kind of telling me so I can now correlate, you know, does higher in, you know, higher unemployment with higher incarceration maybe it does maybe it doesn't right start with the hypothesis. Let's see what the data tells the story. Let's maybe break it down by regions and say oh am I seeing different patterns in different regions and so on and so forth. So building kind of those different insights trying to find something that clicks or no not really trying to find something that clicks but seem to find that there's something that clicks, building kind of a you know visual kind of a picture around that and then sharing that insight. I'm not much trying to get the any kind of correlation maybe it doesn't exist, and playing with these numbers tells me that maybe I work with something else in terms of what my, I call the compensation spend but maybe I want to see how does what I'm spending in the different regions in my organization of my, you know, nonprofit. Does it correspond to how significant the problem is in different places. So for instance, I can probably just keep incarcerated and how much I'm spending in the different regions. I can get a correlation between am I operating in the places where the problem is kind of more, you know, significant and dire so I'll probably need to create a calculated feel for this as well to get. I guess a more even some compensation spend probably a bad idea for me to try and do this on the spot. I'll probably figure out what my total compensation spend is the okay what percentage of my total budget and my spending in which region, and then try and overlay that and say, Oh, am I spending more in the, you know, northeast when in fact the problem is deeper in the south or something of that sort. I'm going to have you visualize that for your own internal decision making and then of course when it comes to do you want to share outside, obviously wouldn't share your own internal decision making data. But just any insight in terms of what's the impact we're having how many people have we served in different regions and how does that correspond with, you know, where the problem is significant and so on and so forth. And of course, there's always you know the ability to map out data, you know, different regions different states and whatnot. It's so fabulous when it comes to translating everything into natural kind of geographies. So, find a metric, choose the map selection, throw the metric on and it's going to say come up with different colors to show how significant the problem is you can even change those colors to say, Well, actually one more of a red green, you know, kind of spectrum, I can do red green probably on reverse that red means the problem is higher and it tells you where the problem is lower versus where the problem is higher. In terms of presentation. Individual worksheets are great maybe I want to throw five four or five different things in the same layout to kind of, you know, create more of a dashboard like feel which is completely possible with the tableau so I can say hey I want to build a dashboard. Actually create these little floating tiles. And resize to your specifications. Just a little bit quicky here. I want this floating and I want to control the size and location of that. So I say I want to keep this one over here I don't need the legend. I want the map right below that. So I'm going to create that as a floating element I'm going to decide my size. I'm going to put that down below the chart so you can see the chart above you can see the map below, and then you can publish this dashboard onto Tableau public grab the embed link and then publish that back to your own website, right and you have the interactive, and of looking feel. So we're coming up on time. I'm going to show you all some of the things that I built recently. And this is a nonprofit that works out and this is kind of in partnership with a couple of different organizations and the idea was to capture the needs of you know the students that are studying in Houston in the Houston independent school district system, based on information we receive from teachers and you know, teachers and other community members in terms of what are the needs of the students, how does it distribute across the city, how does it vary by gender ethnicity, you know all those different metrics, and how do we create an interactive way to kind of visualize I think there must be some issue with Tableau public right now because it never takes this long to load anything. So everything that you're seeing over here these are all Tableau dashboards that we publish to Tableau public and then embedded here on a Salesforce based website. So these are numbers that are coming in from Google sheets and all probability that we put into Tableau, you know, render a certain way and then put on a dashboard in an intuitive way, and then throw on a website for people to explore. There's a little map right there. There's a bunch of different markers I can say hey I want to see, you know how the different regions vary by percentage of students that exhibit an economic disadvantage household. And I want to vary a specific the marker size by well how many of these people actually asked for assistance that you know they consider basic need clothing shelter food and so on and so forth. So I see the problem is more severe and then which schools are exhibiting a larger share of the problem. I can vary it by certain political boundaries I can say hey I want to see it from an elementary kind of zoning district level right so I can change the boundaries based on that. And then it renders and goes and does the crunching and kicks it back and this is all running on the Tableau platform. This is geo mapping, you know it's very popular feature functionality, we can also look at just numbers you know I just want to see numbers I want to see metrics I want to see poverty rates I want to see average income household and so on and so forth. Maybe I want to see district white maybe I just want to see a specific region of the city and all the schools that fall into the specific region so in the Houstonized system we have something called feeder patterns. And that kind of corresponds to maybe I want to vary it by well let's see what else we have in the filters down there but you choose a filter it crunches all your data and then brings back a metric for that specific subset, you know of data that you filter down to. And you can see a bunch of different charts visuals bar charts. Okay they're definitely some issue with table right now the servers, but different kinds of visuals, different ways that people might want to process that information you can hover over it and see the raw numbers, you can put the total separately. So you have the full picture and then you have the breakdown on the left side. I could spend two hours is talking about this I'm not going to talk too much about it but just to give you a sense of what's possible with the data that lives in your Google sheets that lives in your CRM, pulling it into Tableau blending it together, visualizing it and then you know sharing it with the world. Okay. Other questions. I know this is probably too much into a little time, but think of this as a demo and think of, you know, how quick and easy it is if you have the right data and structure the right way to create visuals out of that. Other questions ideas things to explore together. What are we thinking. I'm presuming that the data is stored in the cloud right. Google sheets I'm using is again a cloud based vision you can use your own Excel file to pull into Tableau in which case if you don't publish it to Tableau public. You can keep that data local to yourself. It doesn't have yet. Yeah, that's that's sort of why I was asking because we have horrendous rules and regulations especially around children and vulnerable people about raw data and privacy. Right. I'm actually curious if you can use Tableau public to without storing in the cloud you'd probably want to have a desk top of that you might have to cuff up, you know, a little bit of money, and then keep it off the cloud, right. Yeah, I'm kind of thinking we'd probably have to keep it off the cloud, because there's just too much of a risk of it being hacked or, you know, for me. And there's always, you know, you might want to take kind of a subset of your data and remove anything that's personally identifiable. I know the rules are for good reason, very stringent. In that side of the world, then it is over here, but you could take a subset of data that does that cannot be tied to an individual and just store that in a Google sheets or whatever to the point that even if it was leaked. There's nothing at risk, you know, there's nothing, it's too much. I think I think we'd have to, we'd have to do that basically. Yeah. Don't know, want for better description, wash the data. Yeah. And you know, Tableau does have discounts for nonprofits. I don't work for them I have no idea what they are, but there's always worth exploring, you know what the cost might be and you might just need that one license if you're a single individual, you know, building all the visualizations being to see. What else? Sorry, this is like the first time I'm kind of actually demoing Tableau public so it can only get better if I keep doing this. I feel the need to keep doing this. But there is so much you can do with it there's so many better demos online. I think what I my goal was to show is just how easy it is, how great the returns can be it's definitely going to be a learning curve. So collective wisdom of the world is at your fingertips, thank you YouTube. But it can be so rewarding, and it's so much easier to work with them, you know, in Excel spreadsheets and you know if you're publishing it somewhere if you do go the whole hog, you get Tableau which will probably come with Tableau online which means you're going to get to an on the cloud, but like an authenticated account that just belongs to your organization, you can be looking at each other's work, you know sharing it with each other sharing it with the organization, and really kind of collaborating and building this repository of insights. It's allowing for the data protection legal stuff. And to be honest with Brexit that's a little bit up in the air for us in the UK anyway at the moment. Yeah. It offers fantastic opportunities for interagency working. Absolutely. Yes. Yeah, I'm quite excited about the potential for that interagency working there. Yes. And I don't know if it's going to help at all because I think where the EU is today is probably where everyone ought to be caring about people's data and protection of that people's data and I think people speculate that the US might go the EU route so I don't see why the EU would want to go, you know, a different way, but really stack of like, you just want to see, hey, what are other organizations doing with data around autism, go to Tableau public just search for autism and just see what what people out there have done in terms of visualizing clearly it goes back long ways. So there's 150 bits of work just tied to that one keyword, you know, and you can click into it and say, hmm, what else have people built out out, you know, out there and can I use my data to build something similar and at least that gives you maybe that inspiration and might give you like a guiding star to say, okay, at least I want to leverage or like draw those insights with my data using Tableau or anything else. There's other competing tools. But building this community of everyone boring in their work together, I think is just so powerful. Yeah, I've got to be honest, I'm very excited about potential for interagency working. Because there's so many organizations that kind of I know it sounds awful. There's lots of there's lots of crossovers between the health service, the education service, the employment services. Do you know what I mean they could do it. Yeah, it keeps us in business US like just doing redundant work independent of each other not talking to each other within an organization across organizations. There's so much of that and some fortunate we don't rely on each other's expertise unless someone's having a discussion of the, you know, water cooler and say oh you're doing that we're doing that too. Yes, to whatever extent we can share each other's expertise wisdom, you know with each other and put that I think as well. There's an economic argument for using it on both sides of the Atlantic. Yeah, our economies have taken a massive hit due to COVID. Absolutely. So the opportunity to not duplicate work, but instead to collaborate and build upon, you know, basically, to be more efficient, I suppose, I think, whether or not we want to in the short term that's going to be forced upon all of us whether or not we're in the UK, the Eurozone area or the US because nonprofits and charities are not going to be getting the same level of donations as they were getting pre COVID, because a lot of businesses that used to donate right are in trouble themselves, aren't they? Do you know what to mean? Yeah, for sure. I don't have so much of a question, but I just want to say thank you for the presentation I thought it was really helpful. And I'm also excited. And I'm like these numbers are just not working out. And I that's why he asks me do you want to record this? I'm like, no, not because there's anything, you know, like anything secretive about anything I'm doing, but if tomorrow someone's, if you put this on YouTube and someone's looking at this and they're like, oh, this guy doesn't know what he's doing. I don't want that to be out there. But I think the idea was to show you how easy it is, you know, how accessible it is, how free it is, whatever is free. I think that was kind of the goal. So hopefully if y'all can take that away, not look at the numbers because I honestly barely practiced anything before this call, it's been maybe 20 minutes this morning to make sure that the connections work. So, from a qualitative standpoint anything I did is completely wrong and rely on it but from just knowing the potential of the tools available to you. This is a hint of what's accessible what's available and know what could be available to all of us. Yeah, it was a great overview. Thank you. I'm excited to dive into it now I'm going to make my account. I drew a question I came in a little bit late but where are the, what are all the like the available. Is there a way you can see like specific available public data. Yeah, you can use. Oh, oh, honestly I wish I could say Rosalind is that you okay. Yeah. So what's, do you work in a nonprofit is there a specific space that you work in sustainability. Okay, so yeah in terms of where to find data. I mean Google is my best friend you know I was keen about incarceration. So I went to Google and I, I guess the way I kind of do go about it is if I want to find like an Excel document and whatnot that has some statistics, I might type in a keyword. Inability. Oops, there we go. And I might say hey Excel file, you know, and hope that it throws something useful, which it might not always do. So, it might just come down to knowing because a lot of I think especially since since I work with so many organizations and like education and whatnot a lot of the data repositories are managed by the federal government state governments, right, like report generation tools etc that sometimes you know I have in my work found like an Excel document and wondered where it came from someone generated report from, you know the education department at their state, and use that breadcrumbs to get back to the original source and run the actual numbers from there. I think that's kind of one way or, you know, maybe go to Tableau public and look for sustainability and see what everyone's done. So, interesting things to know you search for keyword you see what other people have done. That's useful if you find something really helpful sometimes people might share their data with you, right so you might actually be able to download the specific workbook that that that their kind of Tableau visualization is built on, it might even let you download just the data, you know if it's an Excel sheet, etc. I don't know how you use that might be good for practice but if you're actually building something for work, you want to know where your data is coming from so I don't know if you anything that's going to be helpful I don't think I can know, given how much time you probably worked in the space. What your reliable data sources are you might know them better but anyway you can generate data that can be spit out in an Excel file and a CSV file. That's a good tip. You know sustainability data is just, you know, it's probably not databases are just being built, should I say. I think that everything out there has been done and surely someone's done this somewhere. When you start getting down to ignore a lot of things haven't been done. Excellent sources or repositories of research or insights on sustainability. So very possibly you might be the first one building something for others to, you know, look. Rosalind also I work in sustainability as well if you haven't already I think draw down is publishing some more. Some more data in the next year. Oh draw down. Yeah. Okay. Alrighty. Thank you. Yeah project job and they're international and they have a bunch of stuff. Wonderful. Okay, cool. Hey Aaron. If you, if you, if you can, can you message me through. I think we can message through here. Yeah, yeah, I'll drop my email. Yeah, thank you because I would love to know a little bit more about what you do. Absolutely. Thanks. Thank you for your work. I think that's part of these meetings. Yeah. But I appreciate the overview. It was actually very, like, I think insightful. I hope so. Yeah. Hopefully I'll see you out of, you know, out of in person meeting. You know, honestly, okay, since you're in Houston, I'm going to try and recruit you. I signed, I already run a Salesforce use group meeting so this gets better.