Insight in BI reports and definitions
Having BI metadata in a tabular structure in a SQL Server database helps you analyzing BI queries, BI reports/dashboards and BI models. You can make an impact analysis as you have insight in the data lineage between model and reports. Create a cross report (or even cross application) analysis in terms of consistent business labels and expressions. Developing automatic documentation for all your reports is one of the charmes of having your BI metadata in a centralized, relational database.