1 / 21

QAD Business Intelligence

QAD Business Intelligence. MMUG Tuesday September 27, 2011. Midwest User Group. Bill Wermes. Operational Data. Report Writing is Complex Multi-system Reports Hard or Impossible Historic Data Access / Availability Spreadsheet Building Time / Effort / Errors. Metrics. Cash Flow Analysis

oya
Télécharger la présentation

QAD Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. QAD Business Intelligence MMUG Tuesday September 27, 2011 Midwest User Group Bill Wermes

  2. Operational Data • Report Writing is Complex • Multi-system Reports Hard or Impossible • Historic Data Access / Availability • Spreadsheet Building Time / Effort / Errors

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

  4. Evolution • Decision Support • QAD BI 1.0 • QAD BI 2.0 • QAD BI 3.0

  5. Today

  6. “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 which affect the economic characteristics and risks of the entire enterprise.” Peter Drucker

  7. BI’s Role in your Organization Matching Need To Solution Executives CEO, CIO, CFO • QAD Business Intelligence • - Long term trend analysis • Both QAD and non-QAD data • Easy access (web, mobile) Strategic Dept. Managers Finance, Sales,... Tactical • QAD Enterprise Applications • Inquiries & Standard Reports • Operational Metrics • Reporting Framework • Browses & Collections Operational Operations Prod. Mgr, Planners Warehouse, Staff

  8. QAD BI Positioning • QAD Business Intelligence • Long term trend analysis • Both QAD and Non-QAD data • Easy Access (Web, Mobile) Strategic Tactical • QAD Enterprise Applications • Inquiries & Standard Reports • Operational Metrics • Reporting Framework • Browses & Collections Operational Executives CEO, CIO, CFO Dept. Managers Finance, Sales, … Operations Prod. Mgr Planners Warehouse Staff … 9

  9. Closed-Loop Decision-Making Measure Business State Implement Gather Data Model V3.6 Analysis Collaborate V3.3

  10. QAD BI 3 – Components • 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

  11. BI Architecture

  12. BI Architecture

  13. BI Architecture

  14. BI Architecture

  15. BI Architecture

  16. BI Architecture

  17. DataAnalysis 18

  18. Collaborate Email Collaboration Forum Collaboration

  19. QAD BI and 3rd Party Solutions • 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

  20. QAD Proprietary

More Related