Google Visualization API Essentials
Formats:
save 15%!
save 37%!
Free Shipping!
| Also available on: |
|
- Wrangle all sorts of data into a visual format, without being an expert programmer
- Visualize new or existing spreadsheet data through charts, graphs, and maps
- Full of diagrams, core concept explanations, best practice tips, and links to working book examples
Book Details
Language : EnglishPaperback : 252 pages [ 235mm x 191mm ]
Release Date : April 2013
ISBN : 1849694362
ISBN 13 : 9781849694360
Author(s) : Traci L. Ruthkoski
Topics and Technologies : All Books, Data, Google
Table of Contents
PrefaceChapter 1: Tools and Setup
Chapter 2: Anatomy of a Visualization
Chapter 3: Spreadsheets, Charts, and Fusion Tables
Chapter 4: Basic Charts
Chapter 5: Formatting Charts
Chapter 6: Data Manipulation and Sources
Chapter 7: Dashboards, Controls, and Events
Chapter 8: Advanced Charts
Chapter 9: Publishing Options
Index
- Chapter 1: Tools and Setup
- Knowledge prerequisites
- Skill summary
- System requirements
- Interacting with Google Visualization Tools
- Charts for Google Spreadsheets
- Getting started – creating a new spreadsheet
- Fusion Tables
- Getting started – creating a new Fusion Table
- Scripting code
- Code Playground
- Debugging tools
- Console
- Gadget Editor
- Summary
- Chapter 2: Anatomy of a Visualization
- Common structure
- Apps Script
- Forms
- Framework
- Fusion Tables
- Scripting code
- HTML Framework
- Technique options
- Categories of visualizations
- Static
- Interactive
- Dashboards
- Events
- Time-based charts
- Summary
- Chapter 3: Spreadsheets, Charts, and Fusion Tables
- Spreadsheets
- Creating a chart
- The Chart Editor
- Chart types
- Reopening the Chart Editor
- Chart styles
- Using Apps Script
- Framework
- Scripting console
- Fusion Tables
- Importing or creating data
- Data management
- Editing rows
- Modifying columns
- Adding a formula
- Views
- New look in Fusion Tables
- Merging tables
- Creating a visualization
- Non-map visualizations
- A simple line graph
- Experimental charts
- Mapping features
- Geocoding
- Cell formatting
- Summary
- Chapter 4: Basic Charts
- Programming concepts
- Variables
- Number
- Boolean
- String
- Array
- Equation
- Functions
- Classes (and objects)
- Libraries
- Commenting
- Spacing/format
- Visualization API common Framework
- Load API modules
- Apps Script Wrapper
- A basic visualization
- Code Playground
- Apps Script
- Summary
- Chapter 5: Formatting Charts
- Static
- Spreadsheets
- Fusion Tables
- Chart Editor
- Filters
- API
- Colors and fonts: Inline
- Colors and fonts: Cascading Style Sheets
- Views
- DataTable formatters
- Dynamic or interactive
- Animated transitions
- Dashboards and controls
- Chart Editor for users
- Summary
- Chapter 6: Data Manipulation and Sources
- Preparing data
- Google Refine – importing data
- Google Refine – Facets
- Google Refine – clean and supplement
- Google Refine – export options
- Architecture and data modification
- Protocol
- Visualization API data capabilities
- Group and join
- Spreadsheets
- Forms
- API
- Fusion Tables – API
- Data sources for Charts
- Spreadsheets
- Preparation
- Query
- Fusion Tables
- Preparation
- Query
- Chart Tools Query Language
- Build your own data source
- Summary
- Chapter 7: Dashboards, Controls, and Events
- Architecture
- HTML framework
- API framework
- ControlWrapper
- ChartWrapper
- Dashboards
- Controls
- StringFilter
- NumberRangeFilter
- CategoryFilter
- ChartRangeFilter
- Controls with dependencies
- Programmatic control
- Global variables
- Transition animation
- Programmatic switch
- User interface toggle
- Create button
- Button behavior
- Chart editor for users
- Summary
- Chapter 8: Advanced Charts
- Time-based charts
- Motion chart
- Spreadsheets
- Code
- Annotated timeline
- Spreadsheets
- Code
- Maps
- geochart versus geomap
- The region option
- The marker option
- geochart
- The ISO 3166 standard
- Spreadsheets
- Code
- geomap
- Code
- Map API
- Your own visualization
- Summary
- Chapter 9: Publishing Options
- Sharing
- Private sharing
- Public sharing
- Publishing
- Spreadsheets
- Fusion Tables
- Apps Script
- Publishing basics
- Embedded in a Spreadsheet
- App Engine
- App Engine Launcher and SDK
- Eclipse plugin
- Integrated Development Environments in the Cloud (IDEs)
- More APIs
- A word on security
- Summary
Traci L. Ruthkoski
Code Downloads
Download the code and support files for this book.
Submit Errata
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
- Quickly launch a graph, chart, or map as an application, without the heavy-duty development environment
- Create a variety of interactive graphs from spreadsheet or database data
- Learn the Google API environment through Visualizations, and then apply the same concepts to other Google APIs
- Give users control over data viewing with Interactive Chart Dashboards, or let them style the visualization themselves with Chart Editor
- Discover Google Refine, a data-cleaning tool not just for visualization data
- Use Google Fusion Tables as a Google Map data source
- Embed a visualization in Google Spreadsheets using Apps Script API integration
- Customize visualization colors, fonts, titles, and chart styles
- Visualize your data over time with timeline and animation features
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.
This book is a step-by-step tutorial full of diagrams, core concept explanations, best practice tips, and links to working book examples.
This book will show you how create web-ready data visualizations using Google’s infrastructure. Some HTML knowledge is the only requirement, although some JavaScript knowledge is also helpful.

