SAS Visual Analytics

Client

Our Client is a data analytics company based in India providing customer value management solutions. The organization specializes in telecom data analytics and serves many telecom service providers worldwide.

Objective

The analytics framework should be able to handle huge data volumes and should also be customizable for different telecom providers. Every telecom provider uses their own data mart and even within a given telecom company, the CDR data format could vary from tower to tower. The data also need to be analyzed almost in real time, so as to identify trends that need to be arrested or promoted. Thus, the analytics framework should be capable of supporting heavy volumes, unstructured data and also work super-fast.

Challenges

Solution

Congruent developed the following solutions to address the customer needs:
• Data extraction tools
• To extract the call detail records (CDRs) in both ASCII and binary formats
• To extract customer information from telecom company’s data mart

• Advanced Analytics tools to identify revenue distribution patterns and trends

• High-performance data visualization tools to create meaningful visuals of the results
A sample list of analytics developed includes:
• Revenue Bell Curves
• COHORT Deep Dives
• User Vs Revenue variance and
• Revenue Influencer tree

Benefits

Leveraging the analytics framework, the customer was able to
• Significantly reduce the lead time by 80% for analysis and identification of insights – it was
brought down from 30 days to one week
• Identify the top 10% of subscribers who contribute to 50% of revenue and defend that
revenue

Technology Used

SAS VA, Oracle Scripts

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.

Other Smartsheet success stories:

Empowering Project Delivery: Revolutionizing IT PMO Operations

In a strategic move to elevate project delivery efficiency, a large IT PMO organization partnered with vSaaS. Faced with sluggish project timelines and inflated costs, the challenge was to harness technology for streamlined operations. vSaaS implemented Smartsheet, integrating it with JIRA and ServiceNow via API connectors. This fusion not only synchronized project management tasks but also enhanced real-time data exchange, achieving unparalleled workflow efficiency.

Key Outcomes:

Accelerated Project Delivery: Slashed project timelines by 25%, ensuring timely market entry.
Cost Reduction: Achieved a 20% reduction in project overheads, optimizing budget allocation.
Enhanced Collaboration: Seamless integration fostered a collaborative environment, boosting team productivity and morale.