Risk management needs to turn data into actionable tasks and risk managers need to visualize business trends, track performance goals and identify exceptions. RSG leverages its Oracle relational database by seamlessly integrating Oracle Discoverer as your ad hoc Business Intelligence tool used to 'mine' and 'explore' all data that resides in your Sigma Encore database. Oracle Discoverer's intuitive user interface guides you through the entire process of building and publishing sophisticated reports and graphs. You choose from multiple charting and layout options to rapidly create a visual representation of the query results. Users then perform drills on their risk management data or graphs to view and analyze the underlying data in order to identify trends and anomalies in their operations.

The combination of Oracle Discoverer's analytical power and ease-of-use empowers risk management to have greater insight into their historical patterns and feel confident in establishing goals and tracking results. One of the most important improvements to relational databases has been the introduction of advanced analytic functions. Oracle Discoverer leverages and extends these capabilities, to allow you to directly answer typical on-line analytical process (OLAP) questions on demand, such as "What are my top ten cause of accidents?" "What is the 3 month moving average of my incurred losses?" "How do my total paid this year compare to total paid last year?" Advanced analytics can even be used to define a condition, so you can view only locations whose losses have grown by more than 10% in one period. Oracle Discoverer permits users to nest functions. This is a difficult if not impossible task for other business intelligence tools where they must rewrite queries impacting system performance.

Features and benefits include:

  • RSG supplies and supports all required relational database joins
  • Drill up and down on result set, pivot data, and change the layout to find answers to questions
  • Users create their own calculations, conditions, and totals to generate custom reports
  • Results are parameterized, shared or exported in a wide variety of formats, including spreadsheets and HTML for distributing to a larger community
  • Users can sort, pivot and total any item, just like any other calculated column
  • Oracle Discoverer provides 'what you see is what you get' results
  • Graphs are always synchronized with the data, so hierarchical drills have never been easier
  • Users easily adjust the layout of their graph to best suit their data. Add graph titles, resize format styles, colors, etc. to conform to their corporate standards

  Home | Legal | Privacy
Copyright © 2008 All rights reserved.
Risk Sciences Group, Inc is a subsidiary of Crawford & Company