OLAP Query Cube
Galaxy Schema — multi-fact architecture with conformed dimensions and cross-model drill-across.
Fact Models
ProvidersKOL ProfilesClinical TrialsPrescriber StatsQuality MeasuresOrganizationsNIH Records
Conformed Dimensions
StateSpecialtyPerformance YearPublication / Performance YearMeSH Topic
Drill-Across Paths
3 models via specialty3 models via state2 models via performance_year3 models via pub_year2 models via mesh_topic
Group By
Measure
Filters
Select a model, group-by, and measure — then Run Query