Technical Solutions
OPERATIONAL BI
About
Run BI reports and visualization on fresh operational data for time-sensitive decision-making
Gain the necessary performance and scale required to support the growing need for real-time analysis and the visualization of fresh operational data for accurate time-sensitive decision making, self-service concurrency and data locality.
Benefits
GigaSpaces InsightEdge’s high-speed in-memory Smart Cache accelerates your existing BI tools by 10-30X with sharding, filtering and server-side dynamic aggregations. Fully SQL compliant, InsightEdge Smart Cache supports multi-criteria queries without the need to add resources.
You can run BI on mutable streaming and hot data, enriched with historical context so that you can visualize and understand your continuously updated operational data with low-latency interactive queries.
A high number of concurrent users is supported while retaining extreme performance. This is achieved by handling peak events through a distributed, highly-efficient, shared-nothing architecture. Autonomous scaling for transactional and analytical workloads, handles peak events without performance degradation or downtime; optimizing resource allocation to avoid overprovisioning on-premise and on the cloud.
One-click database integration supports faster time-to-market and ongoing data integration to radically reduce development overhead by automatically scanning the source data and metadata and mapping them to the GigaSpaces data model, indexing and data distribution. Data model changes are easily made, compatible with and leveraged by BI Tools, resulting in more reliable code integration, faster development, and less administration overhead.
Case Studies
Leading Airline Accelerates Tableau Reports by 3X
A Leading Airline Accelerates Tableau Reports by 3X
Customer
One of the world’s largest airlines, serving over 1,000 airports.
Business Challenge
The airline was using Tableau for fare price forecasting BI. Analysts that reside in multiple geo-locations were querying forecasting data for different airports, but query time was too slow to take relevant action on the data. In addition, the reports were not reflecting fresh constantly changing market data but rather showing statistics based on stale overnight batch output in the data store.
Solution
The airline implemented Smart Cache, allowing them to ingest 800 million forecast records into an in-memory data grid in less than 8 minutes. Price forecasting reports are now based on changing market conditions at much higher speeds, thus providing the most accurate pricing information. Analysts can slide and dice pricing data by flight and class in real-time.
Results:
Tableau reports are accelerated by 3X compared to those previously run directly from an RDBMS.
Real-Time Market Risk BI Application
Real-Time Market Risk BI Application
Customer
An American multinational investment bank and financial services company with over $40B in annual revenues.
Business Challenge
Traders and risk managers need a real-time accurate view of the risk across their portfolios in order to stay within their guidelines.
Technical Challenge
Before implementing InsightEdge Smart Cache, the bank experienced very high latency, leading to poor real-time performance. In addition, the system could not handle more than a few concurrent users.
Solution
Each stock position in every managed portfolio is stored within Smart Cache, over 52 partitions, with 52 backup partitions
A web application aggregates intraday risk measures such as NET P&L, DELTA, MARKET VALUE etc. Traders use an interactive dashboard to view their portfolio risk measures in real-time during trading hours. Risk managers can view risk levels of multiple portfolios, entire categories or even at the bank level.
Results
- Traders get a real-time view of their portfolio risk
- Querying the entire data risk dashboard data takes 100 milliseconds, giving traders a real-time view of their portfolio risk
- Over 100 concurrent traders and analysts
