Data Warehousing and Business Intelligence is a natural
progression to the technical services offered by VA
Associates. Most of the On Line Transaction Processing (OLTP) systems, both custom developed
as well as Commercial Off The Shelf, tend to provide
operational systems of record. The opportunity to leverage
the information from such systems is best realized in data
warehouses that are organized with a functional and
subject-oriented organization to provide actionable information
for both tactical operations personnel as well as strategic
senior executive staff.
VA Associates provides design and development experience in
Data Warehouse design using
-
Dimensional Modeling - Star, Snowflake and Hybrid
-
3NF modeling
-
Data Architecture and Metadata Management
-
Extract, Transform and Load desgin
-
Data Warehouse Maintenance Window Mangement
-
Query Design
-
Tool Evaluation and Selection
VA Associates also brings to bear its Oracle Professional
Services to leverage
-
New features in the database aimed at Data Warehousing
-
On Line Analytical Processing (OLAP) functions built
into the database
-
New SQL extensions
-
Oracle Warehouse Builder
-
Oracle Discoverer
-
Business Intelligence Beans
VA Associates incremental and iterative methodology is aimed
a frequent deliverables that are fit for business purpose
producing results convergent with organizational priorities.