A tool for Data Science - Microsoft "Data Explorer" Preview for Excel now available
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?
- Connect to a web page
- Connect to an Excel or CSV file
- Connect to an XML file
- Connect to a Text file
- Connect to a Folder
- Connect to a SQL Server database
- Connect to a Windows Azure SQL database
- Connect to an Access database
- Connect to an Oracle database
- Connect to an IBM DB2 database
- Connect to a MySQL database
- Connect to a SharePoint List
- Connect to an OData feed
- Connect to a Hadoop Distributed File System (HDFS)
- Connect to Windows Azure Marketplace
- Connect to Active Directory
- Connect to Facebook
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
Cross Posted from Dan Fay's Blog (https://blogs.msdn.com/dan\_fay)