Built-In Business Intelligence
With Excel in Office 2016, Microsoft has decided to add the feature Microsoft Power Query for Excel into the core of Excel, so it no longer requires a separate download. The tool allows you to combine your own data with third-party data from within the program. That in turn allows for some heavy lifting when it comes to discovering, combining and refining data across a wide variety of sources.
With Power Query, you can import into Excel structured or unstructured data from public data sources including Wikipedia tables, Microsoft Azure Marketplace and Data.gov. Then you can use the built-in JSON parser to create data visualizations over Big Data and Azure HDInsight.