Blog

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

Loading Flat Files into a Database with C#

This article features some methods that I have used to load data within a C# application.  The methods discussed are an Insert Loop (with bind parameters), the DataAdapter.Update() method, and a custom method of passing the table to a stored procedure. For this article, a simple website demo was setup that accepted a 6-column CSV […]