Oracle Analytics Data Visualization (DV) Mastery

A Complete Guide to Creating Powerful Visualizations and Smart Analytics

What you’ll learn
✓ Learn how to install, set up, and log in to Oracle Analytics Desktop, OAS, and OAC.
✓ Understand how to create datasets, build visuals, and design interactive dashboards.
✓ Apply filters, drill-downs, calculations, and formatting to improve analysis.
✓ Use advanced analytics like clustering, trends, outliers, and forecasting.
✓ Learn how to use parameters, what-if analysis, and actions for deeper insights.
✓ Use the Explain feature to find insights, patterns, and correlations using ML.
✓ Learn how to migrate DV files between different environments.

Requirements
● No prior experience is needed—just basic computer skills and a laptop with Oracle Analytics Desktop installed.

Description
Oracle Analytics Data Visualization (DV) Mastery is a complete, hands-on training designed for anyone who wants to learn how to explore data, build dashboards, and create powerful insights using Oracle Analytics. This course takes you step-by-step from the basics to advanced topics, making it easy for beginners and valuable for experienced users.

You will start by installing and setting up Oracle Analytics Desktop, OAS, and OAC. Then, you will learn how to create datasets, clean and prepare data, and apply enrichment, profiling, and formatting. You will build a wide range of visualizations including bar charts, maps, tiles, tables, treemaps, pie charts, combo charts, and more, with real examples and practical scenarios.

The course also covers filters, drill-down reporting, calculations, parameters, and what-if analysis to help you make interactive and dynamic dashboards. You will explore advanced analytics features such as clustering, outliers, trend lines, reference lines, and forecasting to support deeper business decisions.

You will also learn how to use the Explain feature, which uses machine learning to uncover hidden insights and patterns automatically and improve your analysis.

By the end of this course, you will be confident in building professional dashboards, analyzing data, and applying smart analytics in real projects using Oracle Analytics DV.

Training Agenda

• Oracle Data Analytics – Data Visualization (DV) Environments

• Introduction to Oracle Analytics Server (OAS)

• Installation of Oracle Analytics Desktop

• Installation Machine Learning and Advanced Analytics on Windows

• Complete Steps to Install and Configure Oracle Analytics Server OAS 6.4

• Log in to Oracle Analytics Desktop, OAS and OAC

• Oracle Analytics Home Page

• Dataset

• Adding a Spreadsheet and Flat files as a Data Source

• Edit Dataset

• Workbook

• Visualize

• Creating a Bar Chart and Exploring Its Properties

• Creating a Pie Chart

• Creating a Tile

• Creating a Title and Image

• Creating a Table and Pivot Table

• Creating a Tree map Chart

• Creating a Map Chart

• Configuring Bubble Size in Oracle Analytics Maps

• Creating a Line Chart

• Creating an Overlay Chart

• Creating a Combo Chart

• Filters

• Creating Drilldown Reporting

• Creating Calculation

• Workbook Properties

• Canvas Properties

• Conditional Formatting

• Parameter

• What-If Analysis using Parameters

• Present Mode

• Visualization Actions

• Advanced Analytics

• Clustering

• Outliers

• Reference Line

• Trend Line

• Forecast

• Migrate DV Files Between Environments

• Explain Feature

Who this course is for
■ This course is for beginners, data analysts, BI users, and anyone who wants to learn Oracle Analytics DV to build dashboards, explore data, and create insights with simple and practical steps.