OAC Data Visualization: Projects, Workbooks & Canvases

Explain the core Data Visualization (DV) building blocks in Oracle Analytics Cloud — projects, datasets, and canvases — and how they differ from RPD-based subject areas.

Data Visualization (DV) is OAC's self-service front end, and it uses a different vocabulary and mental model than classic OBIEE Answers, which is exactly why interviewers test it separately even for candidates strong in on-premise OBIEE.

An RPD subject area is like a professionally organized reference library where a librarian has already catalogued how every book relates to every other book. A DV project is like spreading your own books and a few borrowed ones out on your desk and figuring out on the fly how they connect for the specific question you're trying to answer right now.

Key Concepts

A DV Project is the top-level container for a self-service analysis — roughly analogous to a saved analysis/dashboard, but built around drag-and-drop visualization rather than criteria-tab column selection. Inside a project, one or more Canvases hold the actual visualizations (charts, tables, maps, narrative insights), and a project can have multiple canvases the way a dashboard has multiple pages. Underneath, a project is built against one or more Datasets — these can be an uploaded Excel/CSV file, a direct database connection, a subject area/RPD-based data source (for backward compatibility with governed OBIEE content), or a connection to a cloud application.

ProjectCanvasesDatasets

The key conceptual shift from OBIEE: instead of navigating a pre-modeled Presentation layer with joins already defined by an RPD developer, a DV author can blend multiple datasets together interactively — dragging two different data sources onto a canvas and letting DV either auto-detect a join key or having the author explicitly define one, entirely within the visualization tool, no RPD change required. This is what makes DV "self-service": exploratory joins and blends that would otherwise require an RPD developer and a deployment cycle.

blend multiple datasets together interactively

A sharp interview answer notes the trade-off explicitly: DV's flexibility trades away some of the RPD's governance guarantees — joins and calculations built ad hoc in a DV project aren't centrally reviewed or reused the way an RPD's business model is, so organizations typically pair DV for exploration with RPD-governed subject areas for certified, audited metrics.