Logo

Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863

ASP-SP13BI

SharePoint 2013 for Business Intelligence

Alert Me

Outline

Lesson 1: What is Business Intelligence What Is Business Intelligence
  • Who is your Audience?
  • Where is your Data?
  • How Do I Present My Data?
What's New in Business Intelligence Changes from SharePoint 2010 to SharePoint 2013 Server Requirements Licensing Options and Requirements Lesson 2: The Business Intelligence Center Understanding the SharePoint Hierarchy Purpose and Functionality of the Business Intelligence Center Overview of BI Option in SharePoint
  • SSRS
  • Power View
  • KPI and Chart Web Parts
  • Excel Services
  • PowerPivot
  • Visio Services
  • PerformancePoint
  • Business Connectivity Services
Data Security Overview
  • Managed Accounts
  • Unattended Service Account
  • Office Authentication Options
Lesson 3: SQL Reporting Services Introduction to SQL Reporting Services SSRS Integration with SharePoint Developing Reports with Report Builder
  • Defining Data Sources and Data Sets
  • Report Design: Basics
  • Report Design: Adding Interactivity and Parameters
Deploying and Managing Reports
  • Administering Reporting Services
  • Report Caching and Execution
  • Managing Snapshots and Report History
  • Utilizing SharePoint SSRS Web Part
Lesson 4: Power View Introduction to Power View Power View Designer and Components Filtering, Highlighting and Slicers Lesson 5: KPI web part, Filter web part & Chart web part Key Performance Indicators Charts Filters Lesson 6: Excel Services Introduction to Excel Services Developing Excel Services Reports
  • Data Sources
  • Displaying Data
Deploying Excel Services Reports Administer Excel Services
  • Creating an Excel Services Application
  • Enabling Excel Services
  • Configuring Excel Services
Lesson 7: PowerPivot Introduction to PowerPivot Creating a PowerPivot Gallery Developing a PowerPivot Report Enabling and Configuring Data Refreshes Lesson 8: Visio Services Introduction to Visio Services Developing Visio Services Diagrams Deploying Visio Services Diagrams Administer Visio Services
  • Creating a Visio Services Application
  • Enabling Visio Services
  • Configuring Security, Reporting, and Caching
Lesson 9: PerformancePoint Services Introduction to PerformancePoint Developing Analytics Reports Developing Scorecards Developing Dashboards Administer PerformancePoint Services
  • Enabling PerformancePoint Services
  • Configuring Security, Reporting, and Caching Options
Lesson 10: Business Connectivity Services Introduction to Business Connectivity Services Configuring External Data Connections with SharePoint Designer Administer Business Connectivity Services Lesson 11: Summary Choosing the Right Tool for the Job Hands-On Exercises:
Exercise 1: The Business Intelligence Center
  • Configure a Business Intelligence Center
  • Creating SharePoint Pages and using Web Parts
Exercise 2: SQL Reporting Services
  • Developing Reports with Report Builder
  • Build Interactive Dashboard with SSRS and SharePoint
Exercise 3: Power View
  • Creating basic Power View Reports
  • Analyzing Data with Power View
Exercise 4: KPI web part, Filter web part & Chart web part
  • Filtering SSRS Dashboards with Filter Web Parts
  • Displaying a KPI Status List in SharePoint
  • Using the Chart Web Part
Exercise 5: Excel Services
  • Sales Dashboard using Excel and Excel Services
  • PowerPivot
  • Creating a PowerPivot Report
  • Visio Services
  • Creating a Visio Diagram utilizing Visio Services
Exercise 6: PerformancePoint Services
  • Develop PerformancePoint Reports, Scorecards, and Dashboards
Exercise 7: Business Connectivity Services
  • Integrating external database data into SharePoint

Audience

Basic understanding of the SharePoint user interface and a basic understanding of database reporting tools. This course will benefit:
  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • SharePoint Developers and Administrators
  • Anyone responsible for implementing BI with SharePoint
$1995.00 List Price

3 Days Course

Class Dates

Request a Date or a Private Class below.


MAX Educ. Savings
Categories: , , Tags: ,
Loading ...