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 6 Essbase cubes to SQL Server Analysis Services. As a part of this project, over a […]
About John Shantz
John Shantz is the founder and owner of Data Warehouse Consultants. His credentials include design, development and management duties on dozens of different business intelligence initiatives in various industries across the country. He is an accomplished entrepreneur, data architect and programmer using many different languages and environments. John is also an adjunct professor at the Carnegie Mellon University Heinz School in Pittsburgh.
Entries by John Shantz
I have received the following .NET error several times in the past when developing nested databound controls. I have found the solution does not have good coverage on the Internet. The curious thing about this error is that it does not appear until 2nd or 3rd postback on the page. [box]The SqlDataSource control does not […]
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 […]
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 […]
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.
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 […]
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 […]