Business Intelligence and Reporting

Our Business Intelligence team is focused primarily on helping organizations leverage the Microsoft BI platform, including SQL Server and SharePoint.

Data Warehouse Architecture and Implementation

Our Business Intelligence team can design and implement your Data Warehouse.  We generally advise our clients to start their initiatives with one or serveral Data Marts, moving to an Enterprise Data Warehouse over time.

Reporting and Analytics

Our reporting toolset includes:

• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• PowerPivot for Excel and SharePoint
• Zap CubeXpress and Zap Business Intelligence
• Crystal Reports
• JasperReports
• Access

Executive Dashboards

We create dashboards that provide additional insight into data, the organization, and its customers.  Tools we leverage for this purpose include:

• PerformancePoint Services for SharePoint
• Excel Services for SharePoint
• xCelsius

ETL - Extract, Transform, and Load

ETL is a very important component in a successful Enterprise Data Warehouse. We are experts in SQL Server Integration Services (SSIS), as well as other ETL tools and techniques.