Chapter 10. Business Intelligence
In this chapter, we will cover the following topics:
- Listing items in your SSRS Report Server
- Listing SSRS report properties
- Using
ReportViewerto view your SSRS report - Downloading an SSRS report in Excel and as a 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 a filesystem or a package store
- Downloading an SSIS package to 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
- Listing SSAS instance properties
- Backing up an SSAS database
- Restoring an SSAS database
- Processing an SSAS cube
