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

Applied Excel and Analysis Services

Course Summary

Use the Excel BI capabilities to unlock the power of Analysis Services models

  • +

    Course Syllabus

    • Introduction
      • Course Introduction
      • Introducing Business Intelligence
      • Introducing Analysis Services
      • Why BI with Excel?
      • Creating Excel Reports Connected to Analysis Services
    • Creating PivotTable Reports
      • Excel as Analysis Services Client
      • Connecting to Analysis Services
      • Understanding PivotTable Reports
      • Understanding the PivotTable Field List
      • Configuring PivotTable Reports
      • Creating Basic PivotTable Reports
      • Drilling Down Data
      • Filtering and Sorting Data
      • Modifying the Report Design and Appearance
      • Working with Actions
      • Using Excel OLAP Features
    • Creating PivotChart Reports
      • Understanding PivotChart Reports
      • Configuring PivotChart Reports
      • Working with Data Series
      • Drilling Down Data
      • Filtering and Sorting Data
      • Working with Actions
      • Working with OLAP Features
      • Creating Dashboards
      • Working with Slicers
    • Creating Power View Reports
      • Understanding Power View
      • Creating Tabular Visualizations
      • Creating Chart Visualizations
      • Performing Geospatial Analysis
      • Filtering Data
    • Sharing Reports
      • Introducing SharePoint Insights
      • Working with Shared Connections
      • Publishing Reports
      • Viewing Reports
      • Summary

Course Fee:
USD 99

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