Intelligent apps using Azure Database for MySQL

App Service
Cognitive Services
Database for MySQL
Machine Learning
Power BI

Solution Idea

If you'd like to see us expand this article with more information, implementation details, pricing guidance, or code examples, let us know with GitHub Feedback!

Develop sophisticated, transformational apps using state of the art machine learning algorithms and integrated visualization tools to get actionable insights and analytics.

Architecture

Architecture diagram

Download an SVG of this architecture.

The data flows through the solution as follows:

  1. Data could come from various sources, such as Event Hubs for high volumes of data ingestion, or data that's uploaded to Blob Storage. An Azure Function App is triggered as new data is received.
  2. The Azure Function App calls the Text Analytics API in Azure Cognitive Services to analyse the data (for example, for Sentiment Analysis). The results of the analysis are returned in JSON format.
  3. The Azure Function App stores the data and results from Text Analytics in Azure Database for MySQL.
  4. Azure Machine Learning Studio can be used to further analyze the data, using custom Machine Learning algorithms to gain further insights.
  5. The MySQL Power BI Connector provides options for data visualization and analysis in Power BI.

Components

Alternatives

Next steps

The following solution ideas feature Azure Database for MySQL: