1Z0-1035-25
Coming Soon
Expected availability announced soon
This course is in active development. Preview the scope below and create a free account to be notified the moment it goes live.
Analytics Cloud (1Z0-1035-25)
The Oracle Analytics Cloud Associate certification course teaches data visualization, data modeling, report and dashboard creation, advanced analytics, and administration within OAC, enabling professionals to build and manage end‑to‑end analytics solutions.
90
Minutes
55
Questions
65
Passing Score
$245
Exam Cost
Who Should Take This
It is intended for data analysts, business intelligence developers, and IT administrators who have foundational experience with Oracle databases or cloud services and want to validate their ability to design, deploy, and govern analytics in OAC. These learners aim to advance their careers by earning a recognized credential that demonstrates competence in end‑to‑end analytics workflows.
What's Covered
1
Data Visualization
2
Data Modeling
3
Reports and Dashboards
4
Advanced Analytics
5
Administration
What's Included in AccelaStudy® AI
Adaptive Knowledge Graph
Practice Questions
Lesson Modules
Console Simulator Labs
Exam Tips & Strategy
20 Activity Formats
Course Outline
62 learning goals
1
Data Visualization
2 topics
Workbooks and Canvases
- Identify OAC workbook components: canvases, visualizations, filters, and data elements.
- Configure workbook creation with auto-insights, drag-and-drop visualizations, and canvas layout management.
- Implement data visualization best practices with chart type selection, color coding, and interactive filters.
- Analyze visualization designs to recommend improvements for data storytelling and user comprehension.
- Identify the key components and features of Workbooks and Canvases and describe their primary functions within Oracle Analytics Cloud Associate.
- Deploy Workbooks and Canvases with integration to reporting, monitoring, and audit services for operational visibility.
- Analyze Workbooks and Canvases configurations to identify inefficiencies, gaps, and optimization opportunities.
Visualization Types
- Describe chart types: bar, line, scatter, map, pivot, treemap, and custom visualizations.
- Configure advanced visualizations with calculations, reference lines, trend lines, and forecast projections.
- Implement map visualizations with geographic data, heat maps, and location-based analytics.
- Evaluate visualization approaches to recommend chart types optimal for different data analysis scenarios.
- Configure Visualization Types with appropriate settings and parameters for a production implementation in Oracle Analytics Cloud Associate.
- Assess Visualization Types implementations against best practices to identify gaps and recommend improvements.
- Name the prerequisites, dependencies, and supporting services required for implementing Visualization Types.
2
Data Modeling
2 topics
Semantic Model
- Identify semantic model components: datasets, subject areas, physical and logical layers.
- Configure datasets with joins, data transformations, and calculated columns for analysis preparation.
- Implement subject areas with dimension hierarchies, measures, and aggregation rules for self-service analytics.
- Analyze data model designs to recommend structures optimizing query performance and usability.
- Evaluate Semantic Model alternatives and tradeoffs to recommend the optimal approach for given constraints.
- Recognize common terminology, setup steps, and best practices associated with Semantic Model.
Data Preparation
- Describe data flow components: data sources, transformations, targets, and scheduling.
- Configure data flows with enrichment, cleansing, merge, and aggregation steps for data preparation.
- Implement data replication with connections to databases, cloud storage, and SaaS application sources.
- Evaluate data preparation approaches to recommend efficient pipelines for analytics-ready data.
- List the configuration options and parameters available for Data Preparation and describe when each is appropriate.
- Apply Data Preparation configuration patterns to meet specific business requirements including compliance needs.
3
Reports and Dashboards
2 topics
Pixel-Perfect Reports
- Identify BI Publisher components: data models, report templates, and output formats.
- Configure BI Publisher reports with data models, RTF templates, and scheduling for production reporting.
- Implement parameterized reports with LOVs, bursting, and delivery channels for automated distribution.
- Analyze reporting requirements to recommend the optimal approach: workbook, dashboard, or pixel-perfect report.
- Implement Pixel-Perfect Reports following best practices for efficiency, security, and reliability.
- Diagnose Pixel-Perfect Reports issues by analyzing reports, logs, and configuration to determine root causes.
Dashboards
- Describe dashboard features: KPI cards, action links, navigation, and embedded content.
- Configure dashboards with guided navigation, prompts, and drill-through for executive-level analysis.
- Implement KPI management with target tracking, trend indicators, and status visualization.
- Evaluate dashboard designs to recommend layouts optimizing user engagement and decision-making.
- Analyze Dashboards configurations to identify inefficiencies, gaps, and optimization opportunities.
- Identify the key components and features of Dashboards and describe their primary functions within Oracle Analytics Cloud Associate.
4
Advanced Analytics
2 topics
Machine Learning
- Identify OAC ML features: one-click models, custom models, and Oracle ML integration.
- Configure predictive analytics with training datasets, algorithm selection, and model evaluation.
- Implement ML-powered insights with forecast, outlier detection, and clustering in workbooks.
- Analyze ML model results to evaluate accuracy, recommend feature improvements, and validate predictions.
- Name the prerequisites, dependencies, and supporting services required for implementing Machine Learning.
- Configure Machine Learning with appropriate settings and parameters for a production implementation in Oracle Analytics Cloud Associate.
Data Actions
- Describe data actions: URL navigation, HTTP API, and analytics link for workbook interactivity.
- Configure data actions with parameter passing for cross-workbook navigation and external system integration.
- Implement custom calculations with logical SQL, EVALUATE functions, and advanced analytics expressions.
- Evaluate advanced analytics capabilities to recommend approaches for complex business analysis scenarios.
- Explain how to troubleshoot common issues with Data Actions including error messages and resolution procedures.
- Evaluate Data Actions alternatives and tradeoffs to recommend the optimal approach for given constraints.
5
Administration
2 topics
Security
- Identify OAC security: application roles, data access, and row-level security.
- Configure user provisioning with IDCS integration, application roles, and content permissions.
- Implement data-level security with session variables, initialization blocks, and row-level filtering.
- Analyze security configurations to ensure appropriate data access and content sharing controls.
- Compare Security implementation patterns to determine the best approach for business requirements.
- List the configuration options and parameters available for Security and describe when each is appropriate.
Management
- Describe OAC administration: snapshots, migration, monitoring, and capacity management.
- Configure OAC instance management with scaling, backup, and environment migration procedures.
- Implement content migration with snapshots, export/import, and environment promotion workflows.
- Evaluate administration practices to recommend governance for analytics platform management.
- Describe the architecture and workflow of Management including integration points with related services.
- Implement Management following best practices for efficiency, security, and reliability.
Scope
Included Topics
- All domains in the Oracle Analytics Cloud exam guide.
- Core topics: Data Visualization, Reports, Dashboards, Data Flows, Semantic Models, ML, Data Prep, Administration.
- Oracle services, tools, and best practices relevant to this certification.
- Scenario-based problem solving at the Associate level.
Not Covered
- Topics outside the official exam guide scope.
- Specific pricing values that change over time.
- Third-party products beyond basic integration awareness.
- Custom development beyond standard configuration.
Official Exam Page
Learn more at Oracle
1Z0-1035-25 is coming soon
Adaptive learning that maps your knowledge and closes your gaps.
Create Free Account to Be Notified