1/24
Vocabulary flashcards covering core concepts of Power Query, ETL processes, dataset design, Power Pivot data modeling, and generative artificial intelligence tools.
Power Query
A data transformation and preparation tool built into Microsoft Excel and Power BI that uses a point-and-click interface to extract, clean, organize, and transform data.
Query
A process in Power Query used to get and shape data so that it can be used for reporting, visuals, and analysis.
Extract (ETL)
The first step in ETL, defined as getting data from an external source such as Excel spreadsheets, databases, PDFs, XML files, or websites.
Transform (ETL)
The second step in ETL, which involves cleaning, organizing, and modifying data (e.g., fixing capitalization, combining columns, or calculating values).
Load (ETL)
The final step in ETL, defined as placing the finished, transformed data into a destination such as an Excel worksheet, PivotTable, or Power BI.
Proper Dataset
A dataset structured with one header row, one record per row, no blank rows or columns, one data type per column, valid dates in date columns, and no subtotals.
Data Types
Specifications that define what kind of data a value is and tell Power Query how to manage and process that data.
Data Formatting
Settings that control the visual appearance of a value in Excel (such as showing a number as 10%, 10.0%, or 0.10) without changing its underlying data type.
M Code
The formula and transformation language written automatically behind the scenes in Power Query as users perform point-and-click actions.
Power Pivot
An Excel tool used for advanced data analysis and complex data modeling that connects multiple tables, works with millions of records, and utilizes DAX.
DAX (Data Analysis Expressions)
The formula language used in Power Pivot to create calculations, calculated columns, and data models.
Fact Table
A table (customarily prefixed with a lowercase "f") that contains numerical records, transaction data, dates, and frequently repeated values.
Dimension Table
A lookup table (customarily prefixed with a lowercase "d") that contains descriptive information about data and has at least one column with unique values.
Primary Key
A column in a dimension table containing strictly unique values (no duplicates) that uniquely identifies each record and connects to a fact table.
Foreign Key
A column in a fact table that contains matching identifiers connecting to a dimension table's primary key; it can contain repeated values.
Generative AI
A type of artificial intelligence that generates original content (such as text, images, or videos) from user prompts rather than merely making predictions from existing data.
Large Language Model (LLM)
An AI model trained on massive amounts of data that enables tools to understand natural language prompts and generate human-like text.
Supervised Learning
A form of traditional machine learning that uses labeled, pre-categorized data to train algorithms to classify data or predict outcomes.
Unsupervised Learning
A form of traditional machine learning that evaluates unlabeled data to detect hidden patterns, groupings, or clusters without human intervention.
Markov Models (Markov Chains)
A predictive model introduced in 1906 by Andrey Markov that calculates the likelihood of the next word or phrase based on the preceding word(s).
ChatGPT
A generative AI chatbot developed by OpenAI and released in November 2022 that uses GPT (Generative Pre-trained Transformer) technology for conversation, writing, and analysis.
Microsoft Copilot
Microsoft's generative AI assistant, released in 2023 and built on OpenAI's GPT technology, designed to assist with productivity and creativity across Microsoft applications.
Gemini
An AI chatbot developed by Google (formerly known as Bard) designed to understand and generate text.
Claude
An AI assistant developed by Anthropic designed for writing, data analysis, coding, math, and general task assistance.
DALL-E 3
An OpenAI-developed AI tool that generates images from text prompts; its name blends artist Salvador Dalí with Pixar's WALL-E.