Forum Discussion
Using Power BI to clean and manipulate and visualize text data
Please guys am working on a project that requires me to scrap dataset on reviews from a particular site, clean and visualize it, and then draw inferences from the data and present as powerpoint. I have done th part of web scrapping with python and I have the reviews now. I need help on how to use Power BI to aid the task remaining beacuse I'm new here.
1 Reply
mkyaremateng , You can use Power Query for clean.
Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321aPower Query Table Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq
Power Query DateTime Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X
Power BI List Functions: https://www.youtube.com/playlist?list=PLPaNVDMhUXGbkShvXwEedw-cH3QBYhwvO
