Salesforce ArchitectureArchitect (Hardest)analyticscrm-analyticsdata-cloud
Design analytics architecture across CRM Analytics and Data Cloud
Real World Scenario
Executives receive conflicting revenue numbers from CRM reports CRM Analytics and Snowflake dashboards.
Expected Answer
• Single metric definition catalog owned by finance and data governance
• CRM Analytics for Salesforce-native operational analytics near real-time
• Data Cloud plus warehouse for enterprise cross-system metrics
• One authoritative source per metric published to all consumers
• Data lineage documentation preventing duplicate ETL logic
• Self-service guardrails: certified datasets vs sandbox datasets
• Refresh SLAs documented per dashboard tier
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. Single metric definition catalog owned by finance and data governance. CRM Analytics for Salesforce-native operational analytics near real-time. Pick based on your integration pattern and team capability. Analytics architecture failure is metric definition chaos—govern definitions before buying more BI tools. Document the decision in an ADR and align with enterprise standards.
Architect Perspective
Analytics architecture failure is metric definition chaos—govern definitions before buying more BI tools.