PowerBI Topic & Sentiment Chart
|About the app||Installation guide||Documentation||References||Source code||License||Feedback guidelines|
|Go to about section||How to install||User Guide||References||GitHub||License||Contribute|
About the app
This is a PowerBI application with R script driven visual. This app attempts to help in generating topics and sentiment from text data field by writing low or no code at all. The ease of use of this application also comes with the limitation of not being scalable and sometimes needs changing some part of the code to make it relevant to the data in use.
The author has only put together a piece of code and does not own any original work, both in terms of the visualization and underlying algorithms. To this extent, the author has cited relevant researcher work in the references section.
How to install:
- Install R software from Installation page.
- Install PowerBI desktop application from Installation page.
- Follow the instructions on documentation page to enable R script visual on PowerBI.
- Download the PBI file from here
- If you have downloaded the demo PowerBI application shared by the author, then the app is shipped with the underlying data.
- In such cases, please add your own text data by using the Get Data drop down.
- Select the R Script visual in the canvas by clicking it. This will show the Values field in the visualizations section.
- Then, identify the text field from the Fields section of the app. This field is the one that needs to be analyzed for topics and sentiment.
- Drag and drop this text field into the Values field.
- Wait for the chart to populate. It generally takes less than a minute for about 300 comments with an average character length of 100.
- If you have not downloaded the demo PowerBI application shared by the author, then please do so from the gallery
- Blei D.M., Ng A.Y., Jordan M.I. (2003). Latent Dirichlet Allocation. Journal of Machine Learning Research, 3, 993–1022.
- Phan X.H., Nguyen L.M., Horguchi S. (2008). Learning to Classify Short and Sparse Text & Web with Hidden Topics from Large-scale Data Collections. In Proceedings of the 17th International World Wide Web Conference (WWW 2008), pages 91–100, Beijing, China
- Lu, B., Ott, M., Cardie, C., Tsou, B.K. (2011). Multi-aspect Sentiment Analysis with Topic Models. In Proceedings of the 2011 IEEE 11th International Conference on Data Mining Workshops, pages 81–88
comments powered by Disqus