ABCDEFGHIJKLMNOPQ
1
2
CURRENT SITUATIONNOTE
3
Estimated Storage Costs per Terabyte per Month$120Only edit highlighted cells.
4
Current Compute/ Query Hours per Month8,000Try not to alter cells that contain a formula.
5
Total Data Storage Requirements (Terabytes)1,000
6
Estimated Compute Costs per Hour$4
7
Data Engineers Dedicated to ETL5
8
DBAs Dedicated to Data Infrastructure Maintenance6
9
Number of In-House Analysts Who Want Query Access30
10
11
ASSUMPTIONS
12
Avg Fully-Loaded DBA FTE Annual Cost$150,000
13
Avg Fully-Loaded Data Engineer FTE Annual Cost$150,000© 2020 MarTech Review. cloudroi@martechreview.com
14
15
Avoid Expensive Hardware/ Setting Up Another Cluster
16
17
18
Annual Cost SavingsOld System Costs
Cloud System Costs
19
Legacy Storage$1,274,400$1,440,000$165,600
20
+84%Legacy Compute$230,400$384,000$153,600
21
Decrease in costsCapacity Planning$180,000$180,000$0
22
$1,684,800Totals$1,684,800$2,004,000$319,200
23
INITIAL COSTS
MODERN COSTS
Saved this year
24
$2,004,000$319,200
25
26
27
Free Tech Staff From Many Data Infrastructure Requirements
28
29
30
Annual Cost SavingsOld System Costs
Cloud System Costs
31
ETL Labor Savings$600,000$750,000$150,000
32
+75%Maint. Cost Savings$230,400$384,000$153,600
33
Decrease in costs
Auto Upgrade Savings
$90,000$90,000$0
34
$920,400Totals$920,400$1,224,000$303,600
35
INITIAL COSTS
MODERN COSTS
Saved this year
36
$1,224,000$303,600
37
38
Democratize Data and Query Access
39
40
41
42
43
+200%
44
Increase in Analyst Query Value
45
$600,000
46
INITIAL VALUE
MODERN VALUE
Value created this year
47
$300,000$900,000
48
49
Open up More and Fresher Data. Make Data Projects More Agile.
50
51
52
53
54
+80%
55
Decrease in Costs
56
$720,000
57
INITIAL COSTS
MODERN COSTS
Saved this Year
58
$900,000$180,000
59
60
61
62
63