olap.it                 
The N° 1 site for Data Warehousing Professionals

Business Intelligence & Data Warehouse Resource Center

 Home Consulting Services Web Sites & Resources Books Articles Products Consulting Companies News Other Info

Back to Consulting Services Home Page Assessment of existing Data Warehouses

andrea.vincenzi@olap.it

Tel. (+39) 347 3853617

Download CV pdf format

Download CV Word format

 

A company needs perfectly efficient information systems to work well, and Data Warehouses are no exception. Many Data Warehouses did non reach the expected resultsm, they are no more aligned with business needs, or they are based on obsolete technologies.

The DW Assessment consulting service helps companies identify existing problems and possible solutions in their Data Warehouse implementations.
The areas included in the assessment are:
 

bullet

Organization – roles, responsibilities, structure of the organization including the role of the user

bullet

Metadata – the strategy and implementation of data about data

bullet

Business value – cost justification and governance of projects

bullet

Methodology – the process by which the data warehouse is developed and maintained

bullet

Delivery and tools – the interface seen by the user

bullet

Architecture – the hardware, software and network that supports the data warehouse. Is the DW design based on a solid architecture?

bullet

Strategic direction – support of the strategic goals of the organization

bullet

Data acquisition and cleansing – the critical activity of sourcing, extracting and cleaning the data

bullet

Requirements – the process to determine just what information the users need

bullet

Data modeling – how models are developed and used for the data warehouse

bullet

Data base design – the design of the data warehouse databases being significantly different than those that are operational

bullet

Performance – response time as well as load/refresh/update performance

bullet

User satisfaction – usability of data, flexibility and responsiveness of IT to new requirements, satisfaction with the quality of the data

bullet

KPI's - their respondence to user needs, the way they are presented.

It is superfluous to note that a DW Assessment should be made only by consultants with a deep knowledge of DW theory and a vast experience based on real implementations.
Contacts:
andrea.vincenzi@olap.it Tel. (+39) 347 3853617