Title
RBC BD Simplifies Client Review Preparation
RBC BD Simplifies Client Review Preparation | Databricks Skip to main content Login Why Databricks Discover For App Develop…
Each colour maps a published value to the exact source passage used to support it. Only bounded excerpts are public; administrators can inspect the complete captured source.
Title
RBC BD Simplifies Client Review Preparation
RBC BD Simplifies Client Review Preparation | Databricks Skip to main content Login Why Databricks Discover For App Develop…
Company
RBC Brewin Dolphin
…ormation gathering process. Eliminating guesswork to standardize client reviews RBC Brewin Dolphin, a leading wealth management firm, serves a wide range of clients—from individuals and charities to corporations. With rising client expectations…
Description
RBC Brewin Dolphin built a custom Databricks App orchestrating GenAI pipelines with Llama 3.1/3.3 and RAG to automate about 90% of client annual review meeting pack preparation, unifying data across five systems and saving an estimated 4,700 hours annually while cutting administrative costs by roughly 50% in some offices.
…r confidence.” Delivering reviews quicker, more efficiently and at a lower cost By automating approximately 90% of meeting pack preparation, Financial Planners and their support teams can quickly gather the information needed for a client’s annual review. On average, Databricks automation saves 20 minutes per meeting pack, adding up…
…annual client meeting and assembling them was a manual, time-intensive process. Data lived across five disparate systems, including CRM tools, trading platforms, SharePoint, and locally stored advisor documents. There was no consistent format or method for compiling data for this annual cli…
…t teams can quickly gather the information needed for a client’s annual review. On average, Databricks automation saves 20 minutes per meeting pack, adding up to 4,700 hours saved annually across all packs generated. Delivering fast and comprehensive meeting pack outputs in-house is also expecte…
…annual review meeting pack preparation to be automated through GenAI workflows ~50% Estimated reduction in administrative costs in some RBC BD offices 4,700 hours Potentially saved annually due to reduced preparation time RBC BD h…
Problem
Preparing an advisor for the annual client review meeting was a manual, time-intensive process. Data lived across five disparate systems, including CRM tools, trading platforms, SharePoint, and locally stored advisor documents, with no consistent format for compiling data, and this challenge was compounded across 14,000 annual reviews.
…annual client meeting and assembling them was a manual, time-intensive process. Data lived across five disparate systems, including CRM tools, trading platforms, SharePoint, and locally stored advisor documents. There was no consistent format or method for compiling data for this annual cli…
Solution
RBC Brewin Dolphin used Delta Lake to centralize structured and unstructured data with bronze, silver and gold layers, Unity Catalog for row-level security integrated with SSO, a custom Databricks App built with Dash for advisors, and Lakeflow Jobs orchestrating GenAI pipelines running 30 to 40 tailored LLM prompts per session (primarily Llama 3.1/3.3), plus AI Search and retrieval-augmented generation to produce contextual, advisor-ready outputs.
…ts rigorous compliance and privacy requirements in a highly regulated industry. On the application side, RBC Brewin Dolphin built a custom Databricks App using Dash, a Python framework for data apps. The interface lets advisors upload documents, trigger workflows, and more easil…
…Excel, reducing friction and enabling faster adoption among internal advisors. Behind the scenes, Lakeflow Jobs orchestrates a series of GenAI pipelines that automate the most labor-intensive parts of the CAR process. Each session runs 30 to 40 tailored LLM prompts, primarily using Llama 3.1/3.3,…
…enAI pipelines that automate the most labor-intensive parts of the CAR process. Each session runs 30 to 40 tailored LLM prompts, primarily using Llama 3.1/3.3, optimized for document type and content. This allows the system to parse context-rich narratives and generate insights a…
…rratives and generate insights advisors can review before meeting with clients. The team also integrated AI Search and retrieval-augmented generation (RAG) to support more contextual, advisor-ready outputs. As advisors upload documents, temporary vector indexes are created on the fly,…
Business value
By automating approximately 90% of meeting pack preparation, Databricks automation saves 20 minutes per meeting pack, adding up to 4,700 hours saved annually, and is expected to reduce administrative costs by 50% for client reviews across 33 offices.
…r confidence.” Delivering reviews quicker, more efficiently and at a lower cost By automating approximately 90% of meeting pack preparation, Financial Planners and their support teams can quickly gather the information needed for a client’s annual review. On average, Databricks automation saves 20 minutes per meeting pack, adding up…
…t teams can quickly gather the information needed for a client’s annual review. On average, Databricks automation saves 20 minutes per meeting pack, adding up to 4,700 hours saved annually across all packs generated. Delivering fast and comprehensive meeting pack outputs in-house is also expecte…
…eting pack, adding up to 4,700 hours saved annually across all packs generated. Delivering fast and comprehensive meeting pack outputs in-house is also expected to reduce administrative costs by 50% for client reviews across our 33 offices. With a strong data foundation in place, RBC BD is expanding its use of Databric…
Headline outcome
…r confidence.” Delivering reviews quicker, more efficiently and at a lower cost By automating approximately 90% of meeting pack preparation, Financial Planners and their support teams can quickly gather the information needed for a client’s annual review. On average, Databricks automation saves 20 minutes per meeting pack, adding up…
Industry
Financial Services
…better, more human and more impactful for our clients.” Share this post Details Industry : Financial Services Use Case : Artificial Intelligence , Data Science , Data Warehousing , Governan…
Technology
Databricks, Agent Bricks, Databricks SQL, Delta Lake, Lakeflow Jobs, Unity Catalog
…nd Security , Data + AI Platform , Data Sharing and Collaboration Cloud : Azure Product : Agent Bricks , Databricks SQL , Delta Lake , Lakeflow Jobs , Unity Catalog Ready to get started? Try Databricks for free Learn more about our product Talk…
Use case type
Content generation
…systems and advisor notes, while automating the information gathering process. By integrating GenAI for document parsing, insight extraction and dynamic report generation, RBC BD seeks to create office capacity (an estimated savings of 4,700 hours annually) and simplify the information gat…
AI capabilities
Generative AI, Document Intelligence
…systems and advisor notes, while automating the information gathering process. By integrating GenAI for document parsing, insight extraction and dynamic report generation, RBC BD seeks to create office capacity (an estimated savings of 4,700 hours annually) and simplify the information gat…
Deployment model
Cloud
…best suits their needs. To streamline preparation for a client review meeting, RBC BD turned to the Databricks Data + AI Platform to help unify data across CRM, trading systems and advisor notes, while automating the information gathering process. By integrating GenAI for d…
Deployment options
cloud
…best suits their needs. To streamline preparation for a client review meeting, RBC BD turned to the Databricks Data + AI Platform to help unify data across CRM, trading systems and advisor notes, while automating the information gathering process. By integrating GenAI for d…
Region
UK and Ireland
…offices 4,700 hours Potentially saved annually due to reduced preparation time RBC BD helps people across the UK and Ireland plan and shape their financial futures by protecting, growing and managing their money. We believe in the value of ong…