KPI Monitor Analyzer

Maintaining all functionality of the basic version, KPI MONITOR Analyzer provides higher performance, abilities to integrate and scalings thanks to a data processing core. The software product can act as a full-fledged industrial BI system and, first of all, will be interesting to the companies with large volumes of data, and high requirements to their analysis.

Main platform opportunities:

Performance;

• The core scaled on hardware clusters. An opportunity to separate the server dismissed and the server on different computers and in different installations of one computer. Remote administration of servers, including via the Internet;
• Designer of any forms of input-output of data and organization of a desktop of the user;
• Connection of external data sources and "nachitka" of data directly without import and conversion to required structure;
• The module of tasks SMARTS with a possibility of setup on their basis of algorithms of measure calculation (on terms, by assessment, on a transition graph on the status and so forth);
• Use of the Report generator (Masters of reports) and any creation of reports on analytical cuts;
• The expanded structure of the reference book (a set of attributes of the reference book, support of reference fields on other reference books, use of attributes in imposing of filters according to reports and other calculations), use of an external source (an external DB) as reference books;
• Recalculations of indicators in different currencies and units of change at the scheduled course or recalculation;
• Possibility of authorization through the domain Windows, including without password entry (using electronic keys, etc.).

Data sources

KPI MONITOR Analyzer supports connection in the structure of own information base of a set of different data sources. Abilities to integrate provide as import from databases of accounting applications (the list of compatible databases is given below), and connection to external DB without preliminary import when for storage of reference books and values of Basic indicators tables of an external DB are used. The present possibilities of KPI MONITOR Analyzer provide seamless integration with different ERP, CRM, WMS and other business applications.

The supported data sources:

• Microsoft SQL Server 2008 R2, 2005
• MS Access 2007/2003
• FireBird 2.1/1.5
• MySQL 5.5/5.1/5.0
• Oracle 11/10/9
• Interbase 6/5.5/4
• Sybase 5
• Progress 9
• Paradox
• Dbase
• 1C 8 (COM)
  

^{ETL data processing unit}

The data processing unit is used by ETL for setup of scenarios of work with initial data. Using a user-friendly interface the user configures step-by-step transactions with data of different sources. The result of accomplishment of each transaction can be seen on any of stages of creation of the scenario. The ETL block change of data on a condition, installation of data binding to structure of reference books and structure of Basic indicators supports operations of selection of data on a condition (filtering), adding of values to selections by the set criteria. The optimal scenario is established on periodic accomplishment with the help, the scheduler who is built in a system.

^Architecture

The KPI MONITOR Analyzer application is created using simple and clear architecture. The KPI MONITOR Analyzer server consists of the 4th a component, the users ensuring functioning in a common information space.

'^{OLTP Server (Server of data)}

The server of data provides transfer of the changed data in the OLAP Server. At the same time, the server of data supports work both with own KPI MONITOR database, and with the connected databases of external sources. The server of data KPI MONITOR Analyzer obspechivat operational data processing at hard simultaneous work on input and editing data by more than 500 users. Physically information base is stored on a database server which can be located on one computer with the Server of data or on another and also in case of need on several other computers. The server of data has the functions of fixation of changes of record of tables of the database which are built in a core with a possibility of viewing and rollback to last statuses.

^{OLAP Server (Server of calculations)}

The basic we distinguish constructions of an OLAP cube of data from the classical OLAP applications the fact that an OLAP cube to be under construction in RAM of the server is. Due to use of the RAM the KPI MONITOR servers will allow to build quickly reports on large volumes of data for read seconds. Compact storage of signing up in OZU of the server provides optimal use of RAM for processing big with amount of data. Scaling of the OLAP server allows to parallelize loading of capacities between physical servers, having determined by everyone the necessary volume of the processed information. Special customizers of optimal indexes and version control of an OLAP cube allow to achieve the high performance of a system at creation of difficult reports. Besides, KPI MONITOR Analyzer allows to implement creation of an OLAP cube on external databases without import of data to structure of KPI MONITOR. Recreation of an OLAP cube of data happens only on the changed data that provides its high speed.

In KPI MONITOR Analyzer the possibility of determination of attributes for analytical reference books is provided that allows to reduce the number of the analitichesy reference books connected with a basic indicator and also to receive makismalno the flexible detailing reports, including due to support by the OLAP Server of dereferencing of analytics on its attributes in the conditions of selection.

The KPI MONITOR Analyzer OLAP Server supports the unlimited volume of the processed data. The volume of an OLAP cube is limited only to RAM allocation opportunities in 64-bit the MS Windows operating systems

^{Web server}

As the KPI MONITOR Analyzer Web server uses Internet Information Server (IIS). The Web server provides sale of the user interface of the program in Web to the environment.

^{Client of KPI MONITOR Analyzer}

For work of users the web interface providing access to the program from any the Internet of the browser is implemented. The MS Silverlight technology used in the program provides evident visualization and ergonomics of the interface. In general, use of WEB technology allows to minimize costs on administration and service of users of the program.

For the organization of client access from mobile devices the special client application KPI MONITOR Mobile which provides online access to indicators of activity of the company with iPad and also tablets running the Android operating system is used.