Entries by John Shantz

Customized Data Warehouse Training

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

Geocode It!

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

Read Email into Your Database

Did you ever wish you could have your email converted directly into your database?  We can help you implement the software and processes necessary to accomplish this seemingly simple, but more-complicated-than-expected task.  The DWC Mail Reader will monitor an incoming email box and load the data into your SQL Server database in structured tables.  Header […]

Full Service Consulting

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

Extraction, Transformation and Load (ETL) Development

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

Prototype Review of Azure SQL Data Warehouse

Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings.  The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure SQL Data Warehouse, which is Microsoft’s current cloud offering focusing on the data warehousing space.  For more information on this prototype or similar work […]

Our Experience with Azure HD Insight

Data Warehouse Consultants is constantly investing in our staff to learn new technologies and offerings.  The summary below was published by our analyst Mukesh Thangadurai regarding the use of the Azure HD Insight product, which is Microsoft’s current Hadoop offering.  For more information on this prototype or similar work we can do for your company, […]

HIPAA Compliant Patient Tracking

One major challenge of current Electronic Medical Record (EMR) technology is that it is virtually impossible for a single hospital department to simply track their own patients.  Most departments only need a small subset of the available information, but they need it accessible in their own format.  To solve this problem many departments use shared […]

Read Emails into Your Database

Have you ever wanted to integrate your inbox directly into your website or other database application?  Data Warehouse Consultants has developed a Windows application that can handle this.   This software is typically run as a windows service, and monitors an email inbox or other folder over an IMAP connection.  When email arrives the application seamlessly […]

Radiology Tracking Board

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