AWS AI/ML integration with Power BI

Question

Customer wants to know if AWS AI/ML services integrate with Power BI. The customer currently uses Power BI that integrates with Azure ML for sentiment analysis, opinion mining, etc. Customer is looking for a push button solution where the business analyst can do text analytics on the response from the model. Is there a way to do this on AWS or a marketplace solution?

AWS-User-5862030 · Accepted Answer

PowerBI can connect to Amazon Redshift and leverage the [new SQL based ML capability in Redshift][1] that uses Sagemaker under the hood.

As an alternative thought the customer can integrate Amazon Sagemaker Model with Amazon Quicksight to achieve functionality very similar to PowerBI with Azure ML. Quicksight does have some embedded ML capability like forecasting and anomaly detection but Opinion mining is not one of them yet.

You should be able to leverage [Blazing Text Algorithm][2] in Sagemaker or some market place solution like [Twinword sentiment model][3] in sagemaker for sentiment analysis for Text mining after the integration.

[1]: https://aws.amazon.com/redshift/features/redshift-ml/
  [2]: https://docs.aws.amazon.com/sagemaker/latest/dg/blazingtext.html
  [3]: https://aws.amazon.com/marketplace/pp/Twinword-Inc-Sentiment-Analysis-Inference-Model/prodview-wa74yx5z5qsvw

AWS-User-8841074 · Answer

Please take a look at this AWS solution - https://aws.amazon.com/solutions/implementations/text-analysis-with-amazon-opensearch-service-and-amazon-comprehend/

Comprehend also has an integration with AWS Aurora - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/mysql-ml.html

AWS AI/ML integration with Power BI

Relevant content