Home Accueil / Blog / Freelance Freelance

Why I build interactive tools
instead of sending static reports

Pourquoi je construis des outils interactifs
plutôt que d'envoyer des rapports statiques

TL;DR

A static report answers the questions you anticipated. An interactive tool answers the questions you could not anticipate. For R&D teams who need to explore data, not just read summaries, the difference is the difference between a deliverable and a tool.

La question que vous n'avez pas anticipée

Chaque rapport que j'ai jamais livré a généré au moins une question de suivi que je n'avais pas anticipée. Avec un rapport statique, chaque question devient une nouvelle demande, une nouvelle exécution d'analyse, un nouveau fil d'e-mails, et typiquement un délai de deux jours. Avec un outil interactif, chaque question est un filtre à basculer ou un slider à déplacer.

Les rapports statiques comme conversations gelées

Un rapport statique est un instantané d'une conversation sur les données. Pour les analyses exploratoires et les revues de résultats internes, la conversation sur les données est continue. Un rapport statique force cette conversation à passer par vous, l'analyste, chaque fois que quelqu'un a une nouvelle question.

Ce qui change quand vous livrez un outil

  • L'équipe possède l'analyse, pas seulement la sortie. Les non-statisticiens peuvent interroger les données eux-mêmes.
  • L'exploration de sous-groupes est en libre-service. Chaque filtre démographique, chaque fenêtre temporelle se fait en secondes sans implication de l'analyste.
  • L'outil survit à l'engagement. Une bonne app Shiny fonctionne pendant des mois ou des années après la fin du travail.

Coût, délai et maintenance

Une app Shiny interactive prend 1,5-2x plus de temps à construire qu'un rapport statique pour la même analyse. Mais sur une période d'étude de six mois avec des mises à jour hebdomadaires et des questions continues sur les sous-groupes, l'approche rapport statique génère 10-20 demandes de suivi. L'outil interactif en élimine la plupart.

Quand un rapport statique reste la bonne réponse

Les rapports statiques sont la bonne réponse quand le format est prescrit (tableaux de soumission réglementaire), quand l'audience est externe (brochure investigateur, rapport d'étude clinique), ou quand l'analyse est un instantané unique. Mon approche par défaut : interactif pour les livrables exploratoires et internes, statique avec génération automatisée pour les documents réglementaires et formels.


À retenir

La question "rapport ou outil ?" doit être la première décision de conception dans tout engagement analytique. Ce n'est pas un choix technique: c'est une question sur qui utilise la sortie, ce qu'il doit en faire, et combien de temps elle doit vivre.

The question you did not anticipate

Every report I have ever delivered generated at least one follow-up question that I did not anticipate. The medical director wants the data split by a subgroup that was not in the brief. The regulatory lead wants to see the sensitivity analysis without the three outlier subjects. The commercial team wants the responder rates at a different threshold than the one in the protocol.

With a static report, each of these questions becomes a new request, a new analysis run, a new email thread, and typically a two-day delay. With an interactive tool, each of these questions is a filter toggle or a slider move.

Static reports as frozen conversations

A static report is a snapshot of one conversation about the data. It reflects the questions that were in scope when the analysis was commissioned, and nothing else. The moment it is delivered, it starts to become outdated: not because the data changed, but because understanding of the data deepens as more people engage with it.

For a simple, well-scoped deliverable, a primary endpoint table for a regulatory submission, a demographic summary for an investigator's brochure, a static report is exactly right. The questions are fixed, the format is prescribed, and interactivity adds no value.

But for exploratory analyses, interim results reviews, and internal decision-making, the data conversation is ongoing. A static report forces that conversation to go through you, the analyst, every time someone has a new question.

What changes when you deliver a tool

When the deliverable is an interactive Shiny application, several things change:

  • The team owns the analysis, not just the output. Non-statisticians can interrogate the data themselves, which builds understanding and trust in the results.
  • Subgroup exploration is self-service. Every demographic filter, every time window, every endpoint switch happens in seconds without analyst involvement.
  • The tool outlasts the engagement. A good Shiny app runs for months or years after I have finished the work. The static report from the same analysis is usually superseded within weeks.

The three types of interactive R&D tools I build

For pharma and biotech clients, three patterns come up repeatedly:

  • Study results explorer: a Shiny app that lets the team explore PK profiles, efficacy endpoints, and safety data from a completed trial. Subgroup filters, visit selectors, download buttons. Used from interim analysis through regulatory filing.
  • Longitudinal dashboard: for ongoing programs with multiple studies, a dashboard that tracks KPIs across the program over time. Useful for data review committees and portfolio management.
  • Analysis report with interactive supplements: a Quarto document for the primary report, with linked Shiny apps for the exploratory sections. The best of both worlds: fixed output for regulatory purposes, interactive exploration for internal use.

Cost, timeline, and maintenance

An interactive Shiny app takes longer to build than a static report for the same analysis. The typical ratio in my experience: 1.5-2x the timeline. It also requires maintenance if the underlying data structure changes. For a one-time deliverable with no follow-up, a static report is more efficient.

Where the interactive tool wins on total cost: over a six-month study period with weekly data updates and ongoing subgroup questions, the static report approach generates 10-20 follow-up requests. Each request is an hour of analyst time. The interactive tool eliminates most of those requests.

When a static report is still the right answer

Static reports are the right answer when: the deliverable format is prescribed (regulatory submission tables), the audience is external and needs a formal document (investigator brochure, clinical study report), or the analysis is a one-time snapshot with no anticipated follow-up questions.

My approach: default to interactive for exploratory and internal deliverables, default to static with automated generation for regulatory and formal documents. Often the right answer is both: a formal Quarto-generated report plus a Shiny app for the exploration that happened on the way to the report.

How I approach a new engagement

The first question I ask when taking on a new data analysis engagement is: who will use the output, and what questions will they want to answer? If the answer is "the regulatory team, to review the primary endpoint results," the deliverable is a static, precisely formatted table. If the answer is "the medical team, during the end-of-study readout," the deliverable is a Shiny app.

Getting this decision right at the start saves significant rework. A static report delivered to a team that needs interactive exploration generates a cascade of follow-up requests. An interactive tool delivered to a regulatory submission context generates validation headaches.


Key takeaway

The question "report or tool?" should be the first design decision in any analytical engagement. It is not a technical choice: it is a question about who uses the output, what they need to do with it, and how long it needs to live.

AM

Aslane Mortreau

Freelance Data & AI specialist working with pharmaceutical, biotech, and cosmetic R&D teams. Statistical modeling, analytical pipelines, and custom applications.

Spécialiste Data & IA freelance travaillant avec des équipes R&D pharmaceutiques, biotech et cosmétiques. Modélisation statistique, pipelines analytiques et applications sur mesure.