Citizen AI with Power Platform

Azure Machine Learning
Microsoft Power Platform
Power Apps
Power Automate
Power BI

The following architecture extends the analytics end-to-end with Azure Synapse Analytics scenario. It allows for a custom machine learning (ML) model to be trained in Azure Machine Learning and implemented with a custom application built by using Microsoft Power Platform.

Architecture

Diagram that shows the architecture for citizen AI with Microsoft Power Platform.

Download a Visio file of this architecture.

Workflow

The workflow consists of the following steps:

  • Ingest
  • Store
  • Train and deploy a model
  • Consume

Ingest

Use Azure Synapse Pipelines to pull batch data from various sources, both on-premises and in the cloud. This lambda architecture has two data ingestion flows: streaming and batch. They're described here:

  • Streaming: In the upper half of the preceding architecture diagram are the streaming data flows (for example, big data streams and IoT devices).
    • You can use Azure Event Hubs or Azure IoT Hub to ingest data streams generated by client applications or IoT devices. Event Hubs or IoT Hub ingest and store streaming data, preserving the sequence of events received. Consumers can connect to hub endpoints to retrieve messages for processing.
  • Batch: In the lower half of the architecture diagram, data is ingested and processed in batches such as:
    • Unstructured data (for example, video, images, audio, and free text)

    • Semi-structured data (for example, JSON, XML, CSV, and logs)

    • Structured data (for example, relational databases and Azure Data Services)

      Azure Synapse Link creates a tight seamless integration between Azure Cosmos DB and Azure Synapse Analytics. Azure Synapse Pipelines can be triggered based on a predefined schedule or in response to an event. They can also be invoked by calling REST APIs.

Store

Ingested data can land directly in raw format and then be transformed on the Azure Data Lake. Data once curated and transformed to relational structures can be presented for consumption in Azure Synapse Analytics.

Train and deploy a model

Machine Learning provides an enterprise-grade ML service for building and deploying models faster. It provides users at all skill levels with a low-code designer, automated ML, and a hosted Jupyter notebook environment. Models can be deployed either as real-time endpoints on Azure Kubernetes Service or as a Machine Learning managed endpoint. For batch inferencing of ML models, you can use Machine Learning pipelines.

Consume

A batch or real-time model published in Machine Learning can generate a REST endpoint that can be consumed in a custom application built by using the low-code Power Apps platform. You can also call a real-time Machine Learning endpoint from a Power BI report to present predictions in business reports.

Note

Both Machine Learning and Microsoft Power Platform stack have a range of built-in connectors to help ingest data directly. These connectors might be useful for a one-off minimum viable product (MVP). However, the "Ingest" and "Store" sections of the architecture advise on the role of standardized data pipelines for the sourcing and storage of data from different sources at scale. These patterns are typically implemented and maintained by the enterprise data platform teams.

Components

You can use the following components.

Microsoft Power Platform services

  • Power Platform: A set of tools for analyzing data, building solutions, automating processes, and creating virtual agents. It includes Power Apps, Power Automate, Power BI, and Microsoft Copilot Studio (formerly Power Virtual Agents).
  • Power Apps: A suite of apps, services, connectors, and data platform. It provides a rapid application development environment to build custom apps for your business needs.
  • Power Automate: A service that helps you create automated workflows between your favorite apps and services. Use it to synchronize files, get notifications, collect data, and so on.
  • Power BI: A collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.

Azure services

  • Machine Learning: An enterprise-grade ML service for building and deploying models quickly. It provides users at all skill levels with a low-code designer, automated ML, and a hosted Jupyter notebook environment to support your own preferred IDE of choice.
  • Machine Learning managed endpoints: Online endpoints that enable you to deploy your model without having to create and manage the underlying infrastructure.
  • Azure Kubernetes Service: ML has varying support across different compute targets. Azure Kubernetes Service is one such target, which is a great fit for enterprise grade real-time model endpoints.
  • Azure Data Lake: A Hadoop-compatible file system. It has an integrated hierarchical namespace and the massive scale and economy of Azure Blob Storage.
  • Azure Synapse Analytics: A limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics.
  • Event Hubs and IoT Hub: Both services ingest data streams generated by client applications or IoT devices. They then ingest and store streaming data, preserving the sequence of events received. Consumers can connect to the hub endpoints to retrieve messages for processing.

Platform services

To improve the quality of your Azure solutions, follow the recommendations and guidelines in the Azure Well-Architected Framework. The framework consists of five pillars of architectural excellence:

  • Cost optimization
  • Operational excellence
  • Performance efficiency
  • Reliability
  • Security

To create a design that respects these recommendations, consider the following services:

  • Microsoft Entra ID: Identity services, single sign-on, and multifactor authentication across Azure workloads.
  • Microsoft Cost Management: Financial governance over your Azure workloads.
  • Azure Key Vault: Secure credential and certificate management.
  • Azure Monitor: Collection, analysis, and display of telemetry from your Azure resources. Use Monitor to proactively identify problems to maximize performance and reliability.
  • Microsoft Defender for Cloud: Strengthen and monitor the security posture of your Azure workloads.
  • Azure DevOps & GitHub: Implement DevOps practices to enforce automation and compliance of your workload development and deployment pipelines for Azure Synapse Analytics and Machine Learning.
  • Azure Policy: Implement organizational standards and governance for resource consistency, regulatory compliance, security, cost, and management.

Alternatives

A machine learning MVP benefits from speed to outcome. In some cases, the needs of a custom model can be met by pretrained Azure Cognitive Services or Azure Applied AI Services. In other cases, Power Apps AI Builder might provide a fit for a purpose model.

Scenario details

A general technology trend is the growing popularity of citizen AI roles. Such roles are business practitioners looking to improve business processes through the application of ML and AI technologies. A significant contributor to this trend is the growing maturity and availability of low-code tools to develop ML models.

Because of a well-known high failure rate to such initiatives, the ability to rapidly prototype and validate an AI application in a real-world setting becomes a key enabler to a fail-fast approach. There are two key tools for developing models that modernize processes and drive transformative outcomes:

  • An ML toolkit for all skill levels
    • Supports no-code to fully coded ML development
    • Has a flexible, low-code graphical user interface (GUI)
    • Enables users to rapidly source and prep data
    • Enables users to rapidly build and deploy models
    • Has advanced, automated ML capabilities for ML algorithm development
  • A low-code application development toolkit
    • Enables users to build custom applications and automation workflows
    • Creates workflows so that consumers and business processes can interact with an ML model

Machine Learning fulfills the role of a low-code GUI for ML development. It has automated ML and deployment to batch or real-time endpoints. Power Platform, which includes Power Apps and Power Automate, provides the toolkits to rapidly build a custom application and workflow that implements your ML algorithm. Business users can now build production-grade ML applications to transform legacy business processes.

Potential use cases

These toolkits minimize the time and effort needed to prototype the benefits of an ML model on a business process. You can easily extend a prototype to a production-grade application. The uses for these techniques include:

  • Manufacturing Ops with legacy applications that use outdated deterministic predictions. Such situations can benefit from the improved accuracy of an ML model. Proving improved accuracy requires both a model and development effort to integrate with legacy systems on-premises.
  • Call Center Ops with legacy applications that don't adjust when data drifts. Models that automatically retrain might provide a significant uplift in churn prediction or risk profiling accuracy. Validation requires integration with existing customer relationship management and ticket management systems. Integration could be expensive.

Considerations

These considerations implement the pillars of the Azure Well-Architected Framework, which is a set of guiding tenets that can be used to improve the quality of a workload. For more information, see Microsoft Azure Well-Architected Framework.

Reliability

Reliability ensures your application can meet the commitments you make to your customers. For more information, see Design review checklist for Reliability.

Most of the components used in this example scenario are managed services that scale automatically. The availability of the services used in this example varies by region.

Apps based on ML typically require one set of resources for training and another for serving. Resources required for training generally don't need high availability, as live production requests don't directly hit these resources. Resources required for serving requests need high availability.

Cost Optimization

Cost Optimization is about looking at ways to reduce unnecessary expenses and improve operational efficiencies. For more information, see Design review checklist for Cost Optimization.

Azure pricing: First-party infrastructure as a service (IaaS) and platform as a service (PaaS) services on Azure use a consumption-based pricing model. They don't require a license or subscription fee. In general, use the Azure pricing calculator to estimate costs. For other considerations, see Cost optimization in the Well-Architected Framework.

Power Platform pricing: Power Apps, Power Automate and Power BI are software as a service (SaaS) applications and have their own pricing models, including per app plan and per user.

Operational Excellence

Operational Excellence covers the operations processes that deploy an application and keep it running in production. For more information, see Design review checklist for Operational Excellence.

DevOps practices are used to orchestrate the end-to-end approach used in this example. The Machine Learning DevOps guide presents best practices and learnings on adopting ML operations (MLOps) in the enterprise with Machine Learning.

DevOps automation can be applied to Microsoft Power Platform solution provided in this example. For more information about Microsoft Power Platform DevOps, see Power Platform Build Tools for Azure DevOps: Power Platform.

Deploy this scenario

Consider this business scenario. A field agent uses an app that estimates a car's market price. You can use Machine Learning to quickly prototype an ML model of this app. You use a low-code designer and ML features to create the model, and then deploy it as a real-time REST endpoint.

The model might prove the concept, but a user has no easy way to consume a model implemented as a REST API. Microsoft Power Platform can help close this last mile, as represented here.

Screenshot that shows an ML model that's created in Machine Learning. The model obtains car data from Azure Data Lake, and it provides inferences to an endpoint.

Here's a user interface for the app, created in Power Apps by using the low-code interface that Power Apps provides.

Screenshot that shows buttons and dropdown lists for the user to enter car data. The app predicts a price and displays it when the user selects the Predict button.

You can use Power Automate to build a low-code workflow to parse the user's input, pass it to the Machine Learning endpoint, and retrieve the prediction. You can also use Power BI to interact with the Machine Learning model and create custom business reports and dashboards.

Diagram that shows architecture showing the schematic of the workflow.

To deploy this end-to-end example, follow step by step instructions in Car Price Predictor - Azure Machine Learning + Power App Solution.

Extended scenarios

Consider the following scenarios.

Deploy to Teams

The sample app provided in the preceding example can also be deployed to Microsoft Teams. Teams provides a great distribution channel for your apps and provides your users with a collaborative app experience. For more information about how to deploy an app to Teams by using Power Apps, see Publish your app by using Power Apps in Teams: Power Apps.

Consume the API from multiple apps and automations

In this example, we configure a Power Automate cloud flow to consume the REST endpoint as an HTTP action. We can instead set up a custom connector for the REST endpoint and consume it directly from Power Apps or from Power Automate. This approach is useful when we want multiple apps to consume the same endpoint. It also provides governance by using the connector data loss prevention (DLP) policy in Microsoft Power Platform admin center. To create a custom connector, see Use a custom connector from a Power Apps app. For more information on Microsoft Power Platform connector DLP, see Data loss prevention policies: Power Platform.

Contributors

This article is maintained by Microsoft. It was originally written by:

Next steps