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.
Geocode It!
/in Solutions /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 […]
Radiology Tracking Board
/in Children's Hospital of Pittsburgh, Projects, Solutions /by John ShantzEfficiency is necessary to run a world-class radiology department. Data Warehouse Consultants developed a virtual tracking board that allows nurses to maintain updates on patients who are getting x-rays, MRI’s and other radiology services across many floors and service rooms. This board enhances communication within the unit and reduces the need to make phone calls by […]
Neonatal Breastmilk Tracker
/in Solutions, UPMC /by John ShantzData 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 […]
International Services Database
/in Solutions, UPMC /by John ShantzData Warehouse Consultants collaborated with International Services at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to track referrals for pediatric services for patients in global locations. The new application is enterprise-class and based on ASP.NET and Microsoft SQL Server technologies. It is used by department staff to monitor referrals and […]
Vascular Anomalies Database
/in Children's Hospital of Pittsburgh, Solutions /by John ShantzData Warehouse Consultants worked with the Pediatric Vascular Anomalies Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to provide patient care into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application is used by department staff to track their own patients over time. Before each […]
Cleft Center Database
/in Children's Hospital of Pittsburgh, Solutions /by John ShantzData Warehouse Consultants worked with the Cleft-Craniofacial Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to provide patient care into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application is used by department staff to track their own patients over time. Before each patient visit […]
Heart Center Database
/in Children's Hospital of Pittsburgh, Projects, Solutions /by John ShantzData Warehouse Consultants worked with the Heart Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database tracking hundreds of thousands of patients into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application has evolved to include patient tracking for various areas within the department including Adult Cardiology, […]