Power Query, Power Pivot, and Generative AI Review

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/24

flashcard set

Earn XP

Description and Tags

Vocabulary flashcards covering core concepts of Power Query, ETL processes, dataset design, Power Pivot data modeling, and generative artificial intelligence tools.

25 Terms

1
New cards

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.

2
New cards

Query

A process in Power Query used to get and shape data so that it can be used for reporting, visuals, and analysis.

3
New cards

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.

4
New cards

Transform (ETL)

The second step in ETL, which involves cleaning, organizing, and modifying data (e.g., fixing capitalization, combining columns, or calculating values).

5
New cards

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.

6
New cards

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.

7
New cards

Data Types

Specifications that define what kind of data a value is and tell Power Query how to manage and process that data.

8
New cards

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.

9
New cards

M Code

The formula and transformation language written automatically behind the scenes in Power Query as users perform point-and-click actions.

10
New cards

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.

11
New cards

DAX (Data Analysis Expressions)

The formula language used in Power Pivot to create calculations, calculated columns, and data models.

12
New cards

Fact Table

A table (customarily prefixed with a lowercase "f") that contains numerical records, transaction data, dates, and frequently repeated values.

13
New cards

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.

14
New cards

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.

15
New cards

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.

16
New cards

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.

17
New cards

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.

18
New cards

Supervised Learning

A form of traditional machine learning that uses labeled, pre-categorized data to train algorithms to classify data or predict outcomes.

19
New cards

Unsupervised Learning

A form of traditional machine learning that evaluates unlabeled data to detect hidden patterns, groupings, or clusters without human intervention.

20
New cards

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).

21
New cards

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.

22
New cards

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.

23
New cards

Gemini

An AI chatbot developed by Google (formerly known as Bard) designed to understand and generate text.

24
New cards

Claude

An AI assistant developed by Anthropic designed for writing, data analysis, coding, math, and general task assistance.

25
New cards

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.