Skill 2.3: Describe AI Builder AI Builder is a relatively recent product designed to add intelligence to the apps and flows created in Power Apps and Power Automate. AI Builder enables apps and flows to perform interpretive tasks using data stored in the Common Data Service, such as predicting yes/no outcomes based on historical data patterns, gathering data from forms, classifying text and applying labels or tags to it, counting and identifying objects depicted in an image file, and organizing data scanned from business cards. This skill covers how to: ■ Identify the business value of AI Builder ■ Describe models including business card reader,Read More →

Describe models including business card reader, detection model, form processing model, and prediction model To use AI Builder, developers choose from a collection of models that define scenarios in which an app can apply artificial intelligence to a business task. There are prebuilt model types that define common tasks and are ready for immediate use, as well as custom model types that define basic AI functions, which developers can build and train with their own data. The models included with AI Builder as of this writing are described in the following sections. Prebuilt models The prebuilt models included in AI Builder are designed to performRead More →

Custom models The Refine a model for your business needs section of the AI Builder’s Build screen contains tiles that provide access to models that developers can customize for use with their own data and business needs. Unlike the prebuilt models, which use AI to make determinations based on standard business practices, developers must build and train the custom models with their own data and practices. For example, anyone can use the prebuilt Business Card Reader model without modification of the AI, because the information found on business cards is predictable. For custom models, such as Object Detection, the AI must be trained to recognizeRead More →

Describe how Power Apps and Power Automate can consume AI Builder data AI Builder models all generate data in some form or another. The Business Card Reader model generates database records containing the information scanned from the business cards. The Prediction model generates a single binary result, such as a yes or no. The Language Detection model generates a two-digit code indicating the language of the input data. Apps and flows can make use of this generated data in various ways. In some cases, such as the Business Card Reader and Form Processing models, their primary function is to scan data from source documents andRead More →

Skill 3.1: Identify common Power BI components The process of creating a simple Power BI dashboard consists of the following basic steps: Connect to data sources Transform the data Create report visualizations Build the dashboard Publish the dashboard As dashboard designers work through these steps, they encounter the various Power BI components that can aid them in creating a compelling dashboard design. This skill covers how to: ■ Identify and describe uses for visualization controls including pie, bar, donut, and scatter plots and KPIs ■ Describe types of filters ■ Describe the Power BI Desktop Reports, Data, and Model tabs ■ Describe uses for customRead More →

Line charts Line charts display one or more value sequences represented by horizontal lines running from each value to the next one, as shown in Figure 3-9. Commonly used for the presentation of values over time, as in financial profit and loss charts, the horizontal (or x) axis traditionally represents the time interval, such as days, months, or years. FIGURE 3-9 A line chart in Power BI Combo charts Power BI supports the combination of line and column charts into a composite that overlays line data onto a series of columns. The combination of the two chart types makes it possible to compare data setsRead More →

Describe actions Actions are specific modifications made to the data provided by an outside application or service. In Power Automate, actions are usually the result of a trigger, but developers can use them in Power Apps as well. For example, when a developer creates a manual trigger in a Power Automate flow, the next step is to select an action that will be the result of the trigger, as shown in Figure 2-18. Apps and flows can include multiple actions using different connectors to perform a sequence of tasks. FIGURE 2-18 The Choose an action dialog box in the Power Automate portal Actions can causeRead More →

Key performance indicators A key performance indicator (KPI) is a chart that indicates the progress of a single data point toward a specific predetermined goal. A KPI begins as a standard chart with a time interval on the x-axis, which represents the trend, and a data indicator value on the y-axis. Then the developer specifies a goal, which is a single value, and the chart appears as shown in Figure 3-16. FIGURE 3-16 A key performance indicator chart in Power BI The area chart in the background displays the current trend values, and in the foreground is the current numerical value and the goal value,Read More →

Tables In addition to the many types of charts and graphs available in Power BI, it is possible to include raw data in a dashboard or report in the form of a table, as shown in Figure 3-20. FIGURE 3-20 A table in Power BI Describe types of filters Filters are a means by which Power BI designers and consumers can specify what data is displayed in reports (but not in dashboards, which do not support filtering). For example, if a data set contains company financial information for 10 years, the report designer can create a filter that allows consumers to select specific years toRead More →

Describe the Power BI Desktop Reports, Data, and Model tabs The Power BI service interface, shown in Figure 3-25, has a menu on the left side of the workspace that provides the primary means for users to navigate around the site. The collapsed menu icon (often called the hamburger button) at the top of the menu toggles between the full menu and a narrow button bar that clears more room for the workspace. FIGURE 3-25 Home tab of the Power BI service interface The tabs on the menu bar provide users with access to the various parts of the interface, as follows: ■ Home—Displays tilesRead More →