The Analysis Matrix: How Individual Observations Become an Action Plan

Nov 19, 2026

Michael Ahr - Autor

von Michael Ahr

The Analysis Matrix: How Individual Observations Become an Action Plan

An interview, a workshop, a staff survey, each piece of data collection delivers impressions on its own. Only a shared document turns them into robust findings.

Anyone who systematically analyses a public administration organisation quickly accumulates a great deal of material: interview transcripts, workshop results, survey data, document reviews. The problem rarely lies in collecting it, but in bringing it together. Without a shared instrument, findings remain scattered, recurring themes get overlooked, and in the end gut feeling decides which issue gets tackled first rather than a traceable evidence base.

The VESPRA method has a central tool for exactly this gap: the analysis matrix. It accompanies a transformation project from the first document review through to the derivation of strategic priority areas, and ensures that no piece of data collection remains isolated.

One Row per Survey, One Column per Theme

The basic structure of the matrix is deliberately simple. Each row documents one concrete piece of data collection, with date, format and the organisational unit involved, for instance a document review, an expert interview, a SWOT workshop or a process analysis. The columns are structured along the analysis dimensions such as leadership, collaboration, work organisation or digitalisation, as well as along the project-specific focus areas. Each of these areas is systematically split into findings and recommended actions.

One example makes the benefit tangible: an expert interview on organisational structure produces the finding “no senior manager who sets the direction”. This immediately leads to a recommended action, namely developing clearer leadership structures. This link between observation and consequence is the real value of the matrix: it does not artificially separate analysis from action, but holds both in a single record.

Because every organisation has different priorities, the matrix is adapted individually for each project. An organisational review in the healthcare sector might cover focus areas such as leadership structures, local service footprint or interface optimisation between specialist departments, while a digitalisation project needs different categories. The structure stays the same, the content follows the specific project.

The Living Document

What matters is that the matrix does not only emerge at the end of the data collection phase, but is filled in continuously from the start. After every interview, every workshop, every evaluation of the staff survey, the results flow in directly. This approach has a tangible advantage over evaluating everything afterwards: the advisory team can use the matrix for reflection on a regular basis, even while data collection is still underway, and spot early on when particular themes appear across several formats.

That is the second major benefit alongside pure documentation: the matrix makes patterns visible. When the same observation appears independently in an interview, a workshop and a document review, that is a considerably stronger signal than a single statement. This method is called triangulation: different data collection formats illuminate the same organisational phenomena from different angles, and when they arrive at similar conclusions, the validity of the finding increases substantially.

From Observation to Priority Area

By the end of the data collection phase, the matrix is packed with individual observations that are not yet automatically usable at a strategic level. The decisive next step is clustering: related findings are identified and consolidated into overarching themes. This consolidation does not happen mechanically, it requires professional interpretation.

A typical example from practice shows how this works: individual observations such as unclear responsibilities between departments, duplicate processing across different areas and a lack of coordination on cross-cutting tasks look at first like three separate problems. Viewed side by side in the matrix, they all point to one overarching priority area: interface optimisation and improved collaboration. Addressing this single priority area strategically is considerably more effective than three isolated measures against the individual symptoms.

For senior managers accompanying a modernisation project, the practical benefit of the matrix lies exactly here: it prevents a long list of disconnected individual measures emerging from a multitude of conversations and workshops. Instead, a few, strategically focused priority areas emerge that can have a lasting effect, because they address structural causes rather than individual symptoms. Anyone who maintains this instrument consistently from the start already has, by the end of the analysis phase, the foundation for the next phase in hand: not a pile of transcripts, but a prioritised, robust overview.

Dieser Artikel vertieft Themen aus Kapitel 3 meines Buches
Verwaltungsmodernisierung mit Methode. Mehr dazu im Buch.

About the book