Are you frustrated by a process that is taking way longer than it used to? Do you have an SSIS process running in your database that is frequently breaking and keeping you up at night? Are you worried because a key member of your team – the only one who knows the ETL process – […]
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 provides on-site training services to increase the in-house knowledge of your technical team. Often data warehouse leads are worried about their progress because they don’t know if they are building the system correctly, or they lack confidence because all they know about data warehousing is what they have read in a Ralph […]
GeocodeIt! is a custom application that allows you load addresses from either a file or a database, then run those addresses through a third-party online service to obtain standardized address and location information. Location data is very important in many types of data warehouse and business information projects. Obtaining standardized address information including addresses and […]
At Data Warehouse Consultants we specialize primarily in data warehouse consulting, as you might expect! We have been working in this space for over 20 years and are experts in many aspects of this industry. Through this work we have developed specialized skills related to data warehousing, which are highlighted on other pages on this […]
Most providers in the space know that designing a dimensional model for a data warehouse is really only the first of many steps. The devil is in the ETL details. This is really where our primary expertise lies. We are experts at finding the data needed, transforming it into usable information, and getting it loaded […]
Efficiency is necessary to run a world-class radiology department. Data Warehouse Consultants developed a virtual tracking board that allows nurses to maintain updates on patients who are getting x-rays, MRI’s and other radiology services across many floors and service rooms. This board enhances communication within the unit and reduces the need to make phone calls by […]
If you already have a data warehouse and you are having problems with it, then we can help. We have vast experience in the design and implementation of data warehouse and business intelligence systems. It’s in our name, and it’s the core competency that our firm was originally built upon.
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 […]
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 […]
Data Warehouse Consultants PO Box 101383 Pittsburgh, PA 15237