Calprivate Bank uses Power BI to gain business insights
Location: USA
Industry: Banking
Problems
The customer did not have in-depth business intelligence about its key accounts, such as an understanding that if one customer leaves the bank then how it will impact the other customers (as the bank had a high ratio of referral customers). Other common issues were:
- Missed opportunities to upsell and cross-sell
- Missed opportunities in follow up or closing of potential sales opportunities.
- Restricted view into sales pipeline and forecasts
- Inability to review or iterate your sales process
- Lack of a unified location for customer purchase history, patterns, preferences.
To address these challenges, every department in the company had set up its own framework and methodology to understand and cater to the customer needs.
Solutions
Allied Consultants helped the customer by developing different dashboards in Power BI, including a high-level dashboard for the bank’s CEO and CFO’s consumption. The dashboard gave a 360-degree view of each customer. The dashboard defined the customer relationship, hierarchy charts and tree charts with which the customer was able to study the customers thoroughly. For each customer, the dashboard showed:
- Shared accounts with other customers
- Trustees
- Guaranteed Loan accounts
- Accounts of guarantors ( & balance in their accounts)
With all this, we provided the company a framework with which they could analyze the depth of the bank’s relationship with each customer. The management later decided to name this project as ‘Customer 360 Degree’.
Tech Stack
- Power BI
- SharePoint
- SQL
- SSIS
- SSAS
Get In Touch With Us
we believe in cutting edge solutions and are committed to your success