Takeda

9

DEPARTMENTS CENTRALIZED

CUSTOM

INTELLIGENT ALGORTHMS DEVELOPED

UNIFIED

SCIENTIFIC STUDIES

Takeda, a global pharmaceutical company, engaged InAir to implement Airtable across 9 departments, focusing primarily on developing a comprehensive project management workflow with custom reporting capabilities for leadership.

The centerpiece of this implementation was a custom-built base designed specifically to track scientific medical studies. This sophisticated solution integrated large CSV data sources and employed complex algorithms to correlate tasks with study stages, providing continuous visibility into company progress and research activities.

Takeda was experiencing operational constraints in tracking and managing their scientific medical studies across multiple departments. Without a unified system, they struggled to efficiently monitor study progress, report findings, and make data-driven decisions.

Fragmented Tracking Systems – Disconnected methods for monitoring scientific studies across 9 departments created visibility gaps.
Complex Data Integration Needs – Difficulty incorporating large CSV data sources with study stages and associated tasks.
Limited Leadership Insights – Lack of comprehensive reporting tools for executives to assess progress and make strategic decisions.

InAir partnered with Takeda to design and implement a multi-departmental Airtable solution focused on scientific study management and reporting capabilities.

Cross-Departmental Implementation – Comprehensive Airtable deployment across 9 departments creating a unified tracking system.
Advanced Correlation Algorithms – Custom logic connecting tasks with specific study stages to provide granular progress tracking.
Leadership Reporting Tools – Tailored dashboards and reports delivering actionable insights to decision-makers.
RYAG Status System – Implemented Red Yellow Amber Green status indicators for every project to provide clear visibility on progress.

The centralized Airtable implementation transformed Takeda's scientific study management, creating a unified platform that connected 9 departments through standardized tracking, comprehensive reporting, and enhanced visibility into research activities.

Enhanced Process Understanding - Comprehensive feedback mechanisms providing detailed insights into scientific workflows and procedures.

Increased Efficiency - Streamlined tracking and reporting systems accelerating scientific study management and contributing to company progress.
.
Improved Decision Making - Clear, actionable leadership insights enabling data-driven strategy across the organization.

“InAir provided an excellent service for our unique Airtable needs. They helped us build automations and custom scripts to more effectively manage our internal processes, which they're very experienced and skillful with. We would happily work with InAir again”.

Anne He

Game Producer | Riot Games

“Sergio and the team at InAir are everything you can ask for in your Airtable partners - responsive, engaged, supportive, and extremely skilled. The entire spectrum of experience - intro call, context, implementation, etc - has been nothing short of exceptional. For anyone who is looking to optimize/scale/improve upon an existing or build a new base, InAir is THAT partner”.

Kenny Kwon

Project Manager | Teladoc Health

“I've worked with Dan and his team for several years and for multiple clients. The team at InAir has been instrumental in helping us configure Airtable bases for editorial projects, customize workflows, and create helpful automations to tools like Slack and Asana”.

Derek Korte

Director of Editorial Operations | Message Lab