What is a Star Schema and why is it considered a best practice in Power BI?

Question

Accepted Answer

A Star Schema is a data modeling approach where a central Fact table is connected to multiple Dimension tables.
    

    Structure:

    
        Fact Table → Contains measurable business data.
        Dimension Tables → Store descriptive attributes.
    

    Example:

    
        FactSales
        DimCustomer
        DimProduct
        DimDate
        DimRegion
    

    Benefits:

    
        Better query performance.
        Easier DAX calculations.
        Simplified relationships.
        Improved scalability.
    

    
        Star Schema is the preferred design pattern for enterprise Power BI solutions.

What is a Star Schema and why is it considered a best practice in Power BI?

Answer with Explanation