In the 1980s Thatcher helped attract the likes of Nissan to the region, but it could not revitalise the city itself. Now a new industrial strategy, backed by the local council, is aiming for more sustainable results