Workshop Objectives:
Enhance Terre des Hommes MEAL team skills in Power BI to:
Convert raw data into insight for quick, data-driven decision-making in crisis settings.
Create and manage live dashboards tailored to emergency response needs.
Develop sustainable workflows in Power BI for ongoing reporting.
Module Breakdown:
1. Introduction to Power BI for Emergency Reporting
Overview of Power BI’s capabilities in emergency contexts.
Introducing Power BI Desktop, Service, and Mobile features for field accessibility.
Power BI integration: Excel, KOBO, Activity Info, and IMS.

2. Harnessing the Power of Data in Power BI
Importing data from Excel, KOBO, and Activity Info.
Data transformation techniques to prepare for analysis.
Combining and handling multiple data sources.

3. Data Modeling Essentials
Creating relationships between data sets for dynamic analysis.
Establishing data hierarchies and models for crisis reporting.
Structuring data for optimal Power BI performance.

4. Data Analysis & Visualizations
Using DAX (Data Analysis Expressions) for calculations and insights.
Selecting the right visual elements (maps, tables, KPI cards) for emergency reporting.
Real-time data integration in Power BI dashboards.

5. Designing & Deploying Compelling Dashboards
Dashboard design principles for clarity and impact.
Custom filters and layouts for targeted reporting.
Sharing, publishing, and securing reports in Power BI.

6. Hands-On Practical Exercises
Practical lab on building live dashboards with Excel and KOBO data sets.
Emergency scenario exercises: tracking key indicators and response outcomes.
Q&A and troubleshooting during the exercises.
7. Post-Training Support