MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel: An Analytics Superhub

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 Syllabus

    Introduction
    - 3m 31s

    —Introduction 3m 31s
    Excel as a BI Tool
    - 9m 2s

    —Excel's Ubiquity and Strategic Importance for BI 3m 55s
    —Excel Analytics Facilities and Workflow 5m 7s
    Data Management and Modeling: Core Excel and the Excel Data Model
    - 40m 35s
    Data Management and Modeling: PowerPivot
    - 34m 23s
    Data Discovery and Visualization: Power View
    - 21m 14s
    Data Acquisition: "Data Explorer"
    - 28m 55s
    Mapping: "GeoFlow"
    - 21m 28s
    How SharePoint Ties In
    - 14m 38s
    Wrap-Up
    - 8m 59s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url