fbpx

Training

HomeOn-Demand LearningSQL Server Business IntelligenceSharePoint for Business Intelligence

SharePoint for Business Intelligence

$195.00

What Will You Learn?

  • To architect and configure SharePoint for Business Intelligence
  • How to work with Excel services and Power View
  • How to create and report off a Power Pivot model
  • How to create PerformancePoint content and a PerformancePoint dashboard

Description

This course will help you learn how to use SharePoint to bring business intelligence to the forefront for your users and customers. This class is built to take your SharePoint BI knowledge to the next level. Hands-on labs will reinforce the concepts learned and help familiarize you with the tools in an actual SharePoint environment. Topics covered include basic SharePoint server architecture, Excel, Power Pivot, Power View, PerformancePoint, SQL Server Reporting Services 2012 and site branding.

Instructor

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

What to Know Before the Class

Very little time is spent in the class ramping-up students on the basics of Reporting Services and general cube concepts. End-user experience with SharePoint is beneficial.

Curriculum For This Course

System Requirements

  • Windows Server 2008 R2 or Windows Server 2012
  • 4GB of RAM Minimum (6GB or more recommended)
  • 40 GB of free hard drive space
  • SharePoint 2010 SP1 or Later Enterprise Edition (SharePoint 2013 recommended) with the following configured:
    • Excel Services
    • PerformancePoint Services
    • Reporting Services
    • Secure Store Service
    • Power Pivot
  • SQL Server Developer or Enterprise Edition 2012/2014
    • SQL Server Database Engine
    • SQL Server Reporting Services – Sharepoint
    • SQL Server Reporting Services Add-in For SharePoint Products
    • SQL Server Analysis Services Multidimensional
    • SQL Server Power Pivot for SharePoint
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
  • Microsoft Excel 2010 or later with Power Pivot add-on installed
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • AdventureWorks Cube installed on the Analysis Services instance

You may also like…