SharePoint 2013 for Business Intelligence

Total time

SharePoint 2013 for Business Intelligence

American Management Association
Logo American Management Association

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Enable decision makers to see data in new and dynamic ways.Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities—inhibiting the sharing of key data. Now, you can provide insights into that data through state-of-the-art business intelligence solutions built on the SharePoint 2013 platform, lower costs and improve operational efficiency. BI has never been more accessible!

This course is packed with hands-on labs to teach you everything you need to know to implement BI solutions using Excel Services, SQL Reporting Services, Analysis Services, PerformancePoint, Power View, PowerPivot, and other web parts and tools that are part of the Shar…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Business Intelligence (BI), Data Warehouse, Microsoft SQL Server, IT Security, and Web Accessibility.

Enable decision makers to see data in new and dynamic ways.Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities—inhibiting the sharing of key data. Now, you can provide insights into that data through state-of-the-art business intelligence solutions built on the SharePoint 2013 platform, lower costs and improve operational efficiency. BI has never been more accessible!

This course is packed with hands-on labs to teach you everything you need to know to implement BI solutions using Excel Services, SQL Reporting Services, Analysis Services, PerformancePoint, Power View, PowerPivot, and other web parts and tools that are part of the SharePoint platform. You'll create impressive dashboards, reports, and other business intelligence solutions. Leave with the knowledge and everything you need to build an implementation plan. Plus, make better decisions and provide strategic information to the entire organization with the solutions you build.

Also Available as:
  • Live Online
  • Onsite

How You Will Benefit

  • Understand SharePoint's full feature set
  • Find out how to build Excel services solutions
  • Integrate SQL reporting with SharePoint to build dynamic reports and share data
  • Implement scorecards, dashboards, and KPIs using PerformancePoint and implement out-of-the-box BI web parts
  • Analyze data with PowerPivot
  • Integrate data from multiple external sources with business connectivity services
  • Build interactive dashboards that support filtering, reports, KPIS, scorecards and more
  • Learn best practices for implementing effective, high-performing BI solutions
  • Discover how to use the BI center template
  • Implement PowerView and provide intuitive ad-hoc reporting
  • Work with the SQL server BI development studio
  • Visualize your data with engaging, state-of-the-art graphics
  • Enable social decision making through real-time collaboration features

What You Will Cover

  • Understanding business intelligence and changes from SharePoint 2010 to 2013
  • Understanding the BI options and getting a data security overview
  • Developing, deploying and managing reports with report builder
  • Learning Power View designer and components
  • Becoming conversant with KPI web part, filter web part and chart web part
  • Using Excel services to create reports and applications
  • Creating a PowerPivot gallery and report
  • Developing Visio services diagrams
  • Using PerformancePoint services to develop reports, scorecards and dashboards
  • Integrating external data into SharePoint

Extended Seminar Outline

Print this page Extended Seminar Outline Seminar #76012 SharePoint 2013 for Business Intelligence

Course Outline

1. What Is Business Intelligence?

  • Who is your audience?
  • Where is your data?
  • How Do I Present My Data?
  • What's new in business intelligence
  • Changes from SharePoint 2010 to SharePoint 2013
  • Server requirements
  • Licensing options and requirements

2. The Business Intelligence Center

  • Understanding the SharePoint hierarchy
  • Purpose and functionality of the Business Intelligence Center
  • Overview of BI option in SharePoint
    • SSRS
    • Power View
    • KPI and Chart Web Parts
    • Excel Services
    • PowerPivot
    • Visio Services
    • PerformancePoint
    • Business Connectivity Services
  • Data security overview
    • Managed accounts
    • Unattended service account
    • Office authentication options

3. SQL Reporting Services

  • Introduction to 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

  • Introduction to Power View
  • Power View designer and components
  • Filtering, highlighting and slicers

5. KPI web part, filter web part and chart web part

  • KeypPerformance indicators
  • Charts
  • Filters

6. Excel Services

  • Introduction to Excel Services
  • Developing Excel Services reports
    • Data sources
    • Displaying data
  • Deploying Excel Services reports
  • Administer Excel Services
    • Creating an Excel Services application
    • Enabling Excel Services
    • Configuring Excel Services

7. PowerPivot

  • Introduction to PowerPivot
  • Creating a PowerPivot gallery
  • Developing a PowerPivot report
  • Enabling and configuring data refreshes

8. Visio Services

  • Introduction to 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

  • Introduction to PerformancePoint
  • Developing analytics reports
  • Developing scorecards
  • Developing dashboards
  • Administer PerformancePoint Services
    • Enabling PerformancePoint Services
    • Configuring security, reporting, and caching options

10. Business Connectivity Services

  • Introduction to business connectivity services
  • Configuring external data connections with SharePoint Designer
  • Administer business connectivity services

11. Summary

  • Choosing the right tool for the job


Hands-On Exercises:


Exercise 1: The Business Intelligence Center

  • Configure a business intelligence center
  • Creating SharePoint Pages and using web parts

Exercise 2: SQL Reporting Services

  • Developing reports with Report Builder
  • Build interactive dashboard with SSRS and SharePoint

Exercise 3: Power View

  • Creating basic Power View Reports
  • Analyzing data with Power View

Exercise 4: KPI web part, filter web part and chart web part

  • Filtering SSRS dashboards with filter web parts
  • Displaying a KPI status list in SharePoint
  • Using the Chart Web Part

Exercise 5: Excel Services

  • Sales dashboard using Excel and Excel Services
  • PowerPivot
  • Creating a PowerPivot report
  • Visio Services
  • Creating a Visio diagram utilizing Visio Services

Exercise 6: PerformancePoint Services

  • Develop PerformancePoint reports, scorecards, and dashboards

Exercise 7: Business Connectivity Services

  • Integrating external database data into SharePoint


Who Should Attend

Database managers, project managers, business analysts, business intelligence architects and consultants and SharePoint developers and administrators with a basic understanding of the SharePoint interface and database reporting tools will benefit from this course.
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.