Intelegain Logo
Intelegain Logo
Clariness GmbH Case Study Hero Background

How Clariness Unified Clinical Trial Operations and Resource Allocation with Microsoft Project & Power BI

Flag of Germany
LocationGermany
Power BI
SolutionPower BI Clinical Trial Portfolio & Resource Management Suite
100%
Centralized Trial Portfolio Visibility
25%
Improvement in Resource Allocation & Capacity
Real-Time
Tracking of Milestones, Risks & Deliverables

At-a-Glance

Clariness GmbH - Germany-based international leader in patient recruitment, clinical trial acceleration, and digital healthcare engagement.

Case Study
01

CHALLENGE:

Managing concurrent clinical trial recruitment projects across Europe, North America, and Asia lacked unified operational and financial visibility. Project risks, deliverable milestones, and team resource utilization were siloed, hindering capacity planning.

02

SOLUTION:

Intelegain developed an enterprise Power BI operational reporting platform connected directly to Microsoft Project data, delivering executive portfolio summaries, project risk registers, and time-phased resource allocation models.

03

RESULTS:

Established 100% real-time visibility across all global trial deliverables, boosted resource utilization efficiency by 25%, and provided leadership with instant project health and financial margin tracking.

Alert Icon

The Challenge: Siloed Operations Across Complex Global Clinical Trials

Clinical trial patient recruitment is an exacting, high-stakes discipline governed by rigid pharmaceutical sponsor deadlines and strict regulatory standards. Clariness coordinates multi-center clinical trials for the world’s leading pharmaceutical sponsors across dozens of therapeutic areas.

Managing scores of simultaneous global recruitment campaigns required coordinating medical copywriters, digital marketing specialists, clinical site managers, and patient concierges across multiple time zones. However, project managers tracked schedules in disparate Microsoft Project files, while financials and team allocations were handled in separate spreadsheets.

This fragmentation left executive leadership without a consolidated portfolio view. Project risks and delayed deliverables were often identified too late to prevent sponsor SLA breaches. Furthermore, resource allocation suffered from limited visibility into team capacity, resulting in burned-out specialists on some projects while others were underutilized.

Lack of combined operational and financial visibility across active global clinical trial portfolios.

Project milestones, risk registers, and open deliverable issues managed in siloed local project files.

Inability to forecast resource capacity, utilization, and upcoming task demand accurately.

Time-consuming manual preparation of sponsor reporting decks and internal executive status reviews.

Why Intelegain Was Chosen

Clariness chose Intelegain due to our healthcare sector credentials, deep Microsoft Project and Project Server integration expertise, and advanced Power BI reporting architecture.

Automated Microsoft Project Data Ingestion:
Creating automated pipelines extracting project tasks, dependencies, baseline variances, and actual work hours into an enterprise analytical store.
Executive Portfolio Health Modeling:
Blending project delivery milestones with budget utilization and billing KPIs to produce an overarching portfolio delivery index.
Time-Phased Resource Capacity Management:
Developing custom DAX models that visualize resource demand vs. available capacity across medical specialties and global regions.
Automated Risk & Issue Tracking:
Centralizing project risk registers and escalation status into real-time visual heatmaps for executive review.

Implementation: The Intelegain Approach

The Power BI suite was delivered across three structured phases over 12 weeks:

01

Phase 1: Project Data Extraction & Semantic Modeling

Intelegain established automated data pipelines linking Microsoft Project and financial databases to Power BI. We built a standardized semantic model encompassing project hierarchies, deliverables, resource pools, and financial budgets.

02

Phase 2: Executive Summary & Project Management Reports

We developed the Executive Summary dashboard (blending financial margins with delivery velocity) and detailed Project Management dashboards tracking milestone completion rates, active risk registers, and open deliverable bottlenecks.

03

Phase 3: Resource Capacity Management & Global Deployment

We created the Resource Management suite: time-phased capacity vs. demand heatmaps, billable utilization metrics, and predictive workload forecasts across upcoming quarters. We conducted executive training and deployed the reports globally.

Microsoft Power BIMicrosoft ProjectMicrosoft DataverseDAX Data ModelingPower BI ServiceAzure Cloud
Statistics Icon

Measurable Results & Business Impact

100%

Centralized visibility across all active global clinical trial projects

25%

Optimization in team resource utilization and workload balancing

Zero

Manual spreadsheet compilation required for executive portfolio meetings

Real-Time

Early warning visibility into deliverable delays and clinical trial risk registers

The Power BI operational platform transformed project governance at Clariness. Executive directors now monitor the entire global clinical portfolio from an interactive command center. Project managers identify schedule variances and risk flags weeks before they impact delivery, and resource leads balance specialist workloads proactively, driving clinical trial success and sustaining industry-leading sponsor satisfaction

Project Details

Client

Clariness GmbH

Country

Germany

Industry

Healthcare

Tech Stack
Tech Stack

Microsoft Power BI | Microsoft Project | Microsoft Dataverse | DAX Data Modeling | Power BI Service | Azure Cloud

Abstract Wave Background

Unify project portfolio analytics

See how Power BI and Microsoft Project data provide real-time visibility into milestones, risks, and resource capacity.

Abstract Wave Banner

Looking to unify project portfolios, risk registers, and resource capacity with Power BI?

Discover how Intelegain can build real-time operational and portfolio analytics powered by Microsoft Project data.