Create a Time Intelligence data connection, a Time Intelligence filter, and create a report using both.Create and configure a cascading filter and then tie it into a new analytic chart and grid.Create and configure a filter, and tie the filter into both the analytic chart and analytic grid created earlier.Create and configure an analytic chart and an analytic grid, add them to a dashboard, deploy them to SharePoint, and explore the options available.PerformancePoint Services Dashboard Designer Introduction and Data Source Configuration.Lab 1: SharePoint 2013 PerformancePoint 2013 New 2013 Overview of PerformancePoint Services.Dashboard Designer is explored along with many of the objects and connections available within.
In this module, we will give you an overview of the new 2013 PerformancePoint Services features. Module 5: SharePoint 2013 PerformancePoint 2013 Utilize the Power View add-in for Excel.Save and Share an Excel Workbook to a SharePoint Document Library.Exploring the Power View Add-in for Excel.Creating a Library to Hold Excel Workbooks.SharePoint Libraries to Store Workbooks.There is coverage of the Power View add-in for Excel, and then lastly we will explain the save and share the process and have a look at best practices. We will cover Excel Web Access and it’s capabilities along with any differences you may encounter in the browser as opposed to the desktop client. In this module, we will go over all the new 2013 Excel Services features, and we will explore the core components of Excel Services. SharePoint 2013 Business Intelligence Center (Optional).Lab 1: SharePoint 2013 Business Intelligence Center Included Document Library and List Apps.New 2013 SharePoint Central Administration.Permissions and Roles will be illuminated and the included Document Library and List apps will be explained. We are also going to cover some things that generically apply to SharePoint that you can use within business intelligence.
We are going to cover specifically the new 2013 Business Intelligence Center template within SharePoint. In this module, we will explore the new and improved 2013 SharePoint Central Administration site. Module 3: SharePoint 2013 Business Intelligence Center New 2013 SharePoint Business Intelligence Features.
PowerPivot is covered in more detail in a later module. Finally, we will take a brief look at PowerPivot, examining the new features and their significance. In this section, we will also cover the new business intelligence features available within the SharePoint 2013 release. We will then move to SharePoint 2013 and look at the SharePoint services to examine their relevance and how we can use them in business intelligence to surface data. Then, we’re going to look at the services SQL 2012 provides us and how they apply to business intelligence. In this module we will first look at the three different ways in which business intelligence can be viewed. Module 2: The Business Intelligence Stack
Explore the Dashboard Designer interface and know how to create and configure a data source.Create an Excel workbook with a parameter and save it to a SharePoint document library.Utilize the Power View add-in for Excel.Create a SharePoint library to hold Excel workbooks and explore trusted file locations.Create a new web application and business intelligence site while exploring the features of both.Explore the options and settings available within the new SharePoint 2013 Central Administration.Connect to a tabular source, import tables, and explore the data.Browse the data within the cube using SQL Server Management Studio.As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.Īfter completing this Microsoft business intelligence certification course, students will be able to: The focus of this Microsoft business intelligence certification course is on the SharePoint 2013 business intelligence platform and not on the SQL business intelligence services.