✏️ Explanatory Question

What is a Star Schema and why is it recommended in Power BI?

👁 2 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

A Star Schema is a dimensional modeling technique where Fact tables are connected to Dimension tables.

Benefits:

  • Faster query performance.
  • Reduced model complexity.
  • Better compression.
  • Easier DAX development.
  • Improved maintainability.

Star Schema is considered the industry standard for enterprise Power BI solutions.