Holistics AQL learning Course map

Reference / AQLearn

AQLearn Course Map

Local map of the AQLearn practice spine from play.amql.org.

Use original AQLearn for runnable exercises. Use this workspace for compact review lessons, retrieval practice, and debugging/presales framing.

Chapter 1: Getting Started AQL Novice

  1. Welcome
  2. Function: Aggregate Functions
  3. Dimensions & Measures
  4. Function: date_trunc
  5. Filters
  6. Relationships
  7. Practice (1)

Chapter 2: Metric Expressions AQL Practitioner Lvl 1

  1. Metric Expressions
  2. Pipe (1)
  3. Table vs Scalar Outputs
  4. Function: select & group (1)
  5. Pipe (2)
  6. Function: select & group (2)
  7. Nested Aggregations (1)
  8. Nested Aggregations (2)
  9. Metric vs Explore (1)
  10. Metric vs Explore (2)
  11. Function: filter
  12. Nested Aggregations (3)
  13. Reading & Writing Metrics
  14. Practice (2)

Chapter 3: Using AQL in Holistics AQL Practitioner Lvl 2

  1. Explore UI
  2. Writing AQL in Holistics

Chapter 4: More of Metric Expressions AQL Practitioner Lvl 3

  1. Source Table
  2. Shorthand Aggregate Functions
  3. Logical Functions
  4. where() vs filter() vs explore filters

Chapter 5: Level of Detail (LoD) AQL Expert Lvl 1

  1. Level of Detail
  2. Function: of_all
  3. Function: keep_grains
  4. Function: dimensionalize
  5. Practice (3)

Chapter 6: Advanced Analytical Use Cases AQL Expert Lvl 2

Listed in AQLearn but not populated yet. Planned topics: pivot calculations, time-based analytics, window functions.