Data Push Destination Example Creating Custom SLA/XLA Reports using BigQuery + Mode with UXI Data

Mode Analytics is a great tool for creating custom reports, building custom dashboards, and sharing insights across your organization. Using Mode, it’s easy to integrate with Google BigQuery. Google BigQuery is a data warehouse service that enables you to store vast amounts of data and query it with SQL. When you configure your UXI dashboard to send test result data and issue data to your Google BigQuery data warehouse, you can use tools like Mode Analytics to visualize the data and create custom reports for your team.

You can integrate Google Bigquery with Mode by referring to this: https://mode.com/big-query/

Once the BigQuery instance is connected with Mode, you can write, run and save complex SQL queries.

Example code to get Zoom meetings test results:

SELECT
DATETIME(TIMESTAMP_SECONDS(CAST(timestamp AS INT64))) datetime, service_name,
network_name,
sensor_name,
latency_milliseconds,
latency_min_milliseconds,
latency_max_milliseconds,
jitter_milliseconds,
mean_opinion_score
FROM `data-warehouse-246508.uxi_integrations.test_results_bigquery_7ae10733_a344_4f6c_8bc7_447ce3d76388_VOIP_MOS`
WHERE DATE(_PARTITIONTIME) >= DATE_SUB(CURRENT_DATE(), INTERVAL 14 DAY)
AND service_name = 'Zoom Meetings'

You can build reports and dashboards with the help of layer visualization on top of SQL with built-in charting tools. You can also export the data in CSV or pdf format.

You can curate these charts and tables into on-brand dashboards and share them easily with any of your team members in the company.

You can also parametrize your reports to be able to specify, for example, the time ranges you are interested in, or specific services or networks.

Once you build the table, you can make use of visual explorer to build the visualizations like the following reports.

Example Reports:

Using Test results data

You can build SLA/XLA reports for MS teams or the Zoom apps by collecting test results data coming from the UXI dashboard.

Using Issue data

With the help of issues data coming from the UXI dashboard, you can build ad-hoc summary reports and project them to your NOC team.