Microsoft PBI Data Analyst Certification | Course 3: Extract, Transform and Load Data in Power BI

In this Course 3 project for the Microsoft Power BI Data Analyst Professional Certificate, I showcased my data transformation skills by executing a complete ETL process with three Excel files: Order2022, Order2023, and OrderDetails. Using Power Query, I meticulously cleaned and profiled the data, identifying and removing anomalies to ensure high data quality. Through a series of data transformations, I appended and merged the datasets into a cohesive data model ready for analysis. This project reflects my dedication to precision in data preparation and my growing expertise in Power BI’s ETL capabilities.