Leveraging Cloud for Business Intelligence
Presented By
Aashu Aggarwal www.bluepiit.com
Agenda
01
Business Intelligence
02
Business Intelligence on Cloud
03
Pros and Cons
04
ROI Metrics
05
On-premise vs Cloud ROI
06
Running BI on AWS
www.bluepiit.com
Business Intelligence
• •
•
Set of tools and techniques to get useful information for business analysis purpose. Examine historical data and trends to set metrics benchmark. Consists of ETL Data Warehouses OLAP
www.bluepiit.com
www.bluepiit.com
Cloud Computing
01
On Demand
02
Pool Of Resources
03
Rapid Provision
04
Access From Anywhere
05
Reduced Management Cost
www.bluepiit.com
BI in the Cloud SaaS
PaaS
Data Visualization (SAP Business Object etc.)
Data Warehousing (OCO, Panoroma, etc.)
Data Analytics (SAP Business Objects, Microsoft, LucidEra etc.)
Data Integration (IBM, etc.)
Performance Management(SAP Business Object etc.)
Hosted BI Platform (Microsoft Azure, SAP Business Object etc.)
www.bluepiit.com
Database (Vertica, etc.)
IaaS Data storage and Processing power (Amazon EC2 etc.)
Pros Low Setup Cost Reliability and Scalability Easy Access Easy Maintenance Flexible More Focus on Core activities
www.bluepiit.com
Cons Transfer large data sets Geographical Constraints or Regulations. Limited services by established BI vendors. Integrating on-premise data with cloud components
ROI Metrics
•
Financial Payback Period Net Present Value Internal Rate of Return
•
Non Financial Consumer Satisfaction Ratings by Independent Agencies Better Decisions and Time Utilization
www.bluepiit.com
On-Prem vs Cloud based ROI Hardware Costs | License Costs | IT Services Costs | Support Costs | Upgrades Cashflow Calculation Worksheet
Cost Component
On Premise
Vs On cloud/Hybrid
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Capex-Hardware
140270
122
122
122
0
0
30270
57
57
57
0
0
Capex-Software
251
56
56
56
0
0
251
56
56
56
0
0
0
0
0
0
0
0
66000
66000
66000
66000
0
0
Capex- IT Services
100
0
0
0
0
0
30
4
4
4
0
0
Opex-AMC (Annual Maintenance
225
5
5
5
0
0
225
5
5
5
0
0
Contract) for TCO period
63
3
3
3
0
0
40
0
0
0
0
0
AMC-Hardware for TCO Period
128
0
0
0
0
0
128
0
0
0
0
0
141037
186
186
186
0
0
96944
66122
66122
66122
0
0
Savings
190
102000
102000
102000
0
0
6140
157000
157000
157000
0
0
Revenue
40
0
0
0
0
0
40
0
0
0
0
0
Total Inflow
230
102000
102000
102000
0
0
6180
157000
157000
157000
0
0
-140807
101814
101814
101814
0
0
-90764
90878
90878
90878
0
0
Outflow
Capex-Cloud Licenses
Total outflow Inflow
Cashflow
www.bluepiit.com
On-Prem vs Cloud based ROI
ROI Metrics Payback Period Net Present Value (NPV) Internal Rate of Return (IPR)
www.bluepiit.com
Formula
Values (in Years) Cloud
On Premise
No of years when Total Inflow = Total Outflow
0.99
1.4
The value of future benefits restated in term of today’s money
$122,941.94
&102,172.14
The benefits restated as an interest rate
85%
13%
The world of Reporting
Information Access
Enterprise Information
The Intelligent, Agile Enterprise
Performance Management
ROI($)
Events detection
Enterprise dashboard Propensity modeling
Risk management
segmentation
Data quality
reports
Manual spreadsheets
www.bluepiit.com
KPIs Data marts
Financial management Profitability OLAP Enterprise data warehouse
Relationship optimization
Amazon Web Services
01
Easy To Use
02
Flexible
03
Cost-Effective
04
Reliable
05
Scalable and High Performance
06
Secure
www.bluepiit.com
Why run BI on AWS
01
Managing databases is painful and difficult
02
SQL databases does not scale well
03
Difficult to deploy and manage Hadoop
04
Data warehousing solutions are costly, complex and slow Streaming data is difficult to capture
05
www.bluepiit.com
Databases RDS
Analytics EMR Kinesis
DynamoDB Machine Learning RedShift
ElastiCache
Quicksight
Elastic search Data Pipe Line
www.bluepiit.com
Work Flow Redshift Kinesis Streams
EMR Cluster Engine RDS
6 4 2 0 Series 1
www.bluepiit.com
Series 2
Series 3
Thank You www.bluepiit.com
Contact for further details at aashu@bluepi.in