Sentiment Analysis in Power Automate & creating dashboard in Power BI
Want to perform sentiment analysis for your product reviews by the customers. let’s do that in Power Automate & create a dashboard in Power BI
Steps to perform:
1. Select a product review dataset from Kaggle or other online resources.
2. Create a Power Automate online account to perform Prediction.
3. Create a Power Automate flow:
4. Manually trigger the flow
5. Get the data from the Excel Online account and use the available Excel Connector
6. Use the apply to each condition and loop through the product review column of the table.
7. Use the AI Builder and select the Sentimental Analysis option to predict whether its Positive, Negative, Neutral reviews
8. Add the AI Builder outcome to the Prediction column of the table.
9. Download the predicted values Excel file.
10. Perform analysis in Power BI with respect to Prediction category and maintain a dashboard.
Project Video: