Page 2 - Unanet AE: Creating Analytic Models Using Query Builder
P. 2
TABLE OF CONTENTS
Table of Contents ....................................................................................... 2
ABOUT THIS PARTICIPANT GUIDE .......................................................... 4
Symbols used in this guide ...................................................................................... 4
Unanet Contact Information ..................................................................................... 4
Support Portal ............................................................................................................ 4
COURSE INTRODUCTION ......................................................................... 5
Learning Objectives .................................................................................................. 5
Lesson 1: Query Builder Overview ........................................................... 6
Learning Objectives .................................................................................................. 6
Overview ..................................................................................................................... 6
Query Designer Roles and Responsibilities ............................................................. 6
Query Writer Roles and Responsibilities .................................................................. 7
Configuration and Permissions ................................................................................ 8
Data Sources .............................................................................................................. 8
Analytic Models (Dashboard Query Manager Applet) .............................................. 8
Check Your Understanding ...................................................................................... 9
Lesson 2: Building Queries In The Query Builder Applet .................... 10
Learning Objectives ................................................................................................ 10
Purpose and Benefits .............................................................................................. 10
Datasets and Fields ................................................................................................. 10
Overview of Query Builder Components ............................................................... 11
SQL Statements ....................................................................................................... 11
Activity 2.1 – Build and Save a Query .................................................................... 12
Manage and Edit a Dashboard Query .................................................................... 14
Activity 2.2 – Manage the Analytic Model ............................................................... 14
Activity 2.3 – Edit the Query ................................................................................... 15
Check Your Understanding .................................................................................... 16
LESSON 3: Building Queries In the Analytic Dashboard Designer ..... 17
Learning Objectives ................................................................................................ 17
Purpose and Benefits .............................................................................................. 17
Functionality ............................................................................................................ 18
Table of Contents ©2024 Unanet. All rights reserved. 2