Automating Azure Analysis Services

The elasticity of the cloud lets you provide a better user experience instead of breaking the bank running your solution at the highest scale 24 hours a day. This demo-heavy session will show how to automate Azure Analysis Services. We will look at solutions to the following questions: How do you schedule a refresh of the data in your Azure Analysis Services model? How do you pause the server on the weekends? Better yet, how can you pause it when the last user disconnects and start it automatically when the first user connects in the morning? How do you scale to meet peak demand each day? How can Azure Analysis Services load balance across servers in multiple countries so that the user connects to the geographically closest server? How do you extend your on-premises SSAS solution into Azure Analysis Services?

• Greg Galloway

  2 Recordings

  Greg Galloway is a BI architect with Artis Consulting in Dallas, Texas and a Microsoft Data Platform MVP. He is a coordinator on open-source projects including BI Developer Extensions (formerly BIDS Helper), the Analysis Services Stored Procedure project, and OLAP PivotTable Extensions. He was a co-author of the Analysis Services Tabular Performance Guide.

• SQL Saturday 127 Recordings

• SSAS 4 Recordings