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. 

Comments

Popular posts from this blog

Learning Path: Business Central Technical Consultant | Dynamics 365 Business Central

Top Business Central Interview Questions for Technical Consultants: Tips and Strategies for Nailing Your Interview

Table in Business Central