Data Warehouse, Business Intelligence
We were looking for a way to quickly and efficiently evaluate the comprehensive data from the retail chains in order to determine valuable insights. As an add-on to the existing B.O.S.S. Enterprise ERP system the Data Warehouse System and the associated Business Intelligence were created.
The system is based on a database of the OLAP type (Online Analytical Processing) which enables very fast evaluation of the stored data. Business intelligence often provides a comprehensive and flexible analysis of all possible business situations from different perspectives and in any context. It allows a detailed and very up-to-date overview of retail units operation, supplier performance, employee efficiency and stock levels as well as a comparison of available data in terms of time, location, article categories etc.
Components of the Data Warehouse System & Business Intelligence
Data Warehouse - database of all business data since the beginning of the use of the B.O.S.S. Enterprise ERP system, including already archived data.
OLAP Server, data cube - OLAP (Online Analytical Processing) is a special type of database that allows very fast execution of complex queries and storage of large amounts of data into logical units.
Analysis - detailed and flexible views of business data from different perspectives.
Reporting - possibility of automatic and scheduled creation of reports and their distribution via web or e-mail, dynamic and interactive reports, various types of diagrams, export possibilities to PDF, XLS, HTML and RTF.
Dashboards - instant overview of key performance metrics using interactive control panels and scoreboards, overview of key operational and financial data such as balance sheets, profits and losses.
Data integration - in the data warehouse it is possible to merge additional data from various sources (e.g. accounting software) to data from B.O.S.S. Enterprise and subsequently evaluate all data together.
Connection to MS Excel - analytical operations and evaluations of data in Microsoft Excel are possible through a direct connection to the data warehouse.
Benefits of using the Data Warehouse System - Business Intelligence
- Opportunity for professional number and data-based decision-making
- Long-term data history in one placet
- Strong support in management decisions, increased user productivity
- Constant system performance regardless to increasing data volume
- Low acquisition costs (use of open source technologies)
- High speed of processing of large data amounts
- Data up-to-dateness - daily data import
