Over a million developers have joined DZone.

Excel Evolves in the World of Big Data

Hortonworks DataFlow is an integrated platform that makes data ingestion fast, easy, and secure. Download the white paper now.  Brought to you in partnership with Hortonworks

I don’t know about you, but my go-to piece of software for just about everything is Excel. I have used Excel for over ten years for numerous projects from demographic profiling to building portfolio valuation models. At the Strata event several weeks ago, I was surprised to see Excel 2013 being featured so prominently at Microsoft’s booth, so I sat down and took a look at how Microsoft is positioning Excel in the world of big data.

What impressed me the most about Excel 2013 was the power of Data Explorer which can grab data from a variety of locations, including Hadoop. Additionally, with the press of a button you can search for and import tables from Wikipedia. Microsoft claims that this functionality is being expanded to include public information sources. With the press of another button, you can search the web for tables. The search is smart enough to recognize table tags in HTML and pull in table data from random web pages. Nice.

With all of the new analytics tools on the market, I’m pleased that Microsoft is continuing to evolve Excel to keep pace with the big data explosion. After all, while Excel has its limitations, it’s a familiar analytics tool to millions of people, and anything that reduces the big data learning curve and makes people productive more quickly is a very good thing.

Good move Microsoft (did I really just say that?).

Hortonworks Sandbox is a personal, portable Apache Hadoop® environment that comes with dozens of interactive Hadoop and it's ecosystem tutorials and the most exciting developments from the latest HDP distribution, brought to you in partnership with Hortonworks.


Published at DZone with permission of Bootstrap Marketing , DZone MVB .

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}