MAQL Metrics


To purchase this content please click "Purchase" below. If you are purchasing for someone else please check "This is for someone else".

The content is priced at $ 600.00 USD per participant


The MAQL Metrics training course builds on the information presented in the Front End Essentials training course, and is delivered as a GoodData workspace containing lecture/demonstration videos along with self-paced exercises. A "code by example" approach is used for explaining the Multi-Dimensional Analytical Query Language (MAQL) used in the GoodData Application. This course is designed for business analysts and administrators who will be primarily responsible for maintaining the GoodData workspaces (projects) and creating essential reports. Participants will be able to complete a series of exercises, which provide hands-on practice of the concepts presented in a guided, structured environment.

Expected Duration: 3 hours (self-paced)

After enrolling in this e-learning course, please check your email for your invitation into the training workspace, which includes video presentations and exercises. Please allow up to 24 hours for the invitation to arrive.


This course covers GoodData's MAQL language used for defining how to aggregate raw data to produce a given project's metrics. Topics covered in this course include:

  • Introduction to MAQL and Metrics
  • The project data model
  • Basic Aggregation and Counts
  • Filtering
  • Using date macros
  • Locking aggregation with BY clauses
  • Period-over-period reporting
  • NULL reporting
  • CASE Statements
  • Workarounds and best practices