{"id":832,"date":"2026-04-16T08:02:24","date_gmt":"2026-04-16T08:02:24","guid":{"rendered":"https:\/\/www.devopsschool.com\/tutorials\/oracle-cloud-analytics-cloud-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-analytics-and-ai\/"},"modified":"2026-04-16T08:02:24","modified_gmt":"2026-04-16T08:02:24","slug":"oracle-cloud-analytics-cloud-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-analytics-and-ai","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/tutorials\/oracle-cloud-analytics-cloud-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-analytics-and-ai\/","title":{"rendered":"Oracle Cloud Analytics Cloud Tutorial: Architecture, Pricing, Use Cases, and Hands-On Guide for Analytics and AI"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Category<\/h2>\n\n\n\n<p>Analytics and AI<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Introduction<\/h2>\n\n\n\n<p>Analytics Cloud (on Oracle Cloud) is Oracle\u2019s managed analytics and business intelligence (BI) platform for building dashboards, interactive data visualizations, governed semantic models, and scheduled reporting\u2014without having to install and operate your own BI servers.<\/p>\n\n\n\n<p>In simple terms: you provision an Analytics Cloud instance, connect it to your data (databases, files, and supported applications), then create datasets, visualizations, dashboards, and reports that business users can safely consume.<\/p>\n\n\n\n<p>Technically, Analytics Cloud is a PaaS offering in Oracle Cloud\u2019s <strong>Analytics and AI<\/strong> category. It provides a browser-based authoring experience, a governed modeling layer (for consistent business metrics), secure connectivity patterns (including private endpoints and gateway-based access to on-premises sources), and operational controls for scaling, monitoring, and lifecycle management. Oracle runs the underlying infrastructure and service components, while you manage instance sizing, users, content, data connections, and governance.<\/p>\n\n\n\n<p>The main problem Analytics Cloud solves is <strong>turning raw organizational data into trusted, shareable insights<\/strong>\u2014while balancing self-service (speed) with governance (consistency, security, and compliance).<\/p>\n\n\n\n<blockquote>\n<p>Naming note (important): Oracle\u2019s official product name is commonly presented as <strong>Oracle Analytics Cloud<\/strong> in Oracle documentation and the OCI Console. This tutorial uses <strong>Analytics Cloud<\/strong> as the primary name (as requested) and refers to the same service on <strong>Oracle Cloud<\/strong>.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">2. What is Analytics Cloud?<\/h2>\n\n\n\n<p>Analytics Cloud is Oracle Cloud\u2019s managed analytics and BI service for:\n&#8211; Creating interactive dashboards and data visualizations\n&#8211; Performing self-service data preparation and enrichment\n&#8211; Building governed semantic models (metrics, hierarchies, subject areas)\n&#8211; Enabling secure sharing, scheduled refreshes, and distribution of analytics content<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Official purpose (scope)<\/h3>\n\n\n\n<p>Analytics Cloud is intended to provide an end-to-end analytics layer\u2014spanning data access, preparation, visualization, semantic modeling, sharing, and administration\u2014while Oracle manages the underlying service infrastructure.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Core capabilities (high level)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Self-service analytics<\/strong>: Explore datasets, build visualizations, and publish dashboards.<\/li>\n<li><strong>Data preparation<\/strong>: Create datasets, join\/transform data, and refresh content.<\/li>\n<li><strong>Governed analytics<\/strong>: Define consistent business metrics and reusable models.<\/li>\n<li><strong>Collaboration and distribution<\/strong>: Share content with users\/groups and schedule delivery (capabilities can vary by configuration\u2014verify in official docs for your edition\/features).<\/li>\n<li><strong>Enterprise operations<\/strong>: Scale capacity, monitor service health, and manage lifecycle.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Major components (conceptual)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analytics Cloud instance<\/strong>: The provisioned service environment where content, connections, and users operate.<\/li>\n<li><strong>Content layer<\/strong>: Workbooks, dashboards, reports, and catalog objects.<\/li>\n<li><strong>Dataset and modeling layer<\/strong>: Curated datasets and semantic definitions to standardize business logic.<\/li>\n<li><strong>Connectivity layer<\/strong>: Connections to cloud data sources (for example, Oracle databases) and supported external sources; and gateway options for private\/on-prem connectivity.<\/li>\n<li><strong>Identity and access<\/strong>: User authentication and authorization integrated with Oracle Cloud IAM\/Identity Domains.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Service type<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Managed <strong>PaaS<\/strong> analytics\/BI service on Oracle Cloud (OCI).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Scope (regional \/ tenancy \/ instance)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Analytics Cloud is provisioned as an <strong>instance<\/strong> in a specific <strong>Oracle Cloud region<\/strong> and <strong>compartment<\/strong> (typical OCI resource scoping).<\/li>\n<li>Access can be configured for <strong>public<\/strong> or <strong>private<\/strong> connectivity patterns depending on your deployment and licensing\/options (verify availability and constraints for your tenancy and region in official docs).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">How it fits into Oracle Cloud<\/h3>\n\n\n\n<p>Analytics Cloud sits on top of Oracle Cloud\u2019s data platform and integrates commonly with:\n&#8211; <strong>Oracle Autonomous Database<\/strong> (including data warehouse patterns)\n&#8211; <strong>Oracle Object Storage<\/strong> (often as a landing zone in data architectures, though direct connectivity patterns should be verified for your use case)\n&#8211; <strong>Oracle Data Integration \/ GoldenGate<\/strong> (data movement and CDC patterns\u2014verify exact integration paths)\n&#8211; <strong>OCI Identity and Access Management<\/strong> (Identity Domains, IAM policies)\n&#8211; <strong>OCI Logging \/ Monitoring \/ Audit<\/strong> for operational governance (availability depends on service instrumentation\u2014verify per region)<\/p>\n\n\n\n<p>Official docs starting point (verify latest):<br\/>\nhttps:\/\/docs.oracle.com\/en\/cloud\/paas\/analytics-cloud\/<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Why use Analytics Cloud?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Business reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Faster insight to action<\/strong>: Analysts and business users can explore data without waiting for custom app development.<\/li>\n<li><strong>Single source of truth<\/strong>: A governed model reduces metric disputes (\u201cwhose revenue is correct?\u201d).<\/li>\n<li><strong>Lower time-to-dashboard<\/strong>: Managed service reduces infrastructure lead time.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Technical reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Managed BI platform<\/strong>: Avoid installing, patching, and scaling BI servers yourself.<\/li>\n<li><strong>Reusable semantic layer<\/strong>: Centralized metric definitions improve consistency across dashboards.<\/li>\n<li><strong>Broad connectivity patterns<\/strong>: Cloud databases and supported sources can be integrated; private access can be designed for regulated environments (verify per connector).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Operational reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Elasticity by design<\/strong>: Scale capacity to match demand (subject to edition and limits).<\/li>\n<li><strong>Simplified lifecycle<\/strong>: Provision, patching cadence (Oracle-managed), backups\/restore options (verify specifics per service documentation).<\/li>\n<li><strong>Separation of environments<\/strong>: Use separate instances\/compartments for dev\/test\/prod.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Security \/ compliance reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Central IAM integration<\/strong>: Identity Domains + IAM policies enable least privilege.<\/li>\n<li><strong>Private networking patterns<\/strong>: Support private endpoints \/ gateway access patterns (verify what\u2019s supported in your region\/edition).<\/li>\n<li><strong>Auditing and governance<\/strong>: Leverage OCI Audit and logs where available to track administrative actions.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Scalability \/ performance reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Right-size capacity<\/strong>: Allocate capacity aligned with usage patterns.<\/li>\n<li><strong>Pushdown to the database<\/strong>: Well-designed models and queries can leverage database engines for compute (depends on source and modeling approach).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">When teams should choose Analytics Cloud<\/h3>\n\n\n\n<p>Choose Analytics Cloud when you need:\n&#8211; A managed BI and dashboarding platform on Oracle Cloud\n&#8211; A strong governance layer (semantic model, consistent KPIs)\n&#8211; Integration with Oracle data platforms (especially Autonomous Database patterns)\n&#8211; Enterprise controls for identity, networking, and administration<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">When teams should not choose Analytics Cloud<\/h3>\n\n\n\n<p>Avoid or reconsider Analytics Cloud if:\n&#8211; You only need lightweight charting for a single app (an embedded chart library might be cheaper)\n&#8211; Your primary requirement is operational telemetry dashboards (OCI Observability tools may be a better fit)\n&#8211; You require a BI tool that is already standardized across your enterprise (for example, Power BI\/Tableau) and migration cost outweighs benefits\n&#8211; Your data sources are unsupported or require complex connectivity that you cannot deploy (for example, you cannot deploy a gateway\/agent when needed)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Where is Analytics Cloud used?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Industries<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finance and insurance (risk dashboards, regulatory reporting)<\/li>\n<li>Retail and e-commerce (sales, inventory, customer segmentation)<\/li>\n<li>Manufacturing (quality, supply chain analytics)<\/li>\n<li>Healthcare (operations analytics, patient flow; ensure compliance controls)<\/li>\n<li>Public sector (program KPIs and transparency dashboards)<\/li>\n<li>Technology\/SaaS (product analytics, revenue analytics)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Team types<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BI teams (central analytics platforms)<\/li>\n<li>Data engineering teams (curated datasets + governance)<\/li>\n<li>Product and business analytics teams (self-service exploration)<\/li>\n<li>Finance operations (KPIs, forecasting support)<\/li>\n<li>Security\/compliance teams (controlled access to sensitive metrics)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Workloads<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Executive dashboards and KPI scorecards<\/li>\n<li>Department dashboards (sales, marketing, ops)<\/li>\n<li>Ad hoc exploratory analysis<\/li>\n<li>Scheduled reporting and distribution (capability depends on configuration\u2014verify)<\/li>\n<li>Data preparation workflows for analytics-ready datasets<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Architectures<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lakehouse-style<\/strong>: Object Storage + data processing + curated warehouse + Analytics Cloud on top<\/li>\n<li><strong>Warehouse-first<\/strong>: Autonomous Data Warehouse as system of record + Analytics Cloud semantic layer<\/li>\n<li><strong>Hybrid<\/strong>: On-prem databases accessed via a gateway pattern (Remote Data Gateway or equivalent\u2014verify exact tooling for your deployment)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Production vs dev\/test usage<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Dev\/test<\/strong>: Validate data models, dashboard prototypes, and refresh cadence with smaller datasets.<\/li>\n<li><strong>Production<\/strong>: High concurrency dashboards, strict IAM, private networking, monitored refresh jobs, backup\/DR strategy, and change control.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">5. Top Use Cases and Scenarios<\/h2>\n\n\n\n<p>Below are realistic scenarios where Analytics Cloud is commonly applied. Each includes the problem, why Analytics Cloud fits, and a concrete example.<\/p>\n\n\n\n<p>1) <strong>Executive KPI Dashboard<\/strong>\n&#8211; <strong>Problem<\/strong>: Leadership needs a trusted, consistent view of revenue, margin, and pipeline.\n&#8211; <strong>Why it fits<\/strong>: Governed metrics and centralized dashboards reduce KPI inconsistency.\n&#8211; <strong>Example<\/strong>: CFO dashboard with monthly close KPIs and variance analysis sourced from a warehouse.<\/p>\n\n\n\n<p>2) <strong>Sales Pipeline and Forecast Readiness<\/strong>\n&#8211; <strong>Problem<\/strong>: Sales operations needs up-to-date pipeline views by region and segment.\n&#8211; <strong>Why it fits<\/strong>: Interactive filters, drilldowns, and scheduled refresh support daily cadence.\n&#8211; <strong>Example<\/strong>: Regional pipeline dashboard with drill to account and rep performance.<\/p>\n\n\n\n<p>3) <strong>Marketing Attribution and Campaign Performance<\/strong>\n&#8211; <strong>Problem<\/strong>: Marketing data is fragmented across platforms and spreadsheets.\n&#8211; <strong>Why it fits<\/strong>: Data preparation + unified datasets allow consistent campaign ROI reporting.\n&#8211; <strong>Example<\/strong>: Combine campaign spend CSV exports with lead\/conversion data in dashboards.<\/p>\n\n\n\n<p>4) <strong>Supply Chain Inventory Visibility<\/strong>\n&#8211; <strong>Problem<\/strong>: Overstock\/stockout risk due to delayed reporting.\n&#8211; <strong>Why it fits<\/strong>: Near-real-time reporting (depending on data refresh pipeline) and exception dashboards.\n&#8211; <strong>Example<\/strong>: Inventory turns and safety stock alerts by warehouse.<\/p>\n\n\n\n<p>5) <strong>Financial Close and Variance Analysis<\/strong>\n&#8211; <strong>Problem<\/strong>: Finance teams spend too long reconciling numbers across reports.\n&#8211; <strong>Why it fits<\/strong>: Semantic modeling and governed calculations standardize definitions.\n&#8211; <strong>Example<\/strong>: EBITDA, operating expense, and budget variance dashboards.<\/p>\n\n\n\n<p>6) <strong>Customer Support Operations<\/strong>\n&#8211; <strong>Problem<\/strong>: Support leaders need SLA adherence and ticket backlog analytics.\n&#8211; <strong>Why it fits<\/strong>: Dashboards with segmentation and trend analysis.\n&#8211; <strong>Example<\/strong>: SLA dashboard by product, severity, and region updated hourly from support DB.<\/p>\n\n\n\n<p>7) <strong>Product Usage Analytics (SaaS)<\/strong>\n&#8211; <strong>Problem<\/strong>: Product managers need usage KPIs and cohort retention views.\n&#8211; <strong>Why it fits<\/strong>: Interactive exploration across usage events curated into datasets.\n&#8211; <strong>Example<\/strong>: Weekly active users by plan tier; drilldowns to features.<\/p>\n\n\n\n<p>8) <strong>Regulatory and Compliance Reporting<\/strong>\n&#8211; <strong>Problem<\/strong>: Must produce auditable reports under controlled access.\n&#8211; <strong>Why it fits<\/strong>: Central access controls and repeatable reporting workflows.\n&#8211; <strong>Example<\/strong>: Quarterly compliance pack generated from governed datasets.<\/p>\n\n\n\n<p>9) <strong>Hybrid On-Prem + Cloud Analytics<\/strong>\n&#8211; <strong>Problem<\/strong>: Critical data remains on-prem; analytics is moving to cloud.\n&#8211; <strong>Why it fits<\/strong>: Gateway-based connectivity patterns can bridge private networks (verify supported gateway tooling and constraints).\n&#8211; <strong>Example<\/strong>: Analyze on-prem Oracle DB operational data without exposing it publicly.<\/p>\n\n\n\n<p>10) <strong>Data Quality and Data Pipeline Observability (Business-facing)<\/strong>\n&#8211; <strong>Problem<\/strong>: Business users need to know when data is stale or incomplete.\n&#8211; <strong>Why it fits<\/strong>: Dashboards that include freshness indicators and pipeline status tables.\n&#8211; <strong>Example<\/strong>: A \u201cData Health\u201d dashboard showing last load time and row counts.<\/p>\n\n\n\n<p>11) <strong>HR Workforce Analytics<\/strong>\n&#8211; <strong>Problem<\/strong>: HR needs attrition, hiring funnel, and DEI metrics with strict access controls.\n&#8211; <strong>Why it fits<\/strong>: Role-based access and curated subject areas.\n&#8211; <strong>Example<\/strong>: HR dashboard with anonymized aggregates and restricted detail access.<\/p>\n\n\n\n<p>12) <strong>Embedded Analytics for Internal Portals<\/strong>\n&#8211; <strong>Problem<\/strong>: Teams want dashboards inside an internal portal with consistent identity.\n&#8211; <strong>Why it fits<\/strong>: Analytics Cloud supports embedding patterns depending on licensing and configuration (verify supported embedding\/auth patterns in official docs).\n&#8211; <strong>Example<\/strong>: A procurement portal that shows spend analytics per department.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">6. Core Features<\/h2>\n\n\n\n<p>Feature availability can vary by edition, region, and tenancy configuration. Verify the exact capability set in the official documentation for your Analytics Cloud version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6.1 Managed Analytics Cloud instance provisioning<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Lets you create and operate an Analytics Cloud environment without managing servers.<\/li>\n<li><strong>Why it matters<\/strong>: Removes infrastructure undifferentiated work (patching, scaling infrastructure).<\/li>\n<li><strong>Practical benefit<\/strong>: Faster time-to-value for BI teams.<\/li>\n<li><strong>Caveats<\/strong>: You still own instance sizing, governance, and lifecycle operations.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.2 Self-service visualization and dashboards<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Build interactive charts, tables, maps (where supported), and dashboards from datasets.<\/li>\n<li><strong>Why it matters<\/strong>: Enables rapid analysis by analysts and power users.<\/li>\n<li><strong>Practical benefit<\/strong>: Faster iteration than custom BI development.<\/li>\n<li><strong>Caveats<\/strong>: Data modeling and dataset design strongly influence performance and correctness.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.3 Datasets and data preparation<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Create datasets from files and connections; perform joins, transforms, calculated fields, and refreshes.<\/li>\n<li><strong>Why it matters<\/strong>: Most analytics projects require cleaning and shaping data.<\/li>\n<li><strong>Practical benefit<\/strong>: Reduces dependency on external ETL for smaller transformations.<\/li>\n<li><strong>Caveats<\/strong>: For large-scale transformations, a data warehouse\/ETL service is usually more cost-effective and governable.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.4 Semantic modeling \/ governed metrics<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Define a business-friendly layer (dimensions, measures, hierarchies, calculations) so dashboards use consistent logic.<\/li>\n<li><strong>Why it matters<\/strong>: Prevents \u201cmultiple truths\u201d across teams.<\/li>\n<li><strong>Practical benefit<\/strong>: Standard KPIs across the organization.<\/li>\n<li><strong>Caveats<\/strong>: Requires discipline: change control, versioning, and ownership.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.5 Scheduled refresh and distribution (where available)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Refresh datasets and distribute content on a schedule.<\/li>\n<li><strong>Why it matters<\/strong>: Business users often need routine delivery, not just ad hoc access.<\/li>\n<li><strong>Practical benefit<\/strong>: Automated reporting cycles.<\/li>\n<li><strong>Caveats<\/strong>: Scheduling, email delivery, and external sharing capabilities can be constrained by security policies and configuration\u2014verify.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.6 Security integration with Oracle Cloud IAM \/ Identity Domains<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Centralizes authentication and authorization for users\/groups.<\/li>\n<li><strong>Why it matters<\/strong>: Aligns BI access with enterprise identity governance.<\/li>\n<li><strong>Practical benefit<\/strong>: Faster onboarding\/offboarding, least privilege.<\/li>\n<li><strong>Caveats<\/strong>: You must design policies and roles carefully; misconfiguration is a common risk.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.7 Private networking and secure connectivity patterns (deployment-dependent)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Enables private access patterns (for example, private endpoints) and gateway-based access to private data sources (verify exact options).<\/li>\n<li><strong>Why it matters<\/strong>: Regulated workloads often cannot expose analytics endpoints publicly.<\/li>\n<li><strong>Practical benefit<\/strong>: Reduced attack surface and better compliance posture.<\/li>\n<li><strong>Caveats<\/strong>: Requires VCN\/DNS planning, routing, and possibly additional network components.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.8 Monitoring, auditing, and operational governance<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Provides service health visibility and integrates with Oracle Cloud auditing for administrative actions (verify metric\/log coverage).<\/li>\n<li><strong>Why it matters<\/strong>: BI is production software; you need observability.<\/li>\n<li><strong>Practical benefit<\/strong>: Faster incident response and governance reporting.<\/li>\n<li><strong>Caveats<\/strong>: Not all user-level actions are always exposed as logs; plan for complementary monitoring.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.9 Content management and lifecycle controls<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Organize content in a catalog\/folders, manage permissions, and support promotion patterns (dev \u2192 test \u2192 prod).<\/li>\n<li><strong>Why it matters<\/strong>: Prevents content sprawl and uncontrolled KPI changes.<\/li>\n<li><strong>Practical benefit<\/strong>: Cleaner operations and reliable releases.<\/li>\n<li><strong>Caveats<\/strong>: Without a governance model, catalogs become unmaintainable quickly.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.10 Extensibility and integration (connectors, APIs, embedding)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does<\/strong>: Integrates with data sources and can support embedding and automation via supported interfaces (verify API coverage).<\/li>\n<li><strong>Why it matters<\/strong>: Real deployments require automation and integration with portals and workflows.<\/li>\n<li><strong>Practical benefit<\/strong>: Reduced manual admin work.<\/li>\n<li><strong>Caveats<\/strong>: APIs and embedding approaches vary by version\/edition\u2014verify in official docs.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">7. Architecture and How It Works<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">7.1 High-level service architecture<\/h3>\n\n\n\n<p>At a high level:\n1. Users authenticate via Oracle Cloud IAM \/ Identity Domains.\n2. They access the Analytics Cloud web interface (public or private endpoint depending on configuration).\n3. Analytics Cloud queries connected data sources (databases, files, or other supported systems).\n4. Results are rendered into visualizations\/dashboards.\n5. Admins manage access via IAM policies, Analytics Cloud roles, and content permissions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7.2 Data flow vs control flow<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Control plane<\/strong>: OCI Console and APIs used to provision and manage the Analytics Cloud instance (create, scale, lifecycle actions).<\/li>\n<li><strong>Data plane<\/strong>: User interactions and queries; dataset refresh and content rendering; connectivity to data sources.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">7.3 Common Oracle Cloud integrations<\/h3>\n\n\n\n<p>Typical patterns in Oracle Cloud architectures:\n&#8211; <strong>Autonomous Database<\/strong> as the analytics warehouse.\n&#8211; <strong>Object Storage<\/strong> as raw\/landing storage and archive.\n&#8211; <strong>Data Integration \/ GoldenGate<\/strong> for ingest\/ELT\/CDC (verify best-fit service for your use case).\n&#8211; <strong>OCI Vault<\/strong> for secrets (where integrations allow; otherwise use secure credential storage patterns).\n&#8211; <strong>OCI Logging\/Monitoring<\/strong> for ops, plus <strong>OCI Audit<\/strong> for control-plane actions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7.4 Dependency services<\/h3>\n\n\n\n<p>Most Analytics Cloud deployments depend on:\n&#8211; <strong>OCI IAM \/ Identity Domains<\/strong> for identity and access\n&#8211; <strong>VCN<\/strong> (if using private connectivity)\n&#8211; <strong>Data source services<\/strong> (databases, object storage, SaaS apps) supplying data\n&#8211; Optional: <strong>DNS<\/strong>, <strong>NAT\/Service Gateway<\/strong>, and <strong>FastConnect\/VPN<\/strong> for private routing patterns<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7.5 Security\/auth model (typical)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Authentication<\/strong>: Through IAM\/Identity Domains.<\/li>\n<li><strong>Authorization<\/strong>:<\/li>\n<li>OCI IAM policies determine who can manage the Analytics Cloud instance resource.<\/li>\n<li>Analytics Cloud application roles determine who can create models, datasets, and content.<\/li>\n<li>Content permissions control access to specific folders\/dashboards.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">7.6 Networking model (typical)<\/h3>\n\n\n\n<p>Two common approaches:\n&#8211; <strong>Public endpoint<\/strong>: Fastest to start; secure with strong IAM, MFA, and IP allowlists if supported.\n&#8211; <strong>Private endpoint \/ private access<\/strong>: Preferred for regulated environments; requires VCN planning and private connectivity to data sources.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">7.7 Monitoring\/logging\/governance<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>OCI Audit<\/strong>: Tracks OCI control-plane actions (create\/update\/delete instance, policy changes).<\/li>\n<li><strong>Service metrics\/logs<\/strong>: Availability depends on Analytics Cloud instrumentation in your region\u2014verify in official docs.<\/li>\n<li><strong>Tagging<\/strong>: Use OCI tags to enforce governance (cost center, environment, owner).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Simple architecture diagram (beginner)<\/h4>\n\n\n\n<pre><code class=\"language-mermaid\">flowchart LR\n  U[Business Users] --&gt;|Browser| OAC[Analytics Cloud Instance]\n  OAC --&gt;|Queries| DB[(Oracle Database \/ Autonomous DB)]\n  Admin[Cloud Admin] --&gt;|OCI Console| OCI[Oracle Cloud Control Plane]\n  OCI --&gt; OAC\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Production-style architecture diagram (private, governed)<\/h4>\n\n\n\n<pre><code class=\"language-mermaid\">flowchart TB\n  subgraph IAM[OCI IAM \/ Identity Domains]\n    IDP[Users + Groups + MFA]\n  end\n\n  subgraph VCN[VCN (Private Network)]\n    OAC[Analytics Cloud (Private Access)]\n    ADW[(Autonomous Data Warehouse\\nPrivate Endpoint)]\n    GW[Connectivity (VPN\/FastConnect)\\nfor On-Prem (optional)]\n    SGW[Service Gateway (to OCI services)]\n  end\n\n  subgraph OCI[OCI Services]\n    OS[(Object Storage)]\n    VAULT[OCI Vault]\n    MON[Monitoring \/ Logging]\n    AUD[Audit]\n  end\n\n  IDP --&gt;|Authenticate| OAC\n  OAC --&gt;|SQL \/ Queries| ADW\n  OAC --&gt;|Optional secure access| GW\n  OAC --&gt;|OCI private access| SGW --&gt; OS\n  OAC --&gt; MON\n  OCI --&gt; AUD\n  VAULT -. secrets (pattern depends on integration; verify) .- OAC\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">8. Prerequisites<\/h2>\n\n\n\n<p>Before starting, confirm the following.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Oracle Cloud account \/ tenancy<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An active <strong>Oracle Cloud<\/strong> tenancy with permission to provision services.<\/li>\n<li>A target <strong>region<\/strong> where Analytics Cloud is available. Verify regional availability in official docs and\/or OCI Console service availability.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">IAM permissions and roles<\/h3>\n\n\n\n<p>You typically need:\n&#8211; Permission to <strong>create and manage<\/strong> Analytics Cloud instances in a compartment.\n&#8211; Permission to manage networking resources if using private access (VCN, subnets, gateways, security lists\/NSGs).<\/p>\n\n\n\n<p>OCI IAM policy syntax evolves; verify exact resource-type names in current docs. A common pattern looks like:<\/p>\n\n\n\n<pre><code class=\"language-text\">Allow group &lt;group-name&gt; to manage analytics-instances in compartment &lt;compartment-name&gt;\n<\/code><\/pre>\n\n\n\n<p>Also plan for:\n&#8211; Separate admin group (platform team)\n&#8211; Author group (BI developers)\n&#8211; Consumer group (read-only business users)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Billing requirements<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Analytics Cloud is typically a <strong>paid<\/strong> service (metered or subscription). You need a billing-enabled tenancy or credits.<\/li>\n<li>Free Tier coverage can vary; verify whether Analytics Cloud is included in any trial or promotional credits.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Tools (optional but helpful)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Web browser (primary)<\/li>\n<li>OCI Console access<\/li>\n<li>OCI CLI (optional, for broader automation; not required for the beginner lab)<\/li>\n<li>OCI CLI docs: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/API\/Concepts\/cliconcepts.htm<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Quotas \/ limits<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Analytics Cloud instance limits and capacity limits apply per tenancy\/region.<\/li>\n<li>Check: <strong>OCI Console \u2192 Governance &amp; Administration \u2192 Limits, Quotas and Usage<\/strong> (naming may vary) to ensure you can create an instance.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisite services (for optional extensions)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If you want database-backed analytics: <strong>Autonomous Database<\/strong> (warehouse) or another supported DB.<\/li>\n<li>For private connectivity: <strong>VCN<\/strong>, subnets, VPN\/FastConnect where applicable.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">9. Pricing \/ Cost<\/h2>\n\n\n\n<p>Analytics Cloud pricing can vary by:\n&#8211; Edition (for example, Professional vs Enterprise\u2014verify current editions)\n&#8211; Licensing model (for example, <strong>License Included<\/strong> vs <strong>Bring Your Own License (BYOL)<\/strong>)\n&#8211; Metering unit (often capacity-based, such as OCPU\/hour or similar\u2014verify exact metric for your SKU)\n&#8211; Region and currency\n&#8211; Commitments (monthly\/annual commitments may differ from pay-as-you-go)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Official pricing sources (use these to verify)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Analytics Cloud pricing page (verify current URL and SKUs):<br\/>\n  https:\/\/www.oracle.com\/cloud\/analytics\/analytics-cloud\/pricing\/<\/li>\n<li>Oracle Cloud price list (filter for Analytics):<br\/>\n  https:\/\/www.oracle.com\/cloud\/price-list\/<\/li>\n<li>Oracle Cloud cost estimator:<br\/>\n  https:\/\/www.oracle.com\/cloud\/costestimator.html<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pricing dimensions (typical)<\/h3>\n\n\n\n<p>While exact SKUs can change, Analytics Cloud commonly charges based on:\n&#8211; <strong>Capacity<\/strong> (compute allocation)\n&#8211; <strong>Optional add-ons<\/strong> (feature\/edition dependent)\n&#8211; <strong>Data egress<\/strong> (standard OCI network egress charges may apply for traffic leaving OCI)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Free tier \/ trial<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Analytics Cloud is often started via a <strong>trial<\/strong> or <strong>Oracle Cloud credits<\/strong> rather than Always Free. Verify the current Free Tier eligibility and trial options in your tenancy.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Primary cost drivers<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Allocated capacity<\/strong>: The biggest driver\u2014right-size for concurrent users and query complexity.<\/li>\n<li><strong>Environment sprawl<\/strong>: Dev\/test\/prod instances multiply spend.<\/li>\n<li><strong>Data refresh frequency<\/strong>: Frequent refreshes drive load on data sources and may require more capacity.<\/li>\n<li><strong>Network design<\/strong>: Private connectivity (VPN\/FastConnect) adds cost outside Analytics Cloud itself.<\/li>\n<li><strong>Upstream data platform costs<\/strong>: Autonomous Database, Object Storage, Data Integration, GoldenGate, etc.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Hidden or indirect costs to plan for<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database costs<\/strong> (warehouse capacity, storage, backup)<\/li>\n<li><strong>Data integration costs<\/strong> (ETL\/ELT runs, CDC streams)<\/li>\n<li><strong>Connectivity<\/strong>: VPN\/FastConnect, NAT Gateway where used<\/li>\n<li><strong>Operational overhead<\/strong>: Additional environments, monitoring tooling, and governance<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Network and data transfer implications<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Queries from Analytics Cloud to data sources inside the same region typically avoid internet egress, but cross-region or internet egress can cost extra.<\/li>\n<li>If users access Analytics Cloud over the public internet, that is not usually \u201cegress from OCI\u201d in the same way as data export, but exporting large datasets\/reports out of OCI may incur egress\u2014verify your billing rules and architecture.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Cost optimization strategies<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start with the smallest viable capacity and scale based on measured concurrency and performance.<\/li>\n<li>Use <strong>separate non-production instances<\/strong> but keep them right-sized and scheduled off-hours when possible.<\/li>\n<li>Optimize the semantic model and database performance (indexes\/partitioning\/materialized views) to reduce compute needs.<\/li>\n<li>Prefer pushing heavy transformations into the database\/ETL layer rather than doing everything in the BI tool.<\/li>\n<li>Control large exports and reduce refresh frequency for non-critical datasets.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Example low-cost starter estimate (no fabricated prices)<\/h3>\n\n\n\n<p>A realistic \u201cstarter\u201d approach:\n&#8211; 1 small Analytics Cloud instance (minimum supported capacity for your edition)\n&#8211; Limited author seats; most users are consumers\n&#8211; File upload datasets for demos (no extra database services)<\/p>\n\n\n\n<p>Because the price per capacity unit varies by region, edition, and licensing model, <strong>use the cost estimator<\/strong> and choose the smallest capacity permitted for the SKU to compute your baseline.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example production cost considerations<\/h3>\n\n\n\n<p>For production, include:\n&#8211; Production + staging + development instances\n&#8211; Higher capacity for peak hours and concurrency\n&#8211; Private networking (VCN endpoints, VPN\/FastConnect)\n&#8211; A dedicated warehouse (Autonomous Database) sized for BI workloads\n&#8211; Data integration\/CDC for near-real-time dashboards<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">10. Step-by-Step Hands-On Tutorial<\/h2>\n\n\n\n<p>This lab is designed to be beginner-friendly and executable with minimal dependencies. It focuses on provisioning Analytics Cloud and building a dashboard from a CSV file upload. This is a common \u201cfirst success\u201d pattern and avoids additional costs\/services beyond Analytics Cloud itself.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Objective<\/h3>\n\n\n\n<p>Provision an <strong>Analytics Cloud<\/strong> instance in Oracle Cloud, then:\n&#8211; Sign in to the Analytics Cloud console\n&#8211; Upload a CSV dataset\n&#8211; Build a simple workbook\/dashboard\n&#8211; Share it with a user\/group (basic permissions)\n&#8211; Validate access\n&#8211; Clean up resources to avoid ongoing charges<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Lab Overview<\/h3>\n\n\n\n<p>You will complete:\n1. IAM and compartment setup (minimal)\n2. Create an Analytics Cloud instance\n3. Upload data and create visualizations\n4. Publish and share a dashboard\n5. Validate and troubleshoot\n6. Clean up<\/p>\n\n\n\n<blockquote>\n<p>Expected time: 45\u201390 minutes (instance provisioning time varies).<br\/>\nCost: Depends on your Analytics Cloud SKU and capacity. Stop and delete resources when finished.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Prepare a compartment and IAM group (recommended)<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Separate analytics resources and apply least privilege.<\/p>\n\n\n\n<p>1) In the <strong>OCI Console<\/strong>, create (or choose) a compartment, for example:\n&#8211; <code>analytics-lab<\/code><\/p>\n\n\n\n<p>2) Create an IAM group, for example:\n&#8211; <code>AnalyticsCloudAdmins<\/code><\/p>\n\n\n\n<p>3) Add your user to that group.<\/p>\n\n\n\n<p>4) Create a policy in the root compartment (or appropriate parent) granting the group access to manage Analytics Cloud instances in your lab compartment.<\/p>\n\n\n\n<p>A common policy pattern (verify exact resource names in current docs):<\/p>\n\n\n\n<pre><code class=\"language-text\">Allow group AnalyticsCloudAdmins to manage analytics-instances in compartment analytics-lab\n<\/code><\/pre>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nYou have a compartment and a group that can create and manage Analytics Cloud instances.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Sign out\/in (or refresh console session).\n&#8211; Ensure you can navigate to <strong>Analytics &amp; AI<\/strong> services without authorization errors.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Create an Analytics Cloud instance<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Provision the service instance you will use for the lab.<\/p>\n\n\n\n<p>1) In OCI Console, go to the Analytics service area:\n&#8211; Navigate to <strong>Analytics &amp; AI<\/strong> \u2192 <strong>Analytics Cloud<\/strong> (menu labels can vary slightly by console version).<\/p>\n\n\n\n<p>2) Click <strong>Create instance<\/strong>.<\/p>\n\n\n\n<p>3) Fill in the required fields (names vary slightly by region\/console version):\n&#8211; <strong>Compartment<\/strong>: <code>analytics-lab<\/code>\n&#8211; <strong>Instance name<\/strong>: <code>ac-lab-01<\/code>\n&#8211; <strong>Edition \/ feature set<\/strong>: Choose the smallest\/most appropriate option for a lab (verify edition choices and what they include).\n&#8211; <strong>License type<\/strong>: Choose <strong>License Included<\/strong> unless you are explicitly using BYOL and you are licensed.\n&#8211; <strong>Capacity<\/strong>: Select the minimum allowed for your SKU.\n&#8211; <strong>Network access<\/strong>:\n  &#8211; For a beginner lab, <strong>public access<\/strong> is usually simplest.\n  &#8211; For enterprise practice, consider private access (requires VCN\/subnet design).<\/p>\n\n\n\n<p>4) Create the instance.<\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nThe instance enters a <strong>Provisioning<\/strong> state and later becomes <strong>Active<\/strong>.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; In the instance details page, confirm:\n  &#8211; Lifecycle state is <strong>Active<\/strong>\n  &#8211; You have a <strong>service URL<\/strong> (Analytics Cloud URL)<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; <em>You are not authorized to create this resource<\/em><br\/>\n  Fix: Re-check IAM policy and compartment selection; confirm you\u2019re in the correct identity domain and group.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Sign in to Analytics Cloud and confirm you have author access<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Access the Analytics Cloud user interface and confirm you can create content.<\/p>\n\n\n\n<p>1) Open the instance <strong>service URL<\/strong>.<\/p>\n\n\n\n<p>2) Authenticate with your Oracle Cloud identity (Identity Domains).<\/p>\n\n\n\n<p>3) Confirm you can access the home page and navigate to create content (workbooks\/projects).<\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nYou can access Analytics Cloud and see the authoring UI.<\/p>\n\n\n\n<p><strong>Verification checklist:<\/strong>\n&#8211; You can open the catalog\/content area.\n&#8211; You can start creating a workbook\/project (naming varies by UI).<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; <em>You can log in, but you cannot create content<\/em><br\/>\n  Fix: Ensure your user has the correct Analytics Cloud application role (author\/admin) in addition to OCI IAM permissions.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Upload a CSV dataset<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Create a dataset from a local file (fastest path).<\/p>\n\n\n\n<p>1) Create a small CSV file locally (example: <code>sales.csv<\/code>) with content like:<\/p>\n\n\n\n<pre><code class=\"language-csv\">order_date,region,product,units,unit_price\n2026-01-03,West,Keyboard,3,35.00\n2026-01-03,West,Mouse,5,18.00\n2026-01-07,East,Monitor,2,220.00\n2026-01-10,North,Laptop,1,1200.00\n2026-01-10,East,Keyboard,4,35.00\n2026-01-15,South,Mouse,10,18.00\n2026-01-20,West,Monitor,1,220.00\n2026-01-22,North,Keyboard,2,35.00\n2026-01-25,South,Laptop,1,1200.00\n<\/code><\/pre>\n\n\n\n<p>2) In Analytics Cloud, find the option to <strong>Create Dataset<\/strong> (or <strong>Add Data<\/strong> \/ <strong>Dataset<\/strong>).<\/p>\n\n\n\n<p>3) Choose <strong>File Upload<\/strong> and upload <code>sales.csv<\/code>.<\/p>\n\n\n\n<p>4) During import:\n&#8211; Ensure <code>order_date<\/code> is recognized as a date (or set it manually).\n&#8211; Ensure <code>units<\/code> and <code>unit_price<\/code> are numeric.<\/p>\n\n\n\n<p>5) Save the dataset as:\n&#8211; <code>Sales_Lab_Dataset<\/code><\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nA dataset is created and available for workbook creation.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Preview the dataset rows.\n&#8211; Confirm column data types look correct.<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; <em>Date is imported as text<\/em><br\/>\n  Fix: Adjust the date format during import or convert the column type in dataset preparation (exact steps vary by UI version).<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Build a workbook with 3 visualizations<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Create a practical dashboard quickly.<\/p>\n\n\n\n<p>1) Create a new workbook\/project using <code>Sales_Lab_Dataset<\/code>.<\/p>\n\n\n\n<p>2) Add a calculated measure (if the UI supports it in your workflow):\n&#8211; <code>revenue = units * unit_price<\/code><\/p>\n\n\n\n<p>If the UI requires a different expression syntax, use the UI\u2019s formula editor guidance.<\/p>\n\n\n\n<p>3) Create these visuals:\n&#8211; <strong>Revenue by Region<\/strong> (bar chart)\n  &#8211; Dimension: <code>region<\/code>\n  &#8211; Measure: <code>revenue<\/code>\n&#8211; <strong>Revenue Trend<\/strong> (line chart)\n  &#8211; Dimension: <code>order_date<\/code> (by day\/week)\n  &#8211; Measure: <code>revenue<\/code>\n&#8211; <strong>Top Products by Revenue<\/strong> (bar chart)\n  &#8211; Dimension: <code>product<\/code>\n  &#8211; Measure: <code>revenue<\/code>\n  &#8211; Sort descending<\/p>\n\n\n\n<p>4) Add filters:\n&#8211; Region filter\n&#8211; Date range filter (if supported)<\/p>\n\n\n\n<p>5) Save the workbook as:\n&#8211; <code>Sales_Lab_Workbook<\/code><\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nA workbook with multiple visuals and filters.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Changing region filter updates all visuals.\n&#8211; Trend chart shows data across dates.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Publish\/share the dashboard (basic)<\/h3>\n\n\n\n<p><strong>Goal:<\/strong> Let another user (or group) view the content.<\/p>\n\n\n\n<p>1) Create a folder in the catalog (optional but recommended):\n&#8211; <code>\/Shared Folders\/Analytics-Lab<\/code><\/p>\n\n\n\n<p>2) Move or save <code>Sales_Lab_Workbook<\/code> into that folder.<\/p>\n\n\n\n<p>3) Apply permissions:\n&#8211; Grant <strong>read\/view<\/strong> access to a consumer user or a group (for example, <code>AnalyticsConsumers<\/code>).\n&#8211; Keep edit access restricted to authors\/admins.<\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong><br\/>\nA non-author can view the dashboard but cannot edit it.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Test with a second user (or ask a colleague) to open the workbook link and confirm view-only access.<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; <em>User can\u2019t see the folder<\/em><br\/>\n  Fix: Ensure both folder permissions and item permissions are correct; also confirm user has a viewer\/consumer role in Analytics Cloud.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Validation<\/h3>\n\n\n\n<p>Use this checklist to confirm the lab is successful:\n&#8211; Analytics Cloud instance is <strong>Active<\/strong>\n&#8211; You can sign in and create content\n&#8211; Dataset <code>Sales_Lab_Dataset<\/code> exists and has correct data types\n&#8211; Workbook <code>Sales_Lab_Workbook<\/code> has 3 visuals and filters\n&#8211; A viewer user\/group can access the content with intended permissions<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Troubleshooting<\/h3>\n\n\n\n<p>Common issues and realistic fixes:<\/p>\n\n\n\n<p>1) <strong>Instance stuck in provisioning<\/strong>\n&#8211; Wait longer; provisioning can take time.\n&#8211; Check OCI service health dashboard.\n&#8211; Verify you\u2019re not blocked by limits\/quotas.<\/p>\n\n\n\n<p>2) <strong>Authorization errors in OCI Console<\/strong>\n&#8211; Validate IAM policy is attached at the correct compartment scope.\n&#8211; Ensure you\u2019re in the correct identity domain and group membership is effective.<\/p>\n\n\n\n<p>3) <strong>Can\u2019t sign in to Analytics Cloud URL<\/strong>\n&#8211; Confirm the instance is Active.\n&#8211; Ensure your user is assigned to the correct identity domain and has required roles.\n&#8211; Try an incognito browser session to avoid cached identity issues.<\/p>\n\n\n\n<p>4) <strong>Dataset import issues<\/strong>\n&#8211; Ensure CSV headers are clean (no extra spaces).\n&#8211; Ensure numeric fields are not quoted with currency symbols.\n&#8211; Normalize date format to ISO <code>YYYY-MM-DD<\/code>.<\/p>\n\n\n\n<p>5) <strong>Sharing doesn\u2019t work<\/strong>\n&#8211; Check both catalog folder and item permissions.\n&#8211; Confirm the target user has at least viewer access in Analytics Cloud roles.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Cleanup<\/h3>\n\n\n\n<p>To avoid ongoing charges, clean up in this order:<\/p>\n\n\n\n<p>1) <strong>Delete the Analytics Cloud instance<\/strong>\n&#8211; OCI Console \u2192 Analytics Cloud \u2192 select instance \u2192 <strong>Delete\/Terminate<\/strong>\n&#8211; Confirm deletion and wait for completion.<\/p>\n\n\n\n<p>2) (Optional) <strong>Remove IAM policy and group<\/strong> created for the lab, if not needed.<\/p>\n\n\n\n<p>3) (Optional) <strong>Delete the compartment<\/strong> <code>analytics-lab<\/code> if it was created only for this tutorial and is empty.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">11. Best Practices<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Architecture best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Put Analytics Cloud on top of a <strong>curated analytics store<\/strong> (warehouse\/lakehouse), not raw operational tables.<\/li>\n<li>Separate environments: dev\/test\/prod instances in separate compartments.<\/li>\n<li>Design for <strong>data freshness<\/strong> explicitly (SLA for refresh, source system limits).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">IAM \/ security best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use groups: <code>AnalyticsAdmins<\/code>, <code>AnalyticsAuthors<\/code>, <code>AnalyticsConsumers<\/code>.<\/li>\n<li>Apply <strong>least privilege<\/strong> in OCI IAM policies and in Analytics Cloud roles.<\/li>\n<li>Restrict admin access; require MFA for privileged users.<\/li>\n<li>Review permissions regularly (quarterly at minimum).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Cost best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start small; scale only when you have measured concurrency and query demand.<\/li>\n<li>Minimize the number of always-on non-production instances.<\/li>\n<li>Reduce expensive \u201cwide table\u201d queries by building aggregated tables\/views in the warehouse.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Performance best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Model for analytics: star schemas, aggregated tables, and partitioning where appropriate.<\/li>\n<li>Cache wisely (service behavior varies\u2014verify). Don\u2019t rely on caching as a substitute for modeling.<\/li>\n<li>Use database-side optimization: statistics, indexes, materialized views (if supported by your DB).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Reliability best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Define RPO\/RTO objectives and confirm Analytics Cloud backup\/restore capabilities in official docs.<\/li>\n<li>Use tested promotion practices (export\/import, versioning) between environments.<\/li>\n<li>Avoid making unreviewed changes directly in production.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Operations best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tag instances with <code>env<\/code>, <code>owner<\/code>, <code>cost_center<\/code>, <code>data_classification<\/code>.<\/li>\n<li>Monitor usage and performance indicators (where exposed).<\/li>\n<li>Document data sources, refresh schedules, and business definitions in a central place.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Governance \/ naming best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Standardize naming:<\/li>\n<li>Instances: <code>ac-dev<\/code>, <code>ac-test<\/code>, <code>ac-prod<\/code><\/li>\n<li>Catalog folders: <code>\/Shared Folders\/&lt;Domain&gt;\/&lt;Team&gt;<\/code><\/li>\n<li>Datasets: <code>&lt;Subject&gt;_&lt;Grain&gt;_&lt;Source&gt;<\/code>, e.g., <code>Sales_Daily_ADW<\/code><\/li>\n<li>Maintain a KPI dictionary with owners and definitions.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">12. Security Considerations<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Identity and access model<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>OCI IAM (Identity Domains)<\/strong> controls who can provision\/manage Analytics Cloud instances.<\/li>\n<li><strong>Analytics Cloud roles<\/strong> control who can author content, administer application settings, and consume dashboards.<\/li>\n<li><strong>Catalog permissions<\/strong> restrict access to specific dashboards and folders.<\/li>\n<\/ul>\n\n\n\n<p>Key recommendation: treat IAM + application roles + content permissions as a <strong>three-layer model<\/strong>. Misalignment is a common cause of overexposure.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Encryption<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data in transit should use TLS (standard for browser access).<\/li>\n<li>Data at rest encryption is typically managed by the cloud service, but confirm details for your region and compliance requirements in official docs.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Network exposure<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prefer private access patterns for regulated data:<\/li>\n<li>Private endpoints where supported<\/li>\n<li>Private connectivity to data sources (VCN, VPN\/FastConnect)<\/li>\n<li>If using public endpoints:<\/li>\n<li>Restrict admin access<\/li>\n<li>Use MFA<\/li>\n<li>Use IP controls if supported (verify)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Secrets handling<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Store database credentials securely.<\/li>\n<li>Prefer enterprise secret managers (OCI Vault) where integrations support it; otherwise follow Oracle-recommended credential storage methods and rotation processes (verify in docs for supported patterns).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Audit\/logging<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use <strong>OCI Audit<\/strong> for instance lifecycle and policy actions.<\/li>\n<li>For content-level auditing, review Analytics Cloud\u2019s built-in auditing options (availability varies\u2014verify) and integrate with centralized logging\/SIEM where possible.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Compliance considerations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data residency: deploy in the correct OCI region.<\/li>\n<li>Data classification: do not upload restricted datasets into Analytics Cloud unless permitted by policy.<\/li>\n<li>Follow your org\u2019s access review process, especially for HR\/finance\/PII dashboards.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Common security mistakes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Giving all users author\/admin privileges<\/li>\n<li>Storing credentials in shared documents<\/li>\n<li>Leaving public endpoints open with weak access controls<\/li>\n<li>Sharing dashboards containing row-level sensitive data without row-level security design<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Secure deployment recommendations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create separate instances for prod and non-prod.<\/li>\n<li>Enforce least privilege and MFA.<\/li>\n<li>Use private connectivity for sensitive sources.<\/li>\n<li>Apply tagging and guardrails (quotas, policies) to prevent sprawl.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">13. Limitations and Gotchas<\/h2>\n\n\n\n<p>Because Analytics Cloud is a managed service, some constraints are service-defined. Always verify current limits in official docs for your region and edition.<\/p>\n\n\n\n<p>Common limitations\/gotchas to plan for:\n&#8211; <strong>Region availability<\/strong>: Not all OCI regions necessarily support Analytics Cloud equally.\n&#8211; <strong>Service limits<\/strong>: Instance count and capacity limits per tenancy\/region.\n&#8211; <strong>Connector variability<\/strong>: Supported data sources and features can change; confirm connector support before committing.\n&#8211; <strong>Network complexity<\/strong>: Private endpoint and on-prem connectivity requires careful DNS\/routing design.\n&#8211; <strong>Identity alignment<\/strong>: Users must be in the correct identity domain; role mapping can be confusing initially.\n&#8211; <strong>Large exports<\/strong>: Exporting large datasets\/reports can be slow and may trigger governance concerns; also consider egress costs.\n&#8211; <strong>Content lifecycle<\/strong>: Without a promotion process, dashboards drift and break across environments.\n&#8211; <strong>Performance surprises<\/strong>: Poor data models (wide tables, no aggregations) can cause slow dashboards and higher capacity needs.\n&#8211; <strong>Refresh contention<\/strong>: Frequent refresh jobs can compete with interactive users for resources.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">14. Comparison with Alternatives<\/h2>\n\n\n\n<p>Analytics Cloud is a BI\/analytics platform. In Oracle Cloud and beyond, you should compare it to nearby tools based on governance needs, data platform alignment, and operating model.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Alternatives within Oracle Cloud (adjacent services)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Autonomous Data Warehouse<\/strong>: Data storage\/compute for analytics (not a BI tool).<\/li>\n<li><strong>OCI Data Integration \/ GoldenGate<\/strong>: Data ingestion\/transformation (not BI visualization).<\/li>\n<li><strong>OCI Data Science<\/strong>: Model training and ML workflows (not dashboarding).<\/li>\n<li><strong>Oracle Fusion Analytics<\/strong> (if you use Oracle Fusion apps): Packaged analytics; different scope than general-purpose BI (verify current product positioning).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Alternatives in other clouds<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Microsoft Power BI (with Fabric ecosystem)<\/li>\n<li>Tableau (Salesforce)<\/li>\n<li>Google Looker<\/li>\n<li>AWS QuickSight<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Open-source \/ self-managed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apache Superset<\/li>\n<li>Metabase<\/li>\n<li>Grafana (primarily observability\/time-series, but used for general dashboards sometimes)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Comparison table<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Option<\/th>\n<th>Best For<\/th>\n<th>Strengths<\/th>\n<th>Weaknesses<\/th>\n<th>When to Choose<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Analytics Cloud (Oracle Cloud)<\/td>\n<td>Enterprise BI on Oracle Cloud<\/td>\n<td>Managed service, governance\/semantic modeling, strong fit with Oracle data platforms<\/td>\n<td>Paid service; requires governance and modeling discipline; connector specifics must be validated<\/td>\n<td>You\u2019re on Oracle Cloud and want governed BI with managed ops<\/td>\n<\/tr>\n<tr>\n<td>Power BI<\/td>\n<td>Microsoft-centric orgs<\/td>\n<td>Broad adoption, strong desktop authoring, large community<\/td>\n<td>Governance can require extra platform components; licensing complexity<\/td>\n<td>Your org is standardized on Microsoft ecosystem<\/td>\n<\/tr>\n<tr>\n<td>Tableau<\/td>\n<td>Visual analytics at scale<\/td>\n<td>Rich visualization, strong ecosystem<\/td>\n<td>Licensing and server management (if self-hosted) can be heavy<\/td>\n<td>You already run Tableau or need its specific visual strengths<\/td>\n<\/tr>\n<tr>\n<td>Looker<\/td>\n<td>Semantic modeling with modern BI<\/td>\n<td>Strong modeling layer, good embedding<\/td>\n<td>Requires LookML expertise; Google ecosystem alignment<\/td>\n<td>You\u2019re invested in Google Cloud and want Looker\u2019s modeling\/embedding<\/td>\n<\/tr>\n<tr>\n<td>AWS QuickSight<\/td>\n<td>AWS-native lightweight BI<\/td>\n<td>Serverless, AWS integration<\/td>\n<td>Feature parity varies by use case<\/td>\n<td>You are AWS-first and need fast managed dashboards<\/td>\n<\/tr>\n<tr>\n<td>Apache Superset (self-managed)<\/td>\n<td>Cost-sensitive, engineering-led BI<\/td>\n<td>Open source, flexible<\/td>\n<td>You operate everything; governance varies; scaling and security are your job<\/td>\n<td>You can run and secure it yourself and want open-source control<\/td>\n<\/tr>\n<tr>\n<td>Metabase (self-managed or hosted)<\/td>\n<td>Simple self-service analytics<\/td>\n<td>Easy to start, friendly UI<\/td>\n<td>Advanced governance\/modeling may be limited<\/td>\n<td>Small teams needing quick dashboards<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">15. Real-World Example<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Enterprise example: Retail chain on Oracle Cloud<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem<\/strong>: A retail chain needs standardized sales, inventory, and margin reporting across hundreds of stores. Existing Excel-based reporting leads to inconsistent KPIs and delayed decisions.<\/li>\n<li><strong>Proposed architecture<\/strong>:<\/li>\n<li>Store and POS data ingested into a curated warehouse (for example, Autonomous Data Warehouse).<\/li>\n<li>Dimensional model (products, stores, calendar, promotions).<\/li>\n<li>Analytics Cloud provides:<ul>\n<li>Executive KPI dashboards<\/li>\n<li>Regional manager dashboards with drilldown<\/li>\n<li>Scheduled operational reports (capability dependent\u2014verify)<\/li>\n<\/ul>\n<\/li>\n<li>Private access from corporate network (VPN\/FastConnect), restricted IAM, and strict folder permissions.<\/li>\n<li><strong>Why Analytics Cloud was chosen<\/strong>:<\/li>\n<li>Managed BI service on Oracle Cloud<\/li>\n<li>Semantic model to standardize KPIs<\/li>\n<li>Integration alignment with Oracle database platform<\/li>\n<li><strong>Expected outcomes<\/strong>:<\/li>\n<li>Consistent metrics across business units<\/li>\n<li>Faster inventory and promotion decisions<\/li>\n<li>Reduced manual reporting effort and fewer reconciliation meetings<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Startup \/ small-team example: SaaS usage analytics<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem<\/strong>: A SaaS startup wants a single dashboard for usage, churn signals, and support load. Data comes from product events and a billing system.<\/li>\n<li><strong>Proposed architecture<\/strong>:<\/li>\n<li>A small warehouse (could be Autonomous Database) with daily aggregates.<\/li>\n<li>Analytics Cloud instance sized for a small number of authors and viewers.<\/li>\n<li>Dashboards for product and leadership; limited sharing.<\/li>\n<li><strong>Why Analytics Cloud was chosen<\/strong>:<\/li>\n<li>Managed service reduces ops burden<\/li>\n<li>Rapid dashboard iteration and self-service exploration<\/li>\n<li><strong>Expected outcomes<\/strong>:<\/li>\n<li>Product team visibility into adoption trends<\/li>\n<li>Better prioritization for retention improvements<\/li>\n<li>A repeatable weekly \u201cbusiness review\u201d dashboard<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">16. FAQ<\/h2>\n\n\n\n<p>1) <strong>Is Analytics Cloud the same as Oracle Analytics Cloud?<\/strong><br\/>\nYes. Analytics Cloud in Oracle Cloud typically refers to Oracle\u2019s managed Oracle Analytics Cloud service. Always confirm the exact SKU and edition in your tenancy.<\/p>\n\n\n\n<p>2) <strong>Do I need a data warehouse to use Analytics Cloud?<\/strong><br\/>\nNot strictly\u2014you can start by uploading files. For production and scale, a warehouse is strongly recommended for performance, governance, and reliability.<\/p>\n\n\n\n<p>3) <strong>Can Analytics Cloud connect to on-premises databases?<\/strong><br\/>\nOften yes via secure connectivity patterns (such as a gateway\/agent approach). Verify the current \u201cRemote Data Gateway\u201d (or equivalent) support matrix in official docs.<\/p>\n\n\n\n<p>4) <strong>Can I deploy Analytics Cloud privately (no public endpoint)?<\/strong><br\/>\nPrivate access patterns exist, but availability and design requirements vary. Verify private endpoint support and prerequisites for your region\/edition.<\/p>\n\n\n\n<p>5) <strong>How do I control who can see which dashboards?<\/strong><br\/>\nUse a combination of IAM\/Identity Domain groups, Analytics Cloud application roles, and catalog\/folder permissions. Test with non-admin accounts.<\/p>\n\n\n\n<p>6) <strong>How does Analytics Cloud pricing work?<\/strong><br\/>\nTypically capacity-based with license model choices (License Included vs BYOL). Use Oracle\u2019s official pricing page and the cost estimator for your region.<\/p>\n\n\n\n<p>7) <strong>Is there an Always Free tier for Analytics Cloud?<\/strong><br\/>\nOften Analytics Cloud is not Always Free, but Oracle frequently offers trials\/credits. Verify current Free Tier and trial eligibility.<\/p>\n\n\n\n<p>8) <strong>What\u2019s the difference between an author and a consumer?<\/strong><br\/>\nAuthors create datasets\/models\/workbooks; consumers primarily view and interact with published content. Exact role names differ; verify role definitions in your instance.<\/p>\n\n\n\n<p>9) <strong>Can Analytics Cloud handle row-level security (RLS)?<\/strong><br\/>\nCommonly BI platforms support data security patterns either via the semantic model or source database views. Confirm the supported approach for your modeling method.<\/p>\n\n\n\n<p>10) <strong>How do I promote content from dev to prod?<\/strong><br\/>\nUse separate instances and a controlled export\/import or deployment workflow supported by the service. Verify current recommended promotion practices in official docs.<\/p>\n\n\n\n<p>11) <strong>How do I monitor usage and performance?<\/strong><br\/>\nUse whatever service metrics and logs are available in OCI plus built-in analytics auditing\/usage views (verify availability). Also monitor the database and data pipeline.<\/p>\n\n\n\n<p>12) <strong>Can I embed dashboards into an internal portal?<\/strong><br\/>\nEmbedding is commonly supported in BI platforms, but authentication and licensing constraints matter. Verify embedding methods and supported auth flows for Analytics Cloud.<\/p>\n\n\n\n<p>13) <strong>What data sources are supported?<\/strong><br\/>\nIt depends on the current connector list and version. Always check the official documentation for the supported data sources and any gateway requirements.<\/p>\n\n\n\n<p>14) <strong>Is Analytics Cloud suitable for real-time analytics?<\/strong><br\/>\nIt can support near-real-time dashboards if your data pipeline and database are designed for it (CDC, incremental refresh, fast aggregates). The BI layer is only one part of \u201creal-time.\u201d<\/p>\n\n\n\n<p>15) <strong>What\u2019s the best first project to prove value?<\/strong><br\/>\nA focused KPI dashboard (sales, finance, support) with 1\u20132 curated datasets, clear metric definitions, and a refresh SLA is usually the best first win.<\/p>\n\n\n\n<p>16) <strong>How do I avoid dashboard sprawl?<\/strong><br\/>\nUse folder standards, approval workflows for production dashboards, and retire unused content based on usage reviews.<\/p>\n\n\n\n<p>17) <strong>What\u2019s the biggest performance mistake?<\/strong><br\/>\nLetting dashboards query raw transactional tables directly with no curated model. Fix with star schemas, aggregates, and a well-defined semantic model.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">17. Top Online Resources to Learn Analytics Cloud<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Resource Type<\/th>\n<th>Name<\/th>\n<th>Why It Is Useful<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Official Documentation<\/td>\n<td>Analytics Cloud Documentation<\/td>\n<td>Primary source for features, admin guides, and connectivity. https:\/\/docs.oracle.com\/en\/cloud\/paas\/analytics-cloud\/<\/td>\n<\/tr>\n<tr>\n<td>Official Pricing<\/td>\n<td>Analytics Cloud Pricing<\/td>\n<td>Current SKUs, editions, and billing model references. https:\/\/www.oracle.com\/cloud\/analytics\/analytics-cloud\/pricing\/<\/td>\n<\/tr>\n<tr>\n<td>Official Price List<\/td>\n<td>Oracle Cloud Price List<\/td>\n<td>Region\/SKU-based pricing reference for Oracle Cloud services. https:\/\/www.oracle.com\/cloud\/price-list\/<\/td>\n<\/tr>\n<tr>\n<td>Pricing Calculator<\/td>\n<td>Oracle Cloud Cost Estimator<\/td>\n<td>Build scenario estimates without guessing. https:\/\/www.oracle.com\/cloud\/costestimator.html<\/td>\n<\/tr>\n<tr>\n<td>Architecture Center<\/td>\n<td>Oracle Architecture Center (Solutions)<\/td>\n<td>Reference architectures and design patterns; search for analytics patterns. https:\/\/docs.oracle.com\/en\/solutions\/<\/td>\n<\/tr>\n<tr>\n<td>OCI IAM Docs<\/td>\n<td>IAM \/ Identity Domains Docs<\/td>\n<td>Required for secure access design and least privilege. https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/home.htm<\/td>\n<\/tr>\n<tr>\n<td>OCI Networking Docs<\/td>\n<td>VCN and Connectivity Docs<\/td>\n<td>Needed for private access and hybrid connectivity designs. https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Network\/Concepts\/overview.htm<\/td>\n<\/tr>\n<tr>\n<td>Tutorials (Oracle)<\/td>\n<td>Oracle Cloud Tutorials<\/td>\n<td>Hands-on labs across OCI; search for Analytics Cloud labs. https:\/\/docs.oracle.com\/en\/learn\/<\/td>\n<\/tr>\n<tr>\n<td>Videos<\/td>\n<td>Oracle YouTube Channel<\/td>\n<td>Product walkthroughs, webinars, and demos (verify relevance and version). https:\/\/www.youtube.com\/user\/oracle<\/td>\n<\/tr>\n<tr>\n<td>Community<\/td>\n<td>Oracle Cloud Community<\/td>\n<td>Practical Q&amp;A and real-world issues; validate against docs. https:\/\/community.oracle.com\/<\/td>\n<\/tr>\n<tr>\n<td>Samples (General)<\/td>\n<td>Oracle GitHub<\/td>\n<td>Look for official samples related to analytics\/BI; verify repository ownership and recency. https:\/\/github.com\/oracle<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">18. Training and Certification Providers<\/h2>\n\n\n\n<p>The following institutes are listed as training providers. Details such as exact course availability, schedules, and certification alignment should be verified on each website.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Institute<\/th>\n<th>Suitable Audience<\/th>\n<th>Likely Learning Focus<\/th>\n<th>Mode<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>DevOpsSchool.com<\/td>\n<td>Engineers, DevOps\/SRE, platform teams<\/td>\n<td>Cloud\/DevOps foundations; may include OCI operations context<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.devopsschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>ScmGalaxy.com<\/td>\n<td>DevOps learners, build\/release teams<\/td>\n<td>DevOps tooling and delivery practices<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.scmgalaxy.com\/<\/td>\n<\/tr>\n<tr>\n<td>CLoudOpsNow.in<\/td>\n<td>Cloud operations teams<\/td>\n<td>Cloud operations practices and operational readiness<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.cloudopsnow.in\/<\/td>\n<\/tr>\n<tr>\n<td>SreSchool.com<\/td>\n<td>SREs, reliability engineers<\/td>\n<td>SRE practices: monitoring, incident response, reliability<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.sreschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>AiOpsSchool.com<\/td>\n<td>Ops + AI\/automation learners<\/td>\n<td>AIOps concepts, automation, monitoring analytics<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.aiopsschool.com\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">19. Top Trainers<\/h2>\n\n\n\n<p>The following sites are provided as trainer\/platform resources. Verify specific trainer profiles, course content, and schedules directly.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Platform\/Site<\/th>\n<th>Likely Specialization<\/th>\n<th>Suitable Audience<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>RajeshKumar.xyz<\/td>\n<td>DevOps\/cloud training content (verify offerings)<\/td>\n<td>Beginners to intermediate engineers<\/td>\n<td>https:\/\/rajeshkumar.xyz\/<\/td>\n<\/tr>\n<tr>\n<td>devopstrainer.in<\/td>\n<td>DevOps training (tools and practices)<\/td>\n<td>DevOps engineers and learners<\/td>\n<td>https:\/\/www.devopstrainer.in\/<\/td>\n<\/tr>\n<tr>\n<td>devopsfreelancer.com<\/td>\n<td>Freelance DevOps services\/training (verify)<\/td>\n<td>Teams needing short-term help<\/td>\n<td>https:\/\/www.devopsfreelancer.com\/<\/td>\n<\/tr>\n<tr>\n<td>devopssupport.in<\/td>\n<td>DevOps support\/training (verify)<\/td>\n<td>Ops\/DevOps teams<\/td>\n<td>https:\/\/www.devopssupport.in\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">20. Top Consulting Companies<\/h2>\n\n\n\n<p>The following companies are listed as consulting resources. Verify specific Oracle Cloud and Analytics Cloud capabilities, references, and engagement models directly with the providers.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Company<\/th>\n<th>Likely Service Area<\/th>\n<th>Where They May Help<\/th>\n<th>Consulting Use Case Examples<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>cotocus.com<\/td>\n<td>Cloud\/DevOps consulting (verify exact offerings)<\/td>\n<td>Cloud migration, platform engineering<\/td>\n<td>Set up OCI landing zone, IAM baseline, environment separation<\/td>\n<td>https:\/\/cotocus.com\/<\/td>\n<\/tr>\n<tr>\n<td>DevOpsSchool.com<\/td>\n<td>Training + consulting (verify scope)<\/td>\n<td>DevOps enablement, cloud operations<\/td>\n<td>Operating model, CI\/CD guardrails, runbooks for analytics platform ops<\/td>\n<td>https:\/\/www.devopsschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>DEVOPSCONSULTING.IN<\/td>\n<td>DevOps consulting (verify exact offerings)<\/td>\n<td>Automation and operations<\/td>\n<td>Infrastructure automation for OCI, monitoring and incident workflows<\/td>\n<td>https:\/\/devopsconsulting.in\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">21. Career and Learning Roadmap<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">What to learn before Analytics Cloud<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Cloud fundamentals: compartments, IAM, networking, regions<\/li>\n<li>Data fundamentals: SQL, joins, aggregations, star schema basics<\/li>\n<li>Basic security: least privilege, MFA, audit concepts<\/li>\n<li>BI fundamentals: dimensions\/measures, filters, drilldowns, KPI definition<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">What to learn after Analytics Cloud<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data warehousing on Oracle Cloud (Autonomous Database patterns)<\/li>\n<li>Data integration and orchestration (ETL\/ELT, CDC concepts)<\/li>\n<li>Semantic modeling best practices and governance workflows<\/li>\n<li>Observability and incident management for analytics platforms<\/li>\n<li>FinOps: capacity planning, cost governance, showback\/chargeback<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Job roles that use Analytics Cloud<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BI Developer \/ Analytics Engineer<\/li>\n<li>Data Analyst (power user)<\/li>\n<li>Data Engineer (curation + performance enablement)<\/li>\n<li>Cloud Solutions Architect (analytics reference architectures)<\/li>\n<li>Platform Engineer \/ SRE (ops, IAM, network posture)<\/li>\n<li>Security Engineer (access governance and audit)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Certification path (if available)<\/h3>\n\n\n\n<p>Oracle\u2019s certification catalog changes. Verify current OCI and analytics certifications on Oracle University:\n&#8211; https:\/\/education.oracle.com\/<\/p>\n\n\n\n<p>A practical sequence often looks like:\n1. OCI foundations\n2. OCI architect associate\/professional (role-dependent)\n3. Analytics-focused training for Analytics Cloud and the underlying data platform<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Project ideas for practice<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Build a governed KPI layer for a sales dataset with documented definitions<\/li>\n<li>Implement a dev\/test\/prod promotion process for dashboards<\/li>\n<li>Create a \u201cdata freshness\u201d dashboard and operational SLA<\/li>\n<li>Design a private networking architecture for Analytics Cloud + warehouse<\/li>\n<li>Cost optimization exercise: measure concurrency and right-size capacity<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">22. Glossary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analytics Cloud<\/strong>: Oracle Cloud managed service for BI, dashboards, and analytics content.<\/li>\n<li><strong>Compartment (OCI)<\/strong>: A logical container for organizing and isolating cloud resources for access control and billing.<\/li>\n<li><strong>Identity Domain<\/strong>: OCI\u2019s identity boundary for users, groups, and authentication policies.<\/li>\n<li><strong>IAM Policy<\/strong>: Rules that grant groups\/users permissions to manage or use OCI resources.<\/li>\n<li><strong>Dataset<\/strong>: A curated collection of data used to build visualizations and dashboards.<\/li>\n<li><strong>Semantic Model<\/strong>: A governed layer translating raw data into business-friendly measures and dimensions.<\/li>\n<li><strong>KPI<\/strong>: Key Performance Indicator; a defined metric used to measure business performance.<\/li>\n<li><strong>VCN<\/strong>: Virtual Cloud Network; OCI\u2019s software-defined network in a region.<\/li>\n<li><strong>Private Endpoint<\/strong>: A private network interface to access a service without using a public internet endpoint (availability varies\u2014verify).<\/li>\n<li><strong>RPO\/RTO<\/strong>: Recovery Point Objective \/ Recovery Time Objective; disaster recovery targets.<\/li>\n<li><strong>Egress<\/strong>: Network traffic leaving a cloud boundary; may incur costs depending on destination.<\/li>\n<li><strong>Least Privilege<\/strong>: Granting only the minimum permissions needed to perform a task.<\/li>\n<li><strong>Dev\/Test\/Prod<\/strong>: Separate environments for development, testing, and production operations.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">23. Summary<\/h2>\n\n\n\n<p>Analytics Cloud in Oracle Cloud (Analytics and AI category) is a managed BI and analytics service for building governed dashboards, self-service visualizations, and shareable insights. It fits best as the top-layer analytics experience over curated data platforms (often an Oracle warehouse) and integrates with Oracle Cloud IAM for secure access control.<\/p>\n\n\n\n<p>Cost is primarily driven by allocated capacity, environment count, and upstream data platform and connectivity choices. Security posture depends on strong IAM, careful role design, controlled sharing, and (when required) private networking patterns.<\/p>\n\n\n\n<p>Use Analytics Cloud when you need a managed, enterprise-ready BI platform aligned with Oracle Cloud. Start with the hands-on lab: provision an instance, upload a dataset, build a workbook, and enforce basic sharing controls\u2014then expand toward a warehouse-backed, governed production architecture using official Oracle reference guidance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Analytics and AI<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66,62],"tags":[],"class_list":["post-832","post","type-post","status-publish","format-standard","hentry","category-analytics-and-ai","category-oracle-cloud"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/comments?post=832"}],"version-history":[{"count":0,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/832\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/media?parent=832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/categories?post=832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/tags?post=832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}