The problem with operational systems (ERP, EAM, etc) is that the data is stored in a format and level that supports the day-to-day business processes of the organization. In addition, this transactional data may be stored in many different systems and formats. Business decision making is improved when consolidated data is available with easy-to-use access.

One solution is to extract the data out of the transactional (i.e. “source”) systems and integrate the data in a data warehouse. The data warehouse is often the only true Enterprise system. QAD BI Data Warehouse Designer (BI DWD) provides all the functionality required to build and manage the blue box, whilst remaining agnostic on the reporting tools. Often people have multiple reporting tools to support external, internal and analyst users.