Google Fusion Assignment

Hi, my topic is different types of dogs!

Card layout:

 

Screen Shot 2015-11-03 at 3.28.20 PM

Screen Shot 2015-11-03 at 3.28.38 PM

I included 10 different breeds of dogs and my categories were name of animal, location of origin, country of origin, average life span, image, and size. To see this information you can checkout my google spreadsheet, the link is below!

Spreadsheet: https://docs.google.com/spreadsheets/d/1S-CHkqY1X-iTKZ5NzsDy-VD3nAtCK4EmTxnrqjCpvxE/edit?usp=sharing

Map:

Screen Shot 2015-11-02 at 11.13.52 AM

 

This map corresponds to the location of origin of each dog. There are not 10 individual circles because many dogs came from the United Kingdom and Germany, therefore the dots are clustered together to look like only one.

Bar Graph:

Screen Shot 2015-11-02 at 11.26.45 AM

 

This bar graph is comparing the average life span of different types of dogs. Yorkshire terrier’s have the highest mortality rate while Bull dogs have the lowest.

 

Pie Chart:

Screen Shot 2015-11-03 at 7.40.22 PM

In my pie chart I compared the different sizes of the 10 breeds of dogs I chose.

Network Visualizations Graph:

Screen Shot 2015-11-03 at 2.54.01 PM

 

In this graph I decided to use country of origin because many dogs originate in the same location. For example, the United Kingdom is where Bulldogs, Golden Retrievers, American Pitbull Terirer’s, and Yorkshire Terrier’s originated. A network visualization graph allows this information to be clearly communicated seamlessly to the viewer.

 

To check out this information on the google fusion tables website click the link below:

https://www.google.com/fusiontables/DataSource?docid=1Vr1K-5MTAt7W1Jim-lCHobopXXlYcehI4rH7y8eW

Google Fusion Tables Assignment

For my Google Fusion Tables assignment, I decided to use the software to help compare supercars across the world by country. There are a variety of vehicles in the automotive industry, and surprisingly each country builds there cars very differently.

Data Spreadsheet


 

Data Cards

FusionCard1 FusionCard2 FusionCard3

These are the data cards of the supercars I compared for this assignment. The data can also be observed in the spreadsheet link above.


Base Price by Country

 

Fusion1

The first comparison I made with my data was comparing the average base price of the supercars (in USD) by country using the vertical bar chart feature. This helps us draw the conclusion that American supercars appear to be the most affordable, while Italian supercars are more expensive.


 

Horsepower vs. Torque by Country

Fusion2

The second comparison I made was comparing the ratio of average Horsepower vs. Average Torque by country. Most people tend to only consider horsepower when talking about a vehicle’s power, but torque is also very important in acceleration and power, thus the closer the ratio is in comparison to the horsepower, the better. As we can see by the chart (with average horsepower in blue and torque in red) American cars tend to have the closest ratio of horsepower to torque than any other country.


0-60 Acceleration Performance by Country

Fusion3

While American supercars might look best on paper, the performance numbers are really what is important to determine which vehicle is superior. In this case, using the line chart feature, we can see that although American cars were less than half the price of other cars and had better horsepower to toque ratios, they were not the best performers in 0-60 acceleration due to other variables.


Pie Chart                                                                                      Network Visualization

Fusion6

Fusion7

 

 

 

 

 

I didn’t find the pie chart or the network visualization tools very helpful for the sake of this project and the particular data I chose. I used the pie chart to display base vehicle prices by country, and network visualization for weight by country.


 

Map

Fusion5

Lastly, the map above shows the locations of the automotive manufacturers mentioned previously.


Overall, I found this project to be very interesting, and my favorite thus far in this class. I love learning about the many intuitive tools Google has to offer, and implementing them using data I found.

The link to my final table can be found here.