DRAG DROP -
You are designing reports for a pharmacy. The pharmacy uses Dynamics 365 Sales.
Match each tool to the reporting requirements.
Instructions: To answer, drag the appropriate tool from the column on the left to the requirements on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Reference:
https://docs.microsoft.com/en-us/powerapps/user/export-excel-dynamic-worksheet
The first question should be PowerBI because: - Users are stakeholders. I assumed that they don't have a Dynamics license. - Updated Excel (not static) needs the license to refresh any time you open the document. - In PowerBI you can grant access to external users. Therefore, I would go with PowerBI.
1)Power BI 2)D365 Sales dashboard
pretty sure first one is power bi.
It says Business data not reports Excel is the included option in dynamics, so the first choice would be excel
[ business data ] appear in <Reports>
Export your app data to an Excel dynamic worksheet to get the most up-to-date information from your app. When you export your data to an Excel dynamic worksheet and then make changes to your data in the app, you can use the refresh feature in Excel to get the latest information from the app. because of this then the choice should be Excel
in case of dynamic excel, one would still need license to environment which is clearly not available in the scenario. Hence would go with Power BI instead.
It does not say Dynamic or Static, so Excel is a bit unclear. PowerBI will show data that you are authorised to see in D365, so, if you do not have D365, then you will see nothing. Plugin won't help, Dashboard requires the license. So, the closest correct answer is Excel
ChatGPT said the 2nd Question is also Power BI??
1) PowerBI
Here’s how Copilot would match the tools to the reporting requirements: Power BI: This tool is ideal for stakeholders who do not have access to the environment but need to view up-to-date business data. Power BI can connect to Dynamics 365 Sales, extract data, and present it in a visually appealing and easy-to-understand format. Reports can be shared with stakeholders who can view them on any device. Dynamics 365 Sales Dashboard: This tool is perfect for pharmacists who need a list of the number of orders filled and to fill the next day, week, and month as well as a list of prescription drugs that are out of stock. The dashboard provides real-time data and can be customized to show specific metrics, making it easy for pharmacists to track and manage orders.
from the link mentioned to share the dynamic excel with someone, he should be in the same domain, so the first point is PowerBI (You can email a dynamic Excel file or store it as a shared file if the recipients are in the same domain as you. When recipients open the dynamic file, they only see the data that they have permission to view.)