Logistics Company optimized BI applications and improved corporate data quality

Business challenge

• Conduct code audit, review of QlikView applications UI
• Customize QlikView Applications
• Implement Best Practices.

SOLUTIONS HIGHLIGHTS

IBA Group has developed an Enterprise Data Warehouse, multidimensional data arrays (OLAP cubes) and step-wise data import from various sources: transactional database, Sharepoint, Web services, SAP. Our experts analyzed the company’s processes, set up ETL processes and data cleansing, developed and customized SQL. They also introduced an abnormal event alert system for the ETL-system, configured information collection with the least load on database sources.

For the data warehouse of internal projects, we developed new models and processes for preparing data for QlikView. An IBA Group specialist checks the application for compliance with multiple criteria: design in accordance with corporate styling and coding standards, inclusion of certain visualization objects and proper optimization.

Auditors receive engagements to review the code and UI of applications. The customer receives reports in a standard format, and the developers receive revision lists. After correction, the application is subject to audit again. To speed up the process, the central office delivers some of the applications for refinement to experts from IBA Group.

Result

The Customer is continuously optimizing and improving the quality of QlikView applications and corporate data.