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 diagnosed with the disease. Bill always loved playing sports and spending time with family. Now, his family is teaming up with DWC to raise awareness of this disease and to honor Bill’s memory.  

Registration starts at 7:30 a.m. and a continental breakfast begins at 8 a.m. A 9:30 a.m. shotgun start will kick off the scramble format. There will be prizes for various contests during the outing. Afterwards, there will be a cookout-style lunch at the club.

Registration closes July 31 or when spots fill up.

All the proceeds from the golf outing will benefit the Bill Randall Memorial Scholarship at Duquesne University and the Huntington’s Disease Society of America (HDSA).

Last year’s outing raised $15,000 and brought the donation total to $61,632.16 for the Bill Randall Memorial Scholarship. With the help and support of this year’s golfers and donors, we wish to reach our goal of a $100,000 donation. A donation of $4,500 was also made to the HDSA in 2023.

According to the HDSA, Huntington’s Disease is a genetic brain disease in which there is a mistake in one’s DNA instructions that builds our bodies and keeps them running. Over time, the damage caused to the brain leads to physical, mental and emotional deterioration. There is currently no cure.

Data Warehouse Consultants is the host and diamond sponsor of this event. There are four other sponsorship options available for anyone who is interested. Each sponsorship level and registration option is described in detail on the Bill Randall Memorial Golf Outing website.

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

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

CVRI Application

Community Violence Reduction Initiative Rapid Response

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.

Bad Data Costs More Than You Think, Fortunately Solutions are Achievable

Do you know what duplicate, incorrect, missing, inconsistent, and otherwise ‘bad data’ is costing you? Most organizations don’t. The costs are surprisingly high. Fortunately, improvements are achievable.

Poor quality and inaccurate data (“bad data”) is a source of financial and brand losses for most organizations today. On average, organizations spend 3-5 times more than necessary due to bad data. Bad data results from outdated information, conflicting information, missing information, and data entry errors.

Data management best practices can significantly improve data quality. When developing data improvement tactics, consider accessibility and information security. To achieve the best results, follow proven program management to assess problems, define priorities, develop plans, implement, and evaluate & improve progress. Evaluate resource capabilities and experience when planning. Experts achieve the best results. Know your available resources, if needed, engage consultants to provide guidance, bandwidth, and expertise.

This whitepaper explores ‘bad data’ including:
• Costs and occurrence frequencies
• Causes & remediation strategies
• Data management best practices to consider
• Strategies to achieve ROI from data management projects

Data Warehouse Consultants to Host 2nd Annual Memorial Golf Outing

PITTSBURGH (6/26/2023) – Data Warehouse Consultants (DWC) is hosting the second annual Bill Randall Memorial Golf Outing August 28 at Shannopin Country Club. 

Our friend, Bill, was taken too soon on April 5, 2021, after a long battle with Huntington’s Disease. Since being diagnosed at birth, he led a normal life until his college years. He always loved playing sports and spending time with family. Now, his family is teaming up with DWC to raise awareness of this disease and to honor Bill’s memory.  

Registration starts at 7:30 a.m. and a continental breakfast begins at 8 a.m. A 9:30 a.m. shotgun start will kick off the 15 holes in scramble format. There will be prizes for various contests during the outing. Afterwards, there will be a cookout-style lunch at the club.

Registration closes July 31 or when spots fill up.

All the proceeds from the golf outing will benefit the Bill Randall Memorial Scholarship at Duquesne University and the Huntington’s Disease Society of America (HDSA).

Last year’s outing raised $22,000 and brought the donation total to $46,132.16 for the Bill Randall Memorial Scholarship. With the help and support of this year’s golfers and donors, we wish to reach our goal of a $100,000 donation. A donation of $7,600 was also made to the HDSA in 2022.

According to the HDSA, Huntington’s Disease is a genetic brain disease in which there is a mistake in one’s DNA instructions that builds our bodies and keeps them running. Over time, the damage caused to the brain leads to physical, mental and emotional deterioration. There is currently no cure.

Data Warehouse Consultants is the host and diamond sponsor of this event. There are four other sponsorship options available for anyone who is interested. Each sponsorship level and registration option is described in detail on the Bill Randall Memorial Golf Outing website.

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

Data Warehouse Consultants to Host Memorial Golf Outing

PITTSBURGH (7/5/2022) – Data Warehouse Consultants (DWC) is hosting the Bill Randall Memorial Golf Outing August 29 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 the disease he had since birth was first diagnosed.  He always loved playing sports and spending time with family.  Now his family is teaming up with DWC to raise awareness of this disease and to honor Bill’s memory.  

All the proceeds from the golf outing will benefit the Bill Randall Memorial Scholarship at Duquesne University and the Huntington’s Disease Society of America (HDSA).

According to the HDSA, Huntington’s Disease is a genetic brain disease in which there is a mistake in one’s DNA instructions that builds our bodies and keeps them running. Over time, the damage caused to the brain leads to physical, mental and emotional deterioration. There is currently no cure.

The outing begins with registration and a continental breakfast begins at 7 a.m at Shannopin Country Club. An 8 a.m. shotgun start will kick off the 18 holes in scramble format.  There will be prizes for various contests during the outing, including an opportunity to win a new vehicle from Classic Chevrolet for a hole-in-one.  Afterwards there will be a cookout style lunch at the club.

Registration closes July 31 or when spots fill up.

Data Warehouse Consultants is the host and diamond sponsor of this event.  There are four other sponsorship options available for anyone who is interested. Each sponsorship level and registration option is described in detail on the Bill Randall Memorial Golf Outing website.

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

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).

 

# # #