Data Push Destination Example Creating Custom Reports using BigQuery + PowerBI with UXI Data

PowerBI is a powerful tool for visualizing data, creating reports and sharing the reports with your colleagues. PowerBI can connect to a variety of data sources, including 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 PowerBI to visualize the data and create custom reports for your team.

Using PowerBI Desktop, you can reference the official Microsoft documentation for connecting to Google BigQuery. You may consider creating a Google Service Account specifically for PowerBI. It's also useful to verify your queries first in BIgQuery and adding them under "Advanced Options when you get data from BigQuery.

You may consider using Direct Query instead of making a copy of the data so your report has the latest information.

Once the data is present in PowerBI Desktop, you can create the charts to visualize the data based on the query. When finished in PowerBI Desktop, you can Publish the report to share it with your team.

Example Reports:

A report that looks at Issue data might be useful for your team as they would be able to see which issues are ongoing, and in the report they can order them oldest to newest to prioritize the ones that have been ongoing the longest.

Another example - your team may be interested to know for a given application, which groups and networks have the highest average HTTP GET time. This can help you identify which sites and networks have the worst performance.