Power bi Guides d'étude, Notes de cours & Résumés

You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? a) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR c) DATESYTD You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category. You ...

Role Hierarchy ADMN, Member, Contributor, Viewer Admin Role All responsibilities Member Role Same as Admin but cannot assign roles, delete workspaces, or change metadata Contributor Role Can create, update, and publish and set refreshes for content and reports but cannot publish apps, delete reports change metadata or assign roles Viewer Role Can only view information Auto Date Hierarchy Day, Month, Quarter, Year Lineage View Shows last refresh and can identi...

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do? A. Grant the Read permission for the datasets to the user. B. Add the user as a Viewer of the workspace. C. Share the reports with the user. D. Create a row-level security (RLS) role and add the user to the role. E. Add the user as a member of the workspace. B You have a Power Bl workspace named...

Exam PL-300 Microsoft Power BI Data Analyst Discover Data Analysis Exam Questions and AnswersExam PL-300 Microsoft Power BI Data Analyst Discover Data Analysis Exam Questions and AnswersExam PL-300 Microsoft Power BI Data Analyst Discover Data Analysis Exam Questions and AnswersExam PL-300 Microsoft Power BI Data Analyst Discover Data Analysis Exam Questions and AnswersManage a Power BI workspace, privilege in terms of schedule data refresh - ANSWER-Admin: Mos privileged Member : privileged Co...

You are planning to configure the relationship between Chart of Accounts and Predicted Sales to meet the security requirements. You need to be able to apply the security filter in both directions. What should you do? Set the Cross filter direction option to Both You need to create a table containing unique countries, and a table of unique combinations of countries and territories. Which DAX expressions should you use? Country = VALUES ('Predicted Sales '[Country]) Territory ...

POWER BI 300 EXAM ACTUAL QUESTIONS AND ANSWERS 2024/2025 WITH COMPLETE SOLUTION

Power Bi 300 EXAM LATEST UPDATE...

You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson's Microsoft Entra ID account. You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name. Which two actions should you perform? Each correct answer presents part of the solution. Add a DAX expression to filter to the S...

Power BI Test | Questions with 100% Correct Answers | Latest Update 2024 | Verified What type of expression do you use to extract data from Microsoft SQL Server? A. DAX B. T-SQL C. MDX - B. T-SQL You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? A. Import B. Connect live C. Direct Query - B. Connect live What can you do to improve p...

Which data role enables advanced analytics capabilities specifically through reports and visualizations? -Data scientist -Data engineer -Data analyst Data analyst -A data analyst uses appropriate visuals to help business decision makers gain deep and meaningful insights from data. Which data analyst task has a critical performance impact on reporting and data analysis? -Model -Analyze -Visualize Model -An optimized and tuned data model performs better and provides a better...