Recall & Review
beginner
What is the main goal of a good data model in Power BI?
To organize data efficiently so reports are fast, easy to understand, and accurate.
Click to reveal answer
intermediate
Why should you avoid many-to-many relationships in your data model?
Because they can cause confusion and incorrect results in calculations and visuals.
Click to reveal answer
beginner
What is a star schema and why is it recommended?
A star schema has one central fact table connected to dimension tables. It makes data easy to understand and fast to query.
Click to reveal answer
intermediate
How does using calculated columns differ from measures in Power BI?
Calculated columns add data to the table and increase model size; measures calculate results on the fly without increasing size.
Click to reveal answer
beginner
Why is it important to reduce the size of your data model?
Smaller models load faster, use less memory, and improve report performance.
Click to reveal answer
Which schema is best for organizing data in Power BI?
✗ Incorrect
Star schema is simple and efficient, making it best for Power BI data models.
What should you do to improve report speed?
✗ Incorrect
Reducing data model size helps reports load and respond faster.
What is a dimension table used for?
✗ Incorrect
Dimension tables hold descriptive information to slice and filter data.
Why avoid many-to-many relationships?
✗ Incorrect
Many-to-many relationships can cause confusion and wrong results.
Which is better for calculations in visuals?
✗ Incorrect
Measures calculate on demand and keep the model efficient.
Explain the benefits of using a star schema in Power BI data models.
Think about how organizing data like a star helps reports run smoothly.
You got /5 concepts.
Describe why reducing data model size is important and how you can achieve it.
Smaller models are like lighter backpacks — easier to carry and faster to move.
You got /5 concepts.