Our Services

Data Warehouse Consultants offers a range of services related to database solutions and custom applications.  We solve your business problems with a mix of process improvement, data and technology.  Here is a list of some services we provide.  Please view our Solutions page for details on specific projects we have successfully completed.

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, which are highlighted on other pages on this site.  If you are contemplating a data warehouse or “big data” project or you simply want to begin leveraging the data you already have to implement a business goal, it is likely we can 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.

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 you with your own big data project, or we can use big data techniques to help you offload a specific project.  Either way we encourage you to contact us to find out how big data may be able to help you.

Custom Applications and Solutions

We specialize in the development of custom web-based and handheld applications to meet whatever business need you have.  Our focus is primarily on applications that require the capture and processing of data for your business. Please visit our Solutions page for a list custom applications we have developed for other clients.

Data Warehouse Design and Improvement

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.

Hyperion Essbase Conversions

We have developed custom programs and processes that convert Hyperion Essbase data into a SQL Server database or Analysis Services OLAP cube. Since acquiring Hyperion, Oracle has greatly increased the price to maintain this software.  If you are looking to move your legacy data away from Hyperion we can create a custom, cost-effective solution to meet your requirements regardless of the size of your Hyperion Essbase cubes.  

Microsoft Access Database Conversions

We specialize in converting applications created in Microsoft Access into a more enterprise-level architecture based on ASP.NET and SQL Server or Oracle.  This provides major improvements in performanceaccessibility and security.  Click here to learn more.