...
close
Whitepaper Whitepaper
Universal Semantic Layer : The foundation for instant, actionable, agentic analytics
Case Study

Powered Advanced Analytics for a Global Investment Bank

About the Customer

World’s largest private investment bank

A leading multinational bank that offers financial solutions to private, institutional and corporate clients. With around 200 branches and 4,600 client advisors, they handle nearly 80% of Swiss wealth and serve one in three households, high net worth individuals and pension funds, more than 120,000 companies and around 80% of banks domiciled in Switzerland.

Challenges

Lack of a consolidated KPI view and delayed financial analysis across large datasets

The bank’s financial teams struggled to gain a unified view of performance across diverse business lines. Analyzing diverse financial and non-financial KPIs posed a challenge without this consolidated view of all global operations. Their legacy TM1 environment also had severe scalability limitations as well as issues like slow and inconsistent query responses.

Slow insights: Analysts faced delays in performing ad hoc queries and slicing data across dimensions which made it challenging to gauge the company’s real-time performance.
Complex KPIs and hierarchies: Managing complex financial KPIs across multiple lines of business and handling ragged, unbalanced hierarchies required significant effort.
Excel bottlenecks: FP&A teams heavily relied on Excel for analysis and reporting but rising data volumes caused constant slowdowns and refresh issues.
Business Goals

Unify and accelerate financial analytics across global operations

With a non-negotiable requirement for immediate response times, the bank needed to meet the high standards and tight deadlines set by the executive team. Key priorities included:

Elastic architecture for flexibility and cost-effective scaling.
Real-time performance reporting on massive financial datasets.
Complete visibility into financial data to support financial planning and analysis (FP&A) for their C-suite.
Cross-LOB reporting to identify trends and patterns.
Analytics within Excel with faster data refreshes.
Ad hoc reporting to facilitate in-depth analysis for over 700 analysts across the globe.
How Kyvos Helped

Delivered high-speed analytics for faster decision-making

Kyvos modernized the bank’s infrastructure and revolutionized financial reporting across diverse user levels, business segments and worldwide sites.

Greater flexibility and scaling: Kyvos' AI-powered smart aggregation enabled aggregation of five years of financial data quickly, enabling YoY analysis. Kyvos also ensured high performance and flexibility to handle complex hierarchies for accurate weighted roll-up calculations.
Enhanced global wealth management efficiency: Enabled real-time performance monitoring by allowing instant integration of new data into reporting without downtime. It allowed teams to analyze metrics and KPIs across responsive, interactive reports with fast query responses.
Advanced FP&A capabilities: Kyvos' Excel plugin allowed seamless integration into the existing Excel workflows. Users could perform complex calculations, slice and dice their data, drill down into detailed information, perform ad-hoc analysis, create custom reports and visualize data using Kyvos’ Excel Add-in’s built-in features and functions.
Seamless 360° KPI assessments: Unified cross-LOB reporting for instant visibility into financial and operational KPIs and enabled quick adjustments in COB financials, trend analysis. In addition, dynamic MD&A reporting offered a holistic view of financial health and future projections across all business lines.
Cost-effective scaling: Optimized costs while supporting growing data volumes and analytic demands with elastic cloud architecture.
Impact

Reimagined FP&A for global analysts with sub-second insights and enterprise-wide visibility

UBS 40 min
Data models built in <40 mins
UBS 5sec
Data refreshes in <5 sec
UBS global
700 global analysts empowered
UBS year
5 years’ of data processed