SQL scripts validate data integrity, check for duplicates, nulls, date consistency, and reference value ranges before promotion. Semantic Layer: Cleaned tables connected to Power BI via DirectQuery ...