To Each Their Own: How to Solve Analytic Complexity

39

Transcript of To Each Their Own: How to Solve Analytic Complexity

Twitter Tag: #briefr

[email protected]

8/14/12

Twitter Tag: #briefr

!  Reveal the essential characteristics of enterprise software, good and bad

!  Provide a forum for detailed analysis of today’s innovative technologies

!  Give vendors a chance to explain their product to savvy analysts

!  Allow audience members to pose serious questions... and get answers!

Twitter Tag: #briefr

!  August: Analytics

!  September: Integration

!  October: Database

!  November: Cloud

!  December: Innovators

Twitter Tag: #briefr

!  Analytics has always been about discovering insights that lead to better business decisions.

!  Organizations can be challenged by the

inaccessibility of legacy systems, which can hinder business intelligence processes and strain IT resources.

!  As more customers require faster time-to-insight and user-friendly solutions, vendors are offering products and suites that augment the power of legacy systems, but keep the end user in mind.

Twitter Tag: #briefr

Shawn Rogers is Vice President of Research for Business Intelligence at Enterprise Management Associates, a leading analyst and consulting firm.     Shawn has more than 19 years of hands-on IT experience. Prior to joining EMA he co-founded the BeyeNETWORK, a global online publication covering business intelligence, data warehousing, performance management and data integration. He was also a partner at DMReview magazine (now Information Management) and has held various executive level positions with technology companies.

Twitter Tag: #briefr

!   Committed to helping customers simplify access to data from enterprise applications

!   Specializes in access, reporting and analytics for Oracle E-Business Suite

!   Its BI platform offers a full range of capabilities, including advanced mapping and navigation tools

!   Just introduced Noetix Generator for Microsoft Business Intelligence, an automated modeling solution that can be used in conjunction with Noetix Views and Analytics

Twitter Tag: #briefr

Daryl Orts is the Executive Vice President of Product and Services for Noetix Corporation and is responsible for Noetix technology products and the Consulting organization. Prior to joining Noetix, Daryl was Vice President of Applications R&D for Onyx Software as well as Vice President of Engineering for Luminous Corporation. Daryl received a bachelor’s degree in computer engineering from Case Western Reserve University.   Follow Daryl’s blog at http://darylorts.com/ and Twitter: @darylorts

Noetix Business Intelligence

About Noetix

•  BI solutions experts since 1994

•  Oracle E-Business Suite centric solution

•  Certified with all leading BI Platforms

•  1500 customers globally

PARTNERSHIPS

Why invest in Business Analytics?

Drivers Business / IT

Information Access

Operational Efficiency

Performance Management

Common Business Drivers

dsd Global view of vendor spend to maximize vendor discounts – GE Maximize

Revenue Maximize

Global Visibility Maximize Efficiencies

•  Business users writing their own reports

•  Increase product margins

•  Increase Projects Profitability

•  Global view of vendor spend

•  Streamlined GL period close

•  Global view of customer margins and profitability

Common IT Drivers

Exp a

•  New implementation of Microsoft BI

•  Major Oracle EBS upgrade

Change ERP

Change Organization

Change BI Platform

•  New Oracle EBS implementation

•  Migration from Discoverer to Cognos

•  New joint venture required new ERP instance

•  Acquisition required new ERP instance

How useful is the data?

•  Would maps help? •  How about search

and navigation?

•  Information?

•  How useful is this information?

•  Could you easily find your destination?

Noetix Provides the BI Maps

•  Would maps help?

•  How about search and navigation?

•  How useful is this information?

•  Could you easily find your destination?

Operational Business Views (BI maps)

Emp_Sal_Analysis

Date Effect. Emp. Name Grade Jurisdiction Organization Pay Basis Payroll Name Tax Amount Tax Type Code

HR_LOCATIONS_ALL_TL

HR_ALL_ORG_UNITS

PER_ALL_PEOPLE_F

PER_ALL_ASSIGNMENTS

PAY_US_TAX_BALANCES

PAY_PAYROLL_ACTIONS PAY_PEOPLE_GROUP

Oracle Database Tables View / Map

Analytical (BI maps)

Set of Books Product

Ship To Org

Order Headers

Order Lines

Operational Data Store

Set of Books Product

Ship To Org

Data Mart

Order Lines

BI Maps for Your Tools

Noetix BI Maps

Oracle BI EE

IBM Cognos

SAP BusinessObjects

Salesforce / Other SaaS

Oracle EBS

Other ERP/CRM

Operational

Analytical

Microsoft BI

Noetix Provides Management Dashboards

Noetix Provides Drill-Down Reports

TeleService Inventory

Receivables

Noetix BI Breadth of Coverage

Financials Order Management

Human Resources

Discrete Manufacturing Projects Procurement

General Ledger

Order Management

Human Resources Costing Purchasing

Advanced Benefits Billing

Payables Payroll

iExpense Learning Management

Service Process Manufacturing

Assets

Quality

Master Scheduling

MRP

Advanced Supply Chain Planning

Work in Process

Cost Management

Cash Management

Depot Repair

Field Service

Install Base

Service Contracts

Execution

Financials

Enterprise Asset

Management

Incentive Compensation

Bills of Material

Development Quoting

Financial Statement Generator

Advanced Pricing

Release Management

Shipping Execution

Warehouse Management

Engineering

Working Capital

Time & Labor

Labor Distribution

iProcurement

Planning

Project Contracts

Project Management

Oracle E-Business

Suite

Operational Analytical

Noetix Platform Oracle BI EE Oracle

Discoverer IBM

Cognos BI

SAP Business Objects

Microsoft BI

Transactional Data Warehouse

NOETIX TECHNOLOGY

Noetix BI — Architecture

Real-Time Reports

NOETIX TECHNOLOGY

Business Views

Siebel CRM PeopleSoft Enterprise

Other ERP/CRM Applications

Custom Applications

Drillable Reports

Dashboards KPIs

Data Marts ODS

Why the Noetix packaged solution?

•  Rapid Implementation –  Subject area BI maps

empower users to answer their own questions

•  Lower TCO –  Creating BI maps and

maintaining them is resource intensive

•  Mitigated Risk –  Custom projects don’t

meet expectations more than 50% of the time

Noetix BI Maps with search and navigation

Twitter Tag: #briefr

To Each Their Own: How to Solve Analytic Complexity

August 14, 2012 © 2012 Enterprise Management Associates, Inc.

Shawn P. Rogers Enterprise Management Associates Vice President Research Business Intelligence / Data Warehousing [email protected]

It’s a Complex World

Slide 30 © 2012 Enterprise Management Associates, Inc.

•  Our data management ecosystems continue to expand… •  Difficulty answering the demands of change

•  Lack of flexibility, speed, automation •  Greater focus on operational data

•  Hybrid Data Ecosystem (HDE) •  Accept the change – stay ahead •  Right platform for the right problem

The Drivers of Change

•  Maturing User Community •  Workloads and Demands – Reporting to Advanced Analytics •  Consumer shift, democratization and self service

•  New Technology •  Introduction of new technologies •  More powerful technology

•  Economics •  Enterprise level commodity hardware •  Open Source frameworks •  Business Intelligence is recession resistant and proven

•  Valuable Data Types •  Move from Structured SQL driven analysis - new alternatives •  Sophisticated analysis of new data – Sensor, Machine, Social

Slide 31 © 2012 Enterprise Management Associates, Inc.

The Solution Opportunity

•  Vendors have an opportunity •  Agility •  Automation •  Deep domain expertise

Ø  Fast starts – Data models Ø  Templates coupled to data and structure

•  Extending application functionality •  Taking Analytics Beyond the Application

Ø  Enabling power users and self service

Slide 32 © 2012 Enterprise Management Associates, Inc.

Questions

•  Who buys Noetix solutions and whom do you compete with? Does Noetix focus on the Large Enterprise or SMB Market?

•  Noetix delivers standard data models, semantic layer and ETL mapping optimized to extend Oracle E-Business Suites. Often times predesigned models are too rigid or lack detail. How does Noetix avoid these common pitfalls?

•  Your website says that “Noetix automatically creates queries and reports specific to your organization.” What type of domain experience does Noetix apply to this process?

•  What type of effort is required to design and implement your pre-defined data views in NoetixViews? Does this create a data management challenge?

•  Do you have plans to work with other applications platforms beyond Oracle?

Slide 33 © 2012 Enterprise Management Associates, Inc.

Questions

•  How do you leverage data from other systems in step with Oracle’s application data?

•  Is Noetix capable of handling KPI’s, drill down, trending analysis, scorecards?

•  With the built in BI integration to popular BI platforms are you able to go beyond Oracle, Cognos and SAP? (Noetix Generator)

•  Can an end-user override the automated aspects of Noetix Generator? Especially around the presentation model and semantic layer?

•  How do you protect your clients against Oracle Application upgrades? When customization takes place how are these changes in source structure migrated to the data model, semantic layer and glossary?

Slide 34 © 2012 Enterprise Management Associates, Inc.

Questions

•  What are the hardware requirements to support Noetix Analytics? •  What about ad-hoc queries? Does Noetix support this type of

analytic function? •  If real-time analytics is required how do you serve that need? •  When leveraging the Oracle E-business Suite what operational

areas do you find customers in the deepest pain. Financials, Supply Chain, HRMS, Procurement

•  How do you approach clients that already have a DW? IS Noetix looking to replace the existing DW or operational data stores?

•  How does Noetix handle issues of access, security workload query complexity etc…

•  Does your platform support collaborative interactions between decision makers?

•  Does Noetix have the capability to integrate data from Hadoop or other Big Data platforms?

Slide 35 © 2012 Enterprise Management Associates, Inc.

For more information on Enterprise Management Associates, please go to www.enterprisemanagement.com, or call +1 303-543-9500

Thank you for attending today’s presentation

© 2012 Enterprise Management Associates, Inc.

Twitter Tag: #briefr

Twitter Tag: #briefr

!  August: Analytics

!  September: Integration

!  October: Database

!  November: Cloud

!  December: Innovators

Twitter Tag: #briefr