Savings & ROI Calculator

DWH Automation: Savings and ROI Calculator

This model calculates the savings implementing DWH automation using the Datavault Builder data warehouse automation tool. The following conservative assumptions were made (to the disadvantage of the savings):

Licence costs were depreciated already in year one (usualy split over 3-5 years)

Training costs assigned to year one

Time savings calculated with 15 % according to an independent study over all automation tools (our customers report 30% time savings)

Better data quality not monetized

Faster delivery not monetized

Being more agile not monetized

The result is: expected savings in the 1st year (saving in the following years are higher) and how many months it takes to reach a complete ROI.

SavingsSetup Cost: save with automated infrastructure setup but also with a well defined and tested modelling and development process.Weekly Costs: save at least 15 % of your time by eliminating repetitive tasks using automation

Include setup savings Developers : 0

Sprint 0: 10 Workdays

Include weekly time savings Data Modeler : 0

200 Workdays / Year * 15%

Include weekly time savings Business Analyst : 0

200 Workdays / Year * 15%

Include weekly time savings Developers : 0

200 Workdays / Year * 15%

Deployment: Agile every 2 weeks : 0

Save 23 x 6h developer

Deployment: Every month : 0

Save 11 x 8h developer

Deployment: Every quarter : 0

Save 4 x 16h developer

Gross Savings 1st year in EUR : 1

Gross Savings 1st year in EUR : 0

CostsYou will spent money on buying the licence. You need only one licence for a productive environment. Test and development installations are included in the price.You will need some training on the tool. General modelling training is not included as you will need it disregarding your tool decision.Depending on how your company is accounting for infrastructure you will need to add costs manually for setting up at least one virtual machine or cloud instance to run the Datavault Builder.

Small and Medium Business (SMB) (19'500 EUR + 20% Maintenance)

Postgres, MSSQL 3 User

Enterprise (39'500 EUR + 20% Maintenance)

MSSQL, Oracle, Exasol, snowflake db (Q3/2018)

Include Training Costs Data Modeler : -0.00

3 days per data modeler

Include Training Costs Business Analyst : -0

3 days per Business Analyst

Include Training Costs Developers : -0

3 days per Developer

Results

Gross Savings 1st year in EUR : 1

Net Savings 1st year in EUR : 0

Months to reach ROI : 0

Net Savings 1st year in EUR : 0

Months to reach ROI : 0

This estimated savings and months to ROI are calculated on experience from completed projects and independant research. The situation in your company can vary.Not included are costs to provide a physical or virtual server to run the Datavault Builder software or network configurations required in your company.