Our Business Process Visualization
Use Cases and Deployment Scope
As our company bought another company, their applications was presented with Crystal Report, having dealt with the application few years ago, this brought some memories, we are using to process and present data that is being processes by our lending applications, it is taking data from several database such MySql and SQL Server, External parties, etc. Crystal report are involved in several of our business processes 1. Data initiation 2. Data Checking 3. Credit Checking 4. Loan Scoring 5. Collection 6. Non Performing Loan analysis Every process is resulting a daily report that we consolidate, while on a monthly basis this is the report format we are sending to the government
Our business dashboard is also built on top of Crystal report
Our business dashboard is also built on top of Crystal report
Pros
- Consolidate data from several data sources
- Low to no code report generation
- Configurable
Cons
- This is bound for Windows OS, hard to find similar alternative on other OSs
- Be careful in Indexing your data, as it will consume resources
Most Important Features
- Multiple data sources, by far this is the most important one
- Relatively easy / low code report and dashboard generation
- Tailored solution for business process
Return on Investment
- Without the application, our lending business will be in complete stop, as our applications are wrote in Windows based
- We are processing 300 Loans/Month, taking it as $10000 per loan, having this not working properly will cost potential $150.000 revenue
Alternatives Considered
SQL Server Integration Services and TIBCO Jaspersoft Community Edition
Other Software Used
Microsoft SQL Server, .NET
