Forum Discussion
Should I integrate a script or do R analyzes before loading the data?
I would like to create a sentiment analysis and Iam just considering wheter to do the sentiment analysis before loading the data into the database and saving the results in a new column or if I am evaluating the sentiment during the Power BI Reporting (By integrating a R-Script)
What advantages or disadvantages do I have if I do this in the Reporting (Presentation Layer)?
And what was the intention of the Script integration unction in Power BI? Are there some Analysis-Types that has advantages to do in the presentation layer?
ation layer?Hi yellow_days,
Per my knowledge, to a certain degree, doing data analysis via R script before loading data into desktop might improve the performance while running report, because it reduces the time spent on modeling data via DAX.
Also, using R script can generate more custom visuals apart from those built-in visuals supported by desktop.
Regards,
Yuliana Gu
1 Reply
Hi yellow_days,
Per my knowledge, to a certain degree, doing data analysis via R script before loading data into desktop might improve the performance while running report, because it reduces the time spent on modeling data via DAX.
Also, using R script can generate more custom visuals apart from those built-in visuals supported by desktop.
Regards,
Yuliana Gu