Data Warehouse Consultants · Portfolio
A history of solving business problems with software expertise and business process understanding.
Our approach
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.
The 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.
Read more
The 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.
Read more
Allegheny 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.
Read more
The 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.
Read more
Hello 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 […]
Read more
Allegheny 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.
Read more
GeocodeIt! 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 […]
Read more
Efficiency 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 […]
Read more
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 […]
Read more
Data 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 […]
Read more
Data 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 […]
Read more
Data 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 […]
Read more
Data 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, […]
Read more
The Children’s Hospital of Pittsburgh maintains a world-class program for the study of Neurodevelopment in Rare Disorders led by Dr. Maria Escolar. Data Warehouse Consultants has developed an extensive Virtual Medical Home application for this organization that allows them to track and communicate more effectively with their patients around the world. This application has developed […]
Read more
The Allegheny County Department of Human Services is on the cutting edge of using business intelligence best practices to provide superior service to clients of programs the county offers. The core of this service is the DHS data warehouse which compiles program data from over 25 data sources within the county. Data Warehouse Consultants was […]
Read more
HL7 messages are the primary method that medical systems use to communicate in real time. This product allows the capture and storage of HL7 messages into a generic schema that can then be used for any purpose. Once the HL7 message is parsed and stored in a database, legacy applications and ETL can be run […]
Read more
This product allows you to automatically receive patient communications into SQL Server or other relational database. Our clients use this product to capture patient-related emails that are sent to and from clinical staff. It allows you to simply “CC” the clinical database as part of your normal communications with the client. When this is done, […]
Read more
Data Warehouse Consultants worked with the Armstrong Group on several projects to improve their business intelligence infrastructure. The primary effort was related to creation of a data warehouse and dimensional model in SQL Server to support profitability analysis of the home security installation group. This group used multiple legacy source systems for sales and execution, […]
Read more
Data Warehouse Consultants worked with a specialty pharmacy provider to review their data warehousing strategy, design and architecture for processing prescription related data. Key activities on this project included providing direction for best practices of a reporting architecture and assisting with the selection of an ETL methodology and tools. Our consultants worked with our client’s technical […]
Read more
QuickReport is a custom reporting solution that enables batch reporting and feed creation from an Oracle database by simply writing an SQL query and saving it to a table. After reviewing various third-party solutions a custom, cost-effective solution was developed to generate hundreds of reports and data feeds on a daily and weekly basis. It […]
Read more
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 six Essbase cubes to SQL Server Analysis Services. As a part of this project, over a […]
Read more
Distributors offer incentives to store to carry selects groups of products. Data Warehouse Consultants developed a rules engine to support automated tracking and reporting for these types of trade programs. The application uses a data warehouses based on a distributor’s data to calculate the sales of selected products for participating stores. It supports many types […]
Read more
Data Warehouse Consultants designed, developed and implemented a new system to convert paper-based orders for products into an electronic equivalent via a centralized clearing house. Prior to development of this system the existing process was labor intensive with a low success rate. Sales reps would visit individual convenience stores to get new products onto the […]
Read more
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 […]
Read more
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.
Read moreContact Data Warehouse Consultants for more information.
Contact us