Blog

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

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

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

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

Loading Flat Files into a Database (Method Overview)

Here we feature a few methods for loading files into an Oracle or SQL Server database. There are many methods for accomplishing this, but over the past few projects, and after implementing most of the methods discussed, I documented some of my experiences.   Here I focus on developing an application or process to load data […]