Wealth firms hold rich client data across custodians, portfolio systems and Salesforce; Tableau helps leaders and advisors see where relationships and revenue are heading.
Tableau helps registered investment advisers, broker-dealers, trust departments and multi-family offices analyze client relationships and business performance together. Firm leaders track assets under management, net flows and fee revenue by advisor, team and service model. Advisors review their own books, spotting households due for reviews, clients with concentrated positions or idle cash, and relationships with no recent contact. Compliance and supervision teams monitor activity patterns that need follow-up. Because wealth data is spread across custodial feeds, portfolio accounting, planning tools and Financial Services Cloud, Tableau's value comes from combining those sources into governed views that everyone trusts.
Wealth management analysis centers on the household, not the individual account. A single family may hold trusts, retirement accounts and joint brokerage accounts at several custodians, served by more than one advisor, and revenue depends on fee schedules applied to those balances. Growth comes from retaining assets and deepening relationships rather than closing many new deals. Tableau adapts through household-level data sources that roll up accounts correctly, calculations that separate market movement from client flows, and row-level security that respects advisor books and team splits. Views embedded in Financial Services Cloud let advisors act on insights from the client record, while leadership workbooks aggregate across offices without exposing individual client details unnecessarily.
Each advisor sees households ranked by assets, revenue and service tier, with last meeting date, open service requests and plan status. Filters surface households overdue for a review, clients whose allocation drifted from target, and relationships holding sizable cash. Advisors plan outreach from the list, and managers use the same view in coaching conversations without asking anyone for separate spreadsheets.
Leaders separate asset changes into market movement, new money and withdrawals, then drill into outflows by advisor, household segment and reason code. Early signs of attrition, such as transfers out, declining balances or a surviving spouse with no relationship to the advisor, appear before the household leaves entirely, giving teams time to respond with a plan. Retention conversations start from facts.
Fee revenue depends on schedules, discounts and billing exceptions negotiated over the years. Tableau compares effective fee rates across households of similar size and service level, highlighting exceptions that no longer have a clear reason. Finance and practice leaders review those outliers together and decide which to keep, which to retire at the next billing review, and which need documentation for compliance.
Supervision teams combine trade activity, account types, client age and risk profile to highlight patterns worth review, such as frequent trading in retirement accounts or concentrated positions held by older clients. Tableau does not decide suitability; it helps reviewers prioritize, document which items they examined, and show supervisors how exceptions were handled across branches and advisors over time. Findings route back to Salesforce as tasks.
Start by defining the household hierarchy: which accounts roll up to which household, how joint and trust accounts are attributed, and how team-managed relationships split credit. Financial Services Cloud usually owns relationships; the custodian and portfolio accounting systems own balances, positions and billing. Build a governed daily snapshot table of account values, so trend and flow calculations use consistent as-of dates. Decide how to classify flows, since custodians code transfers and journals differently. Finally, map advisor codes from each custodian to Salesforce users, because inconsistent rep codes are the most common reason books fail to reconcile.
Account balances, positions and transactions supply the snapshot tables behind flow, allocation and cash views, reconciled to household records held in Salesforce.
Performance, billing calculations and model assignments feed revenue and drift analysis, using the firm's official calculations rather than figures recomputed in Tableau.
Plan completion, goal status and projected funding levels appear beside assets and activity, helping advisors identify households whose plans need attention.
Client financial data falls under GLBA privacy and safeguards expectations. Aggregate leadership dashboards where individual clients are not needed, apply row-level security for advisor views, and control downloads and subscriptions so client lists do not leave the firm as spreadsheets attached to emails.
Performance shown to clients is subject to SEC marketing rules and firm policies. Use Tableau for internal analysis, and produce client-facing performance from approved portfolio reporting. If dashboards are ever shared externally, involve compliance in reviewing calculations, disclosures and presentation before release.
Ask an advisor, an operations lead and a controller how many households the firm serves, and expect different answers. Settle definitions for households, assets, revenue and active clients before building, and publish them in the data source descriptions. Otherwise leaders will argue about numbers in every meeting instead of acting on them.
Client names are anonymized.
Yes. Tableau views can be embedded in Financial Services Cloud pages, so an advisor sees a household's asset trends, allocation and revenue while reviewing the client record. The embedded view respects the same row-level rules as the full Tableau site. Keep embedded dashboards focused, since advisors will ignore anything that slows the page down or needs explaining.
Custodial data usually lands in overnight batches, so wealth dashboards typically refresh once the reconciliation process finishes each morning. Show the as-of date prominently on every view. Intraday market values are rarely needed for business analysis, and trying to supply them adds cost and confusion without improving decisions about clients or practice management in any meaningful way.
It can be, once the firm has enough clients and systems that spreadsheets become unreliable. Smaller firms often start with dashboards built on Financial Services Cloud data plus a custodial feed, covering books, flows and review cadence. If the firm's questions fit within standard Salesforce reports, those may be sufficient for now, and we will say so.
Yes. During an acquisition, Tableau helps compare the acquired book with the firm's service tiers, pricing and investment models, and it tracks asset retention after the transition. Those views depend on mapping the acquired practice's accounts and rep codes accurately, so the integration work comes first and the dashboards follow once data is reconciled and reviewed.
One onshore team with 150 Salesforce certifications, a Salesforce Consulting Partner since 2017.
A monthly brief for the people who own Salesforce, AI and revenue technology
What changed in Salesforce and AI this month, and what to do about it.
One email a month. Written by the consultants who deliver the work, not by a marketing team, for the leaders who make the technology decisions.
Consultant analysis, not vendor recaps. One click to leave.