A method, non-transitory computer readable medium and data management computing apparatus comprising searching across a plurality of different heterogeneous data indexes based on portions of one or more search keywords in response to a received request. A result set for each of the plurality of different heterogeneous data indexes is obtained based on the searching. Further, one or more facets to each of the obtained results sets are added. Furthermore, a plurality of visualization techniques are automatically identified for each of the obtained results sets based on the facets in each of the obtained result sets and a model entity type associated with each of the plurality of different heterogeneous data indexes. Finally, each of the obtained results sets with the added facets and the identified one of the plurality of visualization techniques is provided.