A glowing green and red network mesh on black
← All case studies
Case study · Data platform

Collaborative data platform for DOT PROJECT

Client
DOT PROJECT
Sector
Social impact and technology
What I did
Requirements · Data platform · Data modelling · Visualisation
4tools connected: Airtable, Power BI, Kumu and Google Sheets
2automated visualisation feeds, into Power BI and Kumu
3services delivered: analysis, strategy and integration
Background

DOT PROJECT is working towards a future where people flourish through the use of technology. They work at the intersection between civil society and technology, passionately increasing the confidence and capacity of people who are working to solve complex social issues.

Situation

As part of their ongoing work with their clients, DOT PROJECT gathers research to understand the ways in which people and organisations connect, communicate and collaborate.

They needed a better, more robust approach to managing their research data, including ways to make the data accessible to, and maintainable by, their partners.

What I delivered

Requirements, and the right platform

I undertook a requirements gathering phase and went on to select an appropriate cloud data management platform: one that gave them the centralised data integrity they needed, and a user interface that made data management accessible to anyone familiar with a spreadsheet.

An extensible data model, visualised

Following the development of an extensible data model, I implemented the data platform and provided advanced visualisation through an automated data interface to both Microsoft Power BI and Kumu, a tool that visualises connected networks.

Kumu network mapping
Outcome
  • Simple-to-use data platform with built-in collaboration features, now used across a number of DOT PROJECT clients
  • Improved consistency and integrity of data
  • Ability to analyse data in a variety of ways
  • Powerful, interactive data visualisation
Technologies used
Airtable
Microsoft Power BI
Kumu
Google Sheets
Annie Legge, co-founder of DOT PROJECT
Client
“Matt articulated our vision and practically built our MVP at extraordinary speed. A very rare breed: tech and creative, strategic and hands-on. With Matt there is always a way, always a solution.”
Annie LeggeCo-founder, DOT PROJECT
Want to get your business ahead of the game?
Let's get our heads together ↗