endorsedOngoing

BI Implementation for Large-Scale Pharmaceutical Company

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Pharmaceuticals & Biotechnology

Duration

95 months

Budget

Confidential

Start Date

1 September 2018

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

74/100

Good

Project Capability Score (PCS) estimates how capable NeenOpal Inc. is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Chandigarh, India

Project Summary

NeenOpal implemented a Tableau-based BI platform integrated into a custom medical ERP, creating a data warehouse and department-specific dashboards to streamline internal reporting. They worked closely with stakeholders to gather continuous feedback and delivered roughly 25 dashboards in the initial phase. The implementation reduced manual MIS reporting hours and fostered data-driven discussions, with the client praising the team's organization and adaptability.

Key Challenges

Custom-built ERP lacked platform-ready API access.
Existing MIS reporting did not track important KPIs and lacked real-time data.
Need to create a real-time data ecosystem, including a data warehouse and department-specific dashboards.

Project Deliverables

Data warehouse (single source of truth)
Department-specific dashboards (around 25 dashboards)
Stakeholder onboarding and knowledge transfer
Reporting mechanism and weekly status reports

Project Solution

NeenOpal conducted stakeholder meetings to gather reporting requirements and KPIs, created a prioritized list of department-specific dashboards, and built a data warehouse as a single source of truth. The vendor developed and rolled out dashboards (initial target 4/month, ultimately delivering ~25 for the first phase), worked offsite with frequent one-on-one sessions, and provided backend ad-hoc support and knowledge-transfer to client staff.

Project Outcome

Significant reduction in man-hours spent on MIS reporting.
Adoption of data-driven discussions and improved decision-making.
Positive stakeholder feedback and readiness for additional phases.

Platforms

Tech Stack

Tableau

Client Endorsement

Overall Review Rating

4.5

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“To ensure that the end users could easily navigate the dashboards, NeenOpal Intelligent Solutions focused on gathering input from key stakeholders. They collected constant feedback and adjusted accordingly. An organized workflow and impressive technical instincts made for a winning combination.”
Saransh Chaudhary
CEO
Date: 10/27/2019