Why Atoti is different

Atoti is a relational, transactional, columnar, in-memory database coupled with a modern, multidimensional OLAP aggregation engine, allowing for real-time, self-service analysis on fast-moving data and direct queries on cloud databases. Atoti is the fastest data analytics software made for financial services organizations.

Speed

Atoti does everything on-the-fly, giving users complete freedom. Due to Atoti’s sub-second aggregation of complex metrics on large volumes of data, its database innovations (in-memory column stores, bitmap indexes, work-stealing multithreading, distributed computing) and user defined functions that run at native speed, you no longer have to rely on pre-aggregated datasets, pre-calculated metrics or pre-loaded dashboards.

Multidimensional analysis reinvented

Discover the power of Atoti’s new generation of cubes, allowing you to explore and add unlimited measures and dimensions effortlessly. Experience rapid multidimensional analysis with fast queries and concurrent data updates. Atoti serves as a semantic layer, transforming raw data into intuitive business hierarchies and metrics, making complex data analysis accessible and straightforward. Centralize your metrics and generate dynamic business logic to create comprehensive reports, ready to meet the demands of today and the future.

Advanced modeling for
self service data analytics

Eliminate the hassle of complex queries, batch processing, and canned reports. With Atoti, you can achieve simplified, highly detailed key metrics precisely modeled using Java or Python APIs. Atoti metrics are presented as straightforward sums in a pivot table, ready for use in reports and queries. You can easily group or filter using any of the data model’s hierarchies, making it ideal for Value at Risk, Expected Shortfall, Potential Exposure, and real-time PnL estimates.

Mix high performance queries and operational data

Our Multiversion Concurrency Control (MVCC) engine supports queries and transactional data updates at scale. Each transaction generates a new version of the data without interrupting queries running on previous versions.Using lock-free, delta-based data structures, this mechanism scales to large numbers of updates and versions. Several users can work on the same Atoti instance, view their own version of the data, make adjustments and perform what-if simulations without altering official data.

End to end real-time processing

Go beyond fast data updates by implementing continuous queries and aggregate metrics users can see instantly. Our recalculation pipeline enables real-time PnL and risk-monitoring at the scale of an entire trading desk. Traders and desk managers will see new transactions and market data updates on their dashboards in sub-seconds.

Improve performance and reduce infrastructure costs

DirectQuery enables users to access and analyze data stored on a third-party database without needing to load it into memory first. This capability provides access to granular, detailed data with an unlimited historical perspective, allowing all analyses to be performed in a single, consistent, and easily accessible environment. IT managers can optimize data loading by keeping frequently queried hot data in-memory for instant access, while cold data remains on a persistent database for cost-effective storage. Additionally, DirectQuery accelerates project launches with plug-and-play functionality, enabling cubes to start in minutes or even seconds without moving data, supporting on-demand analytics and dynamic provisioning.

Speed

Atoti does everything on-the-fly, giving users complete freedom. Due to Atoti’s sub-second aggregation of complex metrics on large volumes of data, its database innovations (in-memory column stores, bitmap indexes, work-stealing multithreading, distributed computing) and user defined functions that run at native speed, you no longer have to rely on pre-aggregated datasets, pre-calculated metrics or pre-loaded dashboards.

Multidimensional analysis reinvented

Discover the power of Atoti’s new generation of cubes, allowing you to explore and add unlimited measures and dimensions effortlessly. Experience rapid multidimensional analysis with fast queries and concurrent data updates. Atoti serves as a semantic layer, transforming raw data into intuitive business hierarchies and metrics, making complex data analysis accessible and straightforward. Centralize your metrics and generate dynamic business logic to create comprehensive reports, ready to meet the demands of today and the future.

Advanced modeling for
self service data analytics

Eliminate the hassle of complex queries, batch processing, and canned reports. With Atoti, you can achieve simplified, highly detailed key metrics precisely modeled using Java or Python APIs. Atoti metrics are presented as straightforward sums in a pivot table, ready for use in reports and queries. You can easily group or filter using any of the data model’s hierarchies, making it ideal for Value at Risk, Expected Shortfall, Potential Exposure, and real-time PnL estimates.

Mix high performance queries and operational data

Our Multiversion Concurrency Control (MVCC) engine supports queries and transactional data updates at scale. Each transaction generates a new version of the data without interrupting queries running on previous versions.Using lock-free, delta-based data structures, this mechanism scales to large numbers of updates and versions. Several users can work on the same Atoti instance, view their own version of the data, make adjustments and perform what-if simulations without altering official data.

End to end real-time processing

Go beyond fast data updates by implementing continuous queries and aggregate metrics users can see instantly. Our recalculation pipeline enables real-time PnL and risk-monitoring at the scale of an entire trading desk. Traders and desk managers will see new transactions and market data updates on their dashboards in sub-seconds.

Improve performance and reduce infrastructure costs

DirectQuery enables users to access and analyze data stored on a third-party database without needing to load it into memory first. This capability provides access to granular, detailed data with an unlimited historical perspective, allowing all analyses to be performed in a single, consistent, and easily accessible environment. IT managers can optimize data loading by keeping frequently queried hot data in-memory for instant access, while cold data remains on a persistent database for cost-effective storage. Additionally, DirectQuery accelerates project launches with plug-and-play functionality, enabling cubes to start in minutes or even seconds without moving data, supporting on-demand analytics and dynamic provisioning.

The Atoti platform

Supports on-the-fly complex non-linear metrics.
Supports multidimensional queries.
Works with volatile data that changes in real-time.
Operational workflows: allow write-backs, what-if analysis, sign-off, amendments, and more.

Perfect for critical decisions when traditional BI tools are too slow and IT delays are not an option

Front Office & Market Risk

  • Market Risk aggregation & analytics (VAR/ES, Sensitivities)
  • PnL / Performance Attribution
  • Research and Audit
  • Real time PnL & MtM Predict
  • Sensitivity, Risk, and Limit Monitoring
  • FRTB (BCBS 457)

Liquidity Risk & Balance Sheet

  • Balance Sheet & ALM
  • Stress testing
  • Intraday Liquidity Risk (BCBS 248)
  • LCR and NSFR (BCBS 238, 271)
  • Cash Flow Aggregation
  • Interest Rate Risk in the Banking Book

Credit & Counterparty Risk

  • xVA / PFE aggregation and analytics (BCBS 325)
  • Credit Risk and Limit Monitoring
  • SA-CCR (BCBS 279)
  • CCR (BCBS 424)
  • IFRS9 monitoring and analytics
  • Climate Risk

Collateral Optimization & Inventory Management

  • Collateral Optimization
  • Inventory Analytics
  • Real-time Initial Margin / Variation Margin
  • SIMM
  • Risk Not In SIMM (RNIS)

Corporate Finance

  • Financial Planning & Analysis
  • Financial Risk Management
  • Liquidity Management
  • Management Reporting

The only platform dedicated to financial institutions that combines real-time analytics and data management at scale.

AI-Powered Evolution: Enhancing Atoti for Smarter Data Analytics

Atoti, our advanced data analytics platform, is about to get even more powerful with the integration of artificial intelligence. We are dedicated to leveraging AI to enhance the capabilities of Atoti, making it smarter, faster, and more intuitive than ever before. Here’s a glimpse into how AI will revolutionize Atoti and elevate your data analytics experience.

Self-Optimizing Query Engine

The Atoti query engine learns from user interactions to optimize itself continuously. By employing machine learning algorithms such as hierarchical agglomerative clustering, Atoti classifies runtime queries and recommends the best configurations for aggregate caches, partitioning, and other tuning parameters. This self-optimizing capability enhances performance and ensures faster, more efficient data retrieval.

AI-Powered Assistance for Developers

Developers benefit from an intelligent assistant when creating Atoti models. This AI-driven assistant not only explains data modeling APIs but also generates the corresponding Python code based on the developer’s requirements. This feature significantly streamlines the development process, allowing for more efficient and accurate model creation.

AI-Driven KPI Explanations

Understanding the reasons behind changes in KPIs can be challenging. Atoti AI automatically explains variations in measures, whether they occur between different dates or regions. Using marginal calculations within the underlying cube, Atoti AI highlights the cube members contributing most significantly to these changes. This feature provides analysts with immediate insights, streamlining the investigation process.

Natural Language Dashboard Interaction

Navigating complex Atoti dashboards can be daunting, especially for occasional users. With AI, users build and interact with dashboards using natural language. This capability simplifies the user experience, removing barriers to entry and allowing users to leverage Atoti’s full potential without a steep learning curve.

Automated Analysis and Highlighting

Atoti uses generative AI to provide an initial analysis of dashboard data, highlighting critical points of attention. This "What should I look at today?" experience saves analysts significant time, visually accentuating important aspects and offering brief explanations to clarify their significance.

Enhanced Market Risk Scenario Generation

To better assess potential extreme market outcomes, Atoti uses Generative Adversarial Networks (GANs) to generate additional stress scenarios. This enhances VaR calculations and other risk metrics by incorporating a broader range of potential market conditions. This feature provides a more comprehensive risk assessment framework.

Code Upgrade Assist

When customers move to a new version of our business solutions, such as Atoti FRTB or Atoti Market Risk, our Code Upgrade Assist tool automatically upgrades up to 80% of the existing code. This significantly reduces the manual effort required by developers, allowing them to focus on reviewing and finalizing the upgrade efficiently.