Skip to main content

Data Model

This section explains the Advanced Analytics data model used to turn Cloudaware activity, module signals, and CMDB context into reusable CRM Analytics datasets.

Storage Architecture​

Data powering Advanced Analytics lives in three main layers:

  • Salesforce objects – Cloudaware persists normalized events, metrics, and reference attributes as Salesforce records alongside CMDB data.
  • CRM Analytics datasets – curated datasets in Salesforce CRM Analytics (Tableau CRM) back most dashboards, lenses, and KPI tiles.
  • External warehouse/BI exports – optional exports (for example, to Snowflake or BigQuery) mirror the same schema for customers that prefer to analyze data outside Salesforce.

The logical schema is kept consistent across these layers so that filters and KPIs behave the same way whether you are using built‑in dashboards or external BI tools.

Subject Areas​

Advanced Analytics currently covers the following subject areas:

  • Product usage & engagement – user sessions, logins, dashboard views, feature usage, API calls.
  • Module adoption – which Cloudaware modules (for example, Compliance Engine, Cost Management, Unified Monitoring) are enabled and actively used.
  • Operational health – detection and recovery times, coverage KPIs, and policy run outcomes sourced from other modules.
  • Data quality & ingestion – event volume, freshness, and error rates for key data feeds.

Additional subject areas can be added by ingesting new event types or metrics; see Ingestion and Integrations.

Relationship to CMDB​

Most dimensions used in Advanced Analytics are derived from CMDB objects:

  • Cloud scope (account/subscription, project, region/zone).
  • Business context (application, service, environment, business unit).
  • Ownership (team, owner, manager).
  • Risk/cost posture (criticality, tier, cost center).

For details on CMDB attributes, see CMDB Attributes.

Reading Path​

Use these guides to understand how raw events become metrics, how dimensions support filtering and segmentation, and how the model stays consistent across dashboards, KPIs, and exports.

Events​

Advanced Analytics captures atomic actions and system occurrences such as logins, dashboard views, policy evaluations, job runs, and export events. Use this guide when you need to understand source event types, event fields, normalization, and enrichment.

Metrics​

Review the pre-aggregated measures derived from events and CMDB data, including adoption, operational, cost, and coverage metrics. Use this guide when defining KPIs, choosing aggregation windows, or planning dashboard-ready datasets.

Attributes/Dimensions​

Understand the identifiers, business context, analytics context, time fields, and RBAC dimensions used to slice and filter analytics. Use this guide when you need consistent segmentation by account, application, environment, owner, team, module, or feature.

Dashboards & Reporting​

Use the dashboard and reporting guides to see how events, metrics, and attributes are applied in KPI catalogs, dashboards, query patterns, and exports.