Excel 2013: An Analytics Superhub
Offered By: Pluralsight
Course Description
Overview
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.
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.
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.
Syllabus
- Introduction 3mins
- Excel as a BI Tool 9mins
- Data Management and Modeling: Core Excel and the Excel Data Model 40mins
- Data Management and Modeling: PowerPivot 34mins
- Data Discovery and Visualization: Power View 21mins
- Data Acquisition: "Data Explorer" 28mins
- Mapping: "GeoFlow" 21mins
- How SharePoint Ties In 14mins
- Wrap-Up 8mins
Taught by
Andrew Brust
Related Courses
Intro to Hadoop and MapReduceCloudera via Udacity Processing Big Data with Hadoop in Azure HDInsight
Microsoft via edX Implementing Real-Time Analytics with Hadoop in Azure HDInsight
Microsoft via edX Hadoop Platform and Application Framework
University of California, San Diego via Coursera Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera