Further development of a business intelligence database for Repucom

Expansion of the existing application and adaptation to the new corporate design

Repucom provides comprehensive consulting services in the sports and entertainment business and supports its customers in maximizing their economic success. The globally active market research and consulting company in the sports and entertainment business, based in Cologne, has commissioned eWorks to technically and visually optimize an already developed, individual business intelligence database and to expand it to include several new areas.

In consultation with Repucom, a completely new area for non-sports deals (such as in the Culture, Media and Music area) was seamlessly integrated into the existing application. At the same time, the entire layout of the application was adapted to the customer's new corporate design.

The programming challenge was the desire for individually restrictable access for end customers: Data that was previously accessible to every user must now be checked before output, filtered out if necessary and partially alienated. This also had to be taken into account when expanding Microsoft Excel exports.

Technical difficulties when using the yii framework in connection with the connection to Microsoft SQL Server via the sqlsrv driver were resolved by patching the eWorks driver.

eWorks supported Repucom in an advisory capacity right from the start, carried out the further development and handed over the finished application. Afterwards, eWorks supported the customer with any errors (warranty) and occasional questions about installation and expansion requests.