Data Validation Data reported via forms is Defined users review data Once a user has entered a list of profiles, the Preferred Management prone to having mistakes either collected to identify M & E officer may be assigned to check the reported from the source, incomplete, incorrect, accuracy of the data before approving the transcription error, or other inaccurate, or irrelevant parts record. Monitoring and Evaluation (M&E) inaccuracies. of the data and then use staff may also find that a staff member established data cleaning enters the same responses for all techniques to replace, modify, beneficiaries interviewed and the interview or delete the time is short. They follow up to find out “dirty” data. Identify and flag data outliers whether this is one record entered (e.g. potential errors) erroneously multiple times or whether the staff member is not properly interviewing. Data Analytics and Data used as evidence for Define and generate standard Queries may be performed across all Report decision making and reporting and customized reports and fields/sources/geographic regions for which should facilitate the varying dashboards including charts the user has access. Reports and report Management purposes that various users and graphs reflecting trends templates/structures may be saved within the need data for. Only validated and patterns. Enable Pivot system for future access, shared to other Essential data should be pulled for Table like functions allowing registered users, printed, or exported to reports, while analytics should the cross tabulation of different Word, PDF, Excel, and SPSS. Useful enable analysis of full sets to variables in data sets. dashboards that can visualize activity help in flagging data information, indicator progress for results on “dirty” and outliers. a graph or map, program statistics, all of your programs on a (google) map, etc. Custom Reports can be created to identify conditions such as when indicator actuals have not been recorded for a current period.
Data Validation Management Data reported via forms is prone to having mistakes either reported from the source, transcription error, or other inaccuracies. Defined users review data collected to identify incomplete, incorrect, inaccurate, or irrelevant parts of the data and then use established data cleaning techniques to replace, modify, or delete the “dirty” data. Identify and flag data outliers (e.g. potential errors) Once a user has entered a list of profiles, the M & E officer may be assigned to check the accuracy of the data before approving the record. Monitoring and Evaluation (M&E) staff may also find that a staff member enters the same responses for all beneficiaries interviewed and the interview time is short. They follow up to find out whether this is one record entered erroneously multiple times or whether the staff member is not properly interviewing. Preferred Data Analytics and Report Management Data used as evidence for decision making and reporting should facilitate the varying purposes that various users need data for. Only validated data should be pulled for reports, while analytics should enable analysis of full sets to help in flagging “dirty” data and outliers. Define and generate standard and customized reports and dashboards including charts and graphs reflecting trends and patterns. Enable Pivot Table like functions allowing the cross tabulation of different variables in data sets. Queries may be performed across all fields/sources/geographic regions for which the user has access. Reports and report templates/structures may be saved within the system for future access, shared to other registered users, printed, or exported to Word, PDF, Excel, and SPSS. Useful dashboards that can visualize activity information, indicator progress for results on a graph or map, program statistics, all of your programs on a (google) map, etc. Custom Reports can be created to identify conditions such as when indicator actuals have not been recorded for a current period. Essential