Planning & Configuration

SQL Server 2014    |    Expert
  • 12 videos | 1h 6m 19s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 20 users Rating 4.5 of 20 users (20)
Used together, SharePoint and SSRS can provide a powerful report delivery system. Discover how to plan, create, and manage an effective report processing and delivery system for your BI solution.

WHAT YOU WILL LEARN

  • Describe the two types of schedules, what you can accomplish with them, and how they work
    Describe the requirements for security for report processing and scheduling, including credentials for data sources and accounts
    Create and manage a schedule for reporting services in native mode using report manager
    Create and manage a schedule for reporting services in sharepoint mode using central administration
    Plan for data refresh for powerpivot in sharepoint, including security
    Configure data refresh schedules for powerpivot published to sharepoint and perform an interactive refresh
  • Set different processing options for reports in a sharepoint library, including caching, time-out, history options and limits, and database time-out options
    Plan a subscription strategy for report delivery
    Create a subscription for report servers in native mode
    Create a subscription for report servers in sharepoint mode to deliver a report to a library
    Describe what data alerts are and how to use them
    Create a data alert for a report in a sharepoint library

IN THIS COURSE

  • 6m 59s
    After completing this video, you will be able to describe the two types of schedules, what you can accomplish with them, and how they work. FREE ACCESS
  • 4m
    After completing this video, you will be able to describe the requirements for security for report processing and scheduling, including credentials for data sources and accounts. FREE ACCESS
  • Locked
    3.  Creating and Managing Schedules in Native Mode
    7m 47s
    In this video, you will create and manage a schedule for Reporting Services in native mode using the Report Manager. FREE ACCESS
  • Locked
    4.  Creating and Managing a Schedule in SharePoint
    4m 28s
    During this video, you will learn how to create and manage a schedule for Reporting Services in SharePoint mode using the SharePoint Central Administration site. FREE ACCESS
  • Locked
    5.  Planning Data Refresh for PowerPivot
    6m 56s
    In this video, find out how to plan for data refresh for PowerPivot in SharePoint, including security. FREE ACCESS
  • Locked
    6.  Configuring Data Refresh for PowerPivot
    5m 41s
    In this video, learn how to configure data refresh schedules for PowerPivot published to SharePoint and perform an interactive refresh. FREE ACCESS
  • Locked
    7.  Setting Processing Options for Reports
    5m 22s
    Learn how to set different processing options for reports in a SharePoint library, including caching, time-out, history options and limits, and database time-out options. FREE ACCESS
  • Locked
    8.  Planning a Subscription Strategy
    4m 54s
    Find out how to plan a strategy for report delivery. FREE ACCESS
  • Locked
    9.  Creating a Subscription for SSRS in Native Mode
    4m 33s
    In this video, you will learn how to create a subscription for Report Servers in native mode. FREE ACCESS
  • Locked
    10.  Creating a Subscription for SSRS in SharePoint Mode
    5m 18s
    In this video, learn how to create a subscription for Report Servers in SharePoint mode to deliver a report to a document library. FREE ACCESS
  • Locked
    11.  Planning for Data Alerts
    4m 12s
    After completing this video, you will be able to describe what data alerts are and how to use them. FREE ACCESS
  • Locked
    12.  Creating a Data Alert
    6m 8s
    In this video, you will learn how to create a data alert for a report in a SharePoint library. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 60 users Rating 4.3 of 60 users (60)
Rating 4.6 of 1033 users Rating 4.6 of 1033 users (1033)
Rating 4.6 of 18 users Rating 4.6 of 18 users (18)