|
Dataface, Inc. |
|
Software and services without fluff or bit-twiddling! |
|
Data Warehousing and Business Intelligence |
|
DEFINITION
A data warehouse is a repository of historical information for analytical purposes. A data mart is a smaller data warehouse designed for a particular subject area rather than general enterprise-wide browsing. Usually the information is derived from a number of different operational systems.
THE BENEFITS
A well-designed data warehouse enables management and analysts to supply data to advanced scorecards and other KPIs (Key Performance Indicators) to look back and spot business trends to identify the cause of any anomalous business results to compare results before and after a reorganization or product line overhaul to see what resources were consumed by different activities to monitor the effectiveness of advertising and promotions
WHAT WE PROVIDE
Dataface offers: Consultancy to create a project plan and identify a suitable first iteration that will pay back within 6 months. An architect to design the tables of the data warehouse and guide the design of the ETL (Extract, Transformation, Load) processes to obtain data from the operational systems. When appropriate, well-tested scripts to perform certain common ETL functions. The resources of our Excel practice area to implement specialized front-ends to make exactly the reports and queries that are needed by analysts and managers.
What commercial ETL tools lack is a vision of the architecture of the process, and this is what Dataface consultants and tools provide. |
|
Dataface, Inc. |
|
Software and services without fluff or bit-twiddling! |
