oracle support at low prices oracle dba outsourcing oracle database tuning oracle price list
 
data warehousing solutions ~ by Pro-DBA.com Quick page links: services | faqs

data warehouse services

Data warehouses are rich and valuable sources of management reporting and marketing information when developed, managed and harnessed correctly. We can help deliver maximum utility from your data with the following services.
Data warehouse design
We can design your data warehouse using industry-standard star schema (dimensional) modeling techniques. We can also devise and implement an appropriate data aggregation strategy, based on your data volumes and query requirements. Using Oracle's revolutionary warehousing technologies, the resulting aggregates will deliver even the most complex data analysis results in seconds.
Our wealth of experience in the field ensures that crucial data warehouse design challenges such as Slowly Changing Dimension handling and source system change detection are correctly managed.
Data warehouse development
We can assist you with all aspects of data warehouse development, including but not restricted to data feed management and set up, database set up and development, dimension table augmentation and conformation, and data archiving.
ETL tool (extract, transform, load) evaluation and set up
A range of ETL products exist to simplify the considerable challenge of defining, developing and maintaining source data feeds. These products vary greatly in terms of both cost of ownership and feature lists. We can help choose the right tool for you, and can even develop proprietary solutions if no product exists to adequately suit your needs.

We are of course Oracle specialists and have in-depth knowledge of Oracle's low cost, highly featured ETL tool (Oracle Warehouse Builder).
Data visualisation and data warehouse reporting
We have recently completed complex data warehouse reporting projects for high-profile clients, and maintain in-depth knowledge of the latest data reporting and visualisation products. Our experience helps our clients implement robust, supportable and future-proof business intelligence tools, while minimising hardware, license and consultancy spend.
Recent consolidation in the business intelligence marker means that some previously high-profile products may disappear. We have the time and experience to maintain a view on where the market is heading, so you don't have to.
Top of page

frequently asked questions

Q: Our data warehouse is already set up. Can you tune/enhance it?
A: Yes, we are database tuning specialists. Some data warehouse performance issues stem from non-optimal design, however. Correcting such design errors can involve significant effort.
Q: Are you affiliated with any ETL (Extract, Transform and Load) or Business Intelligence product vendors?
A: No, Pro-DBA.com is a completely independent company, and receives no commission from any third party. We therefore give entirely impartial advice on ETL, Business Intelligence and Data Visualisation products.
Q: Which database technologies do you deal with?
A: We are Oracle database experts, and are also highly experienced in Microsoft SQL Server data warehousing technology. Although we can work with other database technologies our main body of database expertise lies with these two database vendors.
Q: Do you provide warranties for the work performed?
A: We will ask you to assess and sign-off the work performed before our consultants leave your site. However, we also provide free remote support for four weeks.
Q: When can we expect documentation for the tasks performed?
A: We typically write up project tasks performed within one week of completion. You are guaranteed to receive our documentation within two weeks.
Q: We require assistance with a client's installation/project. Do you offer resales/subcontracts?
A: Yes. We can rebadge our services, or can pay a one-off commission/referral bounty to you.
Q: How can we be sure of your credentials?
A: We have been providing database consultancy to household name clients since 1996, and have carried out large-scale warehousing projects for international companies during that time. Company references are available on request.
Top of page
 

Copyright Pro-DBA.com 1999-2010, all rights reserved. 11 Greenwich Quay, Clarence Road, London, SE8 3EY.