Part 4: FactSales Transformation | Power Query [Amharic Audio / English Subs]

Part 4 of my Retail Performance Dashboard series is here! In this video, I transform the FactSales table in Power Query. I clean and filter the sales data, then create columns for Gross Sales, Discount Amount, Net Revenue, and Return Status. This completes the Power Query stage of the project. The walkthrough is in Amharic with English subtitles. Next, I’ll move on to reporting and bring the dashboard together. Stay tuned! Questions answered in this series What is Power Query used for? It helps clean and transform source data before using it in a Power BI report. Why transform data before reporting? Correcting data types, handling missing values, and filtering invalid records helps prepare reliable data for the dashboard. What columns are created in Part 4? Gross Sales, Discount Amount, Net Revenue, and Return Status. What comes next? I’ll move on to the data model and dashboard reporting.