Bash, the Crucial Exams Chat Bot
AI Bot
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 |
This deck addresses the creation of data models, relationships, cardinality, and DAX basics to enhance data analysis capabilities.