Oracle CRM On Demand Advanced Analytics Workshop
Аннотация:
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.
Exercises based on real business examples reinforce the skills and knowledge taught in the course.
Слушатели изучат:
- Write time and date formulas and create rolling date reports
- Create effective pivot tables that provide multiple data perspectives
- Link directly from a record to a record-specific analysis
- Filter data based on the results of another analysis or using a simple SQL statement
- Create custom dashboards to provide an in-depth view of the business using simple reports
- Use column and conditional formatting to emphasize key data
Цели курса:
- 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
Программа курса:
- Reporting Methodology
- Formatting Tables
- Working With Pivot Tables
- Using Advanced Layout Views
- Using Filters
- Combining Reports with Set Operations
- Defining Column Filter Prompts
- Column Formulas and Conditional Expressions
- Date and Time Formulas
- Conditional Values
- Navigating Users to Analyses
- Creating Custom Dashboards