We specialize in converting data from operational databases into data warehouse systems, and we find that many organizations still run business-critical applications in Microsoft Access and Excel. This can often lead to issues with application performance, accessibility and security, and represents a major risk that organization don’t need to take. We have helped many organizations convert these applications into a more enterprise-level architecture based on ASP.NET and SQL Server or Oracle which can provide stability and peace of mind for your business, while providing your team access to these previously walled-off applications from anywhere.
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
The original estimate we provide is for the development and conversion of the Microsoft Access application. Once the application goes live, you are responsible for ongoing maintenance and changes. We provide all the database and source code necessary for you or your team to maintain the application yourself. If you don’t have a technical staff […]
Yes! When the conversion is complete, you will have a database and application that are fully modifiable by you The application will contain some modules that are provided to you under license, but that license allows you to fully modify any components you deem necessary as long as they are for your own use. (Licensed […]
Just like everything else, the time it takes to do the conversion varies on a number of factors. But the typical conversion project takes about 4-6 weeks to complete.
There is not a “one-size-fits-all” price for converting access databases, and several factors must be considered. The complexity of the database is generally driven by the number of tables, the number of reports and the number of data entry forms in the database. Our consultants will analyze your database and requirements and develop a conversion […]
Data Warehouse Consultants developed a system to help nurses and other caregivers verify that children residing in the Neonatal Intensive Care Unit (NICU) are given the correct mother’s breast milk when the mother chooses that option for her child. Prior to implementation of our solution there was a greater chance that confusion could occur with […]
Our team has been working for years with several leading health care providers to provide innovative, customized products to meet specific needs of the organization. These solutions help our clients to provide efficient services and improve patient care by giving clinicians quick access to patient data that used to be out of reach. Please explore […]
Pittsburgh, PA: Allegheny County Department of Human Services (DHS) approved Data Warehouse Consultants to build business intelligence and web applications beginning in September 2014. This provides Data Warehouse Consultants the opportunity to fulfill projects for the Department of Human Services on an as needed, project-by-project basis. Of the company’s recent success, Data Warehouse Consultants President John […]
On a client project today we had the need to create a table from an XML data file sent in a hierarchical format. The XML file contains multiple orders. Each order is for a particular store which is provided inside a header tag. Each store can order multiple items which are provided via sub tags […]
Data Warehouse Consultants PO Box 101383 Pittsburgh, PA 15237