This article describes a method for generating large amounts of realistic test data quickly and reliably.
Furthermore, data that is generated by hand is subject to our unconscious and systemic biases. Manually generating realistic datasets of adequate amount and variety is tough (e.g., different data types, characteristics). We must test data apps or pipelines using data similar to what will be observed in production. The issue is that we frequently lack (enough of) it. This is only available if you are within a solution and using the current environment connector.We are all aware of the importance of data. Next, call the Perform an unbound action action. Start with a lead update, which is the same as the one for disqualification except you don’t set the status/status reason. Qualification of a lead is a little trickier. There are other ways to do this, with Selects, etc., but this gives a one-line expression.įinally in this lead update, set the status and status reason. ))]įinally, the Option is actually an object, the value I actually need to populated in the record is Value ? So this effectively chooses which one I am going to use by random. If I have 10 options, the list will be returned with items in slots 0 – 9. Next, select one of the options by choosing a random number between 0 (o indexed array) and the number of options returned. outputs('OptionSetValues')?))]?įirstly get all the options return by my custom connector call. The expression is below and broken down to the key parts. Use this link in the Import Sample and choose Get as the verb should result in the below action configuration. The URL for retrieving a list of option set values is below. What is specific to this project is the action to retrieve the option set. I am not going to go through the basics of the connector creation, see my previous posts for that. A custom connector allows connection to the wider Power Platform API, where you can do all manner of things, but most importantly for us retrieve a list of options for a field. I have been through customer connectors before, for my Org Settings app amongst others. The Common Data Service connector at the moment doesn’t give the user the ability to retrieve the values so you have to resort to a Custom Connector. These fields need updating with a random value prior to (dis)qualification. Also, there are some fields that the Predictive Leads default model would like, such as Industry type, budget, annual revenue and number of employees. To go through the steps to qualify each of the 1000 leads that were just added would be a time-consuming exercise. Augmenting your data in Flowįor Predictive Leads, you need 30 qualified and unqualified leads. Once successful, you will have a new set of “random” data for your use. Hit Finish Import and this will queue your import job. Here, map the CSV fields to the Dynamics fields, particular attention to the Primary fields which you need to populate. Open in Excel to view your random data goodness. It doesn’t really matter for my demo what data was in there, just needed something random, which the type grocery products gives me.Ĭhoose the number of rows you need, select the format as CSV and Download. Some things I needed were not present, such as the topic. It does a great job of ensuring the chosen name / last name also links to the email address. Fake company names, random first and last name etc.
Mockaroo has various types which you can use to flesh out the data. So, First and last name, email, account name, topic, job title and email. Great for my needs.įor Sales Insights Lead prediction, I need Leads.
#Mockaroo data generator generator
Mockaroo is a free data generator service which allows you to establish the fields you want and create a dummy import file for Dynamics. I had used Flow in the past to automate data entry, and it worked well, so I thought I would create some data for my environment using Flow, but first sourcing the data in Mockaroo. Recently, with my look at Sales Insights, the amount of data I needed was increasing. As a consultant, architect or just a blogger, you have to do a lot of demos.
0 kommentar(er)
