Wave - Business Performance

Search wavebusiness.com for:

News and Events
Products > Microsoft SQL Server > SQL Server Analysis Services

SQL Server Integration Services

Microsoft SQL Server 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.

Top New Features

  • Develop solutions quickly with the new, streamlined Cube Designer

  • Take advantage of enhanced Dimension and Aggregation Designers

  • Create attribute relationships easily by using the new Attribute Relationship Designer

  • Avoid common design problems by using best practice

  • Optimize performance with subspace computations

  • Enable high-performance “what if” scenarios by using MOLAP enabled write-back

  • Take advantage of enhanced data mining structures and improved Time Series support

  • Monitor and optimize analytical solutions by using Analysis

 Want more information? - visit Microsoft

  

 

Analysis Services at Work

Use the richness of a single Unified Dimensional Model (UDM) to accommodate multiple analytical needs from multidimensional analysis and reporting to predictive analysis, all in one solution.

Consolidate enterprise analysis data

  • Use the Unified Dimensional Model to provide one consolidated business view for relational and multidimensional data that includes business entities, business logic, calculations, and metrics

  • Facilitate business information modeling, and employ easy to use Business Intelligence wizards to effectively build in time and financial intelligence

Manage key metrics centrally

  • Manage enterprise-wide key performance indicators (KPI’s) centrally by using the Analysis Services KPI Framework — a rich centralized repository for defining, storing, and managing KPIs

  • Make centrally stored KPIs available to users through a variety of applications, including Microsoft Office PerformancePoint Services 2007, Microsoft Office Excel 2007, Microsoft Office SharePoint Server 2007, and SQL Server Reporting Services

Perform predictive analysis

  • Offer advanced analytical capabilities that enable users to learn from large volumes of historic data, perform predictive analysis, and proactively identify patterns and business trends

  • Extend the predictive analysis capabilities of SQL Server with enhanced data mining engine and improved algorithms, and strengthens the powerful data mining framework represented by the extensible .NET programming model and embeddable data mining viewers even further

 

Data Quality Project

Wave has been engaged by a major government department on a data quality project as a pre-cursor to a data warehouse initiative.


Wave saves Water

The development of a management system for Australia's leading olive producer has led to significant gains in productivity whilst reducing the need on water.   Download Story  

 
© 2009 Wave | ABN 75 220 845 484 | All Rights Reserved | Legal & Privacy Statement .