Large Pharma Microsite
Case Study

We utilized R/Excel/VBA to build dashboards for large datasets (200K+ rows of web analytics data) for a large pharmaceutical company’s micro-site. This was a more practical solution than traditional business intelligence solutions, such as QlikView, as Excel reports are easier to navigate and share by the business managers.

Large web analytics data sets typically have consistency and formatting challenges, as tagging schemas can change, and new tags added for data collection. We utilized R for data cleaning and reshaping, as latency for such operations is lower in R, particularly for large datasets.