Commercially Available Off The Shelf (COTS) Software

Pre-Engineered XBRL Analytics Appliance

The power of Data Modelling and Business Intelligence meets the nuance complexities of Prudential Regulation.


SQL Power XBRL Analytics is a fully optimized analytics appliance for financial analysis, data mining and report distribution. It comes pre-built with dynamic validation and parsing capabilities as well as extraction, transformation and load (ETL) technology to import XBRL instance documents and multiple related taxonomies.

XBRL Analytics is commercially available off-the-shelf and offered as a turn-key, stand-alone Appliance or grouped together with other modular SQL Power Suite components to form a complete end-to-end Prudential Regulatory platform.

XBRL Analytics Appliance

XBRL Analytics comes pre-engineered with the following:

  • Stream Analytics: "Operational Intelligence" analyzes against real-time (not low-latency) data as it streams into a regulator's systems. Stream analytics applies fairly static queries against otherwise very dynamic data - we might think of analyses around fraud detection running against every credit card, claim or other transaction streaming into an organization.
  • XPE, the industry's leading XBRL Processing Engine - one of the select few that are fully compliant with the XBRL International 2.1 Specification and currently installed in some of the largest and most successful regulatory installations in the world (US SEC and FDIC, DICO (Canada), Banque de France and numerous other international FSA's and Central Banks worldwide). XPE is also fully integrated with SQL Power's battle-tested ETL data migration processes, and XBRL parsing technologies, to support pre-built structures and reporting objects tailored for financial analysis.
  • A fully integrated Business Intelligence stack from MicroStrategy (NASDAQ: MSTR), the world's largest independent, publicly-traded BI and data mining organization
  • Macro-prudential supervision capabilities - benchmarking, peer rankings by industry category or across market sectors, intra- and cross-sectored analysis and more

Capabilities include:

  • Early warning analytics scenario and stress testing: Key financial thresholding, ratios and other indicators are provided in real time against submitted call reports and financial returns.
  • Key plausibility assessments: Combined with threshold-based flagging identifies low probability data as compared against recent and historical trending.
  • Predictive Time Series patterning and trend Analysis: Analyzing individual financial institution data or data aggregated in a time series across sectors or financial institution groupings is easily accomplished, including autoregressive and moving average models, smoothing and curve fitting techniques, auto correlations, etc.
  • Sector Analysis Breakdowns: Analysts can report share breakdown by industry group, financial or other institution against the market as a whole, including characteristics related to geographical location for instance or other combinations of third party data.
  • Ad-Hoc Queries: Generate ad-hoc queries against the XBRL Analytics Appliance and make them available to other members of the supervisory team.
  • Corporate Profile Reporting and Risk Profiling: Report against summarized corporate profile data such as directors, beneficial owners as well as licenced products, etc. Aggregating risk information from the Risk Profiles of financial institutions also enables real-time risk based regulation through the quantified financial ranking of financial institutions by risk for improved supervision and inspection planning.
  • Executive Management Reports/Dashboards: Dashboards provide senior level executives with a high level financial health check - risk, trend and market data or overall submission process stats and KPI tracking against Supervisory and other divisional team members.


XBRL Analytics: Introduction

XBRL Analytics: Demo


Get a Quote