power query

Data Cleaning & Modeling with Power Query (Power BI)

Every great dashboard starts long before the first chart — it starts with clean data. The raw file behind this project had corrupted dates, blank rows, and inconsistent formats. Using Power Query and custom M formulas, I repaired the dates, removed the noise, standardized everything, and modeled clean relationships with a proper date table and DAX measures. The result: 100% valid data — the invisible foundation every accurate report stands on.