Describe application lifecycle management Application lifecycle management (ALM) is a cyclical paradigm for the development, governance, and maintenance of applications, as illustrated in Figure 2-10. Power Platform supports an ALM strategy that uses Power Apps, Power Automate, and Common Data Service components packaged as a solution. FIGURE 2-10 The lifecycle of an application By packaging the components of an ALM strategy as a solution, administrators can import them into the Common Data Service in other environments. This allows developers in those other environments to access the ALM components when developing their own apps and flows. Describe business process flows Business process flows are tools thatRead More →

Power BI Desktop data types Power BI Desktop includes a larger set of data source connections from which developers can choose and a tabbed interface that provides simpler access to them: ■ All—Contains a list of all the connections found on the other tabs ■ File—Contains connectors for Excel workbooks, text files, SharePoint folders, PDFs, and other standard file formats, as shown in Figure 3-53 FIGURE 3-53 The File tab in Power BI Desktop’s Get Data dialog box ■ Database—Contains connectors for many of the standard commercial database formats, including SQL, Access, Oracle, IBM Informix, Sybase, and SAP, as shown in Figure 3-54 FIGURE 3-54Read More →

Describe use cases and limitations of business rules Business rules enable developers to implement logic on data stored in Common Data Service. Because the rules apply to the data, and not to a specific app, they take effect however the data is used. For example, if the value of the Country field in an entity is entered as Canada, a business rule can enable a six-digit alphanumeric Postal Code field and hide the five-digit numeric Zip Code field used for U.S. addresses. Business rules consist of conditions and actions. Conditions are circumstances that must be met for the rule to apply, and actions are theRead More →

Describe the Common Data Model (CDM) As discussed earlier in this chapter, Common Data Service can function as a database for the Power Platform tools, as well as for Dynamics 365. While Common Data Model sounds similar to Common Data Service, it is not the same thing. CDM is not a database manager or any sort of data storage technology. Instead, the Common Data Model (CDM) is a Microsoft initiative that defines a shared data language, consisting of a unified system of schemas and metadata. The objective behind CDM is to create a standardized format for data sharing and storage that allows applications and servicesRead More →

Skill 2.2: Describe connectors Connectors are the Power Platform components that allow Power Apps and Power Automate to interact with outside applications, services, and data files and utilize their data. Well over 200 public connectors are available to Power Platform users, and for those applications and services that are not supported, it is possible for developers to create custom connectors. A connector is a proxy wrapper that Power Platform tools use to access an application programming interface (API) provided by an application or service. Many applications and cloud services have the necessary APIs, and the Power Platform connectors function as proxies, or intermediaries between theRead More →

Identify use cases for custom connectors As mentioned earlier, a connector is a wrapper that surrounds a REST API supplied by the application or service that will be the data source. Power Platform provides connectors for a great many applications or services, but certainly not for every one. For developers that require access to data sources for which there are no public connectors available, it is possible for them to create their own custom connectors. When a developer creates a custom connector, it is part of the current working environment and is usable only by the apps and flows operating in that same environment. ItRead 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 →

Creating a new workspace The Workspaces tab in the Power BI service interface includes a Create a workspace button that opens the dialog box shown in Figure 3-33. As noted, the new workspace is now the default, so the process of creating a workspace does not automatically create an Office 365 group. FIGURE 3-33 The new Create a workspace dialog box in the Power BI service To control access to a new workspace after it is created, click the Access button to open the Access dialog box, as shown in Figure 3-34, in which you specify users and the workspace roles assigned to them. FIGURERead More →

Skill 3.2: Connect to and consume data The first step in creating Power BI content is to access the data that the developer intends to illustrate using the charts and other types of visualizations that Power BI provides. Doing so calls for the developer to establish a connection to any of the data sources that Power BI supports and to select specific data provided by that source. Power BI Desktop allows developers to connect to multiple data sources and model the data into the form needed to tell an appropriate story in the Power BI report. This skill covers how to: ■ Combine multiple dataRead More →