Data Warehouse

alt_moonWhat is Included

The Data Warehouse enables ARCSys clients to visualize their portfolios using any data elements loaded, as well as ARCSys’ calculated fields. The visualizations create dynamic tables, charts, and graphs representing data analysis and allowance calculations. These visualizations can be shared with shareholders or colleagues seeking management information on their loan and investment portfolios.

alt_standard_visualization
alt_standard_visualization

Standard
Visualization

Our standard analytics dashboard provides insights into your historical and current data, extending beyond CECL, to assist with loan pricing and various reporting needs across your institution. The standard visualizations are displayed based on both vintage and reporting period datasets.

alt_customizable_visualization
alt_customizable_visualization

Customizable
Visualization

Data points from disparate data sources, such as various core files, spreading software, and credit bureau data, are aggregated into a single repository for dynamic analytics. Institutions can also develop their own customized analytics and visualizations using their data, or using the ARCSys anonymized dataset that supports internally developed KPI measures.

alt_anonymized_dataset
alt_anonymized_dataset

Anonymized
Dataset

ARCSys provides summarized institutional data from all ARCSys clients for benchmarking against other institutions based on similar asset size, geography, and portfolio composition, as well as supplementing their CECL model if necessary. The dataset contains information pertaining to loan activity, including charge-offs, prepayments, probability of default, and loss given default. In addition, information by credit quality indicator is also available.

alt_enhanced_datasets
alt_enhanced_datasets

Enhanced
Datasets

When new data becomes available, such as from a merger, and it is loaded into the ARCSys system, it will be available for analysis immediately.

Learn More

The best CECL analytics are built with

alt_moon"The software has made creating board reports a much easier process, not to mention efficient. The reporting and historical data analysis is also extremely useful for our auditors and disclosures."

- Current ARCSys Client

alt_moonWhat Sets Our Data Warehouse Apart

alt_what_sets_our_data_warehouse_apart
  • alt_the_data_warehouse

    The Data Warehouse allows its users to access the data and create customized visualizations without fear of overwriting the original data.

  • alt_the_data_science_and_statistical_modeling_team

    The Data Science & Statistical Modeling Team is available to answer questions and provide additional support.

  • alt_standard_analytics

    As other institutions request certain visualizations or fields that can be beneficial to all institutions, they can be added to your standard analytics.

  • alt_all_visuals

    All visuals can be exported as an Excel file or picture. Additionally, an entire "tab", or page of visuals, can be downloaded as a PDF.

  • alt_dashboards

    Users in the "author" role can create analyses and dashboards and share them with read-only users.

  • alt_look_at_the_visuals

    Users can add “read-only” users who are able to view the visuals, but are not able to change them.

Learn More