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.


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 Kimball book.  We can bring in an experienced consultant to provide guidance to your development team and help answer questions specific to your business.  The training format can be either 2, 3 or 4 days depending on your needs and budget.  Contact Us today to get more information and plan your in-house training.

 

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 site.  Please explore the services we provide using the menu on the right.  If you are contemplating a data warehouse or simply want to begin leveraging the data you already have to implement a business goal then we can help.

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 into your data warehouse for user consumption.  We estimate that in a typical data warehousing implementation, 70-80% of the work is ETL.  We are tool agnostic and can develop the ETL programs either using custom code or a tool you have licensed.

If you don’t understand what ETL is and why it is hard, you are not alone.  It’s a lot like the construction of a new home.  First you design the house by creating a conceptual drawing of what the house will look like when you are done.  It’s clean and straightforward.  It’s pretty, and it’s a very important step to building your dream house.  This is what a dimensional data model design is for a data warehouse.

But when the design is done, the project isn’t finished!  It’s more of a starting point than a result.  Next you have to schedule the work, decide what will be done first, build the house in an intelligent manner, and deal with all of the little problems that come up along the way.  In a data warehouse, that is the ETL development.  It’s the cement, pipes, wood, nails, drywall, tile paint,  appliances and all the associated labor to install them.  It’s taking your design and bringing it to life in a way that will be meaningful for your users for years to come.

 

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.

Custom Applications and Solutions

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 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.

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.

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.

Microsoft Access Database Conversions

We specialize in converting data from operational databases into data warehouse systems, and we find that many organizations still run business-critical applications in Microsoft Access and Excel.  This can often lead to issues with application performance, accessibility and security, and represents a major risk that organization don’t need to take. We have helped many organizations convert these applications into a more enterprise-level architecture based on ASP.NET and SQL Server or Oracle which can provide stability and peace of mind for your business, while providing your team access to these previously walled-off applications from anywhere.

Architecture Redesign

Data Warehouse Consultants works with clients to re-invent and re-architect the back-end processes that are used to provide business intelligence solutions to their clients. We specialize in making our clients’ processes more automated and efficient, and help our clients provide superior business intelligence products faster and with less overhead.

VMS to Database Conversion

Our team has performed a number of VMS to Oracle database conversions. Our consultants are experienced in working with large datasets on the file system and in the database. We have done many projects that involve the conversion of vast amounts of flat file data into a relational database.  Data Warehouse Consultants has developed many custom ETL processes and programs that successfully convert VMS flat file datasets into Oracle. Additionally we have developed custom reporting solutions that provide a means to recreate the flat files from Oracle back to VMS. These solutions provide a proven method to convert from VMS to Oracle in a phased approach, while validating that the data is correct at each phase in the project.