Google: Fusion Tables

Fusion tables are part of Google Apps available on Google Drive.

It allows you to work with a flat database file.

The data can be imported from a Google Spreadsheet, a CSV file or imported from publicly available data.

The data in a fusion table can be visualized using pie charts, bar charts, line plots, scatter plots, timelines and  geographic maps 

Using Public Data

To create a fusion table, you can search for publicly available data and import the data into a Fusion Table.

Personal Note:

My experience shows that importing the table from a Google Sheet or csv file works better than importing the data directly into the fusion table 

Exercise #1

We are going to work the List of the 100 largest municipalities in Canada by population. It is a list that is available on Wikipedia

The Wikipedia site allow the data to be resorted by any field (column), however the data can not be summarized. By importing the table into a fusion table, the data can be summary and displayed visually to extract more information from the data.

Add Summaries to determine each of the following: