Our company leadership is finally getting to the point where they want to use our historical data for analysis and business planning. The problem is, we have no warehouse and have historically (last 2 years) been doing most analysis using our production databases. Now that they want to see certain trend data, I get to be the one to tell them that we don't have the data for it because our systems don't track changes to what they're looking for, only the current value.
One of my personal goals for the next 1-3 years is to stand up a warehouse and ETL layer to make this possible, but I need help in scoping, planning, designing, and implementing. I could theoretically do it all myself, but I'd rather not relearn someone else's lessons. I have an overall idea of what we need and how to do it, but the devil is always in the details.
Does anyone know of any consultants I could talk with to get an idea on platform options, cost, timeline, etc? Anyone with that kind of experience looking for a job?
One of my personal goals for the next 1-3 years is to stand up a warehouse and ETL layer to make this possible, but I need help in scoping, planning, designing, and implementing. I could theoretically do it all myself, but I'd rather not relearn someone else's lessons. I have an overall idea of what we need and how to do it, but the devil is always in the details.
Does anyone know of any consultants I could talk with to get an idea on platform options, cost, timeline, etc? Anyone with that kind of experience looking for a job?