Getting Started with MAQL

Getting Started with MAQL

Learn the language GoodData uses to query data.

About this course

This course is the first in a series of courses about GoodData's query language: MAQL (Multidimensional Analytical Query Language). MAQL is used to define calculation logic for different measures (historically called metrics). You can then use these measures in Analytical Designer to create insights which can be organized into logical groupings on the KPI dashboards.

Even when you are using the drag-and-drop interface of GoodData's Analytical Designer to create simple measures, the platform is generating MAQL statements in the background for you.

Understanding MAQL will allow you to create more complex measures that go beyond what the drag-and-drop interface of Analytical Designer allows you to do.

Prerequisites

Before starting this course, make sure you are familiar with:

You can use the above linked resources to learn more about the listed topics.

Curriculum80 minutes

  • Intro
  • How this course works
  • Basic terminology: MAQL, measure, metric
  • Understanding the data you work with
  • Quiz
  • Basic aggregations
  • How much money was spent on marketing? (SUM)
  • What if you want to see average instead, or min, or max?
  • Quiz
  • Introduction to slicing and dicing
  • Breaking down Total Spend by Campaign Category
  • Quiz
  • Nesting measures and filtering
  • Building an Order Amount measure: multiplying facts
  • Building an Order Revenue measure: basic filtering
  • Building an Order Revenue measure: nesting measures
  • Quiz
  • Counts
  • How many customers do you have?
  • How many customers order which product?
  • Quiz
  • Summary
  • Summary & next steps
  • Provide Feedback

About this course

This course is the first in a series of courses about GoodData's query language: MAQL (Multidimensional Analytical Query Language). MAQL is used to define calculation logic for different measures (historically called metrics). You can then use these measures in Analytical Designer to create insights which can be organized into logical groupings on the KPI dashboards.

Even when you are using the drag-and-drop interface of GoodData's Analytical Designer to create simple measures, the platform is generating MAQL statements in the background for you.

Understanding MAQL will allow you to create more complex measures that go beyond what the drag-and-drop interface of Analytical Designer allows you to do.

Prerequisites

Before starting this course, make sure you are familiar with:

You can use the above linked resources to learn more about the listed topics.

Curriculum80 minutes

  • Intro
  • How this course works
  • Basic terminology: MAQL, measure, metric
  • Understanding the data you work with
  • Quiz
  • Basic aggregations
  • How much money was spent on marketing? (SUM)
  • What if you want to see average instead, or min, or max?
  • Quiz
  • Introduction to slicing and dicing
  • Breaking down Total Spend by Campaign Category
  • Quiz
  • Nesting measures and filtering
  • Building an Order Amount measure: multiplying facts
  • Building an Order Revenue measure: basic filtering
  • Building an Order Revenue measure: nesting measures
  • Quiz
  • Counts
  • How many customers do you have?
  • How many customers order which product?
  • Quiz
  • Summary
  • Summary & next steps
  • Provide Feedback