How To Make A Map With Multiple Locations In Google Fusion Tables | Jayadeep Rath | Skillshare

How To Make A Map With Multiple Locations In Google Fusion Tables

Jayadeep Rath, Digital Marketer | Google Ads Certified

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Lessons (23m)
    • 1. Introduction

    • 2. Step 1: Collate The Data

    • 3. Step 2: Import The Data

    • 4. Step 3: Map The Data

    • 5. Step 4: Enhance The Data

    • 6. Step 5: Publish The Data

    • 7. Step 6: Embed The Data

    • 8. Final Thoughts & Next Steps


About This Class


In 23 minutes, this class teaches you how to make a map with multiple locations in google fusion tables in 6 steps with short lessons having a specific outcome through a really specific application of  the knowledge. Once you go through the learning path, you will be able to mix and match and create a map with google fusion tables using ANY data set as the lessons in the class are universally applicable to understand how to create a map with multiple locations in google fusion tables.

The completion of all the 6 short steps leads to a clear accomplishment which is a map of countries along with their relative global peace index scores wherein we can see the patterns and the clusters visible on the world map. You can find the interactive version of the map by clicking here.


An understanding of Google Fusion Tables coupled with innovative and creative thinking can lead to the generation of location data that can go a long way to gain insights and solve sales, marketing as well as social and economic problems at all levels - global, country, city, local or hyper-local.

This class is the foundation for the know-how that is needed to take this concept to the next level as I will add more classes with innovative and creative uses of google fusion tables.

Here is the class outline with the learning path across 8 short lessons (23 minutes) culminating with the expected outcome. There is zero technical know-how and zero experience required to take this class.


Step 1: Collate The Data

Step 2: Import The Data

Step 3: Map The Data

Step 4: Enhance The Data

Step 5: Publish The Data

Step 6: Embed The Data

Final Thoughts And Next Steps


1. Introduction: Hi and welcome. This is jeremy dot com, and you are listening to JD Craft. In this class, you learn how to make a map with multiple locations in Google fusion tables. We are moving into an increasingly data driven world. Yet very few people know how to analyze and interpret data. The problem with raw data is that it's not good looking. It's ugly to look at. It is extremely difficult for anyone to look at an Excel sheet with numbers and make sense of that data and more so if the numbers in the table present location information, someone had to me such data beautiful and visualize it in such a way so that it becomes easier to analyze your location information on at the same time. It had to be easy to implement that visualization, and who is better qualified to do this? But Google Google Visual Tables is a data management Web application that lets you upload your data and create visualizations with that data. In this class, you will learn how to make a Google vision. People in six steps in step one will collate the data and in step to you, learn how to import data toe create a Google fusion people. After important the data, you map their data instead. Once you visualize the data in the home off a map, you will customize an enhanced their data. Instead, Poor Step five will cover how to publish the data. And finally, in step six, you learn how to embed their data, which has already been converted into a man. What I'm showing you right now, we get a specific outcome from this class. I'm going to be teaching you how to create this man. Having said that, you can always mix and match the knowledge from this plus to create your own custom maps with Google fusion tables, be using your preferred data sets. Whether example issue in this class is the mapping of the GP I or the global Peace index across countries and has more to do in visualizing a global situation. It is important for everyone to be on the same page in understanding the way Google fusion tables are created. The concept itself has universal appeal and can be applied a cross professional functions and a trust multiple verticals in this Internet age. But everything is moving to the cloud and people are consuming online content across devices and trust locations. The fact remains that people will always exist in a physical place, and it goes without saying that the geo locations with people work and recite have a big impact in shaping consumer and human behavior. These semi permanent and permanent locations often provide much deeper, more meaningful and socially identifiable trades. That indicates Porter Person wants Needs on may be interested in the application of fusion tables, goes beyond digital marketing and as social and economic implications. Let's begin but collating their data that we need to create a visualization of the country with G P I R Global Peace Index rankings and the related scores. 2. Step 1: Collate The Data: hi and welcome to Step one in this step will call later data, which involves aggregating the data that we need and formatting it to make it palatable, will be important to create a global fusion table in the next step. While you're doing this based on the g p. A of the global Peace Index is, know that the concepts and the processes that we will use university happy cable to the prison geographic data after computing the class. Just imagine how you can use Google fusion tables to implement a useful Matt based project taking into account Heikal local, local, city, country or even global data. The data source for the global peace index is Wikipedia. You may learn more about the GPS on this you are now. We need to convert the data into a format that can be read by Google fusion tables. And for that we will be using a specific online tool located in this. You are if you already have your data in CSP format or in a Google spreadsheet, you do not need this step. Now let's delivered the data from Wikipedia into a CSP file so that we can important data in our next step. Now that we have converted our data into a readable format in the form offer CSP file, let's get down to important the data to create a global fusion table. 3. Step 2: Import The Data: hi and welcome to step number two. In the previous step, we converted that data to make it readable in the step you learn how to import the data. Now let me walk you through this process of importing their data. You will need a Google account to use Google Fisher tables. The first thing you need to go to create a Google fusion table is to visit bright dot google dot com and signing with your Google account to start a new Google fusion table, click on the new button and then select fusion people from the list. In case you do not have Google fusion tables, so you have in your account you need to click on, connect more abs and search for Google fusion tables so that you can connect it to your account. After you connect Google Fusion tables into a Google account and take on it, it will bring you to the import people screen, where you can upload your CSB file or data file. To do so, let the juice file button and then navigate to the location on your computer with a fire you store as you can see in addition to CSE, files. Google also accept other file formats to create your fusion table. We will change the character according to auto detect in this case, and then move on once the finalists selected, we need to click on the next button over here. You need to specify the row in which the column names are mentioned, which in our example is Rule number one and then click on the next button to go to the next step. The next stream is the place to specify the meta data off other people here. You can add in a name for the people or accept the deport name extracted from the fighting . You can also allow their data to be exported by others. Add a description and set the information about attribution of their data with the attribution. Page link. Once you have filled out the farm, you need to hit the finish button. Import the CSP data file into your Google vision people. Google automatically attempts to recognize location information. If it does, that data in the identified column will be highlighted in yellow. When the importance finish, use your table view off your data. Any column that is able to be translated into map location will be highlighted in yellow if your data does not have a column highlighted in yellow, that means that the fusion tables were not able to identify a location from the data in order to television table as to which column has your location Gator click on the column that holds the location data. After clicking on the right, you see a drop down list label type, select location from the drop down list and then click Save the column. Data should then be highlighted in yellow, indicating that it's now location column. After you have the data in table view and have your location column highlighted, it is time to map the data. Let's move on and visualize their data now, but transforming this table view into a map to you. 4. Step 3: Map The Data: hi and welcome to step number three Very learn how to map their data. This is where we had left off in Step two, when we had imported the leader. In order to map out the data, we had also designated the location column, which we had done in the biggest step, which is the reason the country column is highlighted in yellow. As you can see here in this team will be, he's know that in cases with their using an address, all of the in commission must be in the same column. You can map location in permission in the form of a country, as we're doing now, or it can be in the form of a city postal court. Or it can also be a full address. Now that the appropriate column has been designated as the location data, it's time to get Google to Geo code the column so it can be mapped out. It requests just one leg to initiate that you, according process. Let's do that now. When we click on the tab that we convert a review into a map, view the status, but we'll show you how many off the records have been geo coded. If you have many rows of data, this process can take several minutes. Once the joke loading has been completed, a map showing all points off all geo coded locations will be ready for view. The next step is to enhance and assigned more context to the data based on the type of data that you have, let's move on and explore our options to announce their data in the next step. 5. Step 4: Enhance The Data: hi and welcome to step number four. You are making good progress on you. Have just two more steps to complete the class after the step in this step will customize the man and enhance their data visualization to make it more presentable on meaningful. In the matter we created in the last step, you can always pan and zoom the map. The default symbol is the small red dark, and you can click on any other darts to see a pop up, showing your data for that specific grow, which is the information for that location. You can change how the data is presented and decide what information to show in the information window, and you also have the option to display their data as point locations are as a heat map. For example, to display the map as a heat map, click on the heat map to open up the options. The point locations are transformed through a heat map with radiance. The red areas show locations where the point of data is more clustered. You can change the radius to increase the influence of each point. Data on also set the level off transparency. You also had the option to customize the symbols or the re presentation off the point data . The deport marker is the small red circle could change the symbols, click on the feature map option and select change future styles under the fixed market eye contact. You can change the color and study for all the markers. If you have quantitative information, you can also organize the markers into buckets. For example, in our global peace map, let's segment the world into five buckets based on the global peace index scores. We noticed that Iceland, which is random number one in 2016 has a score of 1.19 And Syria, which is Randy at 1 63 has a score off 3.80 which means that the scores across all countries range from 1.19 upto 3.80 Now let's did the range from 0 to 4 and create five buckets within this ridge. Let's say we have the following five buckets based on a 20% range. If we take into account the relative scores off all the countries and we change the markers to signify the five buckets in the following manner once we classify their data and assigned unique markers toe each of the buckets. This is how the world man will look like in terms of the GP I other global Peace index. You can also add a legion toe the map you have created so that anyone who have used the map can make sense off your classifications off the data points. If you do add multiple color or symbol options for your data, it is helpful to viewers to have a religion attached to the man who are religion. Click on the change feature styles and then select automatic religion. From this window, you can set the legend title legal position and add a link to the source data. When we were discussing how to enhance their data in the map, you also have the option to customize the information window and change the way that data is presented. When a user clicks on one off the point locations. To do this, select the change in for Bill O option. Under the automatic tab, you can choose which columns you would like to be on display. If you want to change how the in commission is shown, you can also use basic HTML to customize the look and feel off their data in the pop up information window under the custom tab. Now let's move on to Step five, where we will publish the data. 6. Step 5: Publish The Data: hi and welcome to step number five. Now that we have an answer data and made the map more meaningful, let's go ahead and publish the data in this step. Once the map is set up in customized, you can opt to share the map with select people or make it publicly available a publicly available map and then be shared with a link or embedded into our page. By default, the table and map is set to private To change the settings. Click on the share button in the upper right hand corner. The pop up shows you a link. You can email to people that gives them direct access to your Google fusion table. Under who has access, You can change the visibility to yourself only whoever has access to the link or public. Once the privacy settings have been changed, you can now publish the map to publish a map, go to the menu bar and select ones and then select publish. Next, A pop up window will let you select how you want to share the map. You can either send out the link on Use the ember Good to serve the map from a with beach. Now let's take a look as to how we can embed the map 7. Step 6: Embed The Data: I and welcome to step number six. The best part of global fusion tables he started visualizations you create can be embedded on any other properties you control. All you have to do is make your original big public. And then in the map display, he can get embedded the link. This will provide a simple job. You can copy and paste on your own block off site who embed the map. Simply said the wig and the height in pixels you want the map will be in and then paste the provided cold in tow with days. Your masterpiece is now available so that your users can explore and interact with congratulations. You have completed all the steps. Listen to my final starts to give some direction to your creativity and innovation so that you can make maps which would be impactful on useful 8. Final Thoughts & Next Steps: in this class. I showed you how to complete the location data important data sets into Google fusion tables, as well as how to map it unanswered. Publish it on em. Better data on your Web properties. I showed you just one example, but there are many other examples out there, which I look into in future classes on understanding of Google fusion tables, coupled with a number different, creative thinking can go a long way to solve sales, marketing as well as social and economic problems at all levels. Location data can be offer livings to decision makers in business as well as government to make better decisions. Location data were used in combination with formal knowledge, and professional judgment can lead to the creation off effective communication in your personal and professional life. The innovations can percolate down from the global and country level, toe the hyper local neighborhood locations and can have far reaching positive implications . As retailing becomes more competitive, optimizing the location off retail outlets has received increased attention from private sector decision makers. And it goes without saying that identifying retail outlets is fundamentally a geographic problem, which means knowledge of location data can have a positive impact in this decision making process. Location data also allows decision makers to optimize the location of all kinds of consumer oriented facilities both in the public and the private sector's, ranging from retail stores, shopping centers, healthcare facilities, daycares and place schools. Just let your imagination take the driving seat and you can start creating your Google official tables from any data set, which requires usual ization as the principles and the processes will remain the same. This is Jodi Brats signing off, and I hope you apply this knowledge to clear awesome data maps, which will have far reaching implications and at the same time create positive economic and social impact. I can't wait to see your maps come to life.