Reporting Solutions

SqlServer Reporting Services

Microsoft Reporting Services is part of the Microsoft Business Intelligence Suite accelerates report creation eases collaboration and more so helps provide a platform that helps deliver key information data on a enterprise wide platform.Reports are developed using either T-SQL or MDX Programming Languages

Key Capabilities:

• Accelerate insight with intuitive and flexible authoring capabilities
• Access and combine data from virtually any data source
• Securely view and share reports directly from the web
• Streamline collaboration and management by using integration with Microsoft SharePoint Server

Diagram showing a Report developed using SqlServer Reporting Services

PerformancePoint Server

PerformancePoint Server is integrated with other Microsoft Office products including Excel Visio SQL Server and SharePoint Server.PerformancePoint Dashboard Designer which is included with PPS in Microsoft SharePoint Server is a tool that you can use to create powerful dashboards in your organization

Key Capabilities:

• Scorecard capabilities
• Performance Monitoring and Analytics
• Planning and Budgeting

As shown in image PPS can be used to display performance in a Scorecard Chart or Report format across an Organization

Sharepoint Business Intelligence Integration

Business Intelligence (BI) in SharePoint 2013 provides comprehensive BI tools that integrate across Microsoft Office applications and other Microsoft technologies.These BI tools are

• SQL Server Reporting Servces
• Excel 2013 including PowerPivot
• PowerView in Excel and Sharepoint
• Excel Services in SharePoint 2013
• PerformancePoint Services in SharePoint Server 2013
• Visio Services in SharePoint
• SharePoint 2013 and Microsoft SQL Server