Microsoft business intelligence performancepoint

Use PerformancePoint Services. Use Business Connectivity Services. Use Excel Services. Use Visio Services. Use PowerPivot. Prerequisites Before attending this course, students must have: An understanding of the benefits of business intelligence. Before attending this course, students must have: An understanding of the benefits of business intelligence.

Course outline Module 1: Course Overview This module explains how the class will be structured and introduces course materials and additional administrative information. Have a full understanding of what the course intends to cover. Module 1: Course Overview This module explains how the class will be structured and introduces course materials and additional administrative information. Browse data using Visual Studio Connect to a tabular source, import tables, and explore the data.

Create a new web application and business intelligence site while exploring the features of both. Create an Excel workbook with a parameter and save it to a SharePoint document library. Create and configure a standard KPI and a scorecard. Create and configure a leaf KPI and a new scorecard. Create and configure an analytic chart and an analytic grid, then add them to a dashboard, deploy them to SharePoint, and explore the options available.

Create and configure a filter, and then tie the filter into both the analytic chart and analytic grid created earlier. Create and configure a cascading filter and then tie it into a new analytic chart and grid.

Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Browse All Sessions. Prerequisites Basic knowledge of SharePoint navigation and functionality.

Basic knowledge of data modeling would be helpful but not required for students in this course. Basic knowledge of SharePoint navigation and functionality. Use Excel Services Web Part. Configure basic Excel services. Refresh data sources. The Report Viewer component is no longer needed.

Reporting Services in SharePoint deployment mode includes all of the web-front-end components required. The Secure Store Service must be configured in the farm if you want to use a Secure Store target application for data refresh scenarios, or if you want to use an Office Data Connection ODC file that specifies a Secure Store target application.

When it is enabled, all connections to Analysis Services data for individual users will be made by using the EffectiveUserName connection string property instead of Windows delegation. If you plan to use Excel Services with advanced data models, at least one Analysis Server in SharePoint mode must be registered in the Excel Services configuration.

The Secure Store Service must be configured in the farm if you want to store encrypted credentials for data refresh scenarios, or if you want to use the Excel Services unattended service account.