Cubot bi for oracle
-
Upload
yadu-balehosur -
Category
Data & Analytics
-
view
35 -
download
0
Transcript of Cubot bi for oracle
Financial Management with
CUBOT BI for Oracle EBS
March 2015
2
Contents
• Overview– What is Cubot BI for Oracle
• Features– Functions – GL, AR, AP, Pur, Or
– Facilities - Reports, Dashboards, Alerts, Ad-Hoc Analysis
– Oracle EBS Integration - ETL, Data Model, Configuration, Administration
– Deployment Diagram
• Implementation – Delivery Timeline
– Delivery Team Org Chart
• Pricing– Pricing models
– Price
3
Financial Management with CUBOT
Agi
lity
and
Eas
e o
f U
se
Ben
efit
s
FeaturesOrder to Cash
Process Improvements –Location Analysis, Market penetration, Top Customers (by user-defined metrics), Ageing and Collections.
Procure to Pay Process Improvements –Vendor Performance (by user-defined metrics), Expenditure Analysis and comparisons with Budgets
Enterprise Management and Reporting – MBO, predict trends, Plan/Budget for growth with real-time analysis
Your operations managers and business leaders get real-time analysis and engage the team
You evaluate on the “right metrics” and change these metrics per business needs
You spend less time in getting reports and analysis, and make decisions faster
Business managers can manage their function and evaluate their performance like a business entity.
Insights for Business on Cost Management and Revenue/Profit optimization
Decision-support for the operations manager and the strategists
Simplified business processes, to improve turnaround times and delight stakeholders
Online, real-time and agile analytics and reports
4
Your Finance Manager is your business partner
Plug Revenue Leakages, Understand Product Contributions & margins
Provides Business Managers insights about revenues and costs
Insights for
Business Periodic Comparison of Costs and Revenues
Track Vendor Performance
Analysis with changes in Dimensions/ Metrics
Use Analytics intelligently to predict trends and plan/ budget for growth
Implement management by objectives
Decision Support For Customers,
Vendors, Government, Tax Authorities, Shareholders
Optimize finance process costs
Real-time reports and analysis helps resource optimization
Simplified processes – improve turnaround times
Frees up Finance team time for Analysis
Simplified Financial Processes Timely Availability
for Budget and Financial Planning
Configurable easily for Organizational and Corporate changes
Analysis and
Reports
The CUBOT CFO Advantage
5
CUBOT BI for Oracle - Details
Integrated with Oracle Operations Analysis
Role Based, multi-org and select company views
Real-time reports and analysis
Alerts
Financial Analytics Order to Cash process
Procure to Pay process
Enterprise – General Ledger, Management & External Reporting
Personalized Dashboards
At a glance picture of the business
Customizable
Critical Insights for Operations, Sales and Procurement Teams
Product, Location, Branch Analytics
Performance management
6
CUBOT BI USPs
• Speed of implementation– Generally faster and more flexibility in terms of
maintenance
• Cost of implementation– Lower
• Cuts across platforms and systems– Especially if there are other non-Oracle modules
• Facilities for Finance Manager to access financial information, process them into a meaningful reports and distribute them for use by other departments -sales, purchasing, warehouse, …
7
Modules Covered
AR AP Orders GL Purchasing
ETL Data Model Reports Dashboards Alerts
ACCOUNTS RECEIVABLE (AR)
9
AR – Reports Summary
Report Summary
Ageing Aging report of receivables (by customers, invoice date, currencies etc)
Customer
Analysis
Listing of sales by customerListing of sales by customer typesListing sales by customers vs receipts (payment date from customer)
Receipts by
Customer
Listing of receipts from customers
Credit Limit
Checks
Listing of outstandings vs credit limit of individual customers
1
0
AR -Sample Report List
AR -Dashboard
Top Customers, Ageing Buckets, Month on Month, Total Collections
1
2
AR - Location Analysis
1
3
AR - Detailed Report
1
4
AR- Schema
AR – ETL Setup
AR Source Data ETL AR Measures
ACCOUNTS PAYABLE(AP)
1
7
AP – Reports Summary
Report Summary
Ageing Report Aging report of payables (by suppliers, invoice date, currencies etc)
Purcahses Listing of purchases by suppliersListing of purchases by suppliers typesListing of purchases by suppliers vs payments (payment date)
Outstandings Listing of outstanding purchases vs credit payment terms
Supplier Analysis
Analyse efficiencies by comparing invoice creation date vs invoice date vs country of suppliers
1
8
AP - Dashboard
Suppliers, Due amounts, Past Due, AP Performance
1
9
AP- Sample Report List
2
0
AP- Schema
AP: ETL Setup
AP Source Data ETL AP Measures
ORDER MANAGEMENT (OM)
2
3
OM – Reports Summary
Report Summary
Customer View
List of orders by customers (drill down to line items)
Salesperson View
List of sale orders by individuals salesperson or departments
Order Status Status of orders (picked release, shipped confirmed, invoiced etc)
Order Analysis Sales Orders by Sales TypesSales orders by industry (customer classifications)Gross margin by sales orders (basically taking a sales order and matching it against cost (from AP))
Uninvoiced Listing of sales orders not invoiced yet
2
4
OM - Dashboard
Orders Y-o-Y across companies, Top Products, Order Fulfilment
2
5
OM - Sample Report List
2
6
OM - Schema
OM – ETL Setup
OM Source Data ETL OM Measures
GENERAL LEDGER (GL)
2
9
Reports Summary
Report Summary
GL Reports • Trial Balance• P&L• Balance Sheet
Analysis Analysis of Individual Accounts
Journal Enquiry Listing of journals posting by period by source (drill down)
Report Summary
Cash Management Listing of bank statements by bank accounts by datesSummary of available cash on hand across all bank accountsListing of unreconciled receipts
General Ledger
Cash Management
3
0
GL-Dashboard
GL
3
1
GL-Sample Report List
3
2
GL-Schema
GL – ETL Setup
GL Source Data ETL GL Measures
PURCHASING
3
5
Purchasing
Report Summary
Supplier Reports Purchase by supplier typesListing of purchase by suppliersList of purchases by originListing of purchases by supplier types* listing of purchases where invoices not created yet (ie,
unmatched)
Department-wise Purchases
List of purchases by individuals/departments
Goods Received Status
Status of purchases (goods received)
3
6
Purchasing- Schema
Purchasing-Source Data ETL & Measures
Purchasing Source Data ETL Purchasing Measures
ALERTS, AD-HOC ANALYSIS
CUBOT Alerts
Creating an Alert Alerts Triggered
4
0
Ad-Hoc Analysis
Last Slide