✏️ Explanatory Question

Real-World Scenario: A Customer Dashboard Must Display Total Orders, Total Revenue, and Last Purchase Date. How Would You Design It?

👁 3 Views
📘 Detailed Answer
🟢 Easy
← Previous Real-World Scenario: Sales Managers Must See All Team Opportunities, But Sales Representatives Should Only See Their Own. How Would You Design Security?
💡

Answer with Explanation

I would use:

  • Rollup Columns for Total Orders
  • Rollup Columns for Total Revenue
  • Calculated or Rollup Column for Last Purchase Date
  • Model-driven App Forms and Dashboards for visualization

Benefits:

  • Minimal custom code
  • Centralized calculations
  • Easy reporting
  • Better maintainability

Architect Insight:

For extremely large datasets, calculations may be offloaded to Power BI or Azure services instead of relying solely on Rollup Columns.

← Previous Real-World Scenario: Sales Managers Must See All Team Opportunities, But Sales Representatives Should Only See Their Own. How Would You Design Security?