The goal of the client is to create a report / view KPIs / view Dashboard, not to collect the data. When working with clients, we noticed that they are data-sensitive and uninterested in filling in more data than required to fulfil one of their goals. Moreover, since the number of functionalities and required data would grow with time, the table would have to be expanded, becoming too challenging to read or input data into.
Information regarding the necessary data for a report / KPI is in a separate view. Hence, when a user wants to get a report or calculate a KPI, they have two options: either enter all the required data into the table (after which the calculations or report creating will follow), or first review what data is needed for the report/KPI, switch to the corresponding view to fill in that data, and then return to view results. In cases where data is missing or incorrect, users may need to repeat this process several times. Both approaches are not convenient for the user.
Not all types of input can be accommodated in a table in a user-friendly manner, such as questionnaires or data with dependencies/nesting. Furthermore, using a table limits the room to provide explanations, particularly for clients who don't have sufficient knowledge and expertise to complete it independently.
The combination of folders and multiple drop-downs within each folder results in numerous combinations of input places. Coupled with the absence of progress or missing data status, this complex arrangement creates a data input maze, making it unclear what data has already been entered and what remains to be provided.