SQL SERVER – Analysis Services and the Network Performance
SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. There are many tools available for enhancing the analysts’ ability to process data and get meaningful insights. These vary from direct queries in Excel to custom applications. For example, using PowerPivot to extend Microsoft Analysis Services directly into an Excel Workbook, you can then use Excel to build and explore an OLAP model using pivot tables and other techniques. One thing you can generally be sure of is that this will result in processing very large sets across the network.