Data warehouses allow for data analysis, including data from a dozen or so years back. The collected data is arranged and archived in a central database which facilitates control over access to data, thereby ensuring the security of the stored data. As time goes by, IT needs arise as a natural result of the company’s development, which is why Data Warehouse end-users should maintain constant contact with BI specialists to verify current business needs.
There are several ways to analyze the collected data, depending on actual business needs, however the most common ones are:
- periodical, standard fixed-structured reporting, with enabled filtering,
- defining reports and queries by means of SQL or generating automated reports,
- static analysis of trends and predictions,
- multi-dimensional and interactive analytical processing (OLAP),
- data mining to predict business and market trends,
- business modelling to predict the results of business operations.