Google Visualization API Essentials

Google Visualization API Essentials
eBook: $26.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $71.98    Print cover: $44.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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 : English
Paperback : 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, Web Development

Table of Contents

Chapter 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
  • 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

                    Traci L. Ruthkoski is from an eclectic background in computation, statistics, media technology, and business. Traci is always looking for the latest challenges in technology. Having worked as an IT professional in both clinical and medical research settings, she has built High Performance Computing clusters from hardware to software application. More recently, Traci has been enabling academic research advancement through computing and cyber infrastructure in the cloud domain. She continues to work at the University of Michigan, now holding several roles supporting the overall advancement of Research Cyber Infrastructure and Information Technology at the University. Traci has published academic work in the IEEE CloudCom 2010 proceedings as well as maintaining a blog/tutorial repository for cloud computing tools and trends.
                    Sorry, we don't have any reviews for this title yet.

                    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.


                    - 4 submitted: last submission 26 Jun 2013

                    The code line below the thord paragraph on page number 188 is as follows:

                    new date(year, day, month)

                    This should be as follows:

                    new date(year, month, day)

                    Errata Type: Typo Page No: 74

                    In the last paragraph,
                    depreciated should be deprecated

                    Errata Type: Typo Page No: 139

                    In the bullet list present,
                    Parsing Expectations should be Parsing Exceptions

                    Errata type: Graphics Page No: 86

                    There was a typo in the Image placed here. The Corrected image is as follows:


                    Sample chapters

                    You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                    Frequently bought together

                    Google Visualization API Essentials +    Oracle E-Business Suite Financials R12: A Functionality Guide =
                    50% Off
                    the second eBook
                    Price for both: $49.20

                    Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                    What you will learn from this book

                    • 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

                    In Detail

                    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.

                    Who this book is for

                    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.

                    Code Download and Errata
                    Packt Anytime, Anywhere
                    Register Books
                    Print Upgrades
                    eBook Downloads
                    Video Support
                    Contact Us
                    Awards Voting Nominations Previous Winners
                    Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                    Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software