Planning & Configuration

SQL Server 2014
  • 12 Videos | 1h 11m 19s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
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

  • Playable
    1. 
    Planning Schedules for Report Processing
    6m 59s
    UP NEXT
  • Playable
    2. 
    Planning Security for Report Processing
    4m
  • Locked
    3. 
    Creating and Managing Schedules in Native Mode
    7m 47s
    FREE ACCESS
  • Locked
    4. 
    Creating and Managing a Schedule in SharePoint
    4m 28s
    FREE ACCESS
  • Locked
    5. 
    Planning Data Refresh for PowerPivot
    6m 56s
    FREE ACCESS
  • Locked
    6. 
    Configuring Data Refresh for PowerPivot
    5m 41s
    FREE ACCESS
  • Locked
    7. 
    Setting Processing Options for Reports
    5m 22s
    FREE ACCESS
  • Locked
    8. 
    Planning a Subscription Strategy
    4m 54s
    FREE ACCESS
  • Locked
    9. 
    Creating a Subscription for SSRS in Native Mode
    4m 33s
    FREE ACCESS
  • Locked
    10. 
    Creating a Subscription for SSRS in SharePoint Mode
    5m 18s
    FREE ACCESS
  • Locked
    11. 
    Planning for Data Alerts
    4m 12s
    FREE ACCESS
  • Locked
    12. 
    Creating a Data Alert
    6m 8s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Managing Reporting Services
Likes 14 Likes 14  
COURSE Business Reporting: Visualizing & Merging Data in Power BI
Likes 33 Likes 33  
COURSE Designing Reports & Creating Datasets
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Warehouse Essential: Concepts
Likes 85 Likes 85  
COURSE Extract, Transform, & Load
Likes 57 Likes 57  
COURSE BI Reporting & Analysis
Likes 52 Likes 52