PowerShell for BI Professionals: Automating SSIS, SSRS & SSAS.
PowerShell has allowed DBAs to manage huge numbers of SQL servers, all
automatically. Now BI practitioners can reap the same benefits of scale and
automation. Scenarios that are normally extremely time consuming can be done
quickly, all with a few lines of PowerShell.
This session will be filled with demos based on real-life scenarios and use-cases.
We will demonstrate how to scale and automate your BI solutions, with a
minimum of effort. In particular, we will be covering PowerShell cmdlets & their
integrations with SSRS, SSIS, & SSAS.
By the end of the session, you’ll be able to accomplish in minutes what would
normally take hours or days. You’ll know ways to quickly deploy hundreds of
SSRS objects to multiple servers; or instantly identify and process stale SSAS
dimensions. Additionally, you will also be able to take care of some pesky ETL
tasks, some by automating SSIS, and others using just plain old PowerShell.
About Aaron Nelson
Aaron Nelson is an author, public speaker, blogger, & leader in the community. He has over 15 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS ( SQLPS.io ), is a board member of PowerShell.org, and is a volunteer at his local PASS chapter, AtlantaMDF.
Signup here: EventBrite
Tuesday September 12th, from 5:30 pm – 8 pm Arizona Time ( first 30 minutes reserved for speaker setup and for attendees to network). Speaker should start around 6 pm.