RCM BI Reports 

Finance teams do not want a dashboard, they want their report — resubmission ageing by insurance and year, unsettled balances, denial breakdowns, statement of account. Each one is registered declaratively: a MongoDB aggregation pipeline plus the column and matrix configuration describing how to render it as a flat table, a pivot, or both. Adding a report means adding a pipeline, not building a page.

Around thirty pipelines are defined this way today, spanning roughly 7.5K lines of aggregation logic. The matrix view is the part that earns its keep — row dimensions, a dynamic column dimension whose distinct values become the columns, and aggregated measures in each cell, which is what lets one definition serve both the tabular export and the pivot an accountant actually reads.

The frontend is Angular 19 with PrimeNG and ECharts, with data import handled through Excel upload and long-running jobs reporting back over Socket.IO. Exports go out as Excel and CSV, because that is where the numbers end up regardless of how good the chart is.