SyrianDeepDive

A data dashboard exploring Syrian migration, employment, and naturalisation in Denmark (2008–2024), using public datasets from Statistics Denmark, SIRI, and other sources.

📦 Data Sources

👶 Population & Age Structure

• FOLK1B: Total population over time, disaggregated by age group

💼 Employment

• DB_Udenlandsk arbejdskraft_Y24B_7.4.2025.xlsx: Industries where Syrians are employed
• health care.xlsx: Regional distribution in healthcare/education sectors
• Resident permits of Syrians with jobs: Types of work permits associated with jobs

🌍 Net Migration Over Time

• VAN1AAR_total_immigrations.csv: Immigration totals (2007–2024)
• VAN2AAR_total_emigrations.csv: Emigration totals (2007–2024)
• FOLK2_total_pop.csv: Syrian population (1980–2024) (not used in dashboard)
• DKSTAT_nydanskere.csv: Acquired Danish citizenships (1979–2024)

🗺️ Geographic Location (by Kommune)

• VAN1AAR_kommunes.csv: Immigration to Danish municipalities (2007–2024)
• VAN2AAR_kommunes.csv: Emigration from municipalities (2007–2024)

🛂 Asylum Applications

• VAN5RKAM.csv: Asylum application data (not used in dashboard)

---

🧠 Notes

• All data is publically available through Statistikbanken.dk or official SIRI extracts
• Some dataset names refer to local filenames or saved queries
• See “Notes & Sources” in the dashboard for assumptions, caveats, and methodology

---

📊 Dashboard File

The main Power BI dashboard is included here:

syriandanes.pbix — Built in Power BI Desktop (April 2025)
To explore or edit the dashboard, open this file using Power BI Desktop.

This file includes:

• All visuals and pages (population, migration, employment, etc.)
• Custom measures, relationships, and slicers
• Embedded metadata and queries from the original source files 📥 Download syriandanes.pbix

👋 Credits

Dashboard by Kelly Rasmussen | April 2025
Not affiliated with any institution. Built for clarity and informed debate.

This site is open source. Improve this page.