Data Explorer – Introduction to Data Explorer for Excel

Microsoft Recently announced a new add-in for Excel called “Data Explorer”. Data Explorer is a data access and data discovery/exploration tool used by Business Intelligence Professionals and Information Workers.

Data Explorer can be used to do a variety of different data access and data discovery/exploration activities, some of them are:

  • Extract data from various different sources including Relational Databases, Feeds, Web, Files, Azure, Hadoop Distributed File System (HDFS), and many others.
  • Cleansing, Transformation, and Consolidation of data for further analysis and reporting.
  • Import the data into Excel and use it for further analysis and reporting in tools like Excel Reports, PowerPivot, and Power View etc.

In this post, we will take a look at the following topics:

  • Installing Data Explorer Add-in
  • Different Sources supported by Data Explorer
  • Importing data from Facebook
  • Perform some basic transformations
  • Creating a Simple Report in Excel

To read the full article, follow the link: Introduction to Data Explorer for Excel.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 22, 2013, in MS Excel, MS Office, Power BI, Power Pivot, Power Query, Self-Service BI and tagged , , , , , , , , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: