MAQL Metrics

Purchase

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



By submitting this form you are confirming that you have read and agree to our privacy policy.

Summary

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.

Description

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