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.
- Introduction to MAQL and Metrics
- The project data model
- Basic Aggregation and Counts
- Using date macros
- Locking aggregation with BY clauses
- Period-over-period reporting
- NULL reporting
- CASE Statements
- Workarounds and best practices