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