Today's activity report #9

Today I continued creating the dashboard. To unify the process, I prepared a separate file with auxiliary tables and aggregated indicators of the first round of distribution. Made edits to the Power BI report structure and filled in gaps with new data. I performed primary data analysis and reconstructed approximate data on the age distribution of children in aid recipients based on the skewed distribution of the first round survey.

I also added calculated columns for calculating and aggregating distribution data in monetary terms. Prepared the preliminary data of the questionnaire of the needs of the respondents from the first round. But did not add them, since most of them are related to CfW distribution.

In addition to creating the dashboard, I made changes to the cleaned list of beneficiaries. When the MEL officer converted the data to reflect the main distribution indicators, we lost some of the beneficiaries' personal data. It was necessary to filter and transfer them from the primary data.

Time spent: 8h