InsFocus Insurance Business Intelligence Blog Business announcements, new features & technologies, version releases

22Apr/10Off

System Center gains Query Builder table editing

Today we are proud to announce that the transition from our previous tool, the Admin Util, to the new System Center, is complete with the introduction of the Query Builder table editor.

The table editor is a sophisticated tool allowing easy editing of Query Builder definitions. By using advanced methods such as row-by-row editing, zero-footprint Javascript code and asynchronous saving, we provide a fast, convenient and simple mechanism for editing the Query Builder tables. Together with the “wizards” for item, dimension and aggregation tables editing, the system center provides administrators a centralized and easy-to-use customization mechanism.

The new tool will be included in our next release, coming in a few weeks.

image

Hanan Taiber
CTO, InsFocus Systems
hanan_taiber@insfocus.com

Filed under: Features Comments Off
11Apr/10Off

Why is InsFocus BI better suited for insurance companies’ analysis and reporting needs?

Last week Hanan has published a blog post in CIO.com regarding our experiences with BI (business intelligence) in insurance, and what makes reporting and analysis different for this vertical. You can read the original blog post Here. In this post I will explain why we believe InsFocus BI is better suited to this job.

When we set out to build InsFocus a few years ago, we found there is a fundamental shortcoming in the way reporting and analysis is done in insurance companies. The main problem was that there was a clear separation between the tool and the model. Thus, a company would go into a process of choosing a tool that looked fit for the purpose (usually Cognos or BO). As a second phase, the company will hire professionals or use in-force persons to build the data model and the ETL processes.

The outcome, in many companies’ view, is disappointing. The tool, that had looked very nice on “demo” data (which is usually simple retail data), suddenly looks rigid and not flexible enough. The model, that is developed by BI professionals, misses the sophistication of insurance. Then, the company goes into endless cycles of data model improvements and enhancements.

So why do we believe that InsFocus BI is better? For a few reasons.

  1. Built-in data model – InsFocus BI ships with a comprehensive insurance data model, covering most insurance aspects available. The model includes earned and unearned premiums, deferred acquisition costs, outstanding claims, IBNR calculations, and a lot more. So basically, we know the end result before even starting. This alone saves tons of executive time, BI developer time and saves the company from making a lot of mistakes.
  2. A tool that is built for insurance – InsFocus BI is not just a shallow data model, but a sophisticated tool that is built specifically for insurance. So, unique insurance techniques, such as changing calculations according to the presented time base (e.g. underwriting, accounting), showing triangulation views, calculating run-off using claim filters, finding the sums insured at a specific snapshot date, and many many more, are already built into the tool.
  3. Granular reporting and advanced filtering – a unique characteristic of insurance reporting is the figures distortion that can be caused by a single event – one big claim can distort an agent’s full record if looking only at top-level averages. To support insurance analysis, InsFocus BI provides two important capabilities:
    1. Drill-down to any level – not just fixed drill-down. With InsFocus BI, you can drill-down to any level, including client, policy, claim and even the individual policy and claim transactions.
    2. Pre-filters – InsFocus BI allows easy creation of pre-query filter on the measurements themselves, enabling analysis such as “show me profitability ignoring claims above X” or “show me a list of the top biggest claims in the last 1 year”.
  4. Ad-hoc reporting – generic solutions have traditionally split users into two superficial types. One type is the so-called “simple user”, who presumably is not computer literate and only wants to see ready-made reports. The second type is the “power user”, who wants to do slicing-and-dicing and maybe alter some reports. In InsFocus, we decided we won’t do not agree with this distinction, and we enabled ad-hoc querying for all users.
    This is especially useful as insurance information workers need ad-hoc querying, and a lot. New reporting needs arise almost daily – and going to the IT department for every new report is a huge waste of time and resources. Using InsFocus BI, we enabled all information workers to perform their own analysis using a very simple to use interface.

We will continue to improve InsFocus BI, and we are very dedicated to the insurance business.

Uri Taiber
CEO, InsFocus Systems

utaiber@insfocus.com

Filed under: Discussions Comments Off
1Apr/10Off

Microsoft Customer Satisfaction Survey Results

March 2010, Microsoft conducted a customer satisfaction survey of InsFocus Systems. The survey, named CSAT, is required by Microsoft for Gold Certified Partners.

12 executives and professionals from 3 different InsFocus customer companies answered the survey. Result highlights:

  • Net satisfaction: 191.67 out of 200, compared to MS partner average of 167.90.
  • Customer loyalty: All considered “Champions”.
  • Loyalty: 100% were satisfied, 100% were likely to recommend, 100% were likely to repurchase and 83.33% stated InsFocus has a “big” or “vital” advantage.
  • Performance: 75% rated overall performance at 8 or 9 out of 9 (the rest at 7). All results were above average.

Uri Taiber
CEO, InsFocus Systems
utaiber@insfocus.com

Filed under: Partnerships Comments Off
8Feb/10Off

Version 1.91 Released

Hi,

Today we are happy to announce the release of InsFocus BI version 1.91.

The new version puts a great emphasis on communication infrastructures, enabling easy integration with other services, various external connectors to BI data and report scheduling, all enabling users to be closer to the BI data they require.

REST communication

InsFocus BI is now fully RESTful, providing much easier SOA and new ways to integrate BI capabilities into the different company’s applications and services;

  • Fully RESTful interface (using GET, POST, PUT and DELETE)
  • Most methods use GET and can be tested from any browser
  • Communication is based on simple basic authentication with SSL encryption
  • Response format is either XML or JSON
  • Most important methods, such as running queries or getting user’s report list, support returning results in HTML
  • Many methods which return large results also support returning compressed byte streams, for fast communication

New external connectors

Based on the previous Excel connector, InsFocus BI now has new ways to connect to the BI server and run queries;

  • Return a query as internal InsFocus object or as HTML table
  • Run a query by parameters or run a report stored in server’s libraries
  • Pass query parameters either as structured XML or as part of the query URL
  • Connect from any browser or from Excel
  • Return HTML table with or without CSS formatting

image

Report scheduler

Utilizing the new communications and connectors, InsFocus BI now has a report scheduler that is able to send report results by mail and SMS;

  • Schedule reports to run daily, weekly or monthly
  • Schedule reports to run one or more times per day
  • Schedule reports saved in library or queries not even saved
  • Send results by template-based, formatted, HTML mail
  • Save results to HTML files
  • Send results by SMS directly to executive’s cell phones

image image

For further inquiries on the new version and its new features, visit our web-site or contact us at info@insfocus.com.

Hanan Taiber
CTO, InsFocus Systems
hanan_taiber@insfocus.com

Filed under: Versions Comments Off
3Jan/10Off

InsFocus Teams with Dortal Software Systems

We are very pleased to announce that we have a new implementation & integration partner in Israel, Dortal Software Systems.

Dortal has many years of experience in insurance software systems and support systems for the insurance industry. Together with Dortal, we will be able to deliver significant value added to customers based in Israel.

For more information, see http://www.insfocus.com or http://www.dortal.co.il.

Uri Taiber
CEO, InsFocus Systems
utaiber@insfocus.com

Filed under: Partnerships Comments Off