Excel: An Analytics Superhub
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction- 3m 31s
—Introduction 3m 31sExcel as a BI Tool- 9m 2s
—Excel's Ubiquity and Strategic Importance for BI 3m 55s
—Excel Analytics Facilities and Workflow 5m 7sData Management and Modeling: Core Excel and the Excel Data Model- 40m 35sData Management and Modeling: PowerPivot- 34m 23sData Discovery and Visualization: Power View- 21m 14sData Acquisition: "Data Explorer"- 28m 55sMapping: "GeoFlow"- 21m 28sHow SharePoint Ties In- 14m 38sWrap-Up- 8m 59s