Page 3 - Unanet AE: Creating Analytic Models Using Query Builder
P. 3
Add Tables ............................................................................................................. 18
Join Tables ............................................................................................................. 19
Edit Column Settings .............................................................................................. 20
Filter Data .............................................................................................................. 22
Edit Query Parameters ........................................................................................... 22
Customize SQL Query ........................................................................................... 22
Preview Data .......................................................................................................... 22
Activity 3.1 – Build a Query .................................................................................... 23
Check Your Understanding ..................................................................... 26
APPENDIX A: Check Your Understanding Answer Key ....................... 27
Lesson 1: Query Builder Overview ........................................................................ 27
Lesson 2: Building Queries in the Query Builder Applet ..................................... 28
Lesson 3: Building Queries in the Analytic Dashboard Designer ....................... 29
COMPLETION CERTIFICATE AND EVALUATION ................................. 30
Table of Contents ©2024 Unanet. All rights reserved. 3