Insights from heterogeneous data through transitive semantic relationships and text analytics