Chapter 8. Business Intelligence

In this chapter, we will cover:

• Listing items in your SSRS Report Server

• Listing SSRS report properties

• Using ReportViewer to view your SSRS report

• Downloading an SSRS report in Excel and PDF

• Creating an SSRS folder

• Creating an SSRS data source

• Changing an SSRS report's data source reference

• Uploading an SSRS report to Report Manager

• Downloading all SSRS report RDL files

• Adding a user with a role to an SSRS report

• Creating folders in an SSIS package store and MSDB

• Deploying an SSIS package to a package store

• Executing an SSIS package stored in the package store or File System

• Downloading an SSIS package into a file

• Creating an SSISDB catalog

• Creating an SSISDB folder

• Deploying an ISPAC file to SSISDB

• Executing an SSIS package stored in SSISDB

• Listing SSAS cmdlets

• Backing up an SSAS database

• Restoring an SSAS database

• Processing an SSAS cube