Logan's Analytics Bootcamp

Glossary

ACAT
Acquisition Category (program size/oversight level)
Anti join
Join that returns rows in one table with no match in the other
CUI
Controlled Unclassified Information
DAX
Data Analysis Expressions, the formula language of Power BI / Power Pivot
Dimension table
Descriptive table used to filter and group (Program, Date)
DLP policy
Data loss prevention rules that limit which connectors can be combined in flows
Fact table
Table of events and measurements (EVM by period, obligations)
Filter context
The set of filters active when a DAX measure is evaluated
Grain
The level of detail a single fact row represents
IMS
Integrated Master Schedule
IPMDAR
Integrated Program Management Data and Analysis Report (DoD EVM reporting)
M
The Power Query formula language
PBIP
Power BI Project format (text-based, version-control friendly)
PoP
Period of Performance (contract)
Query folding
Power Query pushing transformations back to the source system
RLS
Row-level security
Semantic model
Power BI data model (tables, relationships, measures), formerly "dataset"
Spill
Dynamic array formula output filling neighboring cells
Star schema
Model design with fact tables surrounded by dimension tables
WBS
Work Breakdown Structure