BI Implementation for Large-Scale Pharmaceutical Company
Below is a modified rendering of the review: private info excluded, innate facts kept.
Introductory information
A few words almost your organisation and personal responsibilities
I am the CEO of a investigation-based pharmaceutical organisation in India. We have a team size of almost 1000 nation. We',re in the business of pharmaceutical drug investigation, manufacturing and distribution in India and athwart 80+ countries almost the globe.
Desired goal
What issue was the provider supposed to deal with?
NeenOpal Intelligent Solutions?We wanted to instrument a business intelligence platform to streamline inner reporting and help with faster determination making.
The key challenge almost the instrumentation of a off the shelf BI fruit was that the ERP in the organisation was manner built to obey the specific needs of the organisation and so a platform-ready API approach wasn',t useful.
Besides, the inner MIS reporting wasn',t adequately tracking all expressive KPIs and determination making was stagnating due to lack of approach to real time data.
What were your objectives for this project?
Our key goals were to form an ecosystem that thrives on real time data. In order to do so, we divide the project in parts each with a palpable outcome.
- The leading step was data gathering and creating a data warehouse or ",a one rise of veracity",.
- The next step was to apprehend the requirements of each section and key individuals and creating manner dashboards.
- The third and ongoing step is to diligently convey the apprehension associated with the leading 2 steps to chosen individuals in the organisation to empower deeper data insights.
Provided solution
What were the reasons for choosing NeenOpal Intelligent Solutions?
The NeenOpal team reached out to me on LinkedIn. In their throw deck, I saw a well fitted team of young engineers who had a working apprehension of almost all BI platforms useful.
In accession to my bias towards setups, what caught my observation in particular was that their team had done projects on Tableau. Being an avid Tableau user myself, we did a couple rounds of conversation and then determined to go advanced with them as a test.
Describe the project in detail.
The project began with the team setting up different meetings with appropriate stakeholders in the organisation, apprehending the running data decline patterns, reporting requirements and KPIs.
Once all (most) requirements were gathered, a precedingity list of section -specific dashboards were laid down, with more emphasis on sales-based teams since their data requirement was the highest.
A team of two nation, led by one of the co-founders - Nished Singhal, worked on the project. Although they were based offwebsite, they fixd that they get ample one-on-one time with the concerned stakeholders to fix a high condition of output.
We set a modest target of rolling out 4 dashboards a month at the set but soon behind the initial dashboards were rolled out, the project picked up pace and in no time the team had covered almost all dashboards programned for the leading phase of the rollout (almost 25). These encompass different areas of the business, including purchase, sales, logistics, marketing, ethnical rerises, among others.
Were there any dedicated managers or teams that you worked with?
The team was comprised of 2 nation who worked full-time on the project and a backend team for ad hoc support. The NeenOpal team were very pliant with adding rerises as they felt they were lagging behind with the timelines.
Results accomplishd
What results did you accomplish unitedly with NeenOpal Intelligent Solutions?
The learning curve with BI projects can be steep and the onboarding of the appropriate stakeholders is searching. In our case, this was done skilfully by the team by ensuring they maintain a very close tete with the intended users and get uniform feedback.
The team displayed a lot of endurance and big organization in intercourse with the staff, apprehending their queries and kind last diminutive requests to otherwise finalised dashboards. This was possibly the one largest factor that contributed to the achievement of our BI instrumentation project.
As for project kindred outcomes, BI instrumentation using Tableau brought almost a expressive diminution in man-hours spent on MIS reporting. It further formd a vigorous environment for data-driven conversations and insights that spur inquisitiveness.
The feedback from the team has been veritably real, and we are already looking advanced to the second and third phase of the project.
How do you rate the interaction and interaction with NeenOpal Intelligent Solutions?
Their team was organised from the leading day. A reporting mechanism was established to fix everyone was on the same page and dedicated project managers were allocated from the organisation to help the team in setting up meetings with the concerned sections and helping out with other data gathering exercises. A weekly report with the status of all open, proposed, WIP and completed dashboards was submitted to the treatment.
What precisely do you attend to be the key specialty of NeenOpal Intelligent Solutions?
I like that the team is incredibly hard-working, talented, and good with nation. In accession to that, I like that they brought new ideas to the table in almost all meetings I have had with them. Some of these ideas have changed our MIS reporting and unitedly we',ve built further on those ideas to find more meaningful insights.
Although this was their leading project in the pharmaceutical space, their preceding experience in the FMCG sector led to some new interesting cross-domain expertise to flow into our prospect of business which added a new perspective to view things.
Business challenges are largely sector-agnostic and ultimately centre on improving fruitivity of rerises. We',ve benefitted by viewing some intricate business issues from a different perspective and remaining open to new ideas from the team to help tackle it.
What should be done better, if there are any desired improvements?
Things can always be done better and faster the second time but for the leading time there veritably aren',t any complaints.
