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

Configuring SharePoint 2013 for Business Intelligence

Course Summary

SharePoint has many Business Intelligence (BI) tools to help you make informed business decisions quickly and accurately, but getting them all to work properly can be an intimidating task. With this course, you will chart your way through the treacherous

  • +

    Course Syllabus

    ● Configuring the Secure Store Service
        ◦ Intro
        ◦ Create the Service Application
        ◦ Generate the Secure Store Key
        ◦ Summary
    ● Create a Business Intelligence Center
        ◦ Intro
        ◦ Create the BI Site Collection
        ◦ Test the Sample Workbook
        ◦ Summary
    ● Excel Services
        ◦ Intro
        ◦ Create the Excel Services Service App
        ◦ Grant Database Access
        ◦ Suppress OWA
        ◦ Test Excel Services
        ◦ Summary
    ● Install SQL Server Analysis Service
        ◦ Intro
        ◦ Install SSAS
        ◦ Attach the Database
        ◦ Add the Service Account Login
        ◦ Add a Multidimensional Data Cube
        ◦ Configure the Firewall
        ◦ Test Analysis Services
        ◦ Summary
    ● Data Refresh and the Unattended Service Account
        ◦ Intro
        ◦ Data Refresh
        ◦ Create a New Target Application
        ◦ Configure Excel to Use the Secure Store
        ◦ Add the Service Account Login
        ◦ Test the Data Refresh
        ◦ Give the Target Application to the SSAS Cube
        ◦ Test Data Refresh with a SSAS Cube
        ◦ Summary
    ● Install and Configure PowerPivot for SharePoint
        ◦ Intro
        ◦ Install SQL Server PowerPivot for SharePoint
        ◦ Add PowerPivot to Excel Services
        ◦ Run the PowerPivot for SharePoint Configuration Wizard
        ◦ Resolve Configuration Errors
        ◦ The PowerPivot Service Application
        ◦ Test PowerPivot
        ◦ Create the PowerPivot Gallery
        ◦ Grant the APP Pool Permissions to SSAS
        ◦ Test the PowerPivot Gallery
        ◦ Summary
    ● SQL Server Reporting Services
        ◦ Intro
        ◦ Installing SQL Server Reporting Services
        ◦ Create the SSRS Service App
        ◦ Create a SSRS Report Library
        ◦ Test SQL Server Reporting Services
        ◦ Summary
    ● Power View for SharePoint 2013
        ◦ Intro
        ◦ Activate Power View
        ◦ Create a Power View Visualization
        ◦ Summary
    ● PerformancePoint Services
        ◦ Intro
        ◦ Configure PerformancePoint Services (PPS)
        ◦ Configure PPS to use the Secure Store
        ◦ Create a Data Source
        ◦ Create a Report
        ◦ Create a Dashboard
        ◦ Add a Report to a Dashboard and Deploy to SharePoint
        ◦ Summary
    ● Access Services 2013
        ◦ Intro
        ◦ About Access Services
        ◦ Install SQL Server for Access Services
        ◦ Configure SQL Server
        ◦ Create the Access Service App and App Pool
        ◦ Service Account Permissions
        ◦ Configure IIS
        ◦ Create a Custom Web App
        ◦ Summary
    ● Visio Graphics Services
        ◦ Intro
        ◦ Create a Target Application
        ◦ Create the Service Application
        ◦ Add the Target Application to Visio Services
        ◦ Create a Visio Web Drawing
        ◦ Summary


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