Information Anonymization (Monday)

Information Anonymization (Monday)

๐Ÿณ๏ธโ€๐ŸŒˆ LGBTQ+ Organization
votes number
Technical requirements
Automation
Shiny data freak
Google tools wizard
Monday integration
API
Fullstack
Design
projectManager
tagline
Anonymize Monday tatles data for analysis
Voters
Team stack
Tech level ( 1- low)
2
Mentor
Priority 1- low
3
Status
Approved

Context

ืžืขื‘ืจื™ื ืœืงืฉืช ื”ื˜ืจื ืกื™ืช ืงืžื” ื‘-2014 ืžืชื•ืš ื”ืฆื•ืจืš ื”ื‘ื•ืขืจ ืœืืจื’ื•ืŸ ืฉื™ื™ืฆื’ ืื ืฉื™ื ืขืœ ื”ืงืฉืช ื”ื˜ืจื ืกื™ืช ืžื•ืœ ืžื•ืกื“ื•ืช ื”ืžื“ื™ื ื”, ื”ืžืžืกื“ ื”ืจืคื•ืื™ ื•ื”ื—ื‘ืจื” ื”ื›ืœืœื™ืช. ืฉื ื™ ื“ื‘ืจื™ื ื”ื ื—ื• ืืช ื”ืืจื’ื•ืŸ ืœืื•ืจืš ื”ื“ืจืš - ื”ืฆื•ืจืš ืœืกื™ื™ืข ืœืื ืฉื™ื ื˜ืจื ืกื™ื ืœื ื•ื•ื˜ ื‘ื—ื‘ืจื” ืกื™ืกื’'ื ื“ืจื™ืช ื•ืœื’ืฉืช ืœืžืฉืื‘ื™ื ืฉืœื ืžื•ืชืืžื™ื ืืœื™ื ื•, ื•ื”ืฆื•ืจืš ืœื”ืฉืžื™ืข ืงื•ืœ ื˜ืจื ืกื™ ืกื‘ื™ื‘ ืฉื•ืœื—ื ื•ืช ืงื‘ืœืช ื”ื—ืœื˜ื•ืช ืฉืžืฉืคื™ืขื•ืช ืขืœื™ื ื•
ื‘ืืจื’ื•ืŸ ื™ืฉ ืžืขืจืš ืฉืœ ืขื•ื‘ื“ื•ืช ืกื•ืฆื™ืืœื™ื•ืช (ืขื•โ€ืกื™ื•ืช) ืžื˜ืขื ืžืฉืจื“ ื”ืจื•ื•ื—ื” ืฉื ื•ืชื ื•ืช ืžืขื ื” ืคืจื˜ื ื™ ืœืคื ื™ื•ืช ืžืกื•ื’ื™ื ืฉื•ื ื™ื ืฉืžื’ื™ืขื•ืช ืœืืจื’ื•ืŸ. ื›ื—ืœืง ืžื”ืชืคืงื™ื“ ื”ืŸ ื ื“ืจืฉื•ืช ืœืชืขื“ ืืช ื”ืคื ื™ื•ืช ื•ืืช ื”ืžืขื ื” ืฉื ื™ืชืŸ ืขืœื™ื”ืŸ - ืœืฉื ื›ืš ื”ืŸ ืžืฉืชืžืฉื•ืช ื‘ื˜ื‘ืœืช ืžืื ื“ื™ื™. ื‘ืฉืœ ืจื’ื™ืฉื•ืช ื”ื ื•ืฉื, ืจืง ืœืขื•"ืกื™ื•ืช ืžื•ืชืจ ืœืฆืคื•ืช ื‘ืชื™ืขื•ื“, ืœืฉืืจ ื—ื‘ืจื™ ื”ืืจื’ื•ืŸ ืื™ืŸ ื’ื™ืฉื” ืืœื™ื•.
ืžืฆื“ ืฉื ื™, ื—ื‘ืจื•ืช ื”ืืจื’ื•ืŸ ืžืขื•ื ื™ื™ื ื•ืช ืœื”ื›ื™ืจ ืืช ื”ืคื ื™ื•ืช, ืœืœื ืคืจื˜ื™ื ืžื–ื”ื™ื, ืขืœ ืžื ืช ืฉื™ื•ื›ืœื• ืœืชืช ืฉื™ืจื•ืช ื˜ื•ื‘ ื™ื•ืชืจ ืœืงื”ื™ืœื”:
1 - ืœื–ื”ื•ืช ืžื’ืžื•ืช (ืœืžืฉืœ, ืขืœื™ื” ื‘ืคื ื™ื•ืช ืฉืœ ื—ื™ื™ืœื•ืช ื•ื—ื™ื™ืœื™ื ืขืœ ืืคืœื™ื” ื‘ืฆื”"ืœ)
2 - ืœืกืคืง ื ืชื•ื ื™ื ื‘ื™ืฉื™ื‘ื•ืช ืžืžืฉืœื”, ืžืกืžื›ื™ ืขืžื“ื” ื•ื›ื“ื•ืžื” (ืœืžืฉืœ - 30% ืžื”ืคื ื™ื•ืช ืœืืจื’ื•ืŸ ื”ืŸ ืžื”ืงื”ื™ืœื” ื”ื“ืชื™ืช)
3 - ืœืœืžื•ื“ ื”ื™ื›ืŸ ื”ืืจื’ื•ืŸ ืขื•ื‘ื“ ืžืฆื•ื™ืŸ ื•ืื™ืคื” ืื•ืœื™ ืฆืจื™ืš ืœื”ืฉืชืคืจ (ืœืžืฉืœ - ืคื ื™ื•ืช ืžืกื•ื’ ืื—ื“ ื ืกื’ืจื•ืช ืžื”ืจ ื™ื•ืชืจ ืžืคื ื™ื•ืช ืžืกื•ื’ ืื—ืจ)
ื›ืจื’ืข, ื—ื‘ืจื•ืช ื”ืืจื’ื•ืŸ ืฉืื™ื ืŸ ืขื•ืกื™ื•ืช ืื™ื ืŸ ื™ื›ื•ืœื•ืช ืœื’ืฉืช ื‘ื›ืœืœ ืœืžื™ื“ืข ื”ืžืชื•ืขื“.
ื”ืžื˜ืจื” - ืœืืคืฉืจ ืงืจื™ืื” ืฉืœ ื”ื—ื•ืžืจ ืœืœื ื—ืฉื™ืคื” ืœืคืจื˜ื™ื ืžื–ื”ื™ื.

What is the problem and its effects?

The organization has a system of social workers appointed by the Ministry of Welfare who provide personal assistance for various inquiries received by the organization. As part of their role, they are required to document the inquiries and the response provided, using a spreadsheet named "Mandy". Due to the sensitivity of the subject matter, only the social workers are allowed to access the documentation, and other members of the organization have no access to it.
However, members of the organization would like to be able to access the inquiries without identifying details so that they can:
  1. Identify trends (for example, an increase in inquiries from female soldiers regarding discrimination in the IDF)
  1. Provide data in government meetings and position papers (for example, 30% of inquiries to the organization come from the religious community)
  1. Learn where the organization is doing well and where it may need to improve (for example, inquiries of one type are closed more quickly than inquiries of another type)
Currently, members who are not social workers cannot access the documented information at all.

Current state

Currently, members who are not social workers do not have access to the documentation system "Monday", which is used to document inquiries and responses provided by social workers.
ย 

Proposal for solution

To address the issue, a new system will be implemented that will anonymize the inquiries and responses in "Monday" so that other members can access the data without identifying details. The new system will be called "AnonMonday".
AnonMonday will be developed as a web application that will allow access to the data in a controlled manner. Each member will have a unique login and password, and the system will provide access to the data based on the member's role and permissions.
The anonymization process will involve removing all identifying information from the inquiries and responses, such as names, locations, and any other identifying details. The data will be replaced with unique identifiers that will allow trends to be identified without revealing any personal information.

Metrics for success

The success of AnonMonday will be measured based on the following metrics:
  1. Data readability
  1. The number of trends identified through the system.
  1. The number of government meetings and position papers that use data from the system.
ย 

Technical requirements

The following technical requirements will be necessary to implement AnonMonday:
  1. Development of a web application that allows access to the data in a controlled manner.
  1. Implementation of a user authentication system that allows access only to approved members.
  1. Implementation of an anonymization process that removes all identifying information from the inquiries and responses of the monday board.
  1. Implementation of a unique identifier system that allows trends to be identified without revealing any personal information.
  1. Design an interface that could display the identified trends.
ย