Skip to main content

Explore your Troux data in Power BI

Headshot of article author Theresa Palmer

Troux enables businesses to manage technology investments and ensure the greatest impact while minimizing risk. The Power BI content pack allows you to visualize your applications, technologies and capabilities of your current system as well as analysis over time.

This post will provide an overview on how the Power BI content pack helps users analyze and monitor Troux data. For additional details on how to get started, please see the Troux content pack for Power BI help page.

Start loading the content pack by specifying your Troux OData endpoint and signing into your account in Power BI. Once the content pack is loaded, you’ll see a new dashboard, report and dataset in your workspace. Clicking on the tiles will drill into the reports built on top of the data set, for example selecting “Applications” will bring you to the Application Overview report.

Navigate between any of the seven report pages using the named tabs at the bottom. Selecting any of the values will cross filter the other visualizations and hovering over a value will show you more details. The filter pane on the right can be opened to show or change any filters for that report.

Selecting “Edit Report” will list all of the tables and fields that are included in the dataset. This mode allows you to add filters, create or modify visualizations and add new report pages. Selecting a visual will highlight the tables and the fields in the Fields list corresponding to that visual to make it easy to update or change the visual.You can also try asking a question about your data, such as “applications by recommendation” or “applications by recommendation by capability name as stacked bar”. The questions can be easily updated and added to your dashboard using the pin icon.

Any of the visualizations can be pinned back to the dashboard to further customize it. When you pin a visual you’re prompted to choose which dashboard to pin to, allowing you to build up a dashboard with tiles from multiple different reports.

After you initially import the data, the dashboard, reports and data set will continue to update daily. Select “Schedule Refresh” on the data set to customize and control the refresh schedule. The Troux content pack for Power BI helps you visualize and explore a set of metrics and reports that can be customized for your scenario.

We’re always interested in hearing your feedback; please contact us at http://support.powerbi.com to let the team know how your experience was and if there’s anything we can do better. We look forward to your feedback!