Posts

Showing posts with the label ETL Exercise

Basic ETL Exercise in Power BI

 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.