SQL Server 2012 Analysis Services

A single model for Business Intelligence applications, from reporting and analysis to dashboards and scorecards, enabling users to have a consistent view of their data.

Powerful new data models enable flexibility in design and creation of business logic including direct access to the underlying data for real-time analysis.

Enable fine-grain security to ensure information is accurate and accessible.

Take advantage of the latest hardware by using the Vertipaq engine including multithreading and linear scaling with multiple cores.

Take advantage of an improved Aggregation Designer to optimize multidimensional performance and eliminate unnecessary aggregations.

Enable real-time updates with Proactive Caching for superb performance.

Empower business users with Self-Service access to information they need, when they need it with Microsoft Excel, including new PowerPivot capabilities and Data Mining add-ins.

Enable users to create their own mash-ups of information while centrally managing and monitoring the system through tight integration with SharePoint.

Enable users to access the information they need through a single BI semantic model that includes business entities, business logic, calculations and metrics.