Excel: An Analytics Superhub

A look at the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, "Data Explorer" and "GeoFlow," as well as an investigation into how to use these tools together.
Course info
Rating
(302)
Level
Intermediate
Updated
June 12, 2013
Duration
3h 2m
Table of contents
Introduction
3m 31s
Wrap-Up
8m 59s
Description
Course info
Rating
(302)
Level
Intermediate
Updated
June 12, 2013
Duration
3h 2m
Description

This course goes through how to use Excel as an analytics client for BI and Big Data. With coverage applicable to several versions of Excel, but with emphasis on the new capabilities of Excel 2013, the content includes details on, and numerous demos of, the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, and preview add-ins code-named "Data Explorer" and "GeoFlow." This course provides great detail on each tool and shows how they can be used in combination, as well as, with data from HDInsight/Hadoop; Microsoft's Big Data Platform. Tie-ins to SharePoint are discussed and integration with Office 365 is demoed.

About the author
About the author

Andrew Brust is Senior Director of Technical Product Marketing and Evangelism at Datameer, and writes about Big Data for the technology news site, ZDNet. Andrew is the co-author of "Programming Microsoft SQL Server 2012" (Microsoft Press); an advisor to NYTECH, the New York Technology Council; serves as Microsoft Regional Director and MVP; writes the Redmond Review column for VisualStudioMagazine.com; and serves as co-chair of the Visual Studio Live! developer conference.

More from the author
Big Data on Amazon Web Services
Intermediate
3h 54m
30 Jan 2015
SQL Big Data Convergence - The Big Picture
Intermediate
1h 21m
7 Mar 2013
Big Data: The Big Picture
Intermediate
1h 28m
31 Oct 2012
More courses by Andrew Brust