Why we use charts
We use graphics and charts because they help make any data
- More effective
- Easy to understand
- Easy to analyze and compare
They also help one to present data in a logical and a consistent way.
E.g. consider the example of Commission earned by individuals.
- The Bar Chart below shows total commission earned by each individual. The commission amount shown here is grouped by individual
- The same data can be shown in a pie chart like below. Each pie represents the % of commission earned by an individual.
- Pie chart also provides legend for each pie as shown in the right hand section of the figure below and a tool tip representing textual data.
- Google Tables/ Grids provides customizable and interactive grid which has features like:
- Columns Sorting
- Selecting rows and formatting data (currency, hyperlinks, etc.)
The figure below shows details of all commissions earned by an individual. Data is not aggregated on Individual basis.
Combining charts/ grids to show advanced data visualization:
- We can combine the Pie chart/ bar chart with grid to show drill down in data.
- In the below example, we have an event where a user on clicking any pie will see the details of the selected pie (a user in this case) in the grid.
- So on clicking a user say Maria Campbell on Pie chart, the grid will show details of all the commissions earned by her along with other details like Commission Paid Status (Yes/ No), Commission amount and Commission paid date, etc.
Google Charts Working Flow:
- Client wants to visualize data in Charts/ Grids. Sends request to the application server.
- Application server fetches data from CRM or any other Data source.
- Application server processes the data.
- Convert Data to JSON format.
- Specify options for chart. These includes paging/ sorting/ custom formatting for Grids. Also for charts, options like x-axis details, y-axis details, legends, etc. can be specified.
- Call Google Visualization API (JS) which will accept the data and options as specified in Step 3.
- Google API now creates Charts/ Grids based on options and renders on the browser.
Why use Google Visualization API for Grids and Charts:
- Very simple steps to configure Grids and Charts.
- Wide variety of options are available for Charts: Bar charts, Area Charts, Pie charts, Tree maps, Donuts, Column charts, etc.
See the full list in details: https://developers.google.com/chart/interactive/docs/gallery
- Google API are cross-browser compatible, with support for all major browsers as Charts use SVG for drawing.
- Detailed documentation and examples are available
- Biggest reason: It is free for use. Refer Terms : https://developers.google.com/terms/