Business intelligence
BI is an effective tool for the company management.
BI system is intended for the high quality business improvement.
Current situation in the business can be described with such symptoms as-critical competitiveness in the market and susceptivity to economic conditions. And as the consequence it causes unstable market situation, which requires prompt and high quality solutions by enterprise managers. The basis for decision-making is copious information concerning the business situation and market trends. Managing such information is the complicated process and requires an complex approach. Decision support at the modern enterprise is considered as the business development key process.
To enable the process of the decision support it is necessary to provide managers with accurate information timely, as for current state of affairs as well as for future possibilities. Such information must be relevant and balanced. The abovementioned problems are solved using products designed on the basis of the Business Intelligence Platform.
 |
What is Business Intelligence (BI)?
Business Intelligence (BI) or "business – analysis” is the technologies that enable organizations to transform data into business information, then to transform the information into the business management knowledge.
What is the business analytics BI purpose?
Business Intelligence (BI) is intended for the high quality business improvement . It is widely used in such areas as manufacturing, wholesale or retail trade, project management, insurance, marketing, management, budgeting and planning.
|
BI system possibilities
- Reporting - the creation of various interactive reports on the basis of on-line data, with the possibility of bringing them to the necessary standardized forms.
- Interactive dashboard (Dashboards) – interactive reports are convenient information form with the possibility of deepening into data (functions as drill-down, drill-up), that allow the comparison of different data and indicators on the basis of the requested analysts.
- Unstandard requests (Ad hoc query) – the possibility of independent generation of requests on-demand for users to create the necessary reports.
- Possibility to work “off-line” – it allows to synchronize for the subsequent work in the "off-line" mode; the remote access function is also available.
- Integration with Microsoft Office (Microsoft Office integration) – full integration with Microsoft Office applications enables to use the broad functional Excel package, including the updating of data and summary tables.
- Metadata management – BI system is an integrated environment that combines data from different systems and applications into a single meta-database. Metadata management is possible due to the usage of common metrics, items to enter, search and data store.
- Multidimensional data cube processing, (OLAP) – this technology allows to process multidimensional data cubes in the on-line mode, BI-server together with BI Data Warehouse implements the processing of complex queries, without overloading the existing system resources.
- Advanced visualization – is various interactive dashboards with many features that display personalized information that focuses on the making of precise and effective decisions.
- Forecast models , search of hidden principles (Data mining) – the possibility to create categories of values and to calculate the forecasting data. Specific mathematical models optimized for different business needs of a particular company are used.
- Scorecards – the output of data related to key performance indicators, KPI. This feature allows to identify the specified data considering the performance indicators.
- Implementation of delivery and performance of reports according to schedule or according to event (Delivery Report) – the feature that allows flexible configuration of reports performance and delivery via e-mail in various formats according to the schedule or event.
- Access restriction (Restriction) – enables the role-based access to the information system through the privileges distribution to users.
BI systems implementation
BMS Soft company implements solutions for Business Intelligence as on the basis of its own development and on the basis of world producers Oracle, IBM, Microsoft. While selecting BI solutions for the Customer, first of all we estimate such parameters as:
- The budget that is allocated and terms of the BI system implementation
- Customer business area
- Amount of the analyzed data
- The necessity for the detailed information
- Information concerning the period to be analyzed
By implementing Business Intelligence technologies based on our solutions, you get such benefits as:
- the possibility to analyze data within long periods of time, to get details on the "year-quarter-month-day" or "year-week-day, to build reports in the dynamics for few months / years;
- the possibility to process really large amounts of data, herewith the speed of making reports in dozens of times is faster than speed of their formation in the accounting system;
- the possibility of collecting data from several accounting systems and databases of the company and the formation consolidated reports up to them;
- the unique flexibility of the reporting system - an analyst may consider any aspects, set any filters and groups, to receive interpretation of specific indicators, going up to the primary entries, to change the structure of reports “on the fly” and create new ones without the involvement of IT-specialists
BMS Soft implements the BI solutions on the basis of such technologies as:
BMS BI Platform Technologies
Server of the multidimensional Databases: Oracle , PostgreSQL, MySQL Mondrian OLAP Server
Data and processes management: ETL Pentaho Kettel
Data visualization: BI Platform BMS SOFT
Application server: Apache Tomcat, Oracle WebLogic
IBM Technologies:
Server of the multidimensional Databases: IBM DB2 OLAP Server / SPSS ShowCase EssBase,
Data and processes management: IBM DB2 Warehouse
Data visualization: IBM DB2 OLAP Analyzer / SPSS ShowCase Analyzer / Oracle Hyperion Web Analysis Studio
Application server: IBM WebSphere.
Oracle Technologies:
Server of the multidimensional Databases: Oracle 10g OLAP / Oracle Hyperion EssBase System 9
Data and processes management: Oracle Warehouse Builder
Data visualization: Oracle BI Suite / Oracle Hyperion Web Analysis Studio
Application server: Oracle Application Server.
Microsoft Technologies:
Server of the multidimensional Databases: Microsoft SQL Server Analysis Services,
Data and processes management: Microsoft SQL Server Integration Services
Data visualization : PerfomancePoint Server / Proclarity Analytics Platform,
Application server: Internet Information Server