Functionality and features for Excel 2013 just keeps getting better, especially when you realize that Self-Service BI can enable Self-Service SI (Science Intelligence) – the latest is the release of the Microsoft "Data Explorer" Preview for Excel which give you a “intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more.”

There is a good overview and tutorial available at the Data Explorer help site.   I also like all the datasets that can be connected to directly…what other data types/file types would help on the Science side?

 

PREVIEW NOW AVAILABLE: Microsoft "Data Explorer" Preview for Excel: Try the upcoming capabilities for Self-Service BI with the Microsoft "Data Explorer" Preview for Excel. This preview gives you an early look into upcoming features that simplify access to public and corporate data. Now you can easily discover, combine, and refine data for better analysis in Excel.

 

Microsoft Data Explorer Preview for Excel

Office Preview | Microsoft BI