Getting Value from Big Data with Analytics
Edward Roske, CEO
Oracle ACE Director
[email protected]
BLOG: LookSmarter.blogspot.com
WEBSITE: www.interrel.com
TWITTER: Eroske
About interRel
Reigning Oracle Award winner
EPM & BI Solution of the year
Three Oracle ACE Directors
Authors of 10+ of the Best Selling
books on Hyperion & Essbase
Oracle Platinum Partner
One of the 100 fastest growing tech
companies in the USA (CRN
Magazine)
One of the fastest growing companies
in USA (Inc. Magazine 2007-present)
Strategy
Infra structure
Consulting
Training Support
Press
Founded in 1997, we are the
longest-standing, Oracle EPM/BI-
dedicated partner in the world
3 New Hyperion Planning Books!
Planning 11.1.2.2/11.1.2.3: Creating
Applications
Planning 11.1.2.2/11.1.2.3: Advanced
Planning
Planning 11.1.2.2/11.1.2.3: An
End User’s Guide
Smart View 11.1.2.2: End User Guide
Essbase Studio 11.1.2.2
Essbase 11: Admin Guide
Visit interRel.com, to purchase these
titles & more!
10+ Best Selling Hyperion Books
?
What is
Big Data
?
What Are Questions We Can Answer Without Big Data?
D ire cto r o f T e ch n o lo gy S yste m s A rch ite ctu re
C IO
C o rp ora te P la n n ing F in a n cia l A n a lyst V P F in a n ce
B u d g e t D ire ctor D ir. F in an cia l R e p o rting
C o n tro ller C F O
S a le s D ire ctor S a le s D ire ctor R e g io n a l V P
S a le s D ire ctor S a le s D ire ctor R e g io n a l V P V P S a le s
M a rket M an a g er P ro d u ct M a n a g er D ir., P ro d u ct M a rke ting
D ire cto r, P u blic R e la tio ns D ire cto r, C re ative S e rvices
V P M a rke ting
P ro d u ctio n M a n a g er P ro d u ctio n M a n a g er M a n u factu rin g D ire ctor
D ire cto r, L o g istics V P O p e ra tio ns C E O
Can we plan a mid-year Promotion?
Can we support the
additional production?
Can we handle the distribution?
How much will it increase
sales?
Do we have the money to fund this?
How much did it increase
profit?
Did our initiatives increase shareholder
value?
What Are Questions We Need Big Data To Answer?
D ire cto r o f T e ch n o lo gy S yste m s A rch ite ctu re
C IO
C o rp ora te P la n n ing F in a n cia l A n a lyst V P F in a n ce
B u d g e t D ire ctor D ir. F in an cia l R e p o rting
C o n tro ller C F O
S a le s D ire ctor S a le s D ire ctor R e g io n a l V P
S a le s D ire ctor S a le s D ire ctor R e g io n a l V P V P S a le s
M a rket M an a g er P ro d u ct M a n a g er D ir., P ro d u ct M a rke ting
D ire cto r, P u blic R e la tio ns D ire cto r, C re ative S e rvices
V P M a rke ting
P ro d u ctio n M a n a g er P ro d u ctio n M a n a g er M a n u factu rin g D ire ctor
D ire cto r, L o g istics V P O p e ra tio ns C E O
What are people saying
about our product?
Why are we having so much machine
downtime?
Why are shipments being
delayed?
Do we have the right mix of products?
Is their fraud going on in our financials?
Why do our computers crash
all the time?
Is the board of directors about to
terminate me?
What Does Big Data Mean to You?
What Are The Two Types of Data?
Structured
Data
Unstructured
Data
Where Does Big Data Come From?
Structured UnstructuredUnstructured
What Are the V’s of Big Data?
Volume
Scale of Data
Velocity
Speed of Data
Variety
Forms of Data
Veracity
Uncertainty of Data
How Do I Get Value From Big Data?
?
How Do We
Analyze
Big Data
?
Financial GL
HR
DATA
Sales Distribution Custom
Dashboards Adhoc Report Books Mobile Office Self Service
Business Intelligence
How Do We Get Data to End Users?
What Do End Users Want From an Interface?
Consistent Easy to use Interactive
Flexible Fast Seamless
Efficient Thin client
Minimal
training
required
?
How Does
Oracle Handle
Analyzing
Big Data
?
Essbase
Common Enterprise Information Model
Endeca Dimension
Management Interactive
Dashboards Reporting &
Publishing Query &
Analysis Detect
& Alert Office
Integration Search Embedded Mobile
Scorecards
ERP Analytics Planning &
Forecasting Financial Close and
Reporting
Strategy Management
Profitability Management
CRM Analytics
Industry Analytics
Data SourcesBI/EPM PlatformBI / EPM Applications
OLTP & ODS
Systems Data Warehouses
Data Marts Packaged
Applications (Oracle, SAP, Others)
Excel
XML/Office Business Processes SourcesOLAP
Exadata Unstructured &
Semi-Structured
Oracle Business Intelligence Foundation Suite
BI Server
Glimpse into OBIEE
Glimpse into OBIEE
Glimpse into OBIEE
Glimpse into OBIEE
Glimpse into OBIEE
Glimpse into OBIEE
27
Oracle BI Mobile Application Designer
Mobile Reports
?
What Are the Steps to
Integrate Oracle BI
With Big Data
?
30
1. Assess the current state of your data
Assess and understand your biggest pain points and needs
E.g. Collecting information from too many sources and systems for consistent reporting?
E.g. Putting adhoc analysis and advanced analytics in the hands of end users, replacing SQL generated reports?
Other important questions
Where is data stored? Where should I store data? How many sources?
Do I have a data warehouse? Is it complete?
What are the query performance requirements?
What are the requirements for the timing of data delivery (e.g. real-time, nightly)?
What are the subject areas?
What do the reports look like?
What is the time frame for implementation?
Who are my users and what do they need to be able to do?
How do users need to visualize and analyze data?
What calculations and business rules need to be included?
Are write back capabilities required?
3
2. Prioritize and Plan
Prioritize the requirements – this will help you understand where
your focus should be
Take a phased approach in the implementation and remember you
don’t have to build everything at once
Build the right team
Ensure communication between data warehouse resources,
unstructured data resources, and BI resources
You are all on the same Information Delivery team!
Work together!
Start small
Subject area in BI Server, Essbase, or Endeca
And Finally…
3. Implement / Show Success
Next Phases / Continual Improvement
In Summary…
http://bit.ly/ORABigData
34
Solving Common Data Access Issues
Common Data Access Issues The Solution
No single strategy for information delivery Business Intelligence along with your data warehouse and
unstructured data delivers a complete information delivery system IT vs. end user queries Common workspace with user friendly tools puts reporting and
analysis in the hands of end users
Silos of information BI delivers a common enterprise model to eliminate silos of information across databases and systems
Limited visibility BI provides better visibility to key metrics and factors that drive business performance
Limited correlations BI provides a way to correlate relevant information across database and systems
Different end user needs A common workspace provides information access for both advanced and basic end users.
BI allows customizations to different end user groups sourced from the common enterprise model.
Common Data Warehouse Issues
Common DW Issues The Solution Time consuming data warehouse
changes
Incorporate changes and new sources to the data warehouse in BI layer (virtually) vs. in your data warehouse (physically).
Immediate reporting access for new sources as they are included in logical schemas or through information discovery
Can’t handle unstructured data Use Hadoop to house data or just mine the data through your BI layer.
Data latency Provide real time / near real time access with Business Intelligence
Costly aggregate structures OLAP’s main purpose in life is to store aggregated data for fast reporting and analysis.
Remove aggregations from the DW and use OLAP.
Ever changing Business Definitions BI provides a model for easy updates to business definitions Common dimensions and common
definitions
Business Intelligence provides a common enterprise model for information while allowing for customized presentations and views of end user specific terms and dimensions