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 […]
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
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.
The radiology department of a top 10 Children’s Hospital began using a customized on-line patient tracking board created for them by Data Warehouse Consultants this week. 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 implementation of 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 […]
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 […]
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.
Data Warehouse Consultants PO Box 101383 Pittsburgh, PA 15237