What kind of software or coding language is good to implement a user friendly and visually appealing web base, enterprise level dashboard or visualization for analytics ? 

This dashboard / report is run from data that is stored in a database engine. Regardless of what kind of database engine; what do you recommend that works best for the programming language or software that you'll advise to set this "Web-base Enterprise level dashboard" ? 

Free and open source would be ideal, and all the charts that excel has and UI drill down would be great. There are Microstrategy, power BI, Cognos, clickview, tableau, MS sharepoint, MS Reporting Service but which one is free and open sources and has UI drill down out of these ? Would python, vb.net, asp.net, be good, what do you suggest or advise ?