Analytics allow you to examine aggregated data from the database by extracting, filtering, and finally displaying results in a graphical or tabular form. For instance, you can use analytics to create a report that lists all delinquent debtors, along with their outstanding payments and days past due.
There are two stages in setting up your analytics: collecting your data and setting up how you wish to present it.
- To extract the required data, you can run advanced queries based on fetch objects or database stored procedures.
- For presentation, you have the option to display the results in the form of simple grid reports, SSRS compliant reports that meet financial regulations, interactive Power BI reports, or charts.
Data sources are used for generating reports.
Use the Reports section to generate simple grid reports that offer a tabular view of the data, or custom reports that are used for statutory reporting to legal authorities.
Reports can be accessed based on previously defined security roles, or automatically generated on predefined milestones and dates. You can export the reports to multiple file formats, or deliver them to subscribers by e-mail or to a shared file. In addition, reports can be generated from the application menu.
Advanced analytics bring data examination using business intelligence (BI), in order to process large amounts of unstructured data, discover insights, make predictions, and generate recommendations.
Integrated into FintechOS, Microsoft Power BI helps analyze data, determine metrics, and share insights across the organization.
Charts are visual presentations of data that help you convey information, and understand data in a visual way. Use charts when a tabular report won't adequately show relationships between data points.
This section covers the following topics: