Home / Questions / What is a Star Schema and why is it recommended?
Explanatory Question

What is a Star Schema and why is it recommended?

👁 0 Views
📘 Detailed Answer
🕒 Easy to Read
Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

Answer with Explanation

A Star Schema consists of:

  • Fact Tables
  • Dimension Tables

Benefits:

  • Better performance.
  • Simpler relationships.
  • Improved DAX calculations.
  • Easier maintenance.

Microsoft recommends Star Schema for enterprise reporting solutions.