Open-Source Business Intelligence Makes its Way into the Pharmaceutical Industry

Share Article

German based ALTANA Pharma successfully implements full-scale scorecard solution based on Open-Source OLAP database "Palo".

News Image
With Palo & Worksheet-Server, we have managed for the first time a system rollout during which User-Trainings and the information content, but not the technique were the main subject. With a small but efficient team of specialists plus Jedox, this project was realised in a uniquely short time

ALTANA Pharma Deutschland GmbH utilise Palo (http://www.palo.net) for their "Selling Excellence Program". Palo, an Open Source database developed by the Jedox (http://www.jedox.com), is used as a centrally accessible data storage in an application which, based on Key Performance Indicators, depicts and analyses sales performance and trends for 36 sales regions with more than 400 sales districts.

In order to achieve this, Altana elaborated a catalogue of KPIs based on the "European Best Practice Approach". These KPIs now serve as measurement categories for success and competitiveness. The scorecards, which are based on these KPIs, not only show quantitative measures but also visualise current trends in dynamically generated arrow charts. All scorecard data are held centrally in the multidimensional data model of the Palo server. Scorecards were rolled out to the field sales reps with the help of Worksheet-Server, an Excel-to-Web solution also offered by Jedox. Data are thus accessible for evaluation to all authorised team members through both Excel and a web browser.

"With Palo & Worksheet-Server, we have managed for the first time a system rollout during which User-Trainings and the information content, but not the technique were the main subject. With a small but efficient team of specialists plus Jedox, this project was realised in a uniquely short time", says Gerhard Klingele, Director Finance and Controlling at ALTANA Pharma Deutschland GmbH.

Further information about this project is available on Jedox's home page http://www.jedox.com, together with information on the whole range of solutions offered in the field of business analysis and planning.

About Jedox

Jedox GmbH (http://www.jedox.com) is the world's leading supplier for professional Excel to Web solutions. With Worksheet-Server, Excel Applications can easily be transformed into server based Web applications. The Open Source Product Palo expands Excel's data model and is available for free download under http://www.palo.net.

Press Contact

Kristian Raue

Jedox GmbH

Sedanstrasse 7                        

D-79098 Freiburg

phone: +49 (0)761/1514-70

###

Share article on social media or email:

View article via:

Pdf Print

Contact Author

KRISTIAN RAUE
Jedox
+49-761-151470
Email >
Visit website