RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



Oracle CRM On Demand Advanced Analytics Workshop (D56684GC40)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D56684GC40

Dla kogo

  • Administrator
  • Reports Developer
  • Technical Administrator
  • Technical Consultant

Czas trwania

3 dni

Cena bazowa

PLN 7575

Cel

  • Create analyses that answer defined business questions
  • Identify and apply formatting options to emphasize key data
  • Design and format effective pivot tables to show data from multiple perspectives
  • Define prompts to allow users to filter information in an analysis
  • Use advanced filtering options to satisfy report data requirements
  • Filter data based on the results of another analysis
  • Combine reports to create complex filters
  • Use column formulas to calculate data in an analysis
  • Write rolling date filters to display results based on relative time frames
  • Include session variables in filters and formulas
  • Create links to navigate users through a set of reports
  • Use action links to pass record details to a report so that the report results are record-specific
  • Create custom dashboards to provide an in-depth view of the business using simple reports
  • Track usage and performance of the CRM On Demand application using standard and custom usage tracking reports

Opis

In this course, students learn to use advanced features of Oracle CRM On Demand Answers to support custom business reporting needs. These include learning how to: apply advanced formatting and layouts; create and apply multiple filters for rolling date analyses and negative reporting; use advanced formulas and calculated columns; build comparative reports using prompts; create custom dashboards; and, track usage and performance. These skills enable advanced users to build easy-to-use reports and dashboards that meet complex reporting needs.Hands-on exercises based on real business examples reinforce the skills and knowledge taught in the course. This provides an opportunity for students to practice new skills in a safe environment with instructor support.Before the start of the class, students will have to complete the following prerequisites:Oracle CRM On Demand: Build Your Own Reports: 1 Control Visibility to Report DataOracle CRM On Demand: Build Your Own Reports: 2 Create List ReportsOracle CRM On Demand: Build Your Own Reports: 3 Format Custom ReportsOracle CRM On Demand: Build Your Own Reports: 4 Create Charts for ReportsOracle CRM On Demand: Build Your Own Reports: 5 Create Pivot Tables for ReportsOracle CRM On Demand: Build Your Own Reports: 6 Control Access to ReportsOracle CRM On Demand: Creating Custom DashboardsIf you are a CRM On Demand customer to access those prerequisites, please follow the steps below: Go to your CRM On Demand siteClick on Browse TrainingUnder Training Resources by Topic click on Reports and DashboardsAll 6 pre-requisites will appear in the search resultsLearn To:Write time and date formulas and create rolling date reportsCreate effective pivot tables that provide multiple data perspectivesLink directly from a record to a record-specific analysisFilter data based on the results of another analysis or using a simple SQL statementCreate custom dashboards to provide an in-depth view of the business using simple reportsUse column and conditional formatting to emphasize key data

Tematy

  1. Reporting Methodology
    • Identifying Subject Areas
    • Finding Data Columns
    • Analyzing Custom Objects
    • Designing Your Report
  2. Formatting Tables
    • Column Formatting
    • Conditional Formatting
    • Using Images
  3. Working With Pivot Tables
    • Adding Totals and Relative Values
    • Adding Duplicate Columns
  4. Using Advanced Layout Views
    • Column Selectors
    • Gauge Views
    • Adding a Legend
    • Using a Narrative View
  5. Using Filters
    • Filtering with SQL Expressions
    • Using Variables
    • Filtering Based on Results of Another Analysis
    • Using the Filtered Metrics Function
  6. Combining Reports with Set Operations
  7. Defining Column Filter Prompts
    • When to Use Prompts
    • Date Range Prompts
  8. Column Formulas and Conditional Expressions
    • Where to Apply Formulas
    • Creating Mathematical Formulas
  9. Date and Time Formulas
    • Types of Date Formulas
    • Rolling Date Filters
    • Using Session Variables
  10. Conditional Values
    • Using CASE Statements
    • Applying Aggregation Rules
  11. Navigating Users to Analyses
    • Defining Drill-Down Paths
    • Creating a Web Link field
  12. Creating Custom Dashboards
    • Creating and Designing Custom Dashboards
    • Creating Dashboard Prompts

Wymagania

    • Ability to use Oracle CRM On Demand Answers to create basic reports
    • Basic familiarity with the Oracle CRM On Demand application

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.