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.

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

1. Cross-Departmental Implementation – Comprehensive Airtable deployment across 9 departments creating a unified tracking system.
2. Advanced Correlation Algorithms – Custom logic connecting tasks with specific study stages to provide granular progress tracking.
3. Leadership Reporting Tools – Tailored dashboards and reports delivering actionable insights to decision-makers.
4. 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.