live webinar bi in hybrid cloud environment

8/19/2019 Live Webinar BI in Hybrid Cloud Environment

1/40

© Copyright 2015. Apps Associates LLC.

Business Intelligence in a Hybrid Clo

Environment

August 20, 2015

Kshitij KumarGlobal VP of BI/EPM and CTO

Apps Associates LLC


2/40


Ag

• Evolution of Hybrid Cloud

•

Business Intelligence in Hybrid Cloud – Oracle Business Intelligence Enterprise Edition (OBI-EE)

– Oracle Business Intelligence Cloud Services (BICS)

• Why Data Lakes

– Oracle Big Data Discovery (BDD)

• Planning for Hybrid Cloud

• Questions and Answers


3/40


Confidentiality State

The content of this document is proprietary, confidential informatio

Apps Associates’ products, services, solutions and methods. Informa

intended for use by the client or prospective client only and must no

with any third party without consent from Apps Associates.


4/40


About Apps Associates


5/40© Copyright 2015. Apps Associates LLC.

Performance. Growth. Excell

• Global Reach for Global Customers

‒ Founded in 2002 – 650+ employees

‒ HQ in Massachusetts‒ US (East, Central, West)

‒ Europe, India, Middle East

• Oracle BI Journey Started in 2007 – Represents 40%+ of Our Business

‒ BI Pillar Partner & Specialized

‒ Oracle Platform Technology Solutions BI/EPM

‒ Oracle BI Applications Leadership Board

‒ Beta Program for ODI 12c‒ First Oracle Exalytics Certified Delivery Partner

‒ Analytics in a Box (Co developed H/W S/W bundle offering with Oracle)

‒ One of the first partners selected for BI Cloud Services (BICS)

‒ AWS Certified for Oracle on AWS (only 2 partners worldwide)

• Over 125 consultants (all employees) delivering OBI services

• Proprietary data lineage and migration tools



Dedicated Oracle Cloud Exper

• Dedicated On Prem

practices related to

Data, ERP, HCM, Sal

CPQ Cloud

• Oracle Certified con

Functional business

onsite team

•BI and Hyperion skilout the team for the

• Integration teams s

movement between

and non-Oracle syst

Big Data

BICS + PBCS

ERP Cloud

HCM Cloud

Sales Cloud

CPQ Cloud



What is Hybrid Cloud



We are Back Where We Started (So



Evolution of Hard

1970 – 80

Academic,

large

enterprises

1980 – 90

Most

companies,

home use

1990 - 2005

Getting

personal2005 - 2

Explosio

data, dev

everywh



Evolution of Software -> Hybrid Comp

1 9 8 0

- 1 9 9 0

1. Departmental applications

2. Departmental reporting

3. Minimal integration

4. Evolution of data center

5. Structured data

6. No Big Data

1 9 9 0

- 2 0 0 5

1. Evolution of ERP (monolithic)

2. Integrated cross

departmental businessapplications

3. Collect lot of data

4. Mostly departmentalreporting

5. Some cross departmental

6. Data (center) grew

7. Purchase for peak capacity – Capital lock

8. Start of unstructured data

9. Start of mobile devices

10. Big Data only for largeorganizations

2 0 0 5 –

2 0 1 5

1. Explosion of data

2. Explosion of devices

3. Social media

4. Just ERP – no value

5. Just reports – no value

6. DW / BI critical forcompetition

7. Cloud prominent

8. Start of IaaS, SaaS, PaaS

9. Beginning of decoupling ofERP

10. Back to purpose built

business application on cloud – SFDC, Workday

11. Part ERP on Prem, Part ERPon cloud – Hybrid

12. Big Data – seen as valuableby most organizations (cost)

12. Too much data 2 0 1 5 –

2 0 2 0



Hybrid Cloud Frame

HR FIN

SCOM SALES

PROCUREMENT

PLANNING

DW / BI


12/40


Which Architecture to Ch

No good an

Cost of inte

Cost of dataCost of buil

Business Intelligence – an integration approach


13/40


Mega Vendors In Hybrid

• Started in cloud: IaaS

• Moving into applications : SaaS

• Databases

• Relational• Columnar

• Big Data

• Started Ap

• Moving to

• Both IaaS a

• Core On-Pr

• Database

• ERP

• BI


14/40


BI in Hybrid Cloud


15/40


BI in Hybrid Cloud:

• Over 75% - 80% of reporting needs are departmental

• Majority of BI users do not need cross departmental

• Those who do, are used to Excel‒ Single tool that made all integration specialists

• Distributed ERP with distributed BI is OK

• Cost of integration, not a barrier

• Need to stay competi

• Need to retain emplo

• Need customer loyalt

• Data is growing

• Users are growing

• Devices are growing

• Security needs are gro

• BI no longer optional

• Need to be 24x7 like E

• Some Big Data plan in next 18 to 24 months

• Want to dip their toes into ‘Data Lakes’

• Infrastructure needs


16/40


BI in Hybrid Cloud: Op

IaaS SaaS

1. Oracle Business Intelligence Ent Edition (OBIEE)

2. Oracle Business Intelligence Applications (OBIA)

3. Oracle Hyperion Applications

4. Oracle Big Data Discovery (BDD)

B r i n g y o u

r o w n l i c e n s e

Easiest Migration

Lift and Shift

1. Oracle Business Intelligence Cloud

2. Oracle Transactional Business Inte

3. Oracle Transactional Business Inte4. Oracle Planning and Budgeting Clo

5. Oracle Big Data Discovery Services


17/40


Private Cloud / On Prem Public Cloud (SaaS) Public Cloud (IaaS) / Ora

Transactional Data Transactional Data Big Da

BI in Hybrid Cloud: O

Transactional Data File

On PremTraditional DW


18/40




BI in Hybrid Cloud: BI Cloud Services (



Cloud Connector

Visual Analyzer


19/40


BI in Hybrid Cloud: OBIEE vs

OBIEE (2007)

Great for on-prem BI (if majority of reporting)

Any source, direct integration

Data warehouse not a must (but recommended)

Native integration with Hadoop

Native integration with Essbase

ODBC / JDBC Connectors for DB running on Cloud

Keep close to ERP

Option to ‘Bring your Own License’ to Cloud

Building metadata and model – complex

Not written for cloud / hybrid – thick admin client

BICS (Oct 2014)

Written grounds up for cloud

Designed and optimized for clou

Designed with business user foc

No native integration with Hado

No native integration with Essba

Cloud connector for on-prem on

Data load options optimized for

Very rapid implementation

New features pushed, No patch

Visual Analyzer – rich, interactiv


20/40


Data Lakes and Oracle Big Data Discovery


21/40




BI in Hybrid Cloud: Problem with




22/40


What is a Data

Structured Unstructure

Process Visualize

Store all data

No need to model

Define relationship when needed

Allow access thru tools

Store results back or into D/W

Build o

Scalabilit

Can

Achieve

/


23/40


When You Think About Data Lake / Big


24/40


Two sit

Cassandra

I have data lake but I think I need data lake but

Type I : Swimming in the lake Type II : Dipping toe

F o c u

s o n S o l u t i o n :

P l a t f o r m /

I n d

i v i d u a l t o D e p a r t m e

n t a l

1. Have the objective met beyond Phase I ?

2. What new business problems (changed) ?

3. What worries you, people or technology ?

4. Investment not paying off?

5. Business not getting value ?

6. Long time for analysis’ results?

1. What business problem are you t

2. Why data lake / big data?

3. Do you have a roadmap for enter

4. Is the initiative business or IT driv

5. Where to get the skill set?

6. Data Scientists and functional kno

K Ch ll i M i B


25/40


In

Addressed by Big Data Discovery

Key Challenges in Managing B

BDD V l P


26/40


Note: Company logos and images are for illustration purposes only. Not a real use case for the company.

BDD Value Propo

Bi D t Di


27/40


Big Data Disc

28

Fi d D t


28/40


Find Dat

29

E l D t


29/40


Explore Dat

30

Transform Dat


30/40


Transform Dat

31

Dis


31/40


Dis

32

Behind the Scenes Compo


32/40


Behind the Scenes Compo

33

Benefits of BDD for Data


33/40


Benefits of BDD for Data

• Give power of analysis on big data to power users

• Reduced dependency on Data Scientists

• Data Scientists can focus on core analysis

• Easy to define structure on data using GUI based

• GUI will answer over 70% of scenarios

• Allows to integrate

• Allows to integrate

• Allows to save resu

Hadoop

• Allows to save resu

• Allows to perform f

analysis‒ Tie back key dis

actual transactio

• Works on commercial hardware

• Works on Oracle Big Data Appliance

• Works as a service (coming soon)


34/40


Closing

Planning for Hybrid BI + Data


35/40


Planning for Hybrid BI + Data

1. Define Business Problem First

2. Define Business value / desired outcome

3. Define Business Process

4. Build Roadmap

5. DO NOT FOCUS ON TOOLS – they change

6. Let tools not dictate strategy

7. Focus on ease of use for business users

8. Be in the business of your business and not in the

business of data center management9. Don’t get hung up on off the shelf integrated solution

10. Measure the cost of COTS vs. building point solution

11. New technology does not mean harder tools

12. Let business users focus on getting value from new

platform than learning tools

Conc


36/40


Conc

1. Technology is in transition

2. No perfect answer

3. No vendor has comprehensive solution

4. Each has something that other does not

Big Question : Can you afford for technology to mature ?

1. Can you wait for all the integrations in place

2. Customers are going to move to whoever provides best value

3. Identify a pilot project

4. Pilot should have a measurable business value

5. Use that to justify funding for subsequent projects

6. Be prepared – what you do in your pilot + 2 project will be different from what you did in pilot

7. Pick a vendor that will serve as your backbone

1 to 2 weeks

Fast Start Package (BICS, Da

Think of Your Data as Natural Oil – Pre


37/40


Think of Your Data as Natural Oil Pre

Oil refineries are the best example of how they make best use o

Use every part of data. Do not throw any of it away. Storage is c

Than


38/40


Kshitij KumarGlobal VP of BI/EPM and CTO

Apps Associates LLC

[email protected]

Business Intelligence in a Hybrid Cloud Environment

Than

Connect wi

mailto:[email protected]:[email protected]


39/40


Connect wi

Web: www.appsassociates.com

Email: [email protected] YouTube: www.youtube.com/user/AppsAssociates

LinkedIn: www.us.linkedin.com/company/Apps-Associates

Twitter: @AppsAssociates

Facebook: www.facebook.com/AppsAssociatesGlobal

Google+: www.plus.google.com/+AppsAssociatesGlobal/

http://www.appsassociates.com/mailto:[email protected]://www.youtube.com/user/AppsAssociateshttp://www.us.linkedin.com/company/apps-associateshttps://twitter.com/AppsAssociateshttp://www.facebook.com/AppsAssociatesGlobalhttp://www.plus.google.com/+AppsAssociatesGlobal/http://www.plus.google.com/+AppsAssociatesGlobal/http://www.facebook.com/AppsAssociatesGlobalhttps://twitter.com/AppsAssociateshttps://twitter.com/AppsAssociateshttp://www.us.linkedin.com/company/apps-associateshttp://www.us.linkedin.com/company/apps-associateshttp://www.us.linkedin.com/company/apps-associateshttp://www.youtube.com/user/AppsAssociatesmailto:[email protected]://www.appsassociates.com/


40/40

live webinar bi in hybrid cloud environment

Documents