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
   1   2   3   4   5   6   7