We have worked in cooperation with Rainmakers CSI, a boutique market and customer intelligence consulting company, to deliver a business intelligence tool to a leading global health care products & pharmaceuticals manufacturer – Johnson & Johnson.
Project objective
Johnson & Johnson have access to vast amounts of external industry and demographic research data as well as internal data to inform their strategic decisions. Unfortunately, each research data vendor only makes it possible to analyse only a small part of the big/ global picture that Johnson & Johnson were looking to see. The research vendor data is also not easily mashable with internal data to produce the most meaningful analyses. What the team wanted was a BI tool that could store millions of rows of disparate data types and allow for intuitive and rapid analysis and report building across the data sets.Our approach
What we did:
- aggregated millions of rows of data in one place
- cleaned the data up and made it usable for database building and reporting purposes
- chose data storage and reporting interface platform that can be easily deployed on PCs and laptops – so that the strategy team who is continuously on the go can have the data with them wherever they go
- chose a cutting edge BI tool that looks beautiful, is super-fast and user friendly and allows for rapid drag and drop report generation – think pivot table meets Steve Jobs type of look and functionality
- created a starter for ten set of reports – tables, maps, graphs and dashboards
- allowed the team to create any new reports with just dragging data fields around and no need to know any programming languages and gave them a little bit of training
Results
Johnson & Johnson team now use this tool regularly, grow it as they see fit and have appetite to move all the data to their internal Oracle systems and allow for generating mashups with lots more external and internal data to make it a truly amazing decision support tool.
We are not allowed to share any project workbooks and dashboards. However, if you would like to see a sample dashboard we have created one in Tableau Public that you can view below:
Contact us for a superb BI solutions from a driven and focussed, friendly team in London.
Written by Karolina Haller, LogicSpot
- Service tags:
- business intelligence