Multi-scale analysis and modelling of collective migration in biological systems