Ad Hoc Analysis Examples & Workflows | CambioML

A global bank's risk management team utilized an ad hoc query to triage massive quarterly Key Risk Indicator (KRI) variances prior to regulatory submission. The generated dashboard revealed that a modest net portfolio movement of +247.8B masked massive offsetting swings, specifically a -4.04T drop in the Corporate Bank division and a +4.27T spike in Markets. By isolating extreme KRI outliers like Japan (+4.63T) and Greece (-5.19T), the team quickly identified 28 anomaly rows requiring immediate investigation.

What it shows:

Instantly identify multi-trillion-dollar KRI swings and anomalies to ensure accurate regulatory reporting.

A healthcare data analyst replaced manual Excel pivot tables by using ad hoc reporting tools to build a categorical profiling summary of a 303-patient heart disease cohort. The dashboard automatically mapped data dictionary codes to clinical labels, revealing a predominantly Male population (67.99%) where Asymptomatic was the top chest pain type (47.52%). By translating integer-encoded clinical data into readable formats, such as mapping Code 0 to 97 Female patients, the analyst eliminated tedious manual charting for stakeholder presentations.

What it shows:

Automate data dictionary mapping to rapidly visualize clinical cohort characteristics without manual pivot tables.