Entries by John Shantz

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 […]

Hyperion Essbase Conversions

We have developed custom programs and processes that convert Hyperion Essbase data into a SQL Server database or Analysis Services OLAP cube. Since acquiring Hyperion, Oracle has greatly increased the price to maintain this software.  If you are looking to move your legacy data away from Hyperion we can create a custom, cost-effective solution to meet your requirements […]

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.

Mobile Integration Delivers Rapid Results

Our team has developed customized solutions on various mobile platforms to meet the needs of our clients. We like to take the long-term view and provide a mobile solution that will work for the bulk of the application users, or to meet a specific need of the organization. The majority of our solutions began as […]

Big data Delivers Actionable Business Information

We are Data Warehouse Consultants. Big Data requires the combination of both business understanding and technical know-how, and our firm was founded on this principle. This firm was founded to implement data warehousing and dimensional modeling methodology and techniques to effective solve business problems. As new Big Data concepts develop, we continue to investigate new […]