I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.
Connection Strings for named instances as sources for R in SQL 2016. All about the double slashes!!