Business Intelligence and Enterprise Reporting

Covenant Technology Partners is a full-service Business Intelligence (BI) consulting firm, with a breadth of knowledge and depth of experience implementing successful solutions for clients of all sizes.  We bring both strategic and tactical approaches to solving your businesses information delivery, analysis, and visualization needs. 

Business Intelligence Services: 

• Enterprise data warehouse design & implementation
• Data mart design & implementation
• Business analysis and strategy
• ETL design and development
• Analysis Services cube development
• Analytic Dashboards (PerformancePoint, ProClarity, & more)
• Performance Management Scorecards
• Balanced Scorecards
• Key Performance Indicators (KPI)
• Analytic 

• Data Warehouse Hardware Architecture design
• Custom extensions for BI products
• Data mining
• Advanced Data visualizations

Enterprise Reporting Services:

• Report Server Architecture design – From single server to full scale-out environments
• Report rationalization and platform consolidation
• Report development
• Report Model (ad-hoc) development
• SharePoint integration – Single source of the truth 

Some of our recent client engagements include:

Fleet Management Analytics

• Analytic dashboard
• PerformancePoint custom components for enhanced search
• Reporting Services to PerformancePoint integration

Oracle Financial Analyst (OFA) replacement

• GL snapshot ETL, Data mart & cube
• Account rollup editor
• SharePoint management interface to put process control into the hands of the finance users.
• Consolidations reporting in Excel

Manufacturing ERP system Data Warehouse & cube

• Distribution logistics analysis
• Inventory Management
• Sales and Order Management

Hospital demand analytics

• Real-time cube behind a Silverlight/Virtual Earth web application
• What-if scenario development

Custom BI extensions for the Microsoft Stack

• Encrypted SSRS file delivery extension
• Excel data SSRS rendering extension

Business Objects (BO) Replacement

• Enterprise reporting assessment & strategy
• Architecture design & implementation
• Reporting services report migration
• Report model construction for ad-hoc reporting
• Training and support

Crystal Reports Migration to SSRS

• Teradata and Oracle report sources
• Custom delivery extensions for distributing encrypted report files

Analysis Services 2000 and DTS migration/upgrade

• Re-design of SSAS 2000 cube to SSAS 2008
• Migration/redesign of ETL processes from SQL 2000 DTS to SQL 2008 Integration Services
• SQL and MDX based report development
• Cube optimization for Excel 2007 clients.