Page 6 - Unanet AE: Creating Analytic Models Using Query Builder

LESSON 1: QUERY BUILDER OVERVIEW

Learning Objectives

Explain the query data process.

• Describe a query developer’s responsibilities.
• Recall necessary permissions for building queries.
• Identify the data sources for building queries in Unanet A/E.

Overview

Querying data with an analytic dashboard provides a powerful means to extract
actionable information from complex datasets, empowering users to unlock the full
potential of their data resources.

Query Designer Roles and Responsibilities

A query designer for an analytic dashboard is an individual responsible for designing,
building, and optimizing the queries that retrieve and process data for the dashboard's
visualizations. This person typically has expertise in data querying, data modeling, and
understanding the underlying data sources.

The role of a query designer for an analytic dashboard may involve the following
responsibilities:

• Data Analysis and Requirements Gathering: The query designer works
closely with stakeholders, such as business analysts or dashboard users, to
understand their data requirements. They analyze the desired metrics, KPIs, and
dimensions that need to be visualized and make informed decisions on how to
structure and retrieve the relevant data.
• Query Design and Development: The query designer translates the data
requirements into actionable queries. They use query design tools or
programming languages, such as SQL (Structured Query Language) or
specialized query builders, to construct queries that retrieve the necessary data
from the underlying data sources. They optimize the queries for performance and
efficiency, considering factors such as data volume, complexity, and response
time requirements.
• Data Transformation and Modeling: The query designer may be involved in
data transformation tasks, such as aggregating, filtering, joining, or creating

Lesson 1: Query Builder Overview ©2023 Unanet. All rights reserved. 6