BVJ Customers

BVJ Company
Consulting on the Business Workbench Project

Digital Equipment Corporation

Project Summary

The background of BVJ's founder, Bruce A. Bednarski, is varied and diverse and includes working as a consultant for Digital Equipment Corporation developing SQL procedures for the Business Manager's Workbench to collect and process both revenue and certified order information, storing it in an RDB database containing a data warehouse data model, roll the information up along various dimensions using MS Access to prototype RDB SQL stored procedures. The process also included developing a pivot table of year over year, month over month and week over week to show current over last year comparisons. Thus, enabling business managers to make better decisions on current and future product directions.

Project Objective

Provide information on current Profit and Loss data of interest to a business product manager or their upper management for the following dimensional roll ups/drill downs:

This is so the business managers can ask and obtain answers to the following types of questions:

With the above information the business product managers can plan where they need to advertise or what types of products to add which ones to phase out, which customers to give price breaks to, etc.

Process Flow

Obtain information from legacy systems (called legacy not because they may be phased out but because they are existing systems we have to work with) on a weekly basis:

Roll up the data into three major levels, each in a separate data warehouse database:

From which specialize reports are generated. The intermediate and summary level data as well as the reports are made available to the business managers.

If you would like to discuss your project needs with us please call us today at 978-458-4107.



This page, and all contents, are
Copyright © 1999-2017, Bruce A. Bednarski of BVJ Company, Inc.
All Rights Reserved.

Better Value Joined

www.bvj.com
Joining-Information-People-DataBases & Businesses
Click here for more information.