Skip to main content

Agile BI - Managed Funds Analysis

Have you ever struggled making sense of your managed funds performance? This demo show cases how Agile BI put together a clean visual way to monitor them using Power BI.

連絡合作夥伴 觀看影片

Funds Overview

Our first page provides an overview to the performance of all funds.

We created several metrics for assessing performance. The purple icons at the top show basic stats of the funds, such as ROI, fund size and agency ratings. These dynamically change what is plotted on the chart. The chart also provides a simple trend line that highlights how performance has changed over time.

The blue icon sets show seven key investment asset classes. Selecting one of these plots the allocations onto the dynamic chart to show how investment preferences have changed over time.

The bottom section shows rankings of funds by various metrics. This demonstrates the powerful ability to perform dynamic ranking in Power BI.

Fund Cost Performance

This page looks into the performance of funds under a selected firm. We plot the funds’ average ROI and compare it against their ratings and the total fees they charge on a scatter chart. This provides a simple but powerful way to show the relationship between fees charged and returns achieved. In this sample, we don’t see a strong correlation between the two. In other words, customers who pay a higher fee don’t get a matching increase in return.

Asset Allocations

The next page analyses changing preferences of investments by looking at the variations in asset allocation over time. The column chart can be drilled down from year to month, and vice versa. The radar graph visualises which investment areas are most preferred by the managing firm.

Trend and Target

Lastly, we look at individual metrics over a longer term and compare it against their target. We use traffic light colours to indicate whether they been met or not. Values shown in the box represent performance of the most recent month.

想要成為 Power BI 合作夥伴嗎?

認證合作夥伴可說是團隊的重要一環!挖掘最新商機、建立人脈,並與世界各地的 Power BI 使用者分享公司的人才與經驗。