Basic ETL Exercise in Power BI

Join on WhatsApp E-books for International Buyers E-books for Indian Buyers Schedule a Call

 Hi,

Please watch this video before doing the exercise.

ETL-2 video link

Download the data from here: Github link

Task

1. Get the excel file into the Power BI

2. Launch Power Query Editor

3. Check all the columns are properly named (if not, name it properly)

4. Remove the null values (Rows)

5. Delete the irrelevant columns

6. Add a new table with simple columns.

If you face any issues, please comment.