New highlights added 2024-01-22
November 14, 2023 (View Highlight)
- 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)