Planning & Configuration

SQL Server 2014    |    Expert
  • 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

BOOK SAP Analytics Cloud
COURSE Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Likes 239 Likes 239  
COURSE Integration, Features, & Installation
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE T-SQL Queries
Likes 173 Likes 173  
BOOK Power Pivot and Power BI: The Excel User's Guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016, 2nd Edition