SPECIALIZING TRAINING ON RESULTS-BASED
MONITORING AND EVALUATION
August 20-23, 2024
SPECIALIZING TRAINING ON RESULTS-BASED MONITORING AND EVALUATION
August 20-23, 2024
Demystifying Data
1 Preparation &
Cleansing
Understanding
the Data
Understanding the
Data
Data Source Data Type
Data
Familiarization
Erroneou
d
Dup l i cat e s
Entries Exploratory Relationships/
Entries
Analysis Trends
M is s i n g Data O ut l i ers Contextualizi
i e s
En Cleansing &
t r
ng with
Reprocessin Domain
g Knowledge
Data Value Chain Model
Data Collection,
Type, & Privacy
Appropriate Data Cleansing &
Interpretation Aggregation
Exploratory Data Analysis
Framework
Total
Ratio
Inferential
Analysis
Measure of
Central
Numerical Tendency Predictive
Summaries Measure of Analysis
Exploratory Variation
Data Tabulation
Shape
Prescriptive
& Analysis
Analysis Visualizatio
n Position
Why is it
important for
us to do data
cleansing?
DATA CLEANSING is the act of finding and removing errors,
inconsistencies, duplications, and missing entries from data to increase
data consistency and quality.
Duplicated Data
Consistency of Incomplete
Data Format Data
*Pivotal Table for Counting Duplicates
Step 1. Select the data ; Insert tab > Pivot Table
Step 2. Drag the column with potential duplicates into the
rows
MODULE 1: Demystifying Data Preparation and
Cleansing
HANDS-ON ACTIVITY
MODULE 1: Demystifying Data Visualization and
Storytelling
Key Principles in Data
Visualization and
Storytelling
Principle 1. Chart Design Principles
Principle 2. Intention in Presenting
Principle 3. Be Ethical
SPECIALIZING TRAINING ON RESULTS-BASED MONITORING AND EVALUATION
August 20-23, 2024
Demystifying Data
1 Preparation &
Cleansing
