asteRx, an online clinical data and market research services company for the Australian healthcare and pharmaceutical industry, is using Inside Info’s QlikView business intelligence application via the web to help pharmaceutical companies easily identify health market trends, customer behaviour and prescription anomalies.

asteRx provides a fast and secure channel for doctors to participate in market research, collecting anonymous prescription data from a representative national sample of doctors with scriptwriting software. Previously millions of scripts were then analysed in a myriad of ways that would take weeks to manipulate for a single result. Customers were provided with data, usually in Microsoft Access or CSV format, making it difficult from which to draw insight. Data contained lots of hierarchies, continually changing data frequency with varying levels of aggregation. Typical market research analysis and user experience seemed to deteriorate as data volumes grew with other business intelligence tools.

Using QlikView for interactive analysis of data, as well as more effective gender and geographic profiling of the aggregated anonymous data, asteRx helps pharmaceutical companies to effectively dedicate resources, identify health trends and community issues as a whole by having instant access to products, quantities and combinations prescribed across a representative sample of GPs.

“Using QlikView, Inside Info has allowed our customers to easily identify health market trends such as tracking the progression of diseases in the community through more effective profiling of disease trends. It also allows for better management of medicines together with identification of prescription anomalies and their impact on consumers. Essentially, QliKView helps us keep Australia healthy.” said Jon Marshall, Managing Director, asteRx.

QlikView has provided asteRx with an expanded breadth of analysis by easily allowing contextual data to be added to study results, showing unseen or long term trends in data as well as macro and micro level relationships . Data volume, format and structure restrictions are irrelevant in QlikView. With this, asteRx now provides the missing link between how products are being used and the pharmaceutical companies that own the products.

As with all Inside Info’s QlikView deployments, asterX’s solution was delivered quickly in just 12 days.