eis proprietary and confidential andy donovan – eis technologies replacing discoverer? so what are...

27
EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Upload: liberty-bowerman

Post on 31-Mar-2015

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Andy Donovan – EiS Technologies

Replacing Discoverer?So what are your options?

EiS Proprietary and Confidential

Page 2: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 3: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 4: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Dashboards Key Performance Indices (KPIs) Balanced Scorecards Trending Benchmarking Analytics Ah-hoc Reporting

What is Business Intelligence?

Business Intelligence (BI) refers to skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context

© Wikipedia 2009

Page 5: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Dashboards Key Performance Indices (KPIs) Balanced Scorecards Trending Benchmarking Analytics Ah-hoc Reporting

What is Business Intelligence?

Business Intelligence (BI) refers to skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context

© Wikipedia 2009

“Getting the Right Information to the Right People at the

Right Time to improve Organizational Performance”

Page 6: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

• Strategic When - For the next 5 years Who - “C” Level What - Planning and forecasting

What is Business Intelligence?

Page 7: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

Tactical

What is Business Intelligence?

• Tactical When - This and next year Who - VP’s and Senior Directors What - Analysis, Project Over-runs

Page 8: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

Tactical

Operational

• Operational When - Today and yesterday Who - LOB Management What - What happened?

What is Business Intelligence?

Page 9: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 10: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Where Does OBIEE Fit?

Data WarehouseOracle Apps Transactions

Operational Tactical Strategic

Present dayWhat is happening now?Live transactional reporting

History and short to medium termAd hoc reporting, Why?Management & statutory reporting

What will happenLong term plans, ForecastsScorecards and Dashboards

BI Publisher

Page 11: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Where Does OBIEE Fit – REALLY !!!

WarehouseOracle Apps Transactions

Operational Tactical Strategic

BI Publisher

Transactions, Transactions, Transactions

Summary

Page 12: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 13: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Where Does OBIEE Fit – REALLY !!!

WarehouseOracle Apps Transactions

Operational Tactical Strategic

BI Publisher

Transactions, Transactions, Transactions

Summary

Page 14: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

What does OBIEE need then?

Operational Tactical Strategic

WarehouseOracle Apps Transactions

Transactions, Transactions, Transactions Summary

Metadata, Schema, Views – EUL, Universes, Models, Star Schema etc.

Page 15: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

Tactical

Operational

What does OBIEE need then?

Page 16: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

Tactical

Operational

What goes here?Complexity

What does OBIEE need then?

Page 17: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

Strategic

Tactical

Operational

Metadata, Views, Open ObjectsTables, Columns, Fields, Joins,

KP Prof, SQL, PLSQL, Triggers,Keys, Oracle DB, MS SQLDBX

What does OBIEE need then?

Page 18: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

The Complexity Complex Data Structures Data is not always in one module Building a report needs IT involvement User-defined fields need to be reported on Configuration specific elements aren’t there Everyone wants their data in Excel And give it ALL the data to me, I will decide later!

What does OBIEE need then?

Page 19: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 20: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Agenda

Introductions What is Business Intelligence

Strategic v Tactical v Operational When, Who and What

Where does OBIEE fit (and truly fit OOTB) What does OBIEE need So show me! Why EiS? Summary

Page 21: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

The Complexity Complex Data Structures Data is not always in one module Building a report needs IT involvement User-defined fields need to be reported on Configuration specific elements aren’t there Everyone wants their data in Excel

Mask complexity with EiS Views EiS Views are cross modular Enable end users to create reports Auto-detection of ALL KFFs and DFFs Auto-detection of Books, OUs, Inv Orgs. OOTB Excel Pivot Tables with drill to detail

Why EiS?

Page 22: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Coverage and ConfigurationModules – R11.x and R12.x

Financials – GL, AP, AR, FA and CM Projects – Costing, Billing, OTL and Grants HCM – HR, PAY, OTL, OAB, iRec, CWB and OLM Supply Chain – PO, Inv and OM Cross Modular – eg. AP to Projects

Implementation Specific Content discovery of Sets of Books (ledgers), OU’s, Orgs auto-detection of all DFF’s, KFF’s, EIT’s & SIT’s detection of pick-lists, LOVs, IDs etc full documentation & training modules over 500 production ready reports fully supported & maintained software solution

Why EiS?

Page 23: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Why EiS ? Content - Apps Specific Module Coverage Apps Security All Oracle - Integrated Documented Proven

Summary

Page 24: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and ConfidentialEiS Proprietary and Confidential

Thank you for attending

Andy DonovanEiS Technologies

[email protected]

Page 25: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

eXpress Solutions

OBI GeneratorDashboardsEiS eXpress

Views/Reports

Page 26: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

Why EiS?

OracleAppsData

EiSBusiness

ViewsUDML RPD OBIEE

EiS Standard Reports

Page 27: EiS Proprietary and Confidential Andy Donovan – EiS Technologies Replacing Discoverer? So what are your options? EiS Proprietary and Confidential

EiS Proprietary and Confidential

About EiS

EiS Technologies Oracle experts since 2001 Based in Atlanta, GA with offices in India and UK Oracle Certified Partner and ISV More than just a software company

eXpress Reporting Solutions OBI Generator Oracle “eXpress” implementation services On Demand and Managed Services