1 / 29

Business Intelligence System

Business Intelligence System. Mr. Natapong Wongprommoon Solution Architect G-ABLE Company Limited www.g-able.com E-mail : jeng6665@hotmail.com. Agenda. BI Solution Overview BI Product System & Feature Demo – Business Intelligence. 1. FINANCE. Multiple ERP. EBITDA.

Download Presentation

Business Intelligence System

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. Business IntelligenceSystem Mr. NatapongWongprommoon Solution Architect G-ABLE Company Limited www.g-able.com E-mail : jeng6665@hotmail.com

  2. Agenda • BI Solution Overview • BI Product System & Feature • Demo – Business Intelligence G-ABLE Company Limited - 1

  3. FINANCE Multiple ERP EBITDA MultipleSupply Chain OPERATIONS HIRING QUALITY Multiple Data Warehouses BRAND Multiple Legacy Applications SERVICE LEVELS Multiple Point Applications COMPANY HEALTH System Complexity Creates Chaos DIFFERENTMETRICS DISPARATE BI TOOLS & REPORTING SYSTEMS FRAGMENTEDDATA SOURCES MULTIPLE ROLES Finance HumanResources Marketing Customer Service PLANNING Executive G-ABLE Company Limited - 2

  4. Transformation of Data Data Transaction Processing Cleansing / analysis Relational warehouse SQL reporting Investigation/Exploration/Analysis Information People who need it Where they need it When they need it In the form they want G-ABLE Company Limited - 3

  5. External Data BI Solution Overview SQL Server Enterprise Data Warehouse Oracle ETL Ad-hoc Report Access Analysis Metadata Business Intelligence Data Source Data Warehouse G-ABLE Company Limited - 4

  6. Oracle BI Suite Enterprise Edition MS Office Plug-in Interactive Dashboards Reporting & Publishing Ad-hoc Analysis Proactive Detection and Alerts Disconnected Analytics Simplified Business Model and Abstraction Layer Oracle BI Server Intelligent Caching Services Multidimensional Calculation and Integration Engine OLTP & ODS Systems Data Warehouse Data Mart SAP, Oracle PeopleSoft, Siebel, Custom Apps Files Excel XML Business Process BI Product System & Feature G-ABLE Company Limited - 5

  7. Oracle BI Server Business Model and Mapping Physical Presentation G-ABLE Company Limited - 6

  8. Interactive Dashboards Oracle BI Dashboard G-ABLE Company Limited - 7

  9. Reporting & Publishing Oracle BI Publisher • Purchase Orders • Labels / Bar Codes • Collateral • Employee Forms • Government Forms • Order Forms • Invoices • Operational Reports • Correspondence • Financial Statements • Checks G-ABLE Company Limited - 8

  10. Ad-hoc Analysis Oracle BI Ad-hoc Analysis • Full ad hoc analysis, pivot tables, and report creation • Drag and drop report and dashboard authoring • Users shielded from complexity and structure of underlying data structures • Ensures highest ease of use • Lowering the workload on IT support • Easily save reports back into Intelligence Dashboards G-ABLE Company Limited - 9

  11. Oracle Delivers Oracle BI Deliver G-ABLE Company Limited - 10

  12. Oracle BI Disconnect Disconnected Analytics • Full analytical functionality for the mobile user • Enables Intelligence Dashboard and Answers functionality even when offline • Interactive dashboards, ad hoc analysis, pivot tables • Same interface for users whether connected or disconnected • Minimal data set size • Full and incremental synchronization of data with enterprise data sources • Data compressed during synchronization • Data personalized for each user, maintaining all role-based security and visibility G-ABLE Company Limited - 11

  13. MS Office Plug-in Microsoft Office and Reporting Services • Office Plug-in, integration to MS Office • create report/graph for management presentation • next time click refrest, data will be changed without • format G-ABLE Company Limited - 12

  14. Demo G-ABLE Company Limited

  15. Overview of PCS Computing • PCS Computing is a manufacturer of computer and related equipments • PCS Computing carries 7 separated product lines G-ABLE Company Limited - 13

  16. PCS Business Situation • PCS maintains a calendar year and perform quarterly variance analysis comparing Actual Revenue and Expected Revenue • Sales department needs to know clause of revenue drop • Sales department needs to determine which product categories need immediate attention to increase revenue G-ABLE Company Limited - 14

  17. Overall Sales Supply Chain Human Resource Customer Contract G-ABLE Company Limited - 15

  18. Sales Department G-ABLE Company Limited

  19. Sales Department Revenue Drop Check Order & Invoice Send information to Supply Chain Check Operation Backlog G-ABLE Company Limited - 16

  20. Supply Chain Department G-ABLE Company Limited

  21. Supply Chain Department Receive information from Sales Check Inventory Turns Check Bill of Material & Vendors Performance Send information to Customer Contract G-ABLE Company Limited - 17

  22. Customer Contract Center Department G-ABLE Company Limited

  23. Customer Contract Department Receive information from Supply Chain Check Channel Check Team Performance Send information to HR G-ABLE Company Limited - 18

  24. HR Department G-ABLE Company Limited

  25. HR Department Receive information from Customer Contract Check Employee Turnover Risk Send information to Sales G-ABLE Company Limited - 19

  26. Sales Department (again) G-ABLE Company Limited

  27. Sales Department (again) Receive information from HR Check Sales channel Revenue Increase Check Customer A/R G-ABLE Company Limited - 20

  28. Operational Results • Agent Satisfaction • Product : Envoy Standard Laptops with Wireless LAN Card • Vendor : Dell Inc. • Team : PCS Group C • Customer : Business World G-ABLE Company Limited - 21

  29. Q & A G-ABLE Company Limited

More Related