After a recent ERP migration, a large packaging manufacturing company was struggling to understand the new BI environment and create critical business reports for leadership. In a matter of weeks, UDig became familiar with the Qlikview BI capabilities as well as the unique client business and operational requirements for reporting. The consultant wrote custom ETL scripts to enhance the data prep process feeding the BI tool. Once data was properly transformed, the consultant built custom reporting for the client leadership to highlight key performance indicators (KPIs). Company leadership now has quick access to critical performance metrics like contribution margin to help identify opportunities for improvement in operations.

A large packaging manufacturing company recently migrated to a new Enterprise Resource Planning (ERP) software: EFI Radius. The ERP came with built-in Qlikview BI reporting, but the out-of-the-box reports were not in alignment with the company’s standard definition of operational and strategic performance metrics.

The BI tool based in Qlikview had analytic potential, but it was complex to understand how out-of-the-box reports were built or how to create new custom reports for leadership. Qlikview implements a unique flattened data schema, but it was foreign to internal analysts who were comfortable with traditional database structures and more user-friendly BI software. Client turned to UDig to apply database and BI expertise to the Qlikview environment and extract valuable reporting out of the new ERP.