Business intelligence (BI) leverages software and services to transform data into actionable insights that inform an organisation’s strategic and tactical business decisions. BI tools access and analyse data sets and present analytical findings in reports, summaries, dashboards, graphs, charts and maps to provide users with detailed intelligence about the state of the business.
More complex information requests often mean that the necessary data comes from different departments, and exists in different formats.
The solution for this problem is the use of a reporting database, a data warehouse. Here the data is stored in an unambiguous format, and is optimised for the quick analysis of large amounts of data.
Read moreTo fill a data warehouse with updated data in a fully automated manner, software is needed that we refer to as data integration or ETL products (extract, transform, load).
This software can be created manually with scripts, but often specific tools are being used that increase productivity.
Read moreAs Eric