 Welcome everyone. Welcome to our webinar. Five tips to bring your organization's story to life using Silk. Thank you so much for joining us today. I'm Susan Hope-Bart, the online training producer here at TechSoup. And I'm actually really super excited about this presentation and live demo of Silk. I know this presentation will be relevant and interactive to the important work you do. We appreciate the fact that you answered our registration questions. That helps Alex, our presenter, and TechSoup better understand your organization's needs. We're going to be viewing live demonstration of Silk and give you the opportunity to ask questions. Please know your opinion is very important to us at the end of this webinar or if you have to leave early. There will be a pop-up box with a survey. I do want to implore you to complete that survey. That helps us get better helping you. Let's take a few minutes and review our platform ReadyTalk. I'm going to give you a few tips. There's a chat box in the bottom left-hand corner of ReadyTalk. This is where you can chat questions, specifically if you're having technical problems like you can't hear anything, you're having trouble with the audio, or you have a question for our presenter. That's where you can put all of your chat. During the event, we're going to be keeling the questions. So at the end of the event, we will try to answer every one of your questions that you've chatted in. We will be collecting the questions and posting answers in a document that will attach to the webinar itself after we record it, and we post it on our website. Keep in mind if you lose your Internet connection, you can reconnect using the link that was emailed to you. You also should have received a reminder email if you registered more than an hour ago. And keep in mind that much of this session will be a live demo of Silk. If you're hearing an echo through your computer speakers or are having any issues with the audio, you can dial in using the toll-free line listed in your registration email. As I mentioned, we do record the webinar and it will be available on our website in about a week. It's also where you can view any past webinars. It's at www.techsoup.org slash community slash events dash webinars. You can also go to our YouTube channel at httpswww.youtube.com slash techsoupvideo. As I mentioned, you will receive an email in about a week with a link to this recorded presentation and any collateral materials, so like the Q&A or any PowerPoints. You can also follow along on Twitter. You can tweet us at Techsoup or by using hashtag TS webinars. Let me tell you a little bit about our presenter today. Joining us today is Alex. And Alex is the Head of Marketing and Business Development at Silk. Silk is a free data publishing and visualization platform used by dozens of news organizations, marketing teams, and nonprofits to build publish-ready databases, maps, and visualizations. Alex was formerly the Tech Editor at Business Week and he's bylined in numerous national publications and is still blogging and writing. Alex also participates in data journalism education for college media and the open data movement. I've been working with Alex over the past few weeks and talking about this presentation. It's going to be a very good presentation. You'll be able to walk away with a lot of tips for you to use this program. So I encourage everyone to click on the link that was silk.co so you can also follow along. Also on the back end here we have Ali Bisbekan and she's going to help with any technical questions or audio. I'd like to take a minute to review our objectives. Today Alex is going to be showing you how to use silk to build an online impact map, create an online story canvas, create an online interactive visualization, publish online, a simple sortable table, turn contacts into a simple online database, and also answer all of your questions. A few things about TechSoup. We're located here in San Francisco, California, and I'd like to know where you're coming from. So in the chat box go ahead and chat in the city, state, or the country that you're connecting with us. While you're doing that I'm going to talk a little bit about TechSoup. We're a 501c3 nonprofit like many of you joining us today. We work to empower organizations around the world to help them get the latest tools, skills, and resources. This helps them achieve their mission. You can see from our map here that we serve almost every country in the world. We have about 62 partner NGOs around the world. The need is global, and we have a dedicated website for countries outside of the U.S. at www.techsoup.global. This is where people outside of the U.S. would access technology donations. Wow! We have people from all over, ValkaVille, California, San Ramon, Wisconsin. Wow! And we have like 300 folks on the line. Wow! We have some people from San Francisco, Great Texas, Alabama. Welcome everyone. Fantastic. A little bit more about TechSoup. We've helped organizations get more than $5.2 billion in technology products and grants to NGOs around the world. These Tech products and grants come from more than 100 corporate and foundation partners. So before I turn this over to Alex, I do want to ask you a question. This is your live poll question. This is your opportunity to fast this finger. We'd like to know what specifically you'd like to learn today. Build an online impact map. Create an online canvas story. Create an interactive visual. Publish a simple, sortable table. Or turn contacts into a database. Answering this question will help Alex hone and customize his presentation today. And whoa! Those responses are just coming in. Wow! It looks like a couple are tied. Online story canvas. Oh, it's going too fast for me to even count. Wow! It looks like I'm going to give everyone another minute. We have about 200 responses. Let's see what we have. Wow! That's 64, 65% would like to create an online story canvas. And then that's closely followed by creating an online interactive visual. Wow! Thank you everyone. Thank you for chatting in and for answering that poll question. Excellent. Well, Alex, it looks like the presentation you've prepared is going to cover all of this very well. Very cool. I'm super excited to be here Susan. And thank you so much to TechSoup for having me on the webinar. So I'm going to turn it over to Alex, ready to go. Okay. You can hear me okay Susan? Yep. You are perfect. Awesome. So I'm going to go ahead and share my screen with everybody so you can start to see my desktop. And we'll actually walk through a live demo of how to build Silk and how to use it. And unlike other webinars that are based on PowerPoints, you're actually going to be building something, or watching me build something that's going to be live and on the Internet as you see it created that you could actually see on your mobile device, on your desktop, or anywhere. The goal of Silk is, as Susan said, to let anyone build interactive data visualizations, websites, maps, super easily without technical training. To give you an idea of some of the things that people use us for, they use us for things like web canvases about small college basketball players, corruption in Brazil, student journalists use us, lots of nonprofits use us. So for example, we have Pittsburgh Playwrights is a small nonprofit that uses us. And I'm going to show you a little bit of what Soaks look like. And I'll start with sort of one of our proudest ones, which is actually TechSoup. TechSoup uses Silk for its impact stories and maps. And this is a map that is maintained by TechSoup. It's hundreds and hundreds of impact stories around the globe. And each one of these points is a specific impact story that can then be looked at and examined. And so here they have a little bit of the text. They have an image, some of the data about the organization, and they're using Silk to build this map, but also as essentially an online database of the impact stories. So what I'm going to do now is show you this is what the database or basically spreadsheet looks like inside of Silk. And this is the same thing that we turned into a map. Now this is the power and the idea behind Silk is that we take spreadsheets or tables of data and make it easy for you to turn them into far more useful things. Now you can also build things manually with Silk. But for example, remember we were starting on this TechSoup impact stories and I turned this into a table view. Let's say we wanted to add a little bit more information to it. And maybe I wanted to, rather than build a map, I wanted to build a donut chart. This is our visualization palette. You can pick from different types of visualizations. And so now what we did basically is we built a quick donut chart. I'm going to pick let's say something continent. And that will show us the number of program member stories by continent. You can see it's 49% in North America, 34% in Europe. Now this visualization that you're seeing is actually live and on the Internet right now. So even though I don't control this Silk, I can turn it into interesting visualizations. And as you saw, anybody can do that. If you wanted to as well, you could also share this visualization, just this URL as a short link. Or you could embed it in your website. So we generate embed codes which would let you embed it in a WordPress blog, on a website, in a Medium post which is one of only a few visualization platforms that let you do that. And the super neat thing about Silk, I'm going to go back to our homepage here actually, is that some of you are probably watching this from a mobile browser. So Silk is as the whole platform 100% responsive. So what you're seeing now is the middle of my desktop, but this is roughly what it would look like on a mobile phone. So you can see the map size down, all the different pieces in it that all just fit. So it just works. And it's very nice for nonprofits or other organizations that don't have big tech budgets, don't want to think about how do I build a mobile-ready website or mobile-ready visualizations. We just do that for you. So let's take a look at some of the other Silks that have been built by other nonprofits, and then we'll go ahead and dive into the building ourselves. So this is actually a Silk of Analytics by the National Breast Cancer Foundation, and they're using us to map out, to build charts, to map different data around their videos for example, or around the comment, likes, and shares on the different videos. So you can see some of the different charting types. There was a line chart up at the top. This is a column chart. They also added videos so you can actually put playable videos embedded inside of the Silk as well. So it's not just data visualizations and text, it's also multimedia, such as videos, audio, images, slide share, live Twitter feeds. All of this can be embedded inside of Silk. And that's why it's really a data storytelling canvas. So Quebec is a bicycle empowerment program in South Africa, and they used us to build a very beautiful data story canvas. So you can see here is sort of the text part of the canvas. They embedded a picture, some more information. Then they built some charts, a simple map showing the number of bicycles distributed, and specific data down there, and a little video, and their Twitter stream. And this probably took them about 45 minutes to build. And if you actually dive back into the data just like you did with TechSoup, each of these data cards we call them contains data about this particular row or region. So this is a row on a spreadsheet. And that's a core construct of Silk. These are the column headers, and this is the data inside of the columns. And that's the way Silk works. We take what would be a row on a spreadsheet and turn it into what we call a data card. You can also construct the data cards by hand. But let's keep looking at a few of the other NGOs' Silks so that you can get a better idea. This is Arab Digital Rights Data Set. So this is something that a very cool organization in Lebanon called SMACS, or Social Media Exchange, built with us. And this is a map and visualization showing how digital rights laws are in the different Arab states in North Africa states. And so they built a map. They built a nice bulleted table. They have images, slide shares, and you can see they also use a multi-column layout. So you can do slightly more fancy things with this. It doesn't let you have sort of true web offering where you can adjust every bit in piece, but it does let you have quite a variety of ways to display your data and do it visually and in a beautiful way. Some of you may have heard of Human Rights Watch. So they used Silk for their campaign last May I was believed. I believe tracking anti-LGBT legislation around the world. And this map shows sentencing category types. And they again used the Mosaic of Country maps so you can build nice Mosaics with images and some visualizations. And this they embedded in their blog. They drove traffic through this and it drove phenomenal awareness and engagement for them around this topic which as a Human Rights Organization is something that they feel strongly about. Small organizations love us or are enjoying using us too. So this is the Pittsburgh Playwrights Theatre Company. And they created a nice little story gallery which is also a visualization type of all the playwrights with their bios. And each one of these playwrights too has their own data card with the image on it so you can add them there. And I want to point out one thing about the data cards quickly is that if you look so I highlighted the URL section. We not only take each row and turn it into a data card but each row actually becomes its own webpage that you can edit by adding images or text. This is powerful because it makes your data very transparent and exposed. And so when people are looking at the Internet of Searching they can often find data that you've created because rather than it being trapped in a row somewhere it's actually a live webpage that if they search for the URL or search for say like clean up information in Lake Champlain which this is something that Vermont Public Radio built with us they would find not only these pages in this silk which they built but also probably some of the specific location data so for different parts of Lake Champlain or different years. And a lot of public radio stations are using us because this is a really nice way for them to build these data storytelling canvases quickly and easily and actually embed the whole site as an iframe in their domain so that it basically looks like part of what they're doing. And again even with the very complicated layouts like we have on this version, on this silk you can see it's all responsive and completely works just on mobile. I'll scoot down a little further so you can see. So these were multi-column layouts. We reduced them to simplify them so that they all display beautifully on mobile. I'll take a quick pause. I've gone over a lot and asked Susan if there's any questions right now. We're also happy to share all of these different sites and information later on after the webinar. Great. Thank you. Yes, we do have a couple of questions specific to creating maps. Someone is asking if they'd love to create a map of where their patrons are but it would be very local to a specific city and state. So the neighborhoods can your mapping function be this localized? So absolutely we can. And let me see if I can pull something up quickly that would show that. We can put down to the individual levels. I'm trying to think if I have a good silk that shows that right now. So the way to think about data and silk is we're as accurate as your map data is. So if you give us a street address we could plot down directly to a street address. If you just give us a country name then we'll plot to the country name. But it's really a factor of how granular you want the data to be. If you give us six addresses on the same street we'll plot a map that shows a different address. I think that answers the question. And you'll see a little bit of that as we go ahead and build the maps. I'm not going to build them as granular as that but you'll get a bit of an idea of how it works. So the title of the webinar today is Five Things Nonprofits Can Do With Their Data. And we're going to stick pretty closely to that and we're going to build first an impact map, then some sortable tables or just one sortable table, then some data visualization. So interactive story data, interactive visualizations that you could use, and then an employee directory. And then finally, that's a sort of grouping so this is another visualization type. Finally I'm going to build a data story telling canvas. We haven't actually constructed yet and I'm going to show you how we can do that live and on the fly and how quickly you can do it. So let's go ahead and start with an impact map. And what I'm going to show you now is basically the data set that I'm going to use. So in Excel this is an impact map or this is a spreadsheet of organizations that are using open data, nonprofits using open data. I'm sorry this is – forgive me Susan, I totally forgot about this. So here's our quick party trick which we'll show you just to give you a quick flavor on Silk. This is actually the attendee list for the webinar, Anonymized. And Susan shared this with me. So I'm going to actually go and later on, if we have time, I'm going to turn that into a Silk for you which you can then look at and analyze the attendee data. But for now I'm going to go grab this data which is actually – this is the spreadsheet and it is linked and easily downloadable on the website that I am posting. And Susan you can actually share this if you want if people wanted to go look at that. The webinar is at silk-webinar-4techsoup.silk.co. Let me see if I can put that into the chat room really quickly. Where can I get my chat window open? That's probably it. Okay, and this is now out there. So this is basically the canvas that I'm working from and you can access this later and we'll probably add some things to it later as well that will give you more resources. So we'll start with building an impact map and I'm going to use this spreadsheet. What this spreadsheet is, this is actually data from an organization called the Open Data Enterprise Organization. And it's a nonprofit that tracks and maps open data to how it's used by organizations. So they built a very cool thing called the Open Data Enterprise Map. And I'll pull that up really fast so you can see it. And this map is something that they've built which is beautiful and fairly complicated and super nice. And I'm going to show you how to build something that's almost as good just from the spreadsheet and then build all these other things as well. So this is the Open Data Impact Map. Open Data for a lot of nonprofits too is a powerful thing. I highly recommend you exploring it if it's relevant to your organization. So let's go back to the spreadsheet. Now I'm going to simply grab this. I'm literally going to copy all, copy it, and make sure I have the whole thing to make sure I get all of it. So copy all, and I'm going to go into Silk. And so you remember this impact map that you're seeing here. I'm going to go and create a new Silk. And we'll call this just Test 2 for Webinar. And you remember how I copied all of that data into my clipboard. So these are the different ways that you can create pages or data cards in Silk or upload data into Silk. I'm just going to paste that data right in. And I'm going to click Import. And now what you're seeing is actually a live preview of what each data card will look like inside of Silk. I only pulled 48. The data set is closer to 900 total. But just to keep things speedy because if you have 900 data cards going up, it tends to slow down a little bit. So you can preview some of these. And you see here actually we pulled an image out of a web page. So if you go back here, you'd see Abra Latam is an organization in Chile. One of the columns, I didn't do this for all of the sites, but I had a column that's called Image. And when you look at this, you'd see this page as a URL with .jpg in it, which is basically that means there's a picture on that specific web address. So we can pull pictures in off of the Internet from some of these types of pages. We can't do it from Dropbox or Google Drive because they protect it. But it's something to think about if you want to quickly and easily take images that are in your WordPress blog and put them into a Silk. It's very easy to do it that way. As you see down here, this is actually like WRP content so we can pull those kinds of things in. So let's go back here. And I'm previewing the data. So this is basically what your spreadsheet looks like. Let me again change that. Sorry, a little error message there. Love when that happens. And just taking a look at the different things. And the gears on the side too, if for some reason you wanted to split something on commas or ignore fields, so for example like the other field, probably not going to be useful for me, I'm just going to click Ignore. When you see up here too, the data card title, this is the name of your data card or what we would use as the unique identifier for this specific row on your spreadsheet. The reason we need that is because if we do things like counting or visualizations or maps, we need each row to be unique because if they're not unique, then we get confused in the counting or the mapping. So you don't have to worry about that. We also do that automatically in the back. If you don't do that, but this is just to help you understand how Silk works. So I'm going to go ahead and click and start the import now. And this should take not too long, maybe 10, 20 seconds, or maybe less. Okay, cool. And so now if you were to go look at this website, this Silk, it's actually live and on the Internet. So in fact, I'll even quick chat this out to people so if they wanted to go and check if they can. By default, because we detected the images, we'll generate a gallery like this just so people can see it and help them get an idea around the data. So you remember that spreadsheet that we were looking at? That spreadsheet is now in Silk. Exactly the same thing. The spreadsheet of course is a lot uglier and you can't turn it into visualizations, but that's the whole point of Silk. We'll take your spreadsheet through your data and turn it into something online that you can see quickly and easily. So now let's go ahead and build that map. I'm going to go up to the Visualization palette and I'm going to pick the map icon right here which is right in the middle. And we may automatically detect the location that's appropriate. We don't in this case. Sometimes we do that which is nice, usually if the word map or location is in there. I'm going to go ahead and okay, so map location is here. I'm going to select the row value that I want to be for the map. So for example, when you go back and look at your spreadsheet and this is just basic mapping. Map software can't just look at this and say, oh, I know what I want to build the map from. You have to tell it which column, in this case the map location column, I'll make it a little bigger, has the data that you want to build the map from. It's not letting me go more than 200, so let me go up to 250 just to make it a little more visible. So you can see this is the data that I'm picking, map location column J. In Silk I'm picking for the location to be the plot, map location. And now you see all the pins start to drop in. Now we wanted to also do a color buy plot. So we had in the impact map that you saw on the home page, you saw a distribution of, or I'm sorry, you saw a color buy of the industry categories because there's a bunch of different industries that are using open data sets in their nonprofits. And so here I just clicked the color buy and I selected industry category. And now you can see that all of this has been populated. It has a nice key. And this map is now built. It's actually a public URL that you could go and explore if you wanted to, and go build your own visualization. Let's add even a little more to this. So I'm going to add a nice little filter. And I'm going to filter by region. And so now you can filter down to the specific regions. So for example, if we wanted to focus on Latin America and the Caribbean, it will automatically drop the filter down and show this as a map. Now these filters are accessible also to people on the Internet. So I'm going to just clear this filter quickly and then I'll just add it back on really fast. And I'm going to publish this map to the home page of myself. Susan, am I going too fast or is this okay? Susan I think you're showing the connection between taking a spreadsheet, a relational database, and then turning it into a map of visualization. So I think for folks to get that connection, and I like that you're showing the column headers too, so folks know what categories you're focusing on. Cool. Okay, so if I'm going too fast, please shout at me. I'm very happy to show that. So as you see, we now have it done. This is the exact same map that you would see on the page of the webinar soak that I built for you. I can go and edit this. Oops, sorry, sometimes it does that. Let me go back to the home page. Basically I forgot to click Edit Home Page. We're very careful about data. Maybe we don't want people to lose their data. So you have to be in edit mode to edit things like text or maps once you're on the home page, or once you're on a published page. So I'm going to title this map for webinar. And if I wanted to add a caption down here, Data Source with URL, I can add that pretty quickly and easily. So I basically just highlighted, I typed in the text, and then I highlighted it, and I typed in a URL, and it would put the data source right there. I'll do that again. www.techsoup.org click, and now you see it's highlighted. So you can see down there that's highlighted. So I'm going to save this page and just to quickly review this. So first part, Mission Accomplished, Impact Map Built. Now let's build a sortable table. So because we already have the data inside of Silk, we actually don't need to import it again. So I'm going to build the visualizations in a slightly different way now. And rather than go back into the Explore tab up at the top, I'm going to click on one of these plus handles in the pages. And that lets you, if you're editing a page, it lets you access all of the visualization types that you would want anyway. And so also the visualization engine. So I just clicked Visualization. So to go over the steps again, I click Edit Page, Green Plus Handle, Visualization, and now I'm going to click Table. And so it will automatically go ahead and start building the table. And I can pick whatever column headers I want for that table. I don't need to use all of them. So for example, I could pick State Country. Maybe we'll pick also Industry Category like we had. And again, we can add a nice filter. So let's say we want to filter by Region again. We'll leave that there. And if you wanted to filter any of the values in the tables, and this also works in any of the visualization types as well too, we have a very robust filter engine. So if I only wanted to show 20 of the rows because 48 rows in one page is an awful lot. And on default showing from A to Z, that will modify the table so that it will show only 20 rows on the page. So right now, okay, we're still editing the page. So I'll go ahead and edit Table, Sortable Table for Webinar. Okay, so that was the second prompting me to save because it wants me to make sure I'm saving my data. So that was the second mission from what we were trying to do. To show you the sortability, we could sort on Founding Year for example. And then it will show Reverse Order or Order. If I wanted to filter here by the Region, again we did that before. We'll do it again. Now we'll just limit down so that it's only showing North America. So you basically have now a Sortable Table that you can publish on the Internet very easily. And again, to remind you, there's a Share and Embed button. So that means other people or you can generate this table and embed it elsewhere. Or you can also share it as a short link in other places. Or you also have social features. So for example, it should generate a nice little, yeah, okay, we got it good. So we have a Facebook preview which is very nice. So for those of you that are very focused on social media, this makes it a really nice way for you to share visualizations quickly and easily without having to go and cut and paste images and worrying about things like that. And on the same sharing note, as I said before, I don't know how many of you are familiar with Medium. Medium is an absolutely beautiful blocking platform that's working very quickly. And Silk is one of two visualization platforms that has visualizations working on Medium. So right now, most people, you just have to put a static image here. On Silk, when you put visualizations on Medium, we actually have live maps and interactions. There are millions and millions of people on Medium, so this is another interesting publishing venue for you to think about. Let me go ahead and I'll close down these two windows because I don't need them anymore. And back to what we were building. So we have the table. Let me go check back to my list. I believe the third part of the mission, if I'm not incorrect, Susan was going to be visualizations, right? Susan- Correct. I'm creating online interactive visualization. Gregg- Okay. So the interactive visualizations are actually part and parcel of the storytelling canvas, and we weave them in very tightly. But you can also create them as sort of standalone pages or just standalone views as I was showing you earlier. So I'm going to go ahead and save this page. I'm going to edit it again. Now I want to build, let's build more than one visualization. Let's build a couple of them. And I'm going to click again in edit mode, as you see up here. I'm going to click on one of the green plus handles. Now where you see these three icons in a row here, you can actually click plus and create a section type. So this gives you some more variability around the layouts like you saw. So let's do something where we have three visualizations right next to each other. And rather than it be on a white background, I'll pick another dark background. So to access the same visualization engine, again click the plus handle inside of one of these dark windows. And I'm going to click visualization. And now let's go ahead and build that donut chart like I was showing you before. So this is a pretty good one. This is showing a distribution of organizations. They are called company names, but of the nonprofit organizations by the region. So here we've constructed the visualization and it's ready to go. If I wanted to add any kind of filter or something like that, then I can again add a filter like before on the visualization type. And so that makes it very easy for you to create custom views or have your users play with the views. Now I'm going to click done. And so now you'll see in a second that visualization is actually published inside of our data story canvas. Now I don't necessarily like the way this is looking filtered by industry category so I can actually get rid of that. And if I save the page, then you would see, okay so now we've built an interactive visualization that's living right in this page. Let's do another one. So I'm going to go back up to the top again, click edit. And one thing to remember too about visualization is you probably want to educate yourselves on how to use them appropriately. So for example, this is a good use of a donut chart because it has a nice tight legend on it. If we built a donut chart with a different type of data, so let's say we built one with, rather than region, it would be country. And that's just going to be like one slice per country. And I'm going to increase the number of slices you're seeing in the visualization to all. And very quickly you have a mess. It's hard to read. So with donut chart visualizations, you want generally no more than 6 or 7 slices and the rest should all be other. Every visualization type is different and has its own nuances. So let's build a different visualization type because we did a visualization type there. I strongly recommend, and I'll share this with Susan as well. I wrote a little blog post about how you can build, how to think about which visualizations for which data types. So rather than build that, we're going to build instead a vertical bar chart. And something that's very nice about vertical bar charts is they show very well on mobile because people are scrolling up and down a phone like that. So what we want to do for this too is to make it nice because right now this would be very long on our data canvas. I'm actually going to go ahead and limit this a little bit. So let's just limit down to just 10. So it's going to show the top 10 by value. And if you see also this is the distribution which means account. That's a little bit kind of like a pivot in a table, but don't worry about that right now. So I have 10. So this is a nice workable size. I'm going to configure the colors as well. So one nice thing that Sokwets you do also is if you want to add colors to chart values or change the colors in your charts, we let you pick and choose and do some nice little different color variations. Or for example, if you're doing like red states, blue states, red states can be blue. I mean red states can be red and blue states can be blue. Or if you wanted to signify danger or bad, you can use red. So this lets you make charts that are more credible. So right now if you go and look on this version of Sokwets, you would see again we made it responsive for the space. So there we've built the horizontal column chart. And it's live interactive visualization sitting right there on your page. Susan, how am I doing on time? You're fine on time. I think to slow down a little bit and show the steps because you're demonstrating these awesome visualizations. And I think folks like to see those steps that are behind it. So these are amazing. And we're getting a lot of questions about that. So in your next visualizations, the third one that you demo, just take it back down to start from the beginning so that folks see like that one, two, three step. Okay, forgive me. I get too excited and need to click on it. So there's two ways to build visualizations in Sokwets. I showed you before about how to build them in the Explorer mode. Let's go ahead and do that really quickly so you can see it. So you can always build a visualization in Explorer. And that's the tab at the top on the far right. If you click on it, it will give you access to the visualization palette which shows all the visualization types that are accessible. If you click on a visualization type, so we built donuts and bars, let's go ahead and now we'll build a vertical column chart, sorry, a horizontal column chart. So you click on the visualization type you want to build. Next, it will ask you what is the information you want to display in that visualization. So because we're looking for numbers in the charts here, we would actually select rather than a slice value or just like a view of each row, a distribution value which is a count type. So there we could count, let's select a region, okay? And you see here it shows distribution up here now, and I've selected region. So now it will build that chart showing you the different regions and the number of organizations in the different regions. And you can see that Latin American and Caribbean actually has the heaviest followed by other parts of the world. If I wanted to then change the colors on these bars, I could click configure colors which is a little thing down in the corner here. It's a little hard to see. Let me go ahead and blow up and then I'll blow down. Sorry. So you can see it a little better now. I click on that and then I click on the bubble next to the Latin America and then I can pick a different color. And then you'll see in the silk it shows up. Now if I wanted to publish this to a page, I can do that. I can publish it to my home page. And now when we go back to the home page, so you recognize this, here is the chart that we just built. Now if I wanted to go back instead and see we're still in the same visualization, and rather than publish it to the home page, I wanted to just take this as a standalone visualization type. Then you would use the share bar for that. And you could either use it as an embed code and this would be for embedding in a website, or you could publish it on Facebook by clicking the Facebook icon and it will show you the chart type there. Or you can publish it as a short link and save that to send out to people. And if they go to this link, it would show them precisely this visualization. Is that slow enough, Susan? Or does that slow down quite a bit? That was perfect. I think folks just wanted to see that the data came originally from a spreadsheet, just a simple spreadsheet. And you were able to pull it in to show it as a visualization and the different types of visualizations. So that is one way to make visualizations in the silk. The other way is to actually edit them right into the pages as we were doing before. And you saw me clicking on green plus handles, creating these sections. That's in-page data visualization adding and everything. I'm going to shrink down a little bit. And to do those edits, like I said, you click on a green plus handle anywhere you see it in the page. So for example, there should be one floating around here somewhere. Let me shrink it down a little bit more. Yeah, there we go. And there's the third column that we had. I'm going to click this green plus handle and then you get a selector box that opens up. And you can add different content types. So this allows you to add a text, add images, YouTube videos, Twitter, or to add a visualization just like you have in your visualization palette. And so here I'm going to add a quick visualization using the in-page editor. And so you saw me doing this horizontal column chart before. Let's go ahead and build that same column chart but using this editor. So the editor looks almost the same now. It's just now you're publishing something that's designed to go directly into the page. So again, I'm going to click Distribution because I want to see a count of values. And rather than do region, let's do industry category. There's going to be a bit of a wider count. So instead, I'm going to go ahead and filter down to the first five just to make the chart a little more workable for our size. And again, I'm going to configure the colors so that they're a little prettier and a little less boring because if it's all the same color, nobody really likes that. And now I'm going to click Done. And you see it says here, Editing Visualization for a Page Test to Webinar. It's telling you what's happening. Once I click Done, then rather than Explore where you're generating a visualization that sits in the standalone, this drops the visualization right into the page. If I wanted to cut that visualization and use it somewhere else, I can clip it. Click a plus bar somewhere. Down here is my clipboard, and it will drop right in. So another thing to remember about all of these elements that you see in Silk, they are all drag and drop. So every single thing that you see on these pages can be moved around and will resize to fit into the different visualization areas. So if you wanted the table to go above the map, we'll put the table up here. So I think we've gone through the three missions. Do we have time for the last two, or very quickly? Before we get to that, we do have some questions that I think are common throughout. Talking about when you use Silk to create a website or the information, what about privacy? What about selecting things that are viewable only by select folks? So Silk is binary. Either it's entirely public or it's entirely private. If you wish to make your Silk private before you publish it, it's very simple. You would go into your dashboard, then you would go to the Settings menu right here. Click Settings, and then down here you see Privacy. If you click Private, then your Silk becomes private, and it's no longer on the public Internet. And you will see up here, a padlock up here. And then can folks invite people to that site to view it? Exactly. So anyone who is invited to that site can view it. And you can do that by adding a member, and that will let you – sorry, I have to save this before it lets me get back into it. If I click Add a member, then I can add a member down here by adding their email address as the editor. And you can add as many people as you want. So if I wanted to add – it's at Soapbard at TechSoupGlobal.org, you would get an email in a minute Susan saying, hey, would you like to join my Silk? If you want to make it public again, you just click Public. And this is another interesting feature about Silk which is somewhat unique. If you're feeling – if you want to, you can actually make it so that anybody who is a Silk member can edit your Silk. So that's really neat for like – say if you have a community that wants to collaborate to build maps together, you can have everybody that's in your community come and edit your Silk, and add information, or add data, add pictures, all those kinds of things. More questions quickly, or should I go on and do the employee directory real fast? Susan I think as you upload that, a couple of specific questions about the types of Excel files that can be uploaded to use. So are there any restrictions? Gregg So the default restriction is 3,000 rows right now. We can extend that out to 5,000 or 6,000 for longer projects. We hope to make it much bigger in the near future. But for now, that's sort of the limitation. For file types that we can accept from Excel is XLS, Excel is X, CSV, you can paste the Google Sheets URL into Silk and if it's a public sheet or publicly shareable URL, that works as well. You can also cut and paste data into it. And if you're technically inclined, you can import what are called JSON files into Silk. In fact, I'll do an upload on this one rather than just to show you how that works rather than a cut and paste. So this is a little mini employee directory that I made of TechSoup personnel, sort of a random selection. And you can see Susan is one of the people on here. And I added some other folks. I also added an image from the LinkedIn page which should work, and location, and their group. And if you see here too, there's comma separation on some of the columns. So Silk can handle multiple values in a field. We call them facts, and we would call the column tags. So we can handle multiple facts in a tag set. And that lets you group things in a more dynamic way. But let's go ahead and build this really quickly. So Silk is not limited to a single spreadsheet. You can add different collections if we call them, which would be a new spreadsheet. And so I'm going to go and click Upload Spreadsheet now. And I'm going to pick one from my desktop. And it's the TechSoup Global Webinar CSV file. I'm going to click Open. Now I want to actually edit the collection name because otherwise it will get confused and start to think that this is the same collection Oh, I'm sorry. Let me cancel that. So I was on the wrong. So this is what I did wrong. Basically I should have, I don't know if it does it with CSV. It might be with Google Sheets. It may not recognize the rows at the bottom. But normally it does this pretty well. Let me try it again one more time really fast. I don't want to waste your time out here. So anyway, when we're importing, when you import data into Silk, you should be in the Dashboard mode. So this little white tab should be highlighted. That means you're here. And you'll see all of your data cards. So these are all of the organizations that we uploaded before. And these are the options down here for new collection types, which is what we were talking about, ways to get data in. So let me try that spreadsheet again really quickly and see if it should pick up the different collection types. If it doesn't, then that might be a slight bug, and you have to forgive me for that. So it's picking up that. That's not the data that I want actually. Yeah, okay, let me go ahead and just do a cut and paste again. Sorry about that. But trust me, it does work on XLS, XLS, and CSV. Hopefully that answers the question. So I'm going to grab that data. I'm going to go back in. So I copied and pasted it. It's in my clipboard again. We're going to paste that in. And we're going to create very quickly a TechSoup employee directory with 7 employees. And so you can see all the data is in here. There's Susan's picture. This is her expertise. She probably has a lot more than this, but I just sort of put something together. Now I clicked the gear button next to the expertise row. And the reason I did that is because I want to split these values on commas. So now I actually misspelled education. Forgive me. I'll have to go ahead and fix that. When you do that, Silk will recognize each one of those values as an individual data value. And you'll see why that's nice in a little bit. So let's go ahead and click import. And as that's importing, I did want to address some questions as well that we have as you're showing the import. Great. When you upload a spreadsheet, does it automatically become public? Yes, but you can quickly go and like I said, you can set the default. As soon as you upload that spreadsheet, if you basically go and change the settings to private, that's totally fine. And does Silk work as easily on an Apple platform as PC? I'm doing this on an Apple platform. Excellent. Some folks are wondering about the maps that you've created. What about if they wanted to make that interactive for the community to manipulate themselves? Yes, if there are members of Silk and you set your Silk to Silk members can edit, then they can go and they can actually edit the contents of the data cards. Great. Which is essentially the content of the maps. Great. What about exporting from Silk? You wanted to take one of the data visualizations and put it in PowerPoint. So for that, we don't have a specific capability, but if you do a quick screenshot of the PowerPoint, I mean of the visualization, it works fine. And we have people doing that all the time. And frankly, I know this sounds bad, but we built Silk to move away from PowerPoint. So we didn't really think so much about how do we create static images to put into PowerPoint. Okay. Fair enough. What about some folks are thinking, they've got multiple spreadsheets. Can Silk upload and read multiple spreadsheets at one time? Absolutely. I mean, not simultaneously, but yes, you can have multiple collections. And each collection can be a different set of information. Now, it's kind of like a spreadsheet in that you don't want to, for example, put your employee directory into the same Silk as your impact map, because each is a standalone website, has its own URL. So you have to sort of think of it as rather than I am publishing a spreadsheet, I am publishing a website. Do I want — is this the way I want users to interact with it? That said, you may want to say publish an impact story map and a corporate report or a quarterly report or a donor report in the same Silk. And that's totally doable from different spreadsheets. Great. How would you recommend that folks access support for — if they're an organization, then they'd like to use Silk versus an individual. We have some folks that are very interested in using this. So as an organization, we try to support people as best we can. We get back to them fairly quickly. It's also a pretty easy tool, so usually once people get to know it, they have no problems. So I can say like inside of TechSoup, I don't think we've gotten any support calls in the past three months, because I think you have some internal champions that are now pretty good at this stuff. We also have a full support section with videos and portfolios that are much greater depth than the stuff that I'm showing you right now. That's our beautiful error icon. We actually have a visual artist who did everything on Silk, and it's beautiful stuff. So hang on, I'll pull that up really fast so you can see it. I'm going to go to the home page, and then we have a Help button. No. And as you're showing that we are going to be supplying everyone with a link to your website so they can also get support. Folks are wondering about a resource guide as well. Meaning for this webinar? For Silk in general. Can you use it for a resource guide, or how to use it? I think how to resource guide, exactly. Yeah, so that's what this section would be. We have a full knowledge base with videos on how to make basic silks, how to do spreadsheet imports, lots of different topics. And if you can't find what you're looking for in there and you email us, we'll get back to you pretty quickly and tell you how to do what you're trying to do. And it may not be possible inside of Silk. It's not an unlimited platform. We do have some limits just to make it simple. So for example, like the visualizations and the layouts, you can't customize fonts inside the visualizations. You can't write CSS inside of the pages, or you can't alter the HTML of the pages. It's really designed for people that aren't accessing code so that does limit your customization. Great. One more quick thing. A lot of folks are asking about the cost to nonprofits and the fee associated for nonprofits. So this is free for nonprofits. The only thing we would charge for would be something like when Textures did their impact map, you see they have their logo on every page. And they also did some customization around the fonts and something to match their color palette, this nice sort of blue story bar, and the URLs. But frankly, we're not really interested in charging nonprofits much anyway. We certainly wouldn't charge small nonprofits for anything at all because we don't think it's a great way to make money off of nonprofits. We think making money off of guys like banks and lawyers and large profitable public companies is a better way to do it. So the short answer is the cost for nonprofits to start is zero. If you want to customize, we'll talk about it. I can't imagine it being more than $10 or $15 a month. Great. We've got time for one more question. Would the maps work with touch screen technology? I don't know. I mean we are using everything on this is multi-touch, but we haven't tried it. I mean if you had a multi-touch screen on the touch screen then you might, but I don't know enough to really answer that question effectively. Okay. And that's fair enough. We do have a couple of other specific questions about other programs and compatibility with Silk that we are going to answer on the back end and put in our question and answer document that we will be sending to folks probably within the week so that Alex will be able to answer some more of those questions. Our time has come to an end. We didn't get to finish everything. I know. Well, you know what? That will give us an opportunity to have a second level training on Silk because there are so many things that you can do very easily with the program. And since the program is something you can go to right now, play around in, we do encourage folks to do that. That's how I got started. So I can tell you that if I can get in there and start doing some things everybody can. We know we've covered a lot today and some of you still do have questions that we will address in our Q&A. So I wanted to make sure that we got some feedback from all of you if you would chat in the box. One thing that you learned in today's webinar and we know we covered a lot pretty quickly, but we want to know at least one thing that you learned today. So as you are chatting that in, I did want to remind folks that this entire month is we are talking about data and we have some other upcoming webinars. And those in the month of February we have. And it does look like we've got a lot of people that learned a tremendous amount. And it's true that it's right from a spreadsheet. You are correct. Everyone that's plugging in, yep, go right from a spreadsheet. And if there's an image link, Alex, correct me if I'm wrong, that's how we got those employee pictures that were right up there. That's correct. It can't be from Dropbox or Google Drive because they prevent that. But if it's published on the Internet like in Wordpress, it's very easy to do that, yes. Great. So right from a spreadsheet, all the things that you can potentially do for data visualization. So great. We are going to follow up with everyone in email. I want to thank Alex for taking the time to put this together. He's got such a wealth of information. And I'm sorry we didn't get to every single thing during this hour, but we do value your time and we appreciate you coming today. We also want to thank ReadyTalk, our platform for providing us this platform today and for all of our webinars. Yes, I see a lot of folks saying they want to silk too. So we can think about that. And we want to thank everyone, especially you, Alex, and also Ali on the back end for answering the questions for the technical support. Thank you all. Have a great day.