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
/in Projects, Solutions /by John ShantzDWC 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
/in Solutions /by Bob BrichacekDistributors 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
/in Projects, Solutions /by Bob BrichacekData 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
/in Solutions /by John ShantzData 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
/in Children's Hospital of Pittsburgh, Solutions /by John ShantzData 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.