Modules

Module 1: Foundations of Health Data Analytics

• Understanding types of health data (clinical, administrative, survey)

• Descriptive, diagnostic, and predictive analytics

• Importance of analytics in modern health systems

• Practical Exercise: Analyzing public health datasets in Excel

Module 2: Data Preparation and Cleaning Techniques

• Handling missing, inconsistent, and duplicate data

• Creating calculated fields and conditional logic

• Data validation and transformation

• Practical Exercise: Cleaning a raw dataset in Excel and Power Query

Module 3: Introduction to Health Data Visualization

• Principles of effective data visualization

• Choosing the right chart for the right message

• Avoiding misleading visuals in health reporting

• Practical Exercise: Creating visualizations in Power BI or Tableau

Module 4: Building Interactive Dashboards for Health Reports

• Introduction to dashboards and KPIs

• Designing user-friendly interfaces

• Integrating visuals for monitoring health indicators

• Practical Exercise: Build a dashboard with filters and slicers

Module 5: Storytelling with Health Data

• Using narrative structures in presenting data

• Combining text, visuals, and context

• Communicating trends and outliers effectively

• Practical Exercise: Presenting a data story from an M&E dataset