| |
| 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. |
|
|
|
| frequently
asked questions |
Q: Our data warehouse is already
set up. Can you tune/enhance it?
A: Yes, we are database tuning specialists. Many
data warehouse performance issues stem from non-optimal
design. Correcting such design errors can involve significant
effort, but quick gains can be made (e.g. by enhancing your
aggregation strategy).
Q: Are you affiliated with any
ETL 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 third party ETL, Business
Intelligence and Data Visualisation products.
Q: Which database technologies
do you deal with?
A: We are Oracle database experts, and are also 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 document project tasks performed within one week
of completion. You are guaranteed a copy of this 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 data warehousing consultancy
to household name clients since 1996, and company references
are available
on request.
|
|
|
|
|
 |
Copyright Pro-DBA.com 1999-2008, all rights
reserved. 11 Greenwich Quay, Clarence Road, London, SE8 3EY.
|
|
020 8465 9100 
Sales
Enquiries
Other Enquiries
