Analyzing data with Microsoft Excel
Online Analytical Processing (OLAP) cubes are a feature in System Center 2016 Service Manager that leverages the Service Manager Data Warehouse infrastructure to provide self-service Business Intelligence capabilities to the end user.
An OLAP Cube is a data structure that overcomes limitations of relational databases by providing rapid analysis of data. Cubes can display and sum up large amounts of data while also providing users access to the most granular of data. These cubes are stored in SQL Server Analysis Services databases. Self-service BI tools such as Excel and SQL Server Reporting Services can target these cubes and allow the user to analyze the data from multiple perspectives.
In this recipe, we are ...
Get Microsoft System Center 2016 Service Manager Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
