Ajackus replaced MPP’s manual Excel-based reporting with automated Power BI dashboards, consolidating fragmented data across sales, filing, and country analysis into real-time, interactive views.
Engagement Model
Team Augmentation
Your team, supercharged — every Ajackus engineer comes AI-native, shipping 40–60% faster from day one
Managed Delivery
Tell us the problem. We handle everything — discovery, architecture, build, testing, deployment — at AI speed
BOT Model
We build your offshore engineering center with AI-trained teams, operate it to maturity, then transfer ownership to you
Expertise
AI Development
Custom AI agents, LLM integrations, RAG pipelines, and AI enablement — from strategy to production
Web Development
Enterprise web applications built with AI-augmented engineering for 40-60% faster delivery
Mobile Development
Native and cross-platform mobile apps built at AI pace with rigorous automated quality
DevOps
Infrastructure that scales automatically, deploys safely, and costs less
Low-Code/No-Code
Airtable, Glide, Shopify, and WordPress solutions with AI automation layers — built in days
Data Analytics
Turn raw data into decisions that drive revenue — 80% faster with AI-assisted analytics
UI/UX Design
User-centered interfaces designed with AI-powered speed — 3x faster iteration, sharper insights
How Medicines Patent Pool Slashed Report Generation Time from Weeks to Minutes with Power BI
Services
Data Analytics
Web Development
Technologies
Weeks→Min
Report Generation Time Reduction
3
Centralised Dashboards
11 Stages
Product Timeline Tracked Automatically
Overview
Executive Summary
Client Overview
The Challenge
Project Goals
Our Approach
Results and Impact
Frequently Asked Questions
Executive Summary
The Problem
Medicines Patent Pool (MPP), a WHO-funded organisation ensuring affordable medicines for low-income countries, relied on Excel spreadsheets to extract insights across sales, filing, and country-level data. This manual process was time-consuming, error-prone, and couldn’t handle the complexity of tracking 11 product development stages—leading to weeks-long reporting delays.
The Solution
Ajackus built centralised Power BI dashboards integrating sales, sales filing, and country filing analysis into unified views. The team automated data retrieval by connecting MPP’s data portal directly to Power BI, eliminating manual Excel extraction entirely.
The Result
Report generation dropped from weeks to minutes. MPP gained real-time, interactive dashboards, automated data retrieval replaced manual workflows, and the organisation can now respond to changing market dynamics with current intelligence.
Client Overview
Medicines Patent Pool is a United Nations-backed, WHO-funded public health organisation dedicated to making life-saving medicines more accessible in low and middle-income countries. MPP collaborates with local pharmaceutical companies through voluntary licensing and patent pooling, ensuring rapid development of affordable generic medicines.
| Industry | Healthcare / Public Health |
| Organisation Type | UN-supported, WHO-funded |
| Mission | Affordable medicines for low/middle-income countries |
| Key Deliverable | Power BI reporting dashboards |
The Challenge
THE BOTTOM LINE
MPP needed to replace manual Excel-based reporting with automated, real-time dashboards that could consolidate fragmented data across sales, product development, and country-level filing—reducing report generation from weeks to minutes.
MPP’s manual reporting infrastructure was creating bottlenecks that directly impacted the organisation’s ability to respond to market dynamics and make timely decisions about medicine access programmes.
Core Pain Points
- Data fragmentation: Insights across sales, sales filing, and country filing analysis were siloed across three distinct stages, making consolidation extremely difficult.
- Manual Excel workflows: Extracting insights from spreadsheets was time-consuming and error-prone, preventing timely access to accurate information.
- Complex 11-stage tracking: The product development timeline required meticulous management across 11 stages that Excel couldn’t handle flexibly.
- Limited accessibility: Excel lacked real-time updates and interactive features, restricting collaboration and responsiveness.
- Weeks-long reporting delays: Manual report generation caused significant delays, hindering MPP’s ability to identify trends and address challenges promptly.
Project Goals
The project aimed to transform MPP’s reporting from a manual, weeks-long process into an automated, real-time capability that consolidates all analytical streams into interactive dashboards.
| Goal | Success Criteria |
|---|---|
| Centralise fragmented data | Unified dashboard across sales, filing, and country analysis |
| Automate data retrieval | Direct Power BI connection replacing manual Excel extraction |
| Reduce report generation time | From weeks to minutes |
| Track product development | All 11 stages visible and manageable in one view |
| Enable real-time analysis | Interactive dashboards with up-to-date information |
| Improve data accessibility | Collaborative, real-time reporting across the organisation |
Our Approach
Ajackus worked closely with MPP to replace—not augment—their manual reporting workflows, building an automated system from data source to dashboard.
Centralised Dashboard Development
The team built a centralised Power BI dashboard system that integrated insights from sales, sales filing analysis, and country filing analysis into unified views. This gave MPP a comprehensive overview of key metrics across all three analytical stages for the first time, enabling streamlined analysis and faster decision-making.
Automated Data Retrieval
Ajackus connected MPP’s data portal directly to Power BI, eliminating the manual Excel extraction step entirely. This automation ensured real-time data flow into dashboards, removed the error-prone manual process that had caused weeks of delays, and gave the organisation always-current reporting without human intervention.
Results and Impact
The transition from Excel to Power BI fundamentally changed MPP’s ability to generate insights and respond to market dynamics.
Weeks→Min
Report Generation Time
3
Unified Dashboards
Real-Time
Automated Data Retrieval
Operational Improvements
- Report generation reduced from weeks to minutes through automated Power BI dashboards.
- Three centralised dashboards consolidating sales, filing, and country analysis into unified views.
- All 11 product development stages tracked in interactive Power BI views with drill-down capabilities.
Business Impact
- Automated data retrieval replaced manual Excel workflows, eliminating errors and delays at the source.
- Real-time data accessibility enabled faster, evidence-based decision-making about medicine access programmes.
- Organisation-wide access to interactive reporting improved collaboration and responsiveness to market changes.
Why It Worked
Replace, Don’t Layer
Replacing the entire Excel workflow rather than adding BI on top eliminated the root cause of weeks-long delays.
Unified View First
Consolidating three siloed analysis streams into one dashboard gave MPP visibility they’d never had before.
Automate at Source
Connecting Power BI directly to the data portal meant reports were always current, not weeks behind reality.
Frequently Asked Questions
How did Ajackus reduce MPP’s reporting time from weeks to minutes?
By replacing manual Excel-based extraction with automated Power BI integration connected directly to MPP’s data portal, enabling real-time dashboard generation without manual intervention.
What reports does the Power BI dashboard provide?
Three core dashboards: sales analysis, sales filing analysis, and country filing analysis—plus tracking of all 11 product development timeline stages with interactive drill-down capabilities.
Let’s Build your Project Together
