22-25 April 2026 
SQLBits 2013
Analysis Services for the DBA
Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
Many DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution, and managing Analysis Services in a production environment.
Speakers
Mark Stacey's previous sessions
Is your data big enough for a PDW?
You have tuned your SQL server to it's limits, you have maxed the RAM on your server, and still your data warehouse is too slow. Is a Parallel Data Warehouse the next step?
Analysis Services for the DBA
Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
BI from space: PowerPivot with NASA data
In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel.