The challenge was to use one basic SQL query and demonstrate different ways to visualize that query using SquaredUp’s native visualizations.
When working with a customer, the SQL visualization requirement kept changing because the target audience kept changing. In order to demonstrate how flexible SquaredUp is, we needed to build a dashboard that displayed storage information using each of SquaredUp’s native visualizations.
Each tile contains the same “base” SQL query, though for some SQL visualizations, a subsequent query is needed to reformat the data for the visualization.
Please note, even though the SCOM Data Warehouse was the target database, it is not required. Any relevant data from a SQL database can be visualized.
Each tile on the dashboard is a different SquaredUp visualization. Here is how it breaks down:
Tile 1 (Donut) – Case statement for the Donut tile to group and summarize on.
Tile 2 (Bar), 3 (Grid), 4 (Status Block), 5 (Status Icons) – A simple select statement to limit results.
Tile 6 (Sparklines), and 7 (Graph) – A second query to retrieve performance data.
3 users. Unlimited dashboards. Free forever.