Building BI capability and competence at a charity organisation

Background

Keyrus proudly donated its expertise to the Domino Foundation, a non-profit organisation that meets essential needs of the underpriviliged communities and works towards their empowerment.

Challenge

The NPO’s internal processes were Excel-based, making it exceedingly difficult to draw meaningful reports about Fairhavens for donors. This lack of a proper digital infrastructure meant that all data entries had to be done manually. Data analysts spent their time capturing data. This was extremely time-consuming and inefficient use of their skills. They were also required to train volunteers to help, which posed a risk because of the sensitive nature of the data. Finally, many insightful trends went unnoticed because of the Foundation’s limited ability to analyse its information.

Approach

Keyrus’ experts proposed a solution that included Microsoft Power BI for analysis and visualisation, as well as Microsoft SharePoint to host the dataset. These tools were integrated into the Foundation’s Microsoft 365 environment to provide seamless connections to the data. As an NPO, Domino Foundation is eligible for significantly discounted Microsoft Power BI licenses. Keyrus also conducted training upskilling the charity’s staff in Power BI software and creation of reports.

Key results

Efficient sharing of reports within the Foundation and its local and international donors

Increased accuracy of data and insights that influence important decisions about effective fund investments

Significantly improved data security and substantial time savings

Benefits

The Domino Foundation now has clear insight into its data and can efficiently share reports among its stakeholders as well as donors. The organisation is able to view previously hidden trends and metrics. The data is more accurate, easy to consume, and can be visualised instantly as it is captured. The Foundation is also benefitting from improved data security and significant time savings. The solution Keyrus has delivered delivers clear insight and will help the NPO build better systems to track their impact more accurately and more time-effectively, and ultimately to better serve the community. The new reporting system allows staff to be more agile in their day-to-day activities as they are no longer required to focus on data capture. The solution has added incredible value, especially for national and international funding investment opportunities.

What our clients say

The solution Keyrus has delivered is revolutionary. It delivers clear insight and will help us build better systems to track our impact more accurately and more time-effectively.

Leigh-Ann Stevens, Research & Evaluation manager, Domino Foundation