🏠 Overview › 🧩 Components ›🧩 Analytics Store

Analytics Store

Component Detail

Data Layer medium complexity backend
0
Dependencies
1
Dependents
19
Entities
0
Integrations

Description

Data access layer that encapsulates PostgreSQL queries for KPI aggregation, using indexed columns on activities.created_at, activity_approvals.status, and expenses.status for performant metric computation. Provides organization-scoped read operations across multiple tables to supply the aggregation service with raw metric data.

Feature: Dashboard KPIs

analytics-store

Responsibilities

  • Execute optimized SQL aggregate queries across activities, approvals, expenses, and user tables
  • Maintain proper database indexes for KPI query performance
  • Provide organization-scoped data access methods for each metric category
  • Support date-range filtering for time-based KPI calculations

Interfaces

queryActivePeerMentors(organizationId, scope?)
queryActivityCounts(organizationId, dateRange)
queryPendingApprovals(organizationId)
queryExpenseTotals(organizationId, dateRange)
queryReimbursementSummary(organizationId)
queryBufdirProgress(organizationId)
queryActivityTrend(organizationId, period, granularity)

Relationships

Dependents (1)

Components that depend on this component

service KPI Aggregation Service

Related Data Entities (19)

Data entities managed by this component

Accounting Export 24 fields core Activity 26 fields core Activity Approval 19 fields core Bufdir Report 21 fields core Event Registration 13 fields core Expense 23 fields core Expense Approval 13 fields core Local Association 13 fields core Organization 17 fields core Reimbursement 17 fields core User Role Assignment 11 fields core Activities 24 fields core Activity Approvals 14 fields core Bufdir Reports 25 fields core Event Registrations 14 fields core Expense Approvals 13 fields core Expenses 31 fields core Organizations 25 fields core Reimbursements 21 fields core