What is a Star Schema and why is it recommended?

Question

Accepted Answer

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.

What is a Star Schema and why is it recommended?

Answer with Explanation