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 takes a "code by example" approach to explaining Multi-Dimension Analytical Query Language (MAQL) used in GoodData. This course is designed for business analysts and administrators who will be primarily responsible for maintaining the GoodData project and creating essential reports. This course builds on the information presented in the Front End Essentials training course. After the instructor-led (video) portion of the course, attendees will be able to complete a series of exercises, which provide hands-on practice of the concepts presented in a guided, structured environment.

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