InfoPro: Business intelligence

INFOPRO: Business intelligence

Software product "INFOPRO: The BUSINESS INTELLIGENCE" (before SABIB) - multifunction automated information system of data analysis (the system of the class business intelligence (BI)). Purpose of a product The software product is intended for extraction, structurization of the "crude" data which are contained in the operational systems and their conversion to the useful information suitable for carrying out the analysis, a research of data, reporting, forecasting of a situation and development of solutions. The software product is applicable for banking activity, insurance, the enterprises of the industry, telecommunication and trade. Key advantages

Common information space of the enterprise

• uniform conceptual framework and general information space
• possibilities of the analysis on the scale of all enterprise
• increase in efficiency and quality of management decisions

Relevance of data

• automatic control of relevance of values of each indicator
• automatic detection of loss of relevance of indicators
• possibility of performing procedures of recalculation and recovery of relevance of data

Flexibility and configurability

• fast adaptation of models, calculation procedures, definition ranges of indicators for different organization units, types of products to changes of business needs
• possibility of independent determination by the user of a configuration of the software product, correction of model at change of algorithms of calculation, expansion of a circle of the planned and analyzed indicators
• support of multicurrency

Universality

• solution of a broad spectrum of analytical tasks (analysis of sales, analysis of financial and economic activity, analysis of payment discipline of creditors, monitoring and control of investments, etc.)
• solution of a broad spectrum of managerial tasks (budgeting, planning, business planning, etc.)
• solving of tasks of the enterprises of the different industries (production, trade, state bodies, etc.)

Not high total cost of ownership software product

• guaranty period of support – up to 12 months
• flexible price policy of manufacturing company
• possibility of lease of the software product
• Applied characteristics

High-speed performance

• high speed of reaction of the software product to these or those requests to historical information

Integration

Integration with external systems:

• ERP systems (Oracle, Microsoft, SAP)
• Systems of accounting (1C and other)
• Information measuring systems

The software product supports import of these ODBC and XML formats that allows to obtain an original informatin from different external sources Visualization the software product offers the user all range of the tools necessary for input of primary information and viewing information which is stored in the database, in different cuts - tables, diagrams, charts, etc. The user can browse not only the regulated reports, but also to construct any which type and structure he defines

Scalability

• this characteristic allows to set hierarchy of models and their interrelation with each other. It allows to expand consistently model of the enterprise for certain spheres
• the software product allows to store and display indicators of both specific branch of the enterprise, and parent organization, considering a technique of consolidation of information and territorial isolation of branches

Reliability

• the software product ensures safety of data at storage and transfers

Documentation

• existence of a complete set of documentation on the software product, support of current status of documentation

Historicity

• the software product allows to store all structural changes made by the user with models that, eventually, gives the chance to use earlier relevant model

Architecture and structure

System architecture

• The software product has three-unit architecture with selection of the DBMS level including data storage of a complex and service of interaction with the third-party systems, level business of logic, including service of calculation and service of interaction of clients, and client level with service of interaction with Microsoft Excel.

Composition

• Module "Administration"
• Module "Designer of Reports"
• Module "Report generator"
• Module "Import of Data"

Functionality

Information analysis

• online analytical processing of data in real time (OLAP)
• the developed visualization
• modeling
• forecasting
• planning

Data access

• automation of procedures of unloading of data
• verification of data
• flexible determination of the list of the stored indicators
• task of interrelations in one indicator (summary values) and between different indicators
• calculation and mutual recalculation of values of the interconnected indicators can be conducted

o on hierarchy of measurements o on algebraic formulas

• automatic support of relevance of data
• creation of the uniform data warehouse
• creation of user queries
• creation of data marts

Reporting

• formation of the regulated reporting

o accounting and tax accounting o management accounting o industry reporting o corporate reporting

• reporting of any type
• subsystem of an approval of the reporting
• dynamic change of reports
• export of the reporting to Microsoft Excel

Management of audit the built-in system of audit allows to control process of making changes.

Security managements

• management of user rights and roles
• differentiation of access rights to data

o differentiation of access rights can be performed as at the access level to separate report and screen forms, and at the access level to separate lines of tables

• backup
• Specifications

Technology platform - Microsoft. net Framework.

The main DBMS-Oracle Database

Target client OS – Microsoft Windows XP above.

Target server OS – Microsoft Windows XP, Microsoft Windows Server 2003 above.

Implementation options

• Standard Windows is the application
• Web application

Use formats

• data processing center
• the distributed server capacities
• one workplace.

Technical requirements Server: Pentium of 4 1.8 GHz or above 2 GB of OZU or above 250 Of GB Hard drive or more Client: Pentium of 4 1.8 GHz or above 1 GB of OZU for Windows XP or 1.5 for Windows Vista/7 or above 80 Of GB Hard drive The monitor with the supported resolution not less than 800*600

Design methodology When developing the software product Scrum Agile-methodology was applied, at design the methodology of object design of UML was used.

Implementation methodology

Analysis At the Analysis stage during the project the analysis of business processes and requirements of the Customer is carried out. The main result (product) of this stage are the Technical Specifications (TS).

Design At a stage of Design the Conceptual Design of the solution is developed and submitted for approval to the Customer, the software product is shown, the offer on implementation, including the budget on continuation of works and the project schedule prepares. These documents will be approved and affirm the client before the following stage Development and Testing.

Development and Testing At a stage of Development and Testing creation and testing of modifications of a system is performed. If the general time for development exceeds 3 weeks, this work is separated into separate blocks ("Assemblies"), each of which demands 2 – 3 weeks on development. In process of release of each block, it is given to testing to the client. At a stage of development and testing the working environment is established on customer premise.

Implementation At this stage a system completely is implemented at the enterprise of the Customer, and all user trainings are provided in full.