Peter Bian, Author at Microsoft Power Platform Blog http://approjects.co.za/?big=en-us/power-platform/blog Innovate with Business Apps Wed, 11 Jun 2025 15:00:18 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.3 Get to insights even faster with new features from Process advisor task mining http://approjects.co.za/?big=en-us/power-platform/blog/power-automate/get-to-insights-even-faster-with-new-features-from-process-advisor-task-mining/ Thu, 10 Feb 2022 15:29:00 +0000 We’ve made several exciting enhancements to Process advisor in January 2022 to make it even easier and faster to visualize your processes and get to insights with task mining. These features include auto creating activities from recordings, removal of "Ready to analyze", and a link back to Process advisor from the recorder.

The post Get to insights even faster with new features from Process advisor task mining appeared first on Microsoft Power Platform Blog.

]]>
We’ve made several exciting enhancements to Process advisor in January 2022 to make it even easier and faster to visualize your processes and get to insights with task mining. From a combination of talking to customers, looking at the data, and dogfooding our own product, we identified three bottlenecks in the prior task mining experience:

  • Preparing recordings for analysis is time consuming.
  • Requiring users to set recordings as “Ready to analyze” introduces additional friction on the path to insights.
  • Navigating from the recorder to recording details requires too many clicks.

Read on to discover how we are alleviating these pain points and really reducing the amount of time and number of clicks to get to insights.

 Auto create activities from recordings

We have heard your feedback! Manually preparing screen recordings can be painful. Previously you needed to:

  1. Review the recorded actions (e.g. mouse clicks or keyboard events)
  2. Identify sensible groupings
  3. Define a label for each group, AKA activity

Thankfully, Process advisor now support auto creating activities from the recording. We automatically group related recorded actions into a single activity and create a label that accurately describes the user’s action, leveraging the application and window used. You can accept auto created activities as is, you can edit individual auto created activities, or delete all auto created activities and create your own from scratch.

Editing the activities in anyway will remove the “Auto created” tag so you know which activities were edited or added after. This solution helps first time users quickly understand their process activities, while more advanced users have a starting point to fine tune the activities to get the desired results.

Removal of “Ready to analyze”

With the addition of auto created activities, we wanted to streamline the steps to getting to analytics. Having to toggle ready to analyze every time was more of a hinderance than of value. Now, as long as you have two activities in your recording, you are ready to analyze!

Link back to Process advisor from recorder

We added a button once you have finished recording to open the recording details in Process advisor portal. Previously you had to navigate to the page on your own, which required many clicks and was another source of additional friction.

Get started with process advisor to experience these enhancements or try it out for the first time!

The post Get to insights even faster with new features from Process advisor task mining appeared first on Microsoft Power Platform Blog.

]]>
Process advisor updates in March 2021 http://approjects.co.za/?big=en-us/power-platform/blog/power-automate/process-advisor-updates-in-march-2021/ Wed, 07 Apr 2021 15:00:00 +0000 http://approjects.co.za/?big=en-us/power-platform/blog/power-automate/process-advisor-updates-in-march-2021/ We've made several enhancements to Process advisor in March 2021 to make it easier and faster to create and visualize your processes, including a guided first run experience, improvements for preparing your recording, the ability to manage activity names and other usability improvements.

The post Process advisor updates in March 2021 appeared first on Microsoft Power Platform Blog.

]]>
We’ve made several enhancements to Process advisor in March 2021 to make it easier and faster to create and visualize your processes:

  • Guided first run experience
  • Improvements in preparing your recording
  • Manage activity names
  • Usability improvements

Guided first run experience

We’ve added helpful guides when you first interact with Process advisor to learn about the product and guide you on what to do next.

Manage activity names

Process owners can now create and manage recommended activity names for a process, so there will be more consistency in naming across recordings. These names will show up in the activity name list when preparing your recording.

Improvements in preparing your recording

We have made several improvements to the experience of preparing your recording:

  • Updated the look and feel of grouping activities, so it is more clearly delineated which actions are part of an activity
  • Improved the activity name searching
  • Added ability to delete actions that are sensitive or not relevant
  • Moved recording details into its own panel

Usability improvements

We’ve made navigation across all Process advisor screens significantly faster to make the overall experience smoother and more responsive. In addition, we made improvements that should improve usability:

  • Recording details will automatically refresh once it is available
  • Added recording process retry when there is a retriable failure
  • Added ability to reopen the recorder if you closed the pop-up when creating the recording
  • Improved interactivity with the process map especially the ability to tab through the process map labels

Get started with process advisor to experience these enhancements or try it out for the first time!

The post Process advisor updates in March 2021 appeared first on Microsoft Power Platform Blog.

]]>
AI Builder prediction now supports related entities and filtering http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/ai-builder-prediction-now-supports-related-entities-and-filtering/ Tue, 11 Feb 2020 18:53:19 +0000 http://approjects.co.za/?big=en-us/power-platform/blog/power-apps/ai-builder-prediction-now-supports-related-entities-and-filtering/ We’ve updated AI Builder prediction to include support for related entities and filtering. These capabilities give users even more flexibility in model creation. In this post, we demonstrate how these features work by building an end to end scenario for how AI Builder can help to optimize delivery performance for an e-commerce company.

The post AI Builder prediction now supports related entities and filtering appeared first on Microsoft Power Platform Blog.

]]>
We’ve updated AI Builder prediction to include support for related entities and filtering. These capabilities give users even more flexibility in model creation. In this post, we demonstrate how these features work by building an end to end scenario for how AI Builder can help to optimize delivery performance for an e-commerce company.

Related entities

We want AI Builder to work better for the data that you already have in Common Data Service. We know that all of the data that makes your business run probably isn’t in a single entity, and that there are many entities and relationships all of which may help to improve the accuracy of your prediction model.

We’ve added support for adding related entities to be used in training, similar to the way you can add related entities in a view. Currently we only support many-to-one relationships, but we are looking to add more relationship types to support later on.

Filtering

What happens when you know that there are irrelevant data within the same entity you are using to train a model? For example, if you don’t want to train on outdated records, or if you want to build region-specific AI models

We’ve added support for filtering, which is applied to both training and prediction. As an example, if I apply a filter to only look at the U.S. region, then the model will train itself on records where the outcome is known only for U.S. region. Once this model is trained, it will only make a prediction for records where the outcome is not known only for U.S. region.

More information on how to use these features can be found in our documentation.

Example

Let’s say I’m a maker in a typical e-commerce company in Brazil. My CDS database contains typical entities like Order, Product, Customer, etc. I’m noticing that there have been a lot of complaints that deliveries have been delayed specifically for Sao Paulo.

Without fundamentally changing the system, since this is an isolated issue, I want to see if I can train a model to predict whether a delivery to Sao Paulo is likely to be delayed, and automatically upgrade the shipping for the customer from regular to express.

Step 1: create output field

First, I want to create an output field to denote what constitutes a delayed delivery. In my Order entity, I have the estimated delivery date and the actual delivery date. Every record where actual delivery date is a week or more later than estimated delivery date is considered a late delivery. I will create two fields:

Delivery Delta – this is the difference in days between Delivered Date and Estimated Delivery Date.


Delivery Timeliness – this field categorizes the Delivery Delta column into Early, On time, and Late.

If an order has not been delivered, then the Delivery Timeliness value will be null, and those are the records which the model will make a prediction on, once the model is trained and published.

Step 2: create prediction model

Next, I create a new prediction model from AI Builder section of Power Apps.

I use my BC Order entity and the Delivery Timeliness field, which we created earlier. In addition, I want to predict  whether the delivery will be late, so here, I  tell the model that Late is my Yes outcome, and everything else is No.

Next, I select my related entities, Customer and Product.

Also, make sure that Delivery Date and Delivery Delta are not selected, because the model should not have information that is only known after the product has been delivered. If you do keep it selected, then the model will show that it has 100% accuracy, but it will not be able to properly predict new orders. This is known in machine learning as target leak, and you can learn more about it here.

Next, I add a filter, so the model only looks at Sao Paulo orders. The filtering experience is the same as the PowerApps view filtering experience that you may be familiar with. We want to create a filter condition on the Customer entity, since the state information is in that entity and not orders. Set the filter condition as shown here:

Once all that is done, it is time to train the model. For this model, we have an accuracy score of 91%.

Step 3: publish and use in app

Publish your model. As part of publishing, we actually create three outputs:

  • Predicted – The predicted outcome
  • Probability – The probability of the true outcome, from 0 – 1
  • Explanation – A text field in JSON that contains the record level influencers

If you select See details, you will see the output field that we created for the prediction.

You can leverage the view feature to quickly see the predicted output. Refer to this document for more info.

We’re ready to connect the prediction to our app. For this example, let’s assume we have an app that the fulfillment team looks at when they prepare the order. If the model predicts that the shipment is likely to be late, then we will automatically upgrade them to express by connecting the prediction output to the app. To do this, simply reference the prediction output fields in the app.

We’ve now added AI into your business process without any coding!

Appendix: try it yourself

If you want to walk through this example on your own, use the link below to access the solution and the data files you need.

brazilian_commerce

First, import the solution BrazilianCommerce_1_0_0_0.zip that contains the entity definitions.

In PowerApps, Click Solutions on the left menu pane, and then Import on the top menu bar.

Select the attached zip file and follow the instruction to import it.

Once the solution is imported, click the gear icon on the top right of the PowerApps screen, and select Advanced settings.

Click the carrot next to Settings and select Data Management.

Select IMPORT DATA from the top menu bar.

In the Data file name section, select customer.csv and click Next.

Keep clicking Next until you get to the Map Record Types screen.

Select BC Customer from the drop down and click Next.

Map the fields like this:

Source Field Map to
customer_id ID
customer_city City
customer_state State
customer_zip_code_prefix Zip code

Select Next, then Submit, then Finish.

Repeat the process again, but this time use product.csv and map it to BC Product.

Map the fields like this:

Source Field Map to
product_id ID
product_category_name Category
product_description_lenght Description Length
product_height_cm Height cm
product_length_cm Length cm
product_name_lenght Name Length
product_photos_qty Photos Quantity
product_weight_g Weight g
product_width_cm Width cm

Wait until both of these imports are complete before moving onto the next step.

Repeat the process again, but this time use order.csv and map it to BC Order.

Map the fields like this:

Source Field Map to
order_id ID
customer_id Customer (Lookup)
freight_value Freight Value
order_delivered_customer_date Delivered Date
order_estimated_delivery_date Estimated Delivery Date
order_purchase_timestamp Purchase Date
order_status Order Status
price Price
product_id Product (Lookup)

For the two lookup fields, you should get a popup:

Make sure that the checkbox is selected, and that the field is ID. Once that is done, you should have all the data uploaded to start walking through the scenario yourself.

 

The post AI Builder prediction now supports related entities and filtering appeared first on Microsoft Power Platform Blog.

]]>