Power bi - Study guides, Class notes & Summaries

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 ...

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...

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...

Started on Sunday, 1 September 2024, 8:28 PM State Finished Completed on Sunday, 1 September 2024, 9:13 PM Time taken 45 mins 21 secs Grade 38.00 out of 50.00 (76%) Question 1 Complete Mark 1.00 out of 1.00 Flag question Question text Big data is often structured. a. TRUE b. FALSE Question 2 Complete Mark 1.00 out of 1.00 Flag question Question text Which of the following displays a snapshot of each slide? a. View Option b. Status Bar c. Title Bar d. Thumb...

Single Vision - ANSWER-corrects for one distance Multifocal - ANSWER-Corrects with two or more prescriptions (or 'powers') Bifocal - ANSWER-lens having two focus strengths Trifocal - ANSWER-pertaining to having three focus strengths Calculating Prismatic Effects - ANSWER-obtained at the center of an optical lens by producing a difference in edge thickness, either by grinding the back surface at an angle to the front surface during lens surfacing or, if the lens has sufficient power...