For management reporting on daily, weekly or monthly basis and further analytics the data from the data warehouse can be used. With AWACS GUI reports can be made and other third party BI solutions can produce standardised (static) reports and overviews. With advanced BI solutions further analytics capabilities are possible to create drill-down and roll-up features.
BI applications can make use of the open (north bound) interface of the data warehouse solution (AWACS ETL) or a separate BI server can be created with a subset of the data.
Third party BI solutions can interface directly with AWACS ETL or a BI server, such as:
- Business Objects
- MS Power BI
- Excel Power Pivot