Brand New BA here (2 weeks):
- My project involves moving data from TPF to Non relational database with real time ETL along the way, WaterFall. My boss asked me: We are spending money everywhere, there are various costs associated with different things like Azure subscription or Database subscription or whatever may be the case. I need you to collect all the cost and rates and expenditure associated with the project and document it. Is there a template anyone can suggest me i should follow to document such info. Someone might say that is not BAs job; thats ok i am trying to take on extra responsibilities. What would you do ? Excel ? Word ? if yes any templates anyone can send me or direct me towards ?
Much Thanks in advance
Suraj
Hi Suraj
Thinking about what your boss is after, I'd maybe approach it by providing solution options (talk to solution architect if you have one). I don't know what TPF is. Presumably TPF is a relational database?
So costs for each option are the licence and maintenance costs of the database for the target less the same amount for the TPF thing being replaced. then consider the resource costs - people - to do the migration and the phases in the project if its complex. Data mapping, coding, testing, etc. Then if there are additional server costs or other stuff, cost those up. Include other software costs if there are any.
Very broad brush but put it all together including line items for each cost. incurred and cost saved. Look at say 3 or 5 year total cost of ownership.
I usually present this in MS Word in table for each option. If there are lots of options it might be better visually to have a summary table as well.
Don't forget a recommended option.
Hope that helps
Kimbo
brought to you by enabling practitioners & organizations to achieve their goals using: