Module 1: Fundamentals

Fundamentals of Analytics Engineering

What is Analytics Engineering?

It sits at the intersection of data engineering and data analysis. You bring software engineering best practices to data transformation.

K-12 Data Challenges

Schools are complex organizations. You deal with:

• Changing Schemas: deeply nested JSON from assessments.
• Semantic Definitions: What counts as "Present"?

Hands-on: First Query

SELECT 
    student_id,
    AVG(score) as gpa
FROM 
    raw.sis_grades
GROUP BY 
    1