New & Notable
Microsoft SQL Server Analysis Services (SSAS) News
November 12, 2018
Microsoft embeds its SSRS reporting software and more-advanced data preparation tools in Power BI, part of a plan to blend self-service and enterprise BI for users.
January 31, 2014
The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.
Microsoft SQL Server Analysis Services (SSAS) Get Started
Bring yourself up to speed with our introductory content
From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz. Continue Reading
PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources. Continue Reading
A GIS (geographic information system) enables you to envision the geographic aspects of a body of data. Continue Reading
Evaluate Microsoft SQL Server Analysis Services (SSAS) Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports. Continue Reading
Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform. Continue Reading
Learn how to distinguish among the three SQL Server OLAP storage models and decide which one is best in different use cases. Continue Reading
Manage Microsoft SQL Server Analysis Services (SSAS)
Learn to apply best practices and optimize your operations.
Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database. Continue Reading
Optimizing online analytical processing performance is critical. Fortunately, tools are available to help monitor and improve how OLAP cubes perform. Continue Reading
This guide explores the capabilities of the Excel plug-ins PowerPivot and Power View, offering tips for accessing valuable business intelligence data. Continue Reading
Problem Solve Microsoft SQL Server Analysis Services (SSAS) Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Aggregations produce faster queries, but they also increase the size of your Analysis Services database. See how to make the most of aggregations and what tools to experiment with. Continue Reading
Learn everything you need to know to build SSAS partitions from the ground up, with advice on binding, merging, and selecting partition data. Continue Reading
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you ... Continue Reading