Creating Usable Data Views from related records

Creating Usable Data Views from related records

Is there away to create views of contacts using the related data like opportunities or completed activities?

eg. I want  a view of all contacts who have a certain type of opportunity which was lost or is at a certain stage. This can be for any related records such as closed activities, pending activities etc - main aim is I want a view of contacts which i then can sync with campaigns for example - or I can call easily.