Because we are experts with processing data, many clients request customized web applications to provide access and functionality from data they already have or want to collect. We employee specialists in the development of custom web-based and handheld applications to meet just about any business need you have. Our focus is primarily on applications that […]
About John Shantz
John Shantz is the founder and owner of Data Warehouse Consultants. His credentials include design, development and management duties on dozens of different business intelligence initiatives in various industries across the country. He is an accomplished entrepreneur, data architect and programmer using many different languages and environments. John is also an adjunct professor at the Carnegie Mellon University Heinz School in Pittsburgh.
Entries by John Shantz
Data Warehouse Consultants is focused on the Western Pennsylvania market and encourages our consultants to support the local institutions here. Bob Brichacek, a senior consultant for the firm, moonlights as an adjunct professor at the Carnegie Mellon University Heinz Graduate School. Bob teaches a graduate course in Data Warehousing and acts as a regular sponsor of […]
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 […]
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 […]
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 […]
This visualization shows the daily values for a range of pollutants at several sites in Western PA.
This visualization shows the average and maximum monthly values for a range of pollutants at several sites in Western PA.
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 […]
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 […]