Session ID:
Prepared by:
Remember to complete your evaluation for this session within the app!
11147
Augment Oracle Transactional Business Intelligence Reporting with Data Visualization
April 9, 2019 @ 12:45 - 1:45 PM Mano Velu
Director Technology, Analytics BIAS Corporation
About the Presenter
Mano Velu
Director Technology Analytics Practice BIAS Corporation
Passion: Empower business through technology
Company Overview
Founded in 2000 with locations in Atlanta, GA, Reston VA, Bangalore &
Hyderabad, India
5-Time Oracle Excellence Award Winner
~400 employees with 10+ years of Oracle experience on average
Oracle Platinum Partner Cloud Excellence Implementer
BIAS Global Delivery Center Appraised at CMMI Level 3
Inc. 500 | 5000 Fastest Growing Private Companies in the U.S.
for the 8th Time
2018 Best Places to Work
ISO 27001 Certified - Information Security Management System Service Organization Control
(SOC) 2 Certified 35 Oracle Specializations spanning the entire stack
In Cloud,
SaaS Implemented, Have Operational Data,
Cannot Analyze!
The Problem With Multiple Cloud Applications
Vast amounts of data from different areas in an enterprise
• Data from multiple applications
• In different time periods and granularity
• Data is in different formats
• Users don’t always fully understand data
Unable to get a 360 degree view of the business
• More data doesn’t mean more information, unless stitched together
• Some needs are real time and some require historical information
• Data is in silos of SaaS modules
• Reporting capabilities are system or module specific
Organizational Analytics Requirements
Standard Reporting
Formatted Reports Scheduled Delivery Fixed Content
Multiple Consumer Groups
Internal and External
Users
Ad hoc Analysis
Investigative
No Standard Format Analytics and Trends Power Users and Analysts
Business and IT
Users
Dashboards Operational
& Executive
Group of Information Delivered to the Role Daily Refresh
Managers and Executives
Business Users
Different Strokes for Different Folks
Oracle Transaction Business Intelligence
(OTBI)
What is Oracle OTBI?
OTBI is the reporting tool that is comes with SaaS Fusion application. It provides reporting functionality within the module along with ad-hoc query capability.
OTBI enables the end users to create, execute and share reports with minimal IT support:
• Real-time, Self service reporting tool for Fusion Applications
• Seamlessly integrated with Fusion Applications
• Supports Fusion extensions
• Provides Analytical capability
• Drag and drop user friendly reporting tool
• Built in graphs & charts visualization
OTBI Features & Functionality
Real-time Business Intelligence:
➢ No need to extract and/or move data
➢ No latency in reporting Ease of use:
➢ Attributes available in business terms
➢ Folder structure by business entities
➢ Pre-built measures
➢ Minimal configuration needed Interactive reports:
➢ Ability to drilldown to details
➢ Context passed from Apps to OTBI Extensible:
➢ Ability to add DFFs
OTBI Security Features
Enterprise Roles and Duty Roles provide object and data level security:
➢ Enterprise role: Assigned to users which
is related to jobs consisting od one or more duties
➢ Duty role: Group of functional and data privileges representing a duty. These are not assigned to users.
➢ With combination of enterprise and duty role OTBI offers security at
- Subject Area - Report level - Data access
Oracle Analytics Cloud
Data Visualization
What is Oracle Data Visualization?
Data visualization is the process of presenting data in a graphical form. Data visualization simplifies users’ understanding of data by making patterns and outliers visually obvious.
Oracle Data Visualization automates the process of data discovery with features such as:
• Explain any attribute, powered by machine learning
• Automatic identification of anomalies
• Automated/recommended chart creation
• Single-click trending and forecasting
• Drag and drop clustering and outliers
• 100s of built in and 3rd party visualizations
• Voice-enablement and NLP support
Consolidating Cloud Data for Data Visualization
Data Replication for Oracle Analytics Cloud was introduced in 2017 and was significantly improved in September 2018 release.
Data Replication makes data more readily available for Data Visualization without repeatedly executing expensive queries or data extracts on the original data source.
Data Replication allows organizations to build content packs for Oracle Cloud applications.
What targets can I replicate data into?
▪ Oracle Eloqoua
▪ Oracle Fusion Applications
▪ Oracle Service Cloud (RightNow)
▪ Oracle Talent Acquisition Cloud (Taleo)
▪ Oracle Database Cloud Service
▪ Oracle Big Data Cloud
▪ Oracle Autonomous Data Warehouse Cloud
What sources can I replicate?
Data Preparation and Enrichment
Join Merge Filter
Aggregate Group
Predict Train
Data Visualization Sample - Three Sources
Augmenting OTBI with
Data Visualization
The Analytics Dilemma
How do I keep up with new data sources?
• New and updated corporate systems require new and updated data models
• External and ad hoc sources pose unique challenges for data validation and curation
How do I get “360 degree view” of my business?
• Avoiding silos of information which requires a lot of ETL in traditional BI
• End users need cross business operational information and also historical trends
How do I meet the needs of different business users?
• Business at different levels demands different experience
• Different business users require a spectrum of capabilities
SaaS Analytics Needs Beyond OTBI
• Ability to combine SaaS data with data from other applications
• Cross module reporting and analysis – Each subject area is module specific
– Data is often in different modules but needs to be reported together – Project & OTL
• Transformation needed for complex business logic
• Execute custom SQL directly against SaaS database
• Ability to perform complex analysis
• Exporting more than 25000 rows to Excel
Marrying Strengths of OTBI with DV
Best of both worlds
• Realtime reporting
• Access to all attributes in a given module
• Some transformations possible
• Operational reporting for Fusion Applications
• Included with SaaS subscriptions OTBI
• Can combine information from multiple cloud & on-premise applications
• Wide variety of visualization available
• Realtime reporting & from DWH
• Extensive transformations and complex calculations possible
• Built-in adaptors for a wide range of data sources
• Data can be extracted and loaded directly from/to the database
• Intuitive trend lining and predictive modelling capability
DV
DV Content Packages for Oracle SaaS Applications
▪ Oracle Database Cloud Service
▪ Oracle Big Data Cloud
▪ Oracle Autonomous Data Warehouse Cloud
•Options for On-Premise, All Cloud and Hybrid solution
•Easy to setup and manage
•Easy to use – competes with Tableau and Qlik
•Connects to SaaS as well as IaaS Cloud and On-Prem EBS
• Does not require a data warehouse – so less complexity
•Lowers total cost of ownership while providing better capabilities
Technology Benefit
•Migrating to cloud or using cloud applications
•Current users of BI Applications and OBIEE – Visualization capabilities to users
•EBS Customers without BI Apps – Deliver better analytics at lower cost
Use Cases
•Finance Manager
•Sales VP
•Sales Manager
•Marketing Analyst
•Project Manager
•Payables Manager
•Grants Manager
•Service Manager ………
Available Packs - Role Based
Prebuilt Business Content
•Attrition Analysis
•Compensation
•Workforce Performance Sales VP
•Top deals in Play
•Sales review
•Pipeline trend
•Revenue trend
Marketing Analyst
•Campaign performance
•Campaign cost
Service Manager
•Open incidents
•Closed incidents
•Team performance
Setup Content Pack in DV
➢ Download desired Content Packs – Contains .dva file and a .catalog file
➢ Import the .dva file in DV
➢ Deploy the .catalog file in OTBI
➢ Establish a connection from DV to OTBI
➢ All set to go
➢ Create a Dataset
➢ Open a project and build reports
Data Flows
• Join
• Merge
• Filter
• Aggregate
• Group
• Predict
• Train
Session ID:
Remember to complete your evaluation for this session within the app!
11147
