Introduction
Over the years and various versions, SQL Server has increased its Business Intelligence (BI) support and capabilities. Its BI stack—reporting services, integration services, and analysis services have become strong players in today's BI market.
PowerShell offers capabilities to automate and manage any BI-related tasks from rendering SQL Server Reporting Services (SSRS) reports, to deploying the new SQL Server Integration Services (SSIS) 2012 ISPAC files, to backing up and restoring SQL Server Analysis Services (SSAS) cubes.