NEED HELP? TALK TO AN EXPERT (904) 638-5743

SharePoint for Business Intelligence

Part Of The On-Demand Courses

WHAT YOU'LL 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

 

This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course 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.

 

Click here for downloadable PDF

Outline

 

Module 01 | Architecting a SharePoint Environment
22m 24s total

 

Module 01A | Architecting a SharePoint Environment
22m 24s

 

Module 02 | Configuring SharePoint for Business Intelligence
86m 26s total

 

Module 02A | Configuring SharePoint for Business Intelligence
86m 26s

 

Module 03 | Working With Excel Services
60m 19s total

 

Module 03A | Working With Excel Services
60m 19s

 

Module 04 | Creating a Power Pivot Model
73m 45s total

 

Module 04A | Creating a Power Pivot Model
73m 45s

 

Module 05 | Reporting Off a Power Pivot Model
19m 42s total

 

Module 05A | Reporting Off a Power Pivot Model
19m 42s

 

Module 06 | Power Pivot in SharePoint
18m 22s total

 

Module 06A | Power Pivot in SharePoint
18m 22s

 

Module 07 | Working With Power View in SharePoint
53m 08s total

 

Module 07A | Working With Power View in SharePoint
53m 08s

 

Module 08 | Getting Started With PerformancePoint
12m 13s total

 

Module 08A | Getting Started With PerformancePoint
12m 13s

 

Module 09 | Creating PerformancePoint Content
109m 34s total

 

Module 09A | Creating PerformancePoint Content
109m 34s

 

Module 10 | Creating a PerformancePoint Dashboard
124m 23s total

 

Module 10A | Creating a PerformancePoint Dashboard
124m 23s

 

Module 11 & 12 | SQL Server Reporting Services in SharePoint
31m 24s total

 

Module 11 & 12A | SQL Server Reporting Services in SharePoint
31m 24s

 

Module 13 | Branding Your SharePoint Site
01m 22s total

 

Module 13A | Branding Your SharePoint Site
01m 22s

Instructor

MITCHELL PEARSON

Pragmatic Works Trainer 

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

 

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

What to Know Before 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.

REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required