County Selected for National Initiative Addressing Homelessness, Employment

The following press release was taken from Partner4Work.

PITTSBURGH – The Department of Human Services (DHS) and Partner4Work (P4W), the workforce development board for the Pittsburgh area, announced today that Allegheny County is one of seven jurisdictions selected to take part in the Pathways Forward Challenge. The Challenge, overseen by the Heartland Alliance’s National Initiatives on Poverty & Economic Opportunity, is aimed at more effectively and equitably connecting homeless and unstably housed job seekers to employment.

Allegheny County was selected based on its proposed plan to strengthen its already robust data warehouse with additional workforce data and provide analysis to more fully understand and serve the employment needs of those experiencing homelessness for the first time. DHS also plans to use this opportunity to analyze and address racial disparities within the homeless and workforce development services systems.

“We are aware that there’s an important connection between employment and housing needs, and that if you can provide stable employment for someone needing housing early enough, you can stave off potential chronic homelessness,” said Marc Cherna, DHS director. “We thank the Heartland Alliance for helping us find solutions in Allegheny County, and also allowing us to be a part of the national conversation.”

Partner4Work will collaborate with DHS in this initiative to help find ways to better meet the workforce development needs of those experiencing homelessness.

“Through this strategic partnership with Allegheny County DHS, human services and workforce development are better aligned to support some of the region’s most vulnerable citizens, breaking down barriers and opening pathways to opportunity and stability,” said Earl Buford, P4W chief executive officer.

As part of the Pathways Forward Challenge, Allegheny County will receive a $75,000 grant from the Heartland Alliance, supported by the Oak Foundation and Melville Charitable Trust, as well as technical assistance and support from a group of national peers.

“The Pathways Forward Challenge communities not only have the potential to move the needle on increasing employment for homeless job seekers but are also advancing new ideas that will add to our learning about how to create better, more equitable systems,” said Carrie Felton, project manager for Heartland Alliance’s National Center on Employment and Homelessness (NCEH).

 

# # #

Data Warehouse Consultants Releases Major Enhancements to Custom Analytics Tool

PITTSBURGH (April 25, 2019) — Data Warehouse Consultants equips Allegheny County Department of Human Services with an updated Outcomes Tool application, enabling advanced analytics across 25+ human services data sources as of February 1.

The Outcomes Tool is a web-based analytic application that allows authorized users to compile data for evaluation. The purpose is to compile aggregate results based on the specific outcomes of individual programs for Allegheny County Department of Human Services’ (DHS), a public health organization in Pittsburgh, programs and services.

Data Warehouse Consultants furnished the Outcomes Tool with an instinctive functionality and navigation making it easy to use and boosting the tool’s efficiency. This tool solves two primary problems that analysts often face.

When studying the effectiveness of a program, analysts must first identify a cohort of individuals meeting specific demographic and programmatic criteria. For example, for a prevention program the analyst may need to identify clients who have had a homeless episode and also recently been in jail. This tool enables them to define the criteria they would like for the cohort across a range of available options, and to generate a list of clients. This cohort is then saved for future analysis over time.

The analyst may want to evaluate the effect of a program to see what percentage of the group has gone back into jail within a designated amount of time.

The problem with doing this analysis is that these criteria must be evaluated independently for each individual because the release date and relevant time period are different for everyone. The first person may have been released from jail in January, and the next person in March. So determining whether the individual returned to jail within one year changes for each person. The Outcomes Tool performs this analysis individual-by-individual, then compiles the results into a common format the analyst can use for future evaluation.

Overcoming both of these hurdles simultaneously provides DHS analysts with a powerful tool that enables consistent program evaluation over time. The release of the recent enhancements to this tool have greatly increased the range of analyses that can be performed on the DHS data warehouse allowing DHS to enhance the service quality and care provided to Allegheny County residents.

 

About Allegheny County Department of Human Services: DHS is responsible for providing and administering publicly-funded human services to Allegheny County residents. DHS is dedicated to meeting these human services needs, most particularly for the county’s vulnerable populations, through an extensive range of information exchange, prevention, early intervention, case management, crisis intervention and after-care services.

About Data Warehouse Consultants:  Data Warehouse Consultants is a consulting firm based in Pittsburgh, PA.  Founded in 2004 the firm provides custom development services for web applications and corporate database and data warehouse environments.

 

Data Warehouse Consultants Introduce Unique QuickCount Tool

PITTSBURGH (April 4, 2019) — With the help of Data Warehouse Consultants, the Allegheny County Department of Human Services recently launched an updated QuickCount Tool application.

QuickCount is an online, easy-to-use interface that allows journalists, policy researchers, grant writers, nonprofit leaders and community agencies to obtain counts of participants involved in the programs and services provided by the Allegheny County Department of Human Services, a public health organization located in Pittsburgh.  

Data Warehouse Consultants led the effort to update the application with a new visually appealing layout and clearly defined color scheme linked to the “Allegheny County” brand. The features and functionalities conveniently guide users through the application for a pleasant user experience.Picture of an example graph from QuickCount

The tool is available to the public at https://quickcount.alleghenycounty.us.  Users have the option to see counts of cross-program involvement by geography and client demographics for many public programs in the County.  Information on using the tool can be found in the User’s Guide on the QuickCount Help Site.

About Allegheny County Department of Human Services: DHS is responsible for providing and administering publicly-funded human services to Allegheny County residents. DHS is dedicated to meeting these human services needs, most particularly for the county’s vulnerable populations, through an extensive range of information exchange, prevention, early intervention, case management, crisis intervention and after-care services.

About Data Warehouse Consultants:  Data Warehouse Consultants is a consulting firm based in Pittsburgh, PA.  Founded in 2004 the firm provides custom development services for web applications and corporate database and data warehouse environments.

Radiology Tracking Board

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 integrating nurses notes with existing event messages that are sent over the internal message router. This solution was developed specifically to meet the needs of radiology departments by combining several available technologies into one integrated solution at a fraction of the cost of other medical software providers.

For a free demo of the virtual tracking board, contact us today!

UPMC Wins Davies Award for Custom DWC Solution

CHP LogoPittsburgh, PA:  The Children’s Hospital of Pittsburgh of UPMC this week was named the 2015 HIMSS Enterprise Davies Award recipient for two innovative solutions designed and implemented by Data Warehouse Consultants. The Davies Awards program promotes electronic health record-enabled improvement in patient outcomes through sharing of case studies and lessons learned across a wide range of efforts, including implementation strategies, workflow design, best practice development and adherence, and patient engagement that have improved care outcomes for patients.

This specific solution that earned UPMC the awards was the CHP Pharmacy MedEx Mobile Application, which uses mobile technology to accurate track the delivery of pharmaceuticals within the hospital. A second contributing solution was the CHP Breastmilk-Tracking Mobile Application, which uses mobile technology to accurately match babies with their mother’s breastmilk in the Neonatal ICU. For more information please visit the HIMSS Award Page.

About Children’s Hospital of Pittsburgh: Renowned for its outstanding clinical services, research programs and medical education, Children’s Hospital of Pittsburgh of UPMC has helped establish the standards of excellence in pediatric care. From Ambulatory Care to Transplantation and Cardiac Care, talented and committed pediatric experts care for infants, children and adolescents who make more than 1,000,000 visits to Children’s, its many neighborhood locations, and Children’s Community Pediatrics practices each year.   (www.chp.edu)

About Data Warehouse Consultants:  Data Warehouse Consultants is a consulting firm based in Pittsburgh, PA.  Founded in 2004 the firm provides custom development services for web applications and corporate database and data warehouse environments.  (www.dwconsultants.com)

 

 

Neonatal Breastmilk Tracker

intermecData 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 the breast milk bottles, and children could be given milk from an unrelated mother. There was also no audit trail to confirm the correct breast milk was given if a questionable situation arose. This solution provides mobile technology that verifies a match between the baby and the bottle before the breast milk is given.

Our solution provides a mobile application allowing the NICU caregiver to quickly scan a bar code on the bottle and the wristband of the baby to verify they are a match. It also allows for the common situation of multiple births, where one mother can provide breast milk for several babies. This simple system has been instrumental in reducing errors in breast milk delivery, and for providing an audit trail that confirm the correct milk was provided to each child in the NICU.

Contact us today for a free demo!

ACDHS Qualifies Data Warehouse Consultants to Build Custom Applications

Alleghany County Seal LogoPittsburgh, 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 Shantz said “We are very excited to have been qualified to do application work for DHS.  This will allow us to expand our existing relationship with the county to really make a difference in continually improving the valuable services that DHS provides.  We look forward to working closely with DHS to use technology in helping Allegheny County communities and citizens.”

Achieving this qualification designation was the result of a rigorous Request For Qualifications (RFQ) process administered by the county that required Data Warehouse Consultants to compete with other interested firms.  Ultimately DHS decided that the consulting firm’s experience and focus are the best fit for the work that needs to be done.

About Allegheny County Department of Human Services:  DHS is responsible for providing and administering publicly-funded human services to Allegheny County residents. DHS is dedicated to meeting these human services needs, most particularly for the county’s vulnerable populations, through an extensive range of information exchange, prevention, early intervention, case management, crisis intervention and after-care services.  (www.alleghenycounty.us/dhs/)

About Data Warehouse Consultants:  Data Warehouse Consultants is a consulting firm based in Pittsburgh, PA.  Founded in 2004 the firm provides custom development services for web applications and corporate database and data warehouse environments.  (www.dwconsultants.com)

 

 

International Services Database

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 track the workflow of new patient referrals from the time the original referral is received until the time when the patient arrives and receives services at Children’s Hospital.

For a free demo, contact us today!

Vascular Anomalies Database

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 patient visit it helps the department to identify patients that are due to return, and easily generates reminder mailings for each patient. Once the patient arrives at the clinic the department uses the application to monitor the activities the patient experiences in the clinic and to track follow-up services and visits.

Contact us today for a free demo of the vascular anomalies database!

Cleft Center Database

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 it helps the department to identify patients that are due to return, and easily generates reminder mailings for each patient. Once the patient arrives at the clinic the department uses the application to monitor the activities the patient experiences in the clinic and to track follow-up services and visits.

For a free demo, contact us today!