We want to use few huge xls sheet as data source, develop cubes and based on the data, develop complex dashboards. I need to prepare the estimation of the project Is there any template or sample estimation to bench mark ? Please share
There are frameworks you can use to assist your requirement engineering, but only you and your business domain experts will be able to set a realistic time frame based on how complicated the data you're trying to model it. If you're warehousing then look [BEAM]. A lot of the above you should ask your business analysts who are useful for this sort of project planning environment. :
> only you and your business domain experts will be able to set a realistic time frame This. There are so many variables involved that it's impossible to quantify without detailed knowledge. > use few huge xls sheet as data source This always makes me shudder. You should think very carefully about how you are going to ensure that the spreadsheet data is cleaned and validated. This should be a significant exercise in itself. It's so easy to get carried away with all the exciting stuff like cubes and dashboards that nobody bothers to ensure that the data is actually fit for purpose!