INTRODUCTION

At Tagra Management Systems we implement large-scale corporate data warehouses by creating an architecture framework and by designing data marts. Data marts describe a specific business area. This may be Sales, Finance or even Board level analysis of all areas.

Microsoft SQL Server offers a complete database and ETL (Extract, Transform and Load) Tool in the form of Integration Services. This allows data from many disparate sources to be combined into a single repository. Using business rules and data cleansing during the ETL process, we are able to deliver accurate solutions that mirror the way in which clients analyse their business.

 

BENEFITS

 

An environment where a relatively small amount of knowledge of the technical aspects of database technology is required to write and maintain queries and reports.

Usage of data models and/or server technologies designed to optimise reporting performance (as opposed to transactional processing).

Provides a repository of "cleaned up" transaction-processing systems data that can be reported against, without having to modify corporate systems/data in order to facilitate effective reporting.

Ensures no performance degradation of live systems, by reporting against a separate repository.

Makes it easier, on a regular basis, to query and report data from multiple transaction processing systems and/or from external data sources and/or from data that must be stored for query/report purposes only.

Provides a repository of data from a longer span of time than can be efficiently held in a transaction processing system, and the ability to generate reports "as was" as of a previous point in time.

 

HOME