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.

Q-Integrate: Easy Database Integration
/by John ShantzThe Q-integrate tool creates an easy-to-install listener for real-time integration from Qualtrics into your cloud or on-premise database environment. The tool catches event notifications that you subscribe to using your Qualtrics account, and make full integration with their web platform seamless with your other internal tools.
Allegheny Intermediate Unit TEAR Project
/by Taylor CiccarelliThe Allegheny Intermediate Unit (AIU) was in need of a process that would allow it to expand its efforts and reach within Allegheny County. They were in search of a solution that easily blended all organizations involved. The sections below provide a glimpse into the story and development of the solution.
Allegheny County Mental Health Bedboard
/by Taylor CiccarelliAllegheny County Department of Human Services provides hundreds of millions of dollars for mental health services within the county. This allows a lot to occur – services, programs, care, etc. The county was searching for more information on how those dollars were being used and who was being served for mental health (MH) services.
Department of Human Services Data Exchange
/by Taylor CiccarelliThe Allegheny County Department of Human Services uses a data warehouse to collect information from over 185 sources and providers with many being external. It’s used to improve the services offered to clients as well as support management decision-making. It’s vital that this data is correct, clean and organized.
Allegheny County Hello Baby
/by Taylor CiccarelliHello Baby was created for Allegheny County families with newborns to help aid and connect them to resources and services. As a network of supports, Hello Baby was crafted to meet families’ individual needs and interests. The county was in search of a solution to help organize this vast data and ensure seamless coordination among […]
Community Violence Reduction Initiative Rapid Response
/by Taylor CiccarelliAllegheny County, like many across the country, faces some levels of gun violence. The Community Violence Reduction Initiative (CVRI) aims to reduce the amount of gun violence that tears communities apart. The CVRI team desired a mechanism for making a difference.
Geocode It!
/by John ShantzGeocodeIt! is a custom application that allows you load addresses from either a file or a database, then run those addresses through a third-party online service to obtain standardized address and location information. Location data is very important in many types of data warehouse and business information projects. Obtaining standardized address information including addresses and […]