Posted by: bluesyemre | March 20, 2013

New Excel Data Explorer add-in bolsters data analysis by Sharon Machlis

Importing data from the Web with Data Explorer

  • What it does: Getting your data into analysis-ready format can be half the battle (or more) when using a spreadsheet. Microsoft Data Explorer Preview for Excel is designed to help by easing data import from a variety of sources. You can then massage the data in different ways, from reshaping to filtering and grouping. It also simplifies merging tables on a common column. The beta runs on all desktop versions of Excel 2010 and 2013.
  • What’s cool: This plug-in handles an impressively large array of data formats such as HTML tables, CSV, XML, Hadoop, Active Directory and, yes, Facebook. It will import from multiple databases including MySQL, PostgreSQL, Oracle and IBM DB2 as well as Microsoft’s own SQL Server, Azure and Access; and is also designed to help shape “semi-structured” plain text into a better format for analysis.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


%d bloggers like this: