Data Analysis & Design
Microsoft SQL Server 2008 Analysis Services is an OLAP engine and data mining platform that provides a single version of truth for your reports, spreadsheets, key performance indicators (KPIs), and analytical applications. It provides a consolidated view across all business dimensions, enabling insight into the key drivers that impact your business.
API Software is an accredited Microsoft Gold Partner with recognised expertise in delivering data management solutions based on the SQL Server platform. Having attained both the Microsoft Data Management and Business Intelligence competencies we are ideally positioned to assist our clients deliver solutions based on the Microsoft platform.
|
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 Server 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
|
 |
