SQL
This SQL command retrieves data from a table
What is SELECT?
This chart type is best for showing trends over time.
What is a line chart?
This statistic represents the average value of a dataset.
What is the mean?
This branch of AI focuses on training computers to learn from data without being explicitly programmed.
What is machine learning?
The name of the ERP system prior to Munis.
What is AS400?
This clause filters rows in a SQL query.
What is WHERE?
This visualization is commonly used to compare categories.
What is a bar chart?
This measure represents the middle value in an ordered dataset.
What is the median?
This type of AI model is trained to understand and generate human language.
What is a large language model (LLM)?
The All-In Initiative that is focused on redeveloping our community.
What is "Fostering Sensitive Redevelopment"?
This SQL operation combines rows from two tables based on a related column.
What is a JOIN?
This chart shows parts of a whole but is often criticized for readability.
What is a pie chart?
This term describes how spread out data points are.
What is variance?
This company created ChatGPT.
What is OpenAI?
The name of the program that came before Performance Measures and featured 30 of the City's top metrics.
What is Goal Measures?
This SQL function counts the number of rows returned.
What is COUNT()?
This visualization displays relationships between two numeric variables.
What is a scatter plot?
This statistical test compares means between groups.
What is a t-test?
This AI technique allows computers to identify objects, faces, and text in images.
What is computer vision?
The City Manager prior to Mike Goodrum.
Who is Allen Bogard?
This type of JOIN returns all rows from the left table and matching rows from the right.
What is a LEFT JOIN?
This dashboard tool is made by Salesforce and widely used in analytics.
What is Tableau?
This famous theorem describes the distribution of sample means approaching normality.
What is the Central Limit Theorem?
This term describes AI-generated content that appears realistic but is fake, often using manipulated video or audio.
What is a deepfake?
The City of Sugar Land's Office that was in charge of departmental assessments in 2018.
What is the Office of Performance and Accountability?