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

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, t

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Excel as a BI Tool
        ◦ Excel's Ubiquity and Strategic Importance for BI
        ◦ Excel Analytics Facilities and Workflow
    ● Data Management and Modeling: Core Excel and the Excel Data Model
        ◦ Core Excel BI
        ◦ Office Data Connections
        ◦ Analysis Services Support
        ◦ The Excel Data Model
        ◦ The BI Semantic Model
    ● Data Management and Modeling: PowerPivot
        ◦ Features Overview
        ◦ Obtaining the Add-In, Data Import
        ◦ Advanced Modeling
    ● Data Discovery and Visualization: Power View
        ◦ Overview
        ◦ Creating Reports
        ◦ Maximize, Filters and Bubble Charts
        ◦ Advanced Properties
    ● Data Acquisition: "Data Explorer"
        ◦ Overview, Data Sources and Tie-Ins with Excel Data Model
        ◦ Data Shaping, Data Manipulation and Integrating Child Data
        ◦ Data Formulas, Scripts and the 'M' langauge
    ● Mapping: "GeoFlow"
        ◦ Overview and First Steps
        ◦ Chart Types, Controls and Visual Elements
        ◦ Layers, Scenes and Tours
    ● How SharePoint Ties In
        ◦ Overview and Excel Services/Excel Web App
        ◦ PowerPivot and Power View
        ◦ PerformancePoint/Reporting Services, Analysis Services Clients
    ● Wrap-Up
        ◦ Review
        ◦ Upsides, Downsides, Reference Links

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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

Back to Top