Can Presto create mashups with unstructured data (i.e. word doc checked into a SharePoint site)?

Yes.  We often use a type-specific library to extract the information.  we do have out-of-the-box Connectors for Microsoft Excel and another Connecter for HTML 'scraping'.  Other unstructured formats would be accessed through document-type-specific access functions.