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.

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.

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.

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.