Required Skills: T-SQL,SSIS,SSAS
Requirement:
I need to create a multidimensional cube which should have type 2 dimensions tables in it. we work on Kimball method .so,we started populating data from source to stage (direct load through packages
).
and from stage to warehouse by creating type2 packages for the tables,so now i need to work on the etl work to populate the fact table in the data mart and after that type 2 dim tables in the datamart that will have etl work . the final stage is i need to show the type2 records in the cube through excel . I CAN SHOW U THE DOCUMENT ONCE WE GET TO KNOW
thank you
1. Once you send through the requirements. I will review and happy to either discuss any questions through skype or send questions directly to your email.
2. Will then put together a quick specification and design of exactly how the system will work and look and answer any questions you may have to make sure we are both on the same page. And everything is as expected.
3. Will go away and develop the solution using the Microsoft BI stack (Will ensure through initial investigations SQL server version, SPs are in line).
4. Will send through daily/half daily update to you on progress.
5. Will demo output and loading process so you can see as well as data produced through SSAS cube into an Excel Pivot to get output as desired.
6. Any questions, enhancements will be discussed and implemented at this point.
7. Once complete second demo if required
8. Finally will package up through a series of scripts with step by step release guide and technical document describing each component.
9. Once you receive will walk you through making sure system is fully up and running on your environment.
10. Final meeting to agree sign off.
11. Will be on hand in future for any minor support questions / More work if required in the future.