AMI Center 3: Data Aggregation and Visualization

This third tutorial in the series will we explore static and realtime visualizations and aggregations. We will start by using the UNION operator to combine the data from tables with the same schema and UNION BYNAME for tables with differing schemas . We will then aggregate the data using the GROUP BY clause and aggregate functions, resulting in a static visualization of aggregated data from two tables. The data flow from AMI DB to a static visualization in AMI Web via a datamodel will be introduced, as well as how to chain multiple datamodels and visualizations together. We will demonstrate that while a datamodel CAN subscribe to a realtime feed, unless well considered, this is unlikely to be the right mechanism for keeping visualizations in sync with the underlying data. Finally a realtime aggregate table will be created to demonstrate how realtime visualizations work with realtime feeds.