The Automated Report Generation System was designed to streamline the process of creating in-depth reports for IOM's country offices. By utilizing standardized templates and pulling data directly from IOM’s SQL servers and the Migration Data Portal, the system goal was to allow for the rapid generation of reports, complete with key performance indicators, trend analyses, and key statistics. This system emerged out of a need to create reports faster, providing country offices with actionable insights in their engagements with national stakeholders.

The key feature of the system was its ability to automate the insertion of modular indicators into a pre-built Word document template, ensuring that relevant statistics and data visualizations are populated accurately:

hmcs 1
Fig 1. Report Template v1

After choosing from a list of indicators and selecting an ID in this case countries a report is generated:

hmcs 2
Fig 2. Report Example India

The reports generated were meant for external engagement, which is why Microsoft Word was chosen as the output format for its familiarity and ease of sharing across different levels of expertise. There were also considerations of piloting features like generative AI to assist in interpreting and summarizing data. I implemented this feature and after testing it thoroughly it proved useful in descriptive tasks, however, the AI was prone to errors with deeper analysis that involved extra research not currently being showcased in the data.

I developed the proof of concept during my time at IOM’s Global Migration Data Analysis Centre (GMDAC), however I left before it reached completion. My intentions for future advancements would have involved building a user-friendly interface, potentially employing tools such as Streamlit, Dash or Shiny to allow IOM's 160+ country offices to generate reports on demand, refining the system through a pilot phase before global implementation. The impact of this system lies in its ability to automate what was previously a time-consuming process, enabling faster delivery of insights and freeing up resources for deeper analysis and decision-making.