One of the areas of our activity is the Business Intelligence. During realization of each project we are achieving two basic aims - delivering the tools for:
- measurement of efficiency of the business processes on top and mid management levels,
- support the activity on operational level.
The main advantages achieved by the enterprise after the project is introduced are:
- lowering internal cost of business,
- empowering the decision making process,
- accelerating the reports generation process.
During the implementation phase, we use set of trusted Microsoft SQL Server 2005/2008 technologies. The most of our solutions are composed by the following elements:
SQL Server Date Engine / Date Warehouse – is the single place for integrating data collected from various systems inside the enterprise.
Analysis Services / OLAP - consume and precalculate data from the data warehouse in order to supply it to the rest of the solution’s components.
Excel 2007 – is a popular tool used for quick ad-hoc analysis and report generation. Excel can be easily replaced by different client tools.
Dashboards - are applied realization of the Balanced Scorecard management idea. They concentrate the information about the whole enterprise on a single screen.
Reports – utilizing the best features of data warehousing and OLAP technologies, reports are generated almost immediately and the time needed is very slightly dependent from the quantities of data collected in OLTP systems.
