Date: Tuesday, 2019-SEP-17 11:15 AM
Location: Moscone West – Room 3020A
Room Setup: OPEN AIR – AUDIENCE HEADSETS
Session: CON2173
Abstract:
DBAs usually collect a lot of data and present it in a tabular format, but management and users like and understand visual representation of data better. The tabular format does not make the impact or get the attention you desire. Attend this session to see how easily you can convert those tabular formats to pictures using the free and open-source Google Charts. Google Charts is a pure JavaScript-based charting library to enhance web applications by adding interactive charting capability. This session includes two demos and is geared for DBAs, architects, and sysadmins who present data to end-users or management.
Though my abstract sounds this as a DBA specific session, it is not. Developers and end-users (even managers) who use SQL to get data from a database for reporting purposes will benefit from this session on using Google Charts. I first got a taste of Google Charts from EBD360 (Carlos Sierra) and SQLD360 (Mauro Pagano) tools. [Note: If you are DBA and not familiar with these tools, you must download the latest SQLDB360, which includes both tools]. The reports from these tools use Google charts extensively. Thought it would be hard to learn, and never tried until I saw a presentation by Kapil Goyal on Database Capacity planning. He used Google charts extensively. A short chat with him revealed that it is not hard to learn Google Charts if you can generate a dataset from the database to draw charts. He also graciously shared the db_capacity.sql script with me (thank you, Kapil).
So here we are, my session is about drawing pie charts, line charts, bar charts, etc using Google charts. The SQL templates I provide can be used to generate your own HTML reports. The ZIP file you download from OOW Session Catalog will include the session slides as well as the template files. See you on Sep 17th @ 11:15 AM #OOW19
