Should I integrate a script or do R analyzes before loading the data?

[yellow_days]

Hi,

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?

best regards

[yellow_days]

Hi,

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?

best regards

[v-yulgu-msft · Accepted solution]

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