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.
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
