Risk Management Dashboards

Risk Analytics Dashboards in Tableau and Salesforce

Client

Our Client is a leading provider of customized, integrated, and managed communications solutions for enterprise customers. Combining their comprehensive offerings and project management capabilities, the client offers a portfolio of customercentric solutions that boost enterprise productivity, reduce costs, and simplify operations.

Objective

The client’s aim was to build dashboards that would enable them to identify high-risk customers and track their engagement activities.

Challenges

Though the client wished to spot customers at risk, the challenge was with respect to that identification. The underlying data that is required to flag a customer as ‘At risk’, was buried in the meeting notes of account managers. After critical meetings with customers, the engagement managers update the meeting notes on Salesforce, and it was not possible to decipher account risks from this text data.

Solution

Congruent designed a solution using Salesforce and Tableau to resolve this problem. We developed intuitive & responsive user interfaces as part of Salesforce that enabled engagement managers to easily log and track meeting updates. Risk categories and risk reasons were codified and were made as mandatory inputs during meeting updates. Depending on the risk category, managers were also required to fill a questionnaire that provided further relevant details.
Based on these inputs, the application automatically generated meeting minutes and sent it to customers, which reduced the workload of engagement managers and also increased application usage.

Leveraging the data now available in Salesforce, Congruent developed rich dashboards in Tableau, to help the management team easily locate & track customers at risk. Some highlights of the solution design are:
• Technology was leveraged to capture data in analyzable format and drill down dashboards were developed
• The tableau dashboards were made accessible within Salesforce, which was highly useful for the managers.
• The solution was compatible across all devices including mobiles and tablets, which helped in real time data capture, either during or immediately after the meeting.

Benefits

Technology Used

 Visualforce
 Lightning Design System
 Lightning Process Builder
 Flow Component for email notifications
 CSS
 Bootstrap
 JavaScript
 Apex
 Salesforce Object Query Language (SOQL)
 Tableau Desktop
 Tableau Server

Enhancing Patient Safety: Transforming Adverse Event Reporting with Innovative Solutions

As a global pharmaceutical leader, the imperative is to ensure patient safety through meticulous adverse event reporting — a regulatory requirement to monitor products’ safety post-market. Historically, manual processes hampered the client’s ability to rapidly and accurately report adverse events, leading to inefficiencies and data inaccuracies.

vSaaS Global partnered with the client team to integrate Smartsheet and AI technologies to transform their reporting system, yielding:

Streamlined Processes: Achieved a 40% reduction in report processing time.
Improved Data Accuracy: Enhanced validation reduced errors by 30%.
Increased Operational Efficiency: Enabled real-time global collaboration, significantly improving response strategies and patient safety measures.