Data Explorer & Power View – Using Twitter Data (JSON Format)

Every once in a while… Microsoft releases extremely cool tools to the Excel audience that leaves us with a face similar to this one –>

Surprised smile
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
and they just recently introduced the latest version of Data Explorer

(which caused this to many people –>

Surprised smile
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
Surprised smile
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
Surprised smile
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
Surprised smile
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
  • Facebook
  • Twitter
  • LinkedIn
) .

Within the past 3 years, Microsoft has released

  • Powerpivot
  • Power View
  • Data Explorer
  • GeoFlow
  • Excel 2013 (all the new functions and features apart from the ones above)

All of them that answer to the needs of business users to get their hands on the Dataa and be able to explore it and reach extremely useful insights…all of this thanks to the Self-service BI concept.

Data Explorer answers the need of the user that needs to transform his data in an easy and automated way, translating this into excel-geeky language, it means:

  • No more macro recordings
  • No more helper columns
  • No more complicated formulas and arrays that made Excel Crash

Data Explorer it’s a tool that enables you to:

  1. Extract
  2. Transform and
  3. Publish

your data. However you want. Check out this post from The Data Specialist:

http://thedataspecialist.wordpress.com/2013/03/05/microsoft-data-explorera-review/

to know more about what’s Data Explorer

Posted in:

2 Comments

  1. Miguel, pretty cool example. I have taken a very quick look at Data Explorer and did not get time to explore it further. But your video has piqued my interest. Data Explorer looks really cool, especially with that steps thing which looks like a very nice UI for macro recording.

    Your twitter idea was also very good. I am a Twitter-illiterate and it is good to know that it is so easy to do analysis on Twitter feeds using PowerPivot/PowerView.

    Look forward to more posts on Data Explorer from you. I will also explore the tool soon.

Leave a Reply

Your email address will not be published. Required fields are marked *

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