Data Modeling and Relationships Flashcards
Microsoft Power BI Data Analyst Flashcards
| Front | Back |
| How does context affect DAX calculations | Filters and relationships in your data model determine which data is included in DAX calculations |
| How does DAX improve data analysis | By allowing complex calculations, aggregations, and custom measures to be created |
| What are the four main types of relationships in data modeling | One-to-One, One-to-Many, Many-to-One, Many-to-Many |
| What does "Many-to-Many" relationships allow | Data in both tables to relate to multiple rows in the other table |
| What does cardinality in relationships specify | The number of elements in one table that relate to elements in another table |
| What does the CALCULATE function in DAX achieve | Modifies filter context for calculations |
| What does the DISTINCT function in DAX return | A unique list of values from a column or table |
| What does the RELATED function in DAX do | Retrieves a value from a related table based on the model relationships |
| What does the term "referential integrity" mean | Ensuring that relationships between tables remain consistent |
| What is a calculated column in DAX | A column with values computed using a formula for each row in a table |
| What is a data model | A structured framework for organizing and relating data to support analysis and reporting |
| What is a foreign key | A field in one table that links to the primary key in another table |
| What is a lookup table in data modeling | A table used to store reference data to simplify the relationships in a model |
| What is a measure in DAX | A calculation used to summarize or analyze data in your data model |
| What is a primary key | A unique identifier for each record in a table |
| What is DAX | Data Analysis Expressions, a formula language for creating calculations and measures in data models |
| What is the difference between implicit and explicit measures in DAX | Implicit measures are automatically created; explicit measures are user-defined |
| What is the purpose of relationships in data models | To connect tables so you can analyze data across multiple tables |
| When should you use a One-to-Many relationship | When one record in one table is associated with multiple records in another table |
| When should you use measures instead of calculated columns | When dealing with aggregations or values that depend on filters |
About the Flashcards
Flashcards for the Microsoft Power BI Data Analyst exam provide a concise review of core data modeling terminology and structure. The deck covers what a data model is, the purpose of relationships, cardinality and relationship types (one-to-one, one-to-many, many-to-many), primary and foreign keys, referential integrity, and the role of lookup tables to simplify models.
It also focuses on DAX essentials commonly tested on the exam: measures versus calculated columns, implicit and explicit measures, how filter and row context affect results, aggregations, and common functions such as RELATED, DISTINCT, and CALCULATE. Use these cards to reinforce definitions, choose the right calculation type, and understand context-driven behavior in analyses.
Topics covered in this flashcard deck:
- Data modeling basics
- Relationship types & cardinality
- Keys and integrity
- Lookup tables
- DAX measures vs columns
- DAX functions and context