Reference: Query and Analyze#
Technical reference documentation for querying and analyzing EDU data.
Data Concepts#
- Dimensional Models - Understanding dimensional modeling
- SQL - SQL basics and concepts
- Understanding dim_student - Deep dive into the student dimension
Schema#
- Schema - Complete schema reference
- Analytics Database (
prod_wh,prod_seed,prod_stage,prod_qc,prod_dbt_test__audit) - Raw Database (
edfi3) - Development schemas (
rc_*,dev_*)
Connecting#
- Basic Access - Getting started with data warehouse access
- Connect with a BI Tool - Connect Tableau, Power BI, etc.
- Connect with R - R connection guide
Querying#
- Data domains and key tables - Domains of data in the warehouse and which tables to use (attendance, assessment, enrollment, etc.)
- Assessment Query Guide - Patterns for querying assessment data
- Demographics Query Guide - Patterns for querying demographics data
Advanced#
- Using the Sandbox - Work with sandbox environments
See also: Getting Started for Users for guided learning materials.