Financial Analytics Deep Dive

This one day course gives students the opportunity to learn out of the box functionality of Oracle’s Financial Analytics application including an overview of the financial data warehouse, financial metrics and key performance indicators. Students will be exposed to financial dashboards and reports through hands-on exercises.

Audience:

Business users (accountants, financial analysts, etc.), Business Analysts, ETL Developers, OBIEE metadata and report developers.

  1. Understand Oracle BI Applications architecture
  2. Understand the capabilities of the out-of-the-box Oracle Financial Analytics
  3. Out of the box Financial Analytics reports and metrics
  4. Create Financial Analytics reports and dashboards via hands-on exercises
  5. Out of the box Financial Analytics star schemas and ETL logic
  6. Understand deployment options, security and integration into ERP
  7. Understand the typical configuration tasks

Suggested Prerequisites:

Knowledge of Data Warehouse Design and Project Data

Time Description Goal
9:00 - 9:30 Introduction to Oracle BI Applications Application components & architecture
9:30 - 10:45 Financial Analytics Reports and Dashboards Presentation & hands-on exercise modifying Financial Analytics reports
10:45 - 11:00 Break
11:00 - 12:00 Financial Analytics Metrics and Metadata Presentation & hands-on Oracle Answers exercise creating Financial Analytics reports and demonstration of pre-built Oracle BI repository
12:00 - 1:00 Lunch
1:00 - 3:00 Review of Out of the Box Star Schemas Financial data structures and key metrics
3:00 - 3:15 Break
3:15 - 4:00 Security, User Interface Options, Integration into ERP Deployment options, Action links, Flex fields, & Security Integration
4:00 - 4:45 Configuration Tasks (CSV Files, Fiscal Calendars, etc.) Chart of accounts, Fiscal Year, & Multi Currency
4:45 - 5:00 Wrap-Up and Q & A

Download Course PDF: Financial Analytics Deep Dive