Exploratory analysis of data from the Peditório Nacional para a Liga Portuguesa Contra o Cancro in the municipality of Santo Tirso

In partnership with Rotaract Santo Tirso, we developed an exploratory analysis of data from the Peditório Nacional para a Liga Portuguesa Contra o Cancro in Santo Tirso, with suggestions for improvements in the process of fundraising, which increased the credibility of Rotaract as the driving entity of this fundraising.

rotaract_site_Prancheta 1

The Rotaract club is a non-profit initiative of the NGO Rotary International, composed of young people between the ages of 18 and 30, which is dedicated to service, both locally and internationally, as well as to the professional and personal development of its members.

Objectives

Perform an exploratory analysis of the data from the Peditório Nacional para a Liga Portuguesa Contra o Cancro;

Identify strategies to improve the fundraising process.

Team

Lead Team DSSG PT & Maker

Maker

Maker

Presidente Rotaract Santo Tirso  (Ano Rotário 2018/2019)

Results

1 – Creation of a heatmap with information about the amount collected per parish in the municipality of Santo Tirso, normalized by population;
2 – Deep analysis report on the financial and demographic results of each year of fundraising, with suggestions for improvements to be presented to the municipalities;

The Report allows Rotaract Santo Tirso a better exposition of the financial results of its National Fund Raising to the mayors of each parish. This allows a quantitative and informed decision-making process, which hopefully will result in a greater allocation of resources by the local authorities to the fundraising.

Metrics

They were not defined at the time.

Impact Measurement (march 2020)

The analysis made allowed Rotaract to better interpret the results obtained by each parish in the collection. For example, the comparison, between parishes, of the amount raised per inhabitant had never been done before and allowed us to better evaluate the “performance” of each parish.
The visualizations allowed Rotaract to communicate in a more impactful way the results of each parish to the respective Council Presidents. The comparisons made allowed to appeal more directly to the critical sense and responsibility of each parish council.
The analysis regarding the performance of the volunteers, taking into account their age and gender, was important to “show” and motivate the contribution of the older volunteers, who are the ones who contribute the most, but also the ones who tend to give up participating as they get older.
In general, having this analysis and the respective visualizations increased the credibility of Rotaract as the driving entity of the Peditório Nacional da Liga Portuguesa Contra o Cancro in Santo Tirso.