The use of the warehouse was undisturbed. This helped their users understand what data was available to them, which translated into more accurate user requirements for the data warehouse. In two weeks, the IT department completed and delivered the initial implementation of the virtual data warehouse. Accessing the Virtual Data Warehouse Working in an intuitive, Windows-based environment, pioneer users find it relatively easy to access and analyze the data, given the appropriate database view. The values associated with each field are provided to the user upon request, helping the user find the exact data needed.
Users can search the data based on the result of a macro or formula, versus a specific value.
When the user is satisfied with the selection set of records and fields, the user can name and save the selection criteria for easy reuse later. Summarize the Data - Summaries of the data such as counts, averages, and maximum and minimum values are easily gotten. Summaries can be grouped by any number of different fields, or even by computed values. Summaries generally appear instantaneously, regardless of database size, because computations are executed against the index table structures, rather than against the actual database records. Display and Manipulate the Data - The virtual data warehouse comes with numerous tools for data display, including reports, charts, and graphs.