New highlights added 2024-01-22

November 14, 2023 (View Highlight)

  1. they also often disregard questions that are crucial for operational and strategic planning in an enterprise, including questions related to business reporting, metrics, and key performance indicators (KPIs), and 3. a critical missing link is the absence of a business context layer – metadata, mappings, transformations, ontologies, that provides business semantics and knowledge about the enterprise. (View Highlight)

Low question complexity: Pertains to business reporting use cases, aimed at facilitating daily business operations. From a technical standpoint, these questions are translated into SELECT-FROM SQL queries. • High question complexity: Arises in the context of Metrics and Key Performance Indicators (KPIs) within an organization. These questions are posed to make informed strategic decisions crucial for organizational success. From a technical standpoint, these questions are translated to SQL queries involving aggregations and mathematical functions. (View Highlight)

• Low schema complexity: Small number of tables (i.e. 0 - 4), denormalized schema • High schema complexity: Larger number of tables (> 4), normalized schema, many-to many join tables, etc. (View Highlight)

Figure 1: P&C Conceptual Model (View Highlight)

Figure 2: Four quadrants to classify questions: (1) Low Question/Low Schema Complexity, (2) High Question/Low Schema Complexity, (3) Low Question/High Schema Complexity, and (4) High Question/High Schema Complexity (View Highlight)

Low Question/High Schema High Question/High Schema (View Highlight)

Table 1: Average Overall Execution Accuracy (AOEA) of Overall and Quadrant Results (View Highlight)