55157-A: SharePoint 2016 Business Intelligence Course Overview

To successfully undertake the 55157-A: SharePoint 2016 Business Intelligence course, participants should have the following minimum prerequisites:

• Basic understanding of SharePoint environment and functionality.
• Familiarity with Microsoft Office applications, particularly Excel.
• Some experience with data manipulation and visualization using Excel.
• An understanding of basic database concepts, including tables and simple queries.
• A general awareness of business intelligence concepts and the desire to learn how SharePoint can facilitate BI solutions.
• Access to a SharePoint 2016 environment for hands-on activities (if necessary for the course structure).

Please note that while having a background in IT is beneficial, the course is designed to introduce SharePoint Business Intelligence services and features, so foundational knowledge in SharePoint and Excel is more critical.

Target Audience for 55157-A: SharePoint 2016 Business Intelligence

The course 55157-A: SharePoint 2016 Business Intelligence is designed for professionals looking to leverage SharePoint for advanced BI solutions.

• Business Intelligence Analysts
• Data Analysts
• SharePoint Administrators
• BI Developers
• IT Professionals responsible for BI implementations
• Data Architects
• Business Analysts
• System Integrators
• Database Professionals looking to integrate with SharePoint
• Performance Management Professionals
• Report Designers and Developers
• Power BI Developers

Learning Objectives - What you will Learn in this 55157-A: SharePoint 2016 Business Intelligence?

Introduction to Course Learning Outcomes

This course empowers participants with a comprehensive understanding of SharePoint 2016 Business Intelligence capabilities, enabling them to configure, utilize, and integrate various BI services and tools within SharePoint for enhanced data visualization and analysis.

Learning Objectives and Outcomes

• Understand the scope and capabilities of SharePoint BI services and features, including Excel and Visio Services, PowerPivot, Power View, Reporting Services, and PerformancePoint Services.
• Configure SharePoint sites to leverage BI tools, including setting up BI Center sites and integrating BI features into existing team sites.
• Utilize Excel Services for sharing, viewing, and interacting with Excel workbooks in SharePoint, including data refresh and farm configuration options.
• Implement Visio Services to share and connect Visio diagrams with data, enhancing visual representation within SharePoint.
• Manage PowerPivot for SharePoint to create powerful data models, configure data refresh options, and use the PowerPivot Gallery for data analysis.
• Create interactive, data-driven reports with Power View in SharePoint, and understand the configuration of data sources for these reports.
• Integrate SQL Reporting Services with SharePoint, set up report libraries, and manage subscriptions, alerts, and the Report Viewer Web Part.
• Develop and deploy PerformancePoint dashboards, scorecards, and KPIs to create rich, interactive business intelligence content.
• Configure SharePoint lists and libraries to support PerformancePoint content and interactivity for advanced data visualization.
• Explore how Power BI complements SharePoint, and learn to work with Power BI features for a comprehensive BI strategy within the SharePoint ecosystem.