Today's activity report #10

Today's tasks were to create an evaluation table of beneficiaries for KfW distribution and to prepare the second iteration of the Power BI dashboard.

The main problem during the development of the scoring table was to compare the raw data from the external form and the evaluation criteria of the beneficiaries.

For example, the initial data lacked information about the composition of the household and had to be reproduced from other data in the table. Some of the fields were repeated several times, and the information in the records had a dirty look and had to be additionally cleaned.

Time spent: 4h

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Today's activity report #17

Изображение
Today I re-cleaned the primary data for the second round of the survey. Reduced the number of pseudo-unique names and patronymics. Converted respondents' dates of birth from text to date and verified their correctness. Found about 80 errors (for example, people born in 2023 and 2064). In the part of names, when entering, the Latin letter 'i' was used instead of the Ukrainian one. In addition, I found 9 cases of missing names or patronymics (surname or first name written twice) Time spent: 4h
Далее...