QAD Business IntelligenceMMUGTuesday September 27, 2011

Bill Wermes

MidwestUser Group

• Report Writing is Complex

• Multi-system Reports Hard or Impossible

• Historic Data Access / Availability

• Spreadsheet Building Time / Effort / Errors

Operational Data

• Cash Flow Analysis• Customer & Product Profitability• Sales Plan vs Forecast• Inventory Turnover• On-time Delivery in Full

Metrics

• Decision Support• QAD BI 1.0• QAD BI 2.0• QAD BI 3.0

Evolution

Today

7

“It is perfectly true that top management must have the final say, the final responsibility. But the

business enterprise of today is no longer an organization in which there are a handful of

“bosses” at the top who make all the decisions while the “workers” carry out orders. It is primarily

an organization of professionals...exercising autonomous, responsible judgment. And every

one of them -- whether manager or individual expert contributor -- constantly makes truly

entrepreneurial decisions, that is, decisions whichaffect the economic characteristics and risks of

the entire enterprise.”

Peter Drucker

QAD Business Intelligence- Long term trend analysis- Both QAD and non-QAD data- Easy access (web, mobile)

QAD Enterprise Applications- Inquiries & Standard

Reports- Operational Metrics - Reporting Framework- Browses & Collections

Operational

Tactical

StrategicExecutives

CEO, CIO, CFO

Dept. ManagersFinance, Sales,...

OperationsProd. Mgr, PlannersWarehouse, Staff

Matching Need To Solution

BI’s Role in your Organization

9

QAD BI Positioning

QAD Business Intelligence- Long term trend analysis

- Both QAD and Non-QAD data- Easy Access (Web, Mobile)

QAD Enterprise Applications

- Inquiries & Standard Reports

- Operational Metrics - Reporting Framework

- Browses & Collections

Strategic

Tactical

Operational

ExecutivesCEO, CIO, CFO

Dept. ManagersFinance, Sales, …

OperationsProd. MgrPlannersWarehouse Staff…

10

Closed-Loop Decision-MakingMeasure

Business State

Gather Data

Analysis

CollaborateV3.3

Implement

ModelV3.6

• QAD Data Warehouse Designer- Consolidate into a single warehouse optimized for simple, fast

access- QAD and non-QAD data sources- Uses MS SQL Server and Analysis Services for Data

Warehouse

• Modules- ERP “aware” streamlines access to current and historical QAD

ERP data- Extensible to support non-QAD data sources

• Collaborative Portal- Easy to use and create dashboard and reporting environment

• Optional: Cognos or other BI or Reporting solution- Can provide advanced capabilities beyond the QAD BI Portal

QAD BI 3 – Components

12

BI Architecture

13

BI Architecture

14

BI Architecture

15

BI Architecture

16

BI Architecture

17

BI Architecture

DataAnalysis

18

19

Collaborate

Forum Collaboration

Email Collaboration

• QAD’s Data Warehouse is designed to be used with 3rd party reporting and BI tools

• Compared to a 100% “roll your own” DW and BI solution, QAD BI benefits:- Low Total Cost of Ownership - Ease of use- Faster Implementation- Industry Leading Data Warehouse

Designer - Single Vendor Solution and Support

Contact- Single Corporate Data Warehouse

QAD BI and 3rd Party Solutions

QAD Proprietary