Summary


Analysis Services consists of two components : Online Analytical Processing (OLAP) and Data Mining (DM). OLAP is designed to summarize data and DM is designed to look for patterns and trends in data.

Microsoft has added new Analysis Services and Data Mining capabilities to SSRS 2005. Some of the key capabilities that can be leveraged by SSRS are as follows :

  • Unified Data Model (UDM) Is designed to simplify access to data and combines the best of relational and analytical models.

  • Key Performance Indicators (KPIs) Are designed to evaluate performance criteria that a business, usually, considers strategic in nature. Performance is evaluated against a specified goal and has to be quantifiable. Some of the KPI examples are stock performance, cost of operations, customer satisfaction, and so on.

  • Graphical Query Builders for Online Analytical Processing (OLAP) and Data Mining Are designed to simplify development of multidimensional and data-mining queries by providing a very intuitive graphical user interface.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net