Entries by John Shantz

Software Engineer

  DWC is currently seeking to fill a software engineer position. The position requires a strong leader who is comfortable working directly with the client throughout all of a system’s development in a technical environment. Applicants must have previous consulting experience.  This is an excellent position for a consultant at a large consulting services provider […]

Excel External Content Blocked

We have been encountering a new issue with Microsoft Excel and one of our clients had it today.  It took a little while to figure out, so we want to help out others in this situation.   Issue – Excel External/Web Content is Blocked: In most of our interactive applications, we allow for exporting data (either to […]

UPMC Wins Davies Award for Custom DWC Solution

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

Children’s Hospital Implements Radiology Tracking Board

Pittsburgh, PA:  The radiology department at Children’s Hospital of Pittsburgh of UPMC this week began using a customized on-line patient tracking board created for them by Data Warehouse Consultants. This new application significantly reduces the phone calls and coordination that nurses, physicians and staff must do to efficiently move patients through the radiology department. The […]

Development in Sqoop 1 vs Sqoop 2

I was working on a project last week to load data into a HDFS-based Hive database. This was essentially a periodic load so Sqoop appeared to be the best tool for the job. My small project consisted of the following goals: – Connect Sqoop to SQL Server and/or Oracle instances – Export a set of […]

Big Data and Hadoop

Our firm is on the cutting edge of data warehouse technologies including the new “big data” technologies surrounding the Hadoop ecosystem.  We have project experience with Map-R and Hortonworks, as well as many of the related tools including Hive, HBase, HUE, Sqoop, HDFS and Flume to name a few.  We support consulting engagements to help […]

Tableau Development

We have recently identified several clients who are standardizing on the Tableau tool set. This tool is a very powerful addition to a data warehouse or other reporting environment. Our firm has invested time and resources into training for this tool. With this knowledge and our significant experience in data manipulation and processing, we are able to quickly deliver innovative visualizations for our customers within custom constraints they require. We can build these visualizations against both static data sets and complex systems like production databases and data warehouses. Here are a few small samples of our work in this area.