Data warehouse implementation
This is a service designed to relieve you of data warehouse technical implementation. This service is for you if you want to have a data warehouse, but do not want to be bothered with all the technical details of a data warehouse, such as
  • how to store data more efficiently,
  • how to make it run faster,
  • how to extract, transform and load data (ETL) to Staging, ODS and data marts,
  • how to create cubes,
  • how to query the data marts and cubes, and produce reports,
To use this service, you need one good business analyst, who will be your contact point and will provide us with at least a logical model of the data warehouse. (A physical model will help, but if you are too busy, we could produce one for you. If you need us to produce the logical model for you, you need to use our Data warehouse design service.)

You will also need at least two physical SQL servers (or two SQL instances) , one for your UAT environment, and the other for your production environment. When we complete the implementation, we will send SQL script file(s), SSIS Package file(s) and report file(s) to you with deployment instructions. You will deploy the implementation to your UAT environment, and do user acceptance testing. When your testers and/or business users are happy with the implementation, you will deploy the implementation to your production environment.
Our SQL script migration file(s) will contain all databases and their tables as specified in the physical model, all the necessary views, all ETL stored procedures, and all ETL SSIS Packages. These databases, tables, views, stored procedures and SSIS packages will be delivered in probably 8-12 weeks after the physical model is accepted by you and by us.

If you need to migrate data from other data sources, such as Oracle, DB2, MySQL, it will take longer. If you need reports using Reporting Services, reports will be produced for you in one or more future iterations.
To start the subscription, please use our online subscription form. When we receive your request for subscription, we will first assess our resource availability. We will not accept your subscription if we do not have adequate resources. If we accept your subscription, we will assign an expert as our contact point. All requests for implementation and maintenance will go though your contact point to our contact point, and vise versa.
Related information
Home     |     Company     |     Privacy     |     Disclaimer
© 2009, 2015 XQ Knowledge Management