Duration: 3 Days
In this course, you will learn to use SharePoint 2013 as your business
intelligence (BI) platform. You'll learn how to implement solutions using the
SharePoint Business Intelligence Center, Excel Services, SQL Reporting Services,
Analysis Services, PerformancePoint, PowerPivot, Power View, Business
Connectivity Services, and the KPI and chart web parts.
Through hands-on labs that re-enforce class topics, you will gain the skills
needed to successfully create impressive dashboards, reports, and other BI
solutions. You'll learn best practices for implementing SharePoint BI solutions
and practical ideas for implementing the solutions within you organization.
Companies today generate enormous amounts of valuable information, but often
have poor reporting capabilities - inhibiting the sharing of key information.
You will learn how to provide executives, managers, and your entire staff with
insights into your data through state-of-the-art BI built on the SharePoint 2013
platform. You'll learn to make better decisions and provide strategic
information to the entire organization with the solutions you build.
What You Will Learn
- SharePoint 2013's full
feature set of business intelligence features
- Excel Services and how to build Excel Services solutions
- Integrate SQL Reporting Services with SharePoint to build dynamic reports and
share information
- Surface
Analysis Services cubes via SharePoint BI features
- Implement scorecards, dashboards, and KPIs using PerformancePoint
- Capabilities of PowerPivot and how to analyze data with PowerPivot
- Integrate data from many different external data sources utilizing Business
Connectivity Services
- Implement out-of-box BI web parts, including KPI and chart web parts
- Build interactive dashboards that support filtering, reports, KPIS, scorecards,
and more
- Best practices
for implementing effective, high-performing BI solutions
- Business Intelligence Center template provides and when to use it
- Provide intuitive ad-hoc reporting for business users by implementing Power View
- SQL Server Business
Intelligence Development Studio
- Benefits and limitations of each BI tool and which ones will work best for your
needs
Audience
- Basic understanding of the SharePoint user interface
- 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
Prerequistes
Course Outline
1.
What is Business Intelligence
- Who is your audience?
- Where is your data?
- How do
I present my data?
- Changes
from SharePoint 2010 to SharePoint 2013
- Server requirements
- Licensing options and requirements
2.
Business Intelligence Center
- SharePoint hierarchy
- Purpose and functionality of the Business Intelligence Center
- BI option in SharePoint
- SSRS
- Power View
- KPI and chart web parts
- Excel Services
- PowerPivot
- Visio
Services
- PerformancePoint
- Business Connectivity Services
- Data security
- Managed accounts
- Unattended service account
- Office authentication options
3.
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
4.
Power View
- Power View
designer and components
- Filtering, highlighting, and slicers
5.
KPI Web Part, Filter Web Part, and Chart Web Part
- Key Performance Indicators (KPIs)
- Charts
- Filters
6.
Excel Services
- Developing
Excel Services reports
- Data sources
- Displaying data
- Deploying
Excel Services reports
- Administering Excel Services
- Creating an Excel Services
application
- Enabling Excel Services
- Configuring Excel Services
7.
PowerPivot
- Creating a
PowerPivot gallery
- Developing a PowerPivot report
- Enabling and configuring data refreshes
8.
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
9.
PerformancePoint Services
- PerformancePoint
- Developing analytics reports
- Developing scorecards
- Developing dashboards
- Administer PerformancePoint Services
- Enabling
PerformancePoint Services
- Configuring security,
reporting, and caching options
10.
Business Connectivity Services
- Configuring external data connections with SharePoint Designer
- Administering Business Connectivity Services
Exercises:
Exercise 1: Configure a Business Intelligence Center
Exercise 2: Create
SharePoint pages and using web parts
Exercise 3: Develop reports with Report
Builder
Exercise 4: Build interactive dashboard with SSRS and SharePoint
Exercise 5: Create basic Power View Reports
Exercise 6: Analyze data with
Power View
Exercise 7: Filter SSRS dashboards with filter web parts
Exercise 8: Display a KPI status list in SharePoint
Exercise 9: Use the
chart web part
Exercise 10: Sales dashboard using Excel and Excel Services
Exercise 11: Create a PowerPivot report
Exercise 12: Create a Visio
Diagram utilizing Visio Services
Exercise 13: Develop PerformancePoint
reports, scorecards, and dashboards
Exercise 14: Integrate external database
data into SharePoint
Course Labs
