This week we have been working on answering Eric's question with the data warehouse. I feel like the planning made before hand was good but I can now see where it can be polished a little more:
1) First thing is ALWAYS add time to research and understand how to answer the question in production and how things are linked. When we planned this, we just thought of the work to make the dimensional model.
2) Time to Build and load ETL + time to link in Framework Manager + time to make reports + research time + testing time = total time. Keep in mind while testing, this might mean going back through the whole process (hopefully not, but it happens).
While doing this I was able to squeeze in fixing the leave in production. Banner figures leave a little different than how we used to figure leave so we are going to match how Banner works with leave rather than the other way.
No comments:
Post a Comment