System benefits from SQL Server Integration Services tools. Thanks to them you can easily add data warehouse to any type of source: database, web service, Excel file or text file. During the processing process you can complete other operations such as: data validation, cleaning, counting, etc.

Efficiency in SQL Server architecture is the result of Analysis Services. You can create multidimensional models (OLAP) tabular ones (In-memory). Both technologies allow smooth work with reports despite intense data sources.

System has build-in data warehouse equipped with basic OLAP’s cubes, which can fit into NAVIGATOR configuration. With them you can analyze the data inside the system: documents, budgets, processes, etc.

Most of the implementations include dedicated data warehouse creation. This comes with the benefit that it fulfills the company’s needs 100%. This project can be expanded independently or by us.

The whole system works in any browser. It does not require installation of any components or programs except MS Excel (and only if someone decides to use Excel sheets or reports).

Authorizations can be locked directly inside the data warehouse. They allow for precise management of access to particular data branches (separate departments or accounting records). Thanks to that the same report will show different data for different users.

System handles budget sheets prepared in Excel. The planning person can fill them directly in Excel or by using the Excels web version.

This sheet type works only in the browser. It comes with the benefit that it handles sheets with dynamic structure (different budgeting positions for different departments). Web sheets are also easier to automate (data is being calculated on its own).