Book Image

Google Visualization API Essentials

By : Traci Lynn Ruthkoski
Book Image

Google Visualization API Essentials

By: Traci Lynn Ruthkoski

Overview of this book

There's a lot of data in our world, and visual representations are often the best method of making sense of it all. Yet, it should not take an army of programmers and analysts to create visualizations in order to make data useful. The Google Visualization API is accessible to novice and advanced programmers alike, making data useful to more people."Google Visualization API Essentials" will show you how to create interactive data displays with very little code. The API, combined with Google Spreadsheets and Fusion Tables, is a complete system, from data management to analytical displays. Not only is it simple to learn, but the Google Visualization API can also be viewed as a first step to learning additional Google APIs."Google Visualization API Essentials" uses both methodology overviews and hands-on examples with real data to introduce chart and graph creation on the Google platform. Topics are presented from various aspects, including Google Spreadsheets and Fusion Tables, and Graphic User Interfaces. An overview of the various API development environments available to developers is also covered. Basic and advanced charts, data source connectivity, style formatting, and publishing options are also explored in depth."Google Visualization API Essentials" brings the arsenal of Google Visualizations into the web developer toolkit.
Table of Contents (16 chapters)

Chapter 6. Data Manipulation and Sources

Until now, data rendered in this book's examples have been defined within the code itself. Given this is a fairly limited method of storing data it naturally follows that a connection to external data sources must be developed. This chapter is dedicated to the topic of data accessibility for use in the Visualization API, including the following topics:

  • Preparing/cleaning data

  • Manipulating data with the Visualization API

  • Configuring the following to be consumed as a data source:

    • Spreadsheets

    • Fusion Tables

  • Manipulating data with their native APIs

  • Apps Script equivalent functionality

  • Creating your own data source

Data management is a topic that ranges well beyond the pages of this book, and the survey of methods presented in this chapter give only a handful of technical methods for working with data. This chapter is also not an exhaustive description of all Google data capabilities. For example, during the writing of this book, the Google Big Query (no SQL) and...