Overview of the Microsoft Business Intelligence Stack
- Introducing Business Intelligence
- Databases, data warehouses and OLAP cubes
- What is Analysis Services
- Querying relational and OLAP data sources: a brief peek in SQL, MDX and DAX
SharePoint Business Intelligence Center
- SharePoint storage: Web applications, Sites and lists
- What are Service applications?
- Creating a Business Intelligence Center site
- Exploring the BI Center site
Business Connectivity Services
- Overview of the BCS architecture
- Creating External Content Types with SharePoint Designer
- Connecting to databases and OData services
- Working with External Lists to support CRUD operations on your data in SharePoint
- Overview of Excel Services
- Learn how to publish Excel BI workbooks to Excel Services
- Configure and secure Shared Data Connections
- Configure Excel Services security
- Use the Excel Services Web Part
- Learn how to access the Excel Services REST-full API
- Excel Services and the Filter Web Parts
PowerPivot for Excel and SharePoint
- PowerPivot Overview.
- What is the role of PowerPivot in the Microsoft BI world?
- Overview of PowerPivot for Excel and PowerPivot for SharePoint.
- Setup of PowerPivot For SharePoint .
Reporting Services and SharePoint
- Configure Reporting Services to run in SharePoint Integrated mode.
- Setup Reporting Services security in Integrated Mode.
- How to deploy Reports to Reporting Services in Integrated Mode.
- Reporting Services Web Part.
- Combining Reporting Services Web Part and the Filter Web Part.
- Configuring Visio Services.
- Visio Services Authentication.
- Publish Visio BI Maps to Visio Services.
- Connecting Visio Shapes to data.
Introducing PerformancePoint Services
- Operation management and Balanced Scorecards
- The need for Dashboards and Scorecards
- Explore PerformancePoint Dashboard and Scoreboard Designer
- PerformancePoint Document library
PerformancePoint Services Data Sources
- OLAP versus non-OLAP data sources
- Analysis Services data source
- Simple Time Period Specification (STPS)
- Tabular data sources
- Deploying data sources to SharePoint
Developing Indicators, KPIs and Filters
- Exploring the build-in indicators
- Creating custom indicators
- Key Perormance Indicators
- Configuring KPI setting
- Importing Analaysis Services KPIs in PerformancePoint
- Create Filters and add Time Intelligence To PerformancePoint
From KPIs to DashBoards
- Reports in PerformancePoint
- Using Excel services reports
- Using Reporting services reports
- Combining KPIs into scorecards
- Linking scorecards, filters and reports into dashboards
- Deploying versus publishing dashboards
- From personal BI to corporate BI
- Introducing PowerView in SharePoint
Authoring PowerView reports
- Create tables and charts
- Interactive sorting, filtering and highlighting
- Working with multi-view reports
- Exporting to PowerPoint
This instructor-led course will provide you with the knowledge and skills to develop Business Intelligence solutions on SharePoint Server 2013 with SQL Server. SharePoint 2013 Business Intelligence lets everyone access the business
information they need to make good decisions. With powerful features such as interactive
dashboards and scorecards they can work naturally and confidently, using well-known
interfaces: Reporting Services, PerformancePoint, Visio and Excel.
This course is not only targeting Business Intelligence developers who would like
to know the benefits of using SharePoint Server as a Business Intelligence
platform but also SharePoint architects, developers or power users who are interested
in all the SharePoint Server Business Intelligence features.
Attendees should have a basic knowledge of Microsoft SQL Server (using Management Studio, querying tables)
and have some hands-on experience with Excel 2007 or later.