Oracle Analytics Server: Analytics and P.C.

I.                   Objectives

This course is focused on creating reports (analysis) and dashboards in Oracle Analytics Server

Upon completion of the course, the student will have sufficient knowledge to:

Create reports with tables and graphs using user and dynamic filter options, groupings and advanced selections with hierarchy members.

Create different types of graphs and configure their properties. Add them to reports and establish master-detail links.

Use of key process indicators, KPIs, and follow their trend based on dimensions.

Create dashboards, with dynamic filters using prompts and conditioning the display of objects.

Use of tools: Delivers, for automatic and scheduled delivery of reports; briefing books

Use of the new Oracle Analytics Server tools for data visualization.

II. Requirements

There are no specific requirements.

Optional:

Knowledge of SQL and data analysis.

III. Duration

30 hours.

IV. Methodology

The course is developed through theoretical presentation accompanied by practical demonstrations and explanations of the results obtained.

The student carries out the creation of analyses using different characteristics of the product of varying complexity. A control panel is developed with the previous analyses.

Resolution of doubts about the concepts presented.

V.               Content

Introduction to Oracle Analytics Server and Oracle Analytics Cloud.

Architecture.

Data modeling. Create and publish a model. Create fact and dimension tables. Create hierarchies.

Additional data modeling techniques.

User interface. Subject areas and relationships with the repository. Main page, favorites and catalog.

Introduction to the analysis editor.

Creating viewsCreating analysesOrdering dataViews in analysesEditing charts

Creating calculated items

FormattingFormatting columns

Conditional formatting

Filters and promptsData filters

Using prompts and variables

Grouping and selection stepsUsing selection stepsCreating and using groups

Creating and using calculated items

Advanced use of the analysis editorView editorsCompound Layout panel featuresUsing sections (page, section, measures, rows, columns, exclusion)

Chart editorDefining general chart propertiesModifying a chart’s styleUsing titles and labelsConditional formattingAdding totals and subtotalsUsing bins (combining values)

Using the master-detail function

Graphical ObjectsAdvanced OptionsUsing KPIs

Additional Graphical Objects

Dashboards.Interactive Analytics.Creating Dashboards.Expressions.Adding Subpages.Adding Dashboard Actions.Using Prompts.Personalization.

Adding Content.

Briefing Books.Creating Briefing Books.

Using Briefing Books.

Delivers.Creating Automatic Content with Deliveries.

Creating Agents.

Cache Management.

Oracle Data Visualization.Projects and Data.

Creating Visualizations and Stories.