You are previewing Google Visualization API Essentials.
O'Reilly logo
Google Visualization API Essentials

Book Description

Make sense of your data: make it visual with the Google Visualization API

  • 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

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

    Table of Contents

    1. Google Visualization API Essentials
      1. Table of Contents
      2. Google Visualization API Essentials
      3. Credits
      4. About the Author
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      8. 1. Tools and Setup
        1. Knowledge prerequisites
          1. Skill summary
          2. System requirements
        2. Interacting with Google Visualization Tools
          1. Charts for Google Spreadsheets
            1. Getting started – creating a new spreadsheet
          2. Fusion Tables
            1. Getting started – creating a new Fusion Table
          3. Scripting code
          4. Code Playground
            1. Debugging tools
            2. Console
            3. Gadget Editor
        3. Summary
      9. 2. Anatomy of a Visualization
        1. Common structure
          1. Apps Script
          2. Forms
          3. Framework
          4. Fusion Tables
          5. Scripting code
            1. HTML Framework
            2. Technique options
              1. Comparison: chart.draw() versus ChartWrapper versus Draw.Chart()
        2. Categories of visualizations
          1. Static
          2. Interactive
            1. Dashboards
              1. Filter by string
              2. Filter by number range
              3. Filter by chart range
              4. Programmatic filtering
              5. Filter by category
              6. Filter by dependencies
            2. Events
              1. Selection and sort
              2. Ready for interaction
              3. Error handling
            3. Time-based charts
              1. Annotated timeline charts
              2. Motion charts
        3. Summary
      10. 3. Spreadsheets, Charts, and Fusion Tables
        1. Spreadsheets
          1. Creating a chart
          2. The Chart Editor
            1. Chart types
            2. Reopening the Chart Editor
            3. Chart styles
          3. Using Apps Script
            1. Framework
            2. Scripting console
              1. Testing functions
              2. Debugging scripts
              3. Event triggers
              4. Publishing as an App
        2. Fusion Tables
          1. Importing or creating data
          2. Data management
            1. Editing rows
            2. Modifying columns
            3. Adding a formula
            4. Views
            5. New look in Fusion Tables
            6. Merging tables
            7. Creating a visualization
          3. Non-map visualizations
            1. A simple line graph
            2. Experimental charts
          4. Mapping features
            1. Geocoding
              1. Manual method
              2. Address method
              3. Third-party tools method
              4. Recognizing errors
            2. Cell formatting
              1. Markers, lines, and area
              2. Info windows
        3. Summary
      11. 4. Basic Charts
        1. Programming concepts
          1. Variables
            1. Number
            2. Boolean
            3. String
            4. Array
            5. Equation
              1. API call and attributes
              2. Conditional logic
          2. Functions
          3. Classes (and objects)
          4. Libraries
            1. Commenting
            2. Spacing/format
        2. Visualization API common Framework
          1. Load API modules
          2. Apps Script Wrapper
        3. A basic visualization
          1. Code Playground
          2. Apps Script
        4. Summary
      12. 5. Formatting Charts
        1. Static
          1. Spreadsheets
          2. Fusion Tables
            1. Chart Editor
            2. Filters
          3. API
            1. Colors and fonts: Inline
            2. Colors and fonts: Cascading Style Sheets
            3. Views
              1. Using DataView
              2. Axes options
            4. DataTable formatters
              1. Arrow
              2. Bar
              3. Color
              4. Date
              5. Number
              6. Pattern
              7. Paging
        2. Dynamic or interactive
          1. Animated transitions
          2. Dashboards and controls
          3. Chart Editor for users
        3. Summary
      13. 6. Data Manipulation and Sources
        1. Preparing data
          1. Google Refine – importing data
          2. Google Refine – Facets
          3. Google Refine – clean and supplement
          4. Google Refine – export options
        2. Architecture and data modification
          1. Protocol
          2. Visualization API data capabilities
            1. Group and join
          3. Spreadsheets
            1. Forms
            2. API
          4. Fusion Tables – API
        3. Data sources for Charts
          1. Spreadsheets
            1. Preparation
              1. Permissions
              2. Get the URL path
            2. Query
              1. Apps Script method
          2. Fusion Tables
            1. Preparation
              1. Permissions
              2. Get the URL path
            2. Query
              1. API Explorer
          3. Chart Tools Query Language
          4. Build your own data source
        4. Summary
      14. 7. Dashboards, Controls, and Events
        1. Architecture
          1. HTML framework
          2. API framework
            1. ControlWrapper
            2. ChartWrapper
              1. Load
              2. Data source
              3. Draw
              4. Events
                1. Error
                2. Ready
                3. Select
        2. Dashboards
          1. Controls
            1. StringFilter
              1. Predictability of a control
            2. NumberRangeFilter
            3. CategoryFilter
            4. ChartRangeFilter
          2. Controls with dependencies
          3. Programmatic control
            1. Global variables
        3. Transition animation
          1. Programmatic switch
          2. User interface toggle
            1. Create button
            2. Button behavior
        4. Chart editor for users
        5. Summary
      15. 8. Advanced Charts
        1. Time-based charts
          1. Motion chart
            1. Spreadsheets
            2. Code
          2. Annotated timeline
            1. Spreadsheets
              1. Event flags and descriptions
            2. Code
        2. Maps
          1. geochart versus geomap
            1. The region option
            2. The marker option
          2. geochart
            1. The ISO 3166 standard
            2. Spreadsheets
            3. Code
          3. geomap
            1. Code
          4. Map API
        3. Your own visualization
        4. Summary
      16. 9. Publishing Options
        1. Sharing
          1. Private sharing
          2. Public sharing
        2. Publishing
          1. Spreadsheets
          2. Fusion Tables
          3. Apps Script
            1. Publishing basics
            2. Embedded in a Spreadsheet
          4. App Engine
            1. App Engine Launcher and SDK
            2. Eclipse plugin
            3. Integrated Development Environments in the Cloud (IDEs)
            4. More APIs
        3. A word on security
        4. Summary
      17. Index