Solutions

Few firms enjoy the same unqualified history of success as Data Warehouse Consultants.  If you have a business problem, we can help with the solution. Our team uses software expertise and business process understanding to help you improve the way you run your business. We are a group of talented engineers who will work with you to quickly understand your problem, identify a viable solution, and then implement that solution using custom software development.  

Hyperion Essbase Conversion

DWC has developed custom programs and processes that convert Hyperion Essbase data to SQL Server Analysis Services. After exploring and attempting to use Third-Party solutions, our consultants created a custom, cost-effective solution to meet the client requirements of converting six Essbase cubes to SQL Server Analysis Services. As a part of this project, over a […]

Trade Program Rules Engine

Distributors offer incentives to store to carry selects groups of products. Data Warehouse Consultants developed a rules engine to support automated tracking and reporting for these types of trade programs. The application uses a data warehouses based on a distributor’s data to calculate the sales of selected products for participating stores. It supports many types […]

Auto Ordering System

Data Warehouse Consultants designed, developed and implemented a new system to convert paper-based orders for products into an electronic equivalent via a centralized clearing house. Prior to development of this system the existing process was labor intensive with a low success rate. Sales reps would visit individual convenience stores to get new products onto the […]

Report Conversion

Data Warehouse Consultants led an effort to convert business-critical reports from a legacy VMS platform into a modern, high-performing and low maintenance Oracle 10g system. These reports were worth approximately $5m/year in revenues and distributed monthly, quarterly and annually to a large manufacturer. The reports provide in-depth marketing analytics and sales data that is critical […]

Pharmacy Mobile Application

Data Warehouse Consultants developed a system to track the delivery of custom medications within the hospital. Current EMR systems only track the submission of a medication order until the point where the order is sent to the patient from the internal pharmacy.  This can lead to situations where a medication is delivered to caregivers or remote stations and then lost.