Data Warehouse Consultants to Host 3rd Annual Memorial Golf Outing

PITTSBURGH (April 15, 2024) – Data Warehouse Consultants (DWC) is hosting the third annual Bill Randall Memorial Golf Outing August 26 at Shannopin Country Club.  Our friend, Bill, was taken too soon on April 5, 2021, after a long battle with Huntington’s Disease. He led a normal life until his college years when he was […]

AIU TEAR Application

Allegheny Intermediate Unit TEAR Project

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.

MH Bedboard Application

Allegheny County Mental Health Bedboard

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.

DHS Data Exchange Application

Department of Human Services Data Exchange

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.

Hello Baby Application

Allegheny County Hello Baby

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 […]