iCentrix Corp. - Data Integration
iCentrix Corp.

Data Integration is the Extract Transform and Load (ETL) layer which provides for integration of multiple data sources using Microsoft Data Transform Services (DTS) into an aggregated SQL Server database.


Information can be collected from all parts of an organization including Billing, Financial, Payroll, HR, Budgets and A/R, while data sources may include various databases, Excel, XML and Flat files.

Data integration starts with data analysis and data cleansing. Disparate data sources with variable key structures are analyzed, compared and combined into a working relational data model that will be the basis for all ongoing analysis and reporting.

Data integration also provides the means for data management as well as the ability to create and update information such as holiday schedules, budgets, team structures and roles. Web based administration gives users a non-technical access to data management and data organization where they can create new data groups and update the existing ones.

Periodic data feeds are established to constantly and automatically retrieve and update the system with the most current information available.

more >

 
       
   
    Healthcare BI Dashboard
    Healthcare EHR Systems
    Behavioral KPI Whitepaper
    Business Intelligence (BI)
 ·Data Integration
 ·Data Warehouse
 ·KPI Reports and Dashboard
 ·Ad-hoc Analysis
 ·Example of Drill Down Analysis
 ·Example of Developed KPIs
    Executive Dashboards & Key Performance Indicators (KPI)


iCentrix Corp. Newpoint Technology Park, 11 Red Roof Lane, Salem, NH  03079
Voice: 603.893.3922   Fax: 603.893.3849

©1999-2014 iCentrix Corp. All rights reserved. iCentrix, and iCentrix logo are trademarks of iCentrix Corp.
All other product or service names mentioned herein may be trademarks or registered trademarks of their respective owners.