Skip to content
ZYNXTECH

Wealth Management 360

One Power BI report for assets, clients, advisers and regions.

A six-page report for a wealth management business. It covers assets under management, the client book, relationship manager performance and geography, with a pivot page the reader builds from slicers and a page for questions in plain language.

Executive SummaryClient AnalyticsRM PerformanceGeographyDynamic DataAI
AUM ₹ Cr
P&L ₹ Cr
FYTD %
Alpha bps
report pages
6report pages
KPI cards, each paired with its year-on-year change
20KPI cards, each paired with its year-on-year change
slicers on every analysis page
9slicers on every analysis page
AUM and P&L shown in crores
₹ CrAUM and P&L shown in crores

Pages

Page What it answers
Executive Summary How big is the book and how is it doing? AUM, P&L, portfolio return for the financial year to date, alpha against the Nifty 50 in basis points and active relationship managers, each with its change year on year. AUM and unrealized P&L by month, the asset-class mix, AUM by region and by client segment, and ranked tables of advisers and clients.
Client Analytics Who are the clients? Active and new clients, average ticket size, how much of the book sits with the top ten, KYC-pending clients, client type and age, segment against risk profile, vintage cohorts, AUM bands and the share of AUM linked to goals.
RM Performance Which relationship managers are carrying the book? Average AUM and clients per RM, target achievement and how many are above target, experience against AUM by designation, and a drill-down from team lead to RM to client.
Geography Where is the money? Active branches, metro against non-metro AUM, the best region by AUM and by return, AUM by zone over time, and a drill-down from state group to state, region and branch.
Dynamic Data A pivot the reader builds: field parameters let you choose the rows, columns and values from slicers instead of asking for a new table.
AI A Q&A visual for asking questions of the model in plain language.

Measures worth noting

Besides the headline figures, the model carries measures that a wealth business actually reviews: management fee revenue for the year to date, unrealized P&L, advisory share of AUM, average ticket size, new clients this financial year, KYC-pending clients, and alpha in basis points as well as percent.

Model

A holdings-level fact table with client, adviser, branch, product and market attributes, a portfolio-against-market comparison table and a date dimension. Every analysis page shares the same nine slicers, so a filter set on one page means the same thing on the next.

Opening it

The repository holds Wealth Management 360.pbix (about 55 MB). Open it in Power BI Desktop. It is also the kind of report pbidriver was built to drive: an agent can capture every page, read the cards and run DAX against the model without anyone publishing it first.