Business Intelligence

InPhase is a Microsoft Certified Gold Partner and PerformancePlus® is provided with completely seamless integration to the worlds leading BI suite enabling users of PerformancePlus® to carry out additional predictive analysis. By integrating with Microsoft we leverage the world leading BI applications for your benefit.

Data Warehousing

Data warehousing can help you provide insight into corporate data through an integrated, centrally managed, and trusted data source. Using the PerformancePlus® SQL database you have an enterprise-ready data warehouse platform that can help extend the value of your enterprise data.

With PerformancePlus® and SQL Server 2005 you get more than just data management tools - you get the core components to build a trusted BI platform:

  • The data integration platform brings your data together from virtually any source within your organization.
  • The format of the industry-leading ad hoc analysis engine-online analytical processing (OLAP)-enables decision makers not only to explore data in ways that make sense to them but also to centrally define and manage organizational business logic like key performance indicators (KPIs).
  • SQL Server supports a broad variety of data analysis scenarios-from simple ad hoc analysis to sophisticated predictive analytics-all in familiar, easy-to-use tools.
  • The managed-production reporting environment helps you publish highly formatted and interactive reports that make data easily accessible to a large number of people.
© Microsoft 2008

Query and Analysis

Microsoft Analysis Services contains data mining and predictive analytical functionality that makes advanced analytics accessible to a much wider audience than ever before. The InPhase integrated approach will enable you to leverage powerful data mining capabilities from SQL Server 2005 to forecast metrics and spot trends, which can all be carried out with full integrate with MS excel as a special add in if required.

This combined with the already very powerful statistical forecasting in PerformancePlus® enables you to achieve both descriptive and predictive statistics, and even create custom analytic models.

Data Integration

The traditional ETL-centric data integration from standard data sources continues to be at the heart of most data warehouses. However, demands to include more diverse data sources, regulatory requirements, and global and online operations are quickly transforming the traditional requirements for data integration. In this fast growing and changing landscape, the need to extract value from data and the need to be able to rely on it is more important than ever before. Effective data integration has become the basis of effective decision making. SQL Server Integration Services provides a flexible, fast, and scalable architecture that enables effective data integration in current business environments.

SSIS will support your comprehensive data automation requirements including:

  • Extract, transform and load data from multiple data sources ( each with different formats)
  • Enable you to manage data quality
  • Make sense of different data formats
  • Clean data prior to it being loaded into PerformancePlus®
  • Transform the data into a format that is meaningful to business analysts
  • Manage huge volumes of data

This approach will also enables you to handle different types of data for example, data from a call centre that is semi structured can be handled as easily as binary data from your legacy applications, and of course it will also pull data from your application databases.

Integration with MS Office

Both PerformancePlus® and the Microsoft BI offering provide seamless two way integration with MS Office making it simple for you to access data and move it from the database to excel or to PerformancePlus®. This provides you with a hugely powerful way of managing, analysing and sharing data.