PL-300: Microsoft Power BI Data Analyst part 3
Time series charts can be imported from AppSource.
Where are time series charts located? The filter pane is where all filters on visuals and pages are located. The fields pane is where all charts are located. Time series charts can be imported from AppSource.
column chart
You are creating a visualization in a Power BI report. You need to recommend which visualization to use in the report to perform a quick comparison of the current quarter sales by country. Which visualization type should you recommend? matrix column chart scatter chart gauge chart
Highlight When the interaction mode is set to "highlight", the relevant subsegments in the chart are highlighted based on the selection.
What type of visual interaction has been applied to the bar chart above? Filter Highlight Subfilter None of the above
Tooltip Tooltips, like the one shown above, are a way to add additional data when you hover over a visual.
What type of visual interaction is shown in the map above? Highlight Bookmark Drill through filter Tooltip
The scatter chart displays outliers.
What visual should be used to display outliers? The line chart is best-suited to display outliers. The clustered column chart is best-suited to display outliers. The scatter chart displays outliers.
Pinning a page is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard.
Pinning an entire report page to a dashboard ensure what? Users are seeing individual tiles displaying key results. Pinning a page is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard.
Power BI Report Builder
Power BI paginated reports are created by using which tool? Power BI Report Builder Power BI Desktop Power BI Service
SQL Server Reporting Services
Power BI paginated reports is an evolved technology that was built from which original tool? SQL Server Analysis Services Microsoft SharePoint SQL Server Reporting Services
Power BI Service
Where are the dataset-scheduled refreshes configured? Power BI Desktop Power BI Service AppSource
It gives end users more control over the data that is displayed.
What benefit does dynamic reports provide to end users? It provides static views of data that can only be manipulated by report developers. It gives end users more control over the data that is displayed.
The classification of critical content in Power BI
A key tenant of data protection is sensitivity labels, which specifies what? The classification of critical content in Power BI Access to content in the Power BI service
They save a pre-filtered view of your report Bookmarks allow you to create pre-filtered views of your reports, which you can then link to an object using it's action properties.
What do bookmarks accomplish in Power BI? They save a query for use in other reports They save a subsegment of your data table as a separate file They save a pre-filtered view of your report They save your chart as a template
Yes, dashboards can be created from multiple datasets or reports.
Can a dashboard be created from multiple reports? No, dashboards can only be created from a single dataset or report. Yes, dashboards can be created from multiple datasets or reports.
Yes, you can access the Q&A feature by selecting the Q&A button type.
Can you access the Q&A feature by using buttons? Yes, you can, but you will need to add the Q&A visual to your reporting canvas and then link your button with the visual that you have added. Yes, you can access the Q&A feature by selecting the Q&A button type. No, to use the Q&A feature, you will need to add the Q&A visual to your reporting canvas.
RangeStart and RangeEnd
What reserved parameters configure the start and end of where incremental refresh should occur? RangeStart and RangeEnd Start and End parameters StartRange and EndRange
Admins are the only role that can remove users.
How does the admin workspace role differ from other types of workspace roles? Admin is the only role that can publish or update apps. Admins are the only role that can remove users. Admin is the only role that can create, edit, or delete content in a workspace. Admin is the only role that can publish content to a workspace.
Modify the members of the app workspace. If you modify his permission to be a Member then he can Create, edit, and delete content in the workspace and Share an item or share an app.
In the Power BI service, you create an app workspace that contains several dashboards. You need to provide a user named [email protected] with the ability to edit and publish dashboards. What should you do? Modify the members of the app workspace. Configure security for the dataset used by the app. Share the dashboard, and then modify the Access settings of the dashboard. From the app workspace, click Update app, and then configure the Access settings.
The Analyze feature allows a user to understand why the distribution of data looks the way it does.
What Power BI feature can give an in-depth analysis of the distribution of data? The Next Level of Hierarchy feature can give in-depth analysis because it will allow you to drill down for all subcategories and is not used to analyze the distribution. The Analyze feature allows a user to understand why the distribution of data looks the way it does. Only time series analysis can provide in-depth analysis on the data.
Drill through filters Drill through filters allow users to jump to different report pages (like bookmarks), while simultaneously filtering based on the specific item selected.
What allows users to jump to different report pages while simultaneously filtering based on the specific item selected? Drill through filters Tooltips R visuals Page filters
AI splits work by considering all the available fields and determining which one to drill into to get the highest/lowest value of a measure that is being analyzed.
What does the AI splits feature do? AI splits work by considering all the available fields and determining which one to drill into to get the highest/lowest value of a measure that is being analyzed. AI splits work by considering all available fields and determining which one to drill into to get the highest/lowest value of the measure that is being analyzed. AI splits only display the difference between highest and lowest value of the measure that is being analyzed.
Conduct what-if analysis with built-in parameters.
What does the decomposition tree not enable you to do? Conduct root cause analysis to understand a measure better. Conduct what-if analysis with built-in parameters. Automatically analyze selected dimensions to find where a measure is highest or lowest.
The Q&A feature
What feature allows you to ask a natural-language query about the data? The synonym feature The smart narrative visual The Q&A feature
Lineage view
What feature in Power BI service can you use to troubleshoot the flow of data from its source to destination? Usage metrics report Query caching Quick insights Lineage view
Data classification
What feature in dashboards is used to alert consumers to the sensitivity of the data? Dashboard themes Data classification
A canvas of report elements that can be built in the Power BI service.
What is a dashboard? A canvas of report elements that can be built in Power BI desktop. Dashboards can be built by using visuals that are developed with an underlying data source. A canvas of report elements that can be built in the Power BI service. The canvas in which you can view the data model of a report.
You can stream data and update dashboards as soon as the data is logged.
What is a key benefit of Power BI's real-time streaming capabilities? Users are limited to the data refresh as established by the developer. You can stream data and update dashboards as soon as the data is logged.
Searching for help topics about Power BI.
What is not a feature of the Q&A feature? Searching for help topics about Power BI. Adding new synonyms to fields through Q&A tooling. Converting a Q&A answer into a visual inside your report.
In reports, you can have multiple pages; in dashboards, you can have only one page.
What is one way that reports and dashboards differ? In reports, you can have multiple pages; in dashboards, you can have only one page. In reports, you can use the slicers and filter by selecting a data point on a visual; in dashboards, you can only filter a dashboard tile in focus mode, but can't save the filter. You can only build reports and dashboards in Power BI service. They are the same.
A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, etc.
What is the best description of a workspace? A workspace is a feature in Power BI service that allows you to view reports only. A workspace is a feature that allows you to view and edit the data model, build visualizations, and transform the data. A workspace is a feature of Power BI Desktop that allows you to build reports only. A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, etc.
Apps Reports are best for individuals, dashboards are best for teams, and apps are best for organizations.
What is the best sharing option for organizations? Reports Dashboards Apps Spreadsheets
Promotion does not need specific permissions while Certification requires permission from the dataset owner to access the dataset.
What is the difference between Promotion and Certification when endorsing a dataset? Promotion is for broad usage while Certification needs permission granted on the Admin Tenant settings. Promotion does not need specific permissions while Certification requires permission from the dataset owner to access the dataset.
150,000 rows R plots are limited to 150,000 rows
What is the row limit when creating R visuals? 100,000 rows 150,000 rows 500,000 rows 1,000,000 rows
What-if
What type of parameter provides a look at how different scenarios might play out? What-if If-then
Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.
Where can you configure and set alerts? Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards. Data alerts can be set in both Power BI service and Power BI Desktop on any kind of visual. Data alerts can be set in Power BI service on any kind of visual. Data alerts can be set only in Power BI Desktop on specific kinds of visuals such as KPI cards and gauges.
Importing custom visuals Importing custom visuals from files, your organization, or the AppSource marketplace requires you to sign in to Power BI.
Which of the following actions requires you to be signed in to Power BI? Importing custom visuals Linking bookmarks Editing report interactions All of the above
Set permissions for one member at a time Azure Active Directory security groups allow you to manage an entire group of users instead of a list of individual users. One of the benefits is that they allow you to set permissions for all members of a group at once.
Which of the following is NOT a benefit of Azure Active Directory security groups? Manage member and computer access to shared resources Create specific security policies for different groups Set permissions for one member at a time Manage user access when people leave and join teams
All of the above The Pin Live Page option pins an entire report to a dashboard while also importing slicers, preserving functionality, and reflecting any updates to the report.
Which of the following is a benefit of pinning a live page? Slicers are imported Functionality is preserved Updates to the report are reflected All of the above
Drill through Report interactions allow you to define how filters applied to one visual impact the others. The options are: filter, which produces a fully filtered chart; highlight, which produced a chart that highlights the filtered segments; and none, in which the chart remains unfiltered. Drill through is a separate type of filter.
Which of the following is not an option when editing report interactions? Filter Highlight None Drill through
Admin Admins have all the rights from Viewers, Contributors, and Members, plus the ability to update & delete workspaces and add or remove other users.
Which of the following is the highest level of permissions when sharing workspaces? Admin Member Contributor Viewer
Slicers Slicers cannot be pinned to a dashboard individually, they need to be pinned as part of a live page.
Which of the following objects cannot be pinned as an individual tile to a dashboard? Filled Maps Tables Slicers Bar Charts
All of the above These are all part of Power BI's different accessibility features that allow consumers to easily navigate reports.
Which of the following options is part of Power BI's accessibility features? Themes Layer order Tab order All of the above
They allow the user to control aspects of how the report is rendered when the report is run.
Why are parameters important in Power BI paginated reports? They are required so that Power BI can call the paginated report. They allow the report developer to control the refresh interval of the report. They allow the user to control aspects of how the report is rendered when the report is run.
Convert the list to a table. Expand the columns. Set the data types.
You are building a dataset from a JSON file that contains an array of documents. You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports. Which three actions should you perform in sequence? Actions Expand the columns. Expand the records. Add columns that use data type conversions. Set the data types. Convert the list to a table.
Filter the bar charts by using the slicer, and then create bookmarks. You can use bookmarks to keep track of your own progress in creating reports (bookmarks are easy to add, delete, and rename) and you can create bookmarks to build a PowerPoint-like presentation that steps through bookmarks in order, thereby telling a story with your report.
You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What should you do before you publish the report? Configure report level filters, and then create groups that use the List group type. Configure drillthrough filters for each bar chart, and then select Selection Pane. Filter the bar charts by using the slicer, and then create bookmarks. Configure page level filters, and then create groups that use the Bin group type.
Pin the report page as a live tile. One way to add a new dashboard tile is by pinning an entire report page. This is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard. And changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile as well.Pinning live tiles from reports to dashboards is only available in Power BI service (app.powerbi.com).
You are creating a dashboard by using the Power BI service.You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do? Edit interactions in the report and set all interactions to Filter. Pin each chart as a tile. Edit the dashboard theme and pin each chart as a tile. Pin the report page as a live tile.
the tab order If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader.You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power BI Desktop? the tab order the layer order the bookmark order the X position
CALCULATE( DATESBETWEEN
You are enhancing a Power BI model that has DAX calculations. You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? Sales PYTD = VAR startyear = STARTOFYEAR ( PREVIOUSYEAR ('Date' [DATE] )) VAR enddate = LASTDATE (Sales [Date] ) - 365 RETURN CALCULATE( DATESBETWEEN( SAMEPERIODLASTYEAR( SLIM( (SALES[SALES] ), CALCULATE DATESBETWEEN SAMEPERIODLASTYEAR SLIM ( 'Calendar' [Date], startyear, enddate ) )
Customers in Austria order 18.8 more units than the average order quantity. Average quantity of units is displayed. Not B: Average quantity of units is displayed, not percentage.
You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field: - Customer Country - Product Category - Supplier Country - Sales Employee - Supplier Name - Product Name - Customer City The key influencers visual returns the results shown in the following exhibit (see image). What can you identify from the visual? Customers in Austria order 18.8 more units than the average order quantity. Customers in Boise order 20.37 percent more than the average order quantity. Product Category positively influences the quantity per order. Customers in Cork order lower quantities than average.
Convert the visualization to a different type. KPI doesn't have SORT option. You need to start over again. Converting to different visual type just in order to view the month sequence, and then go to Table View, selecting the month column, and click "Sort by column" under Ribbon Tab "Table Tools", selecting the "Sort by Month #", and back to Visual interface, check the result (month(text) sequence), if ok, convert back to KPI visual. Key Note: Once you convert the visualization to a KPI, there's no option to sort. You must sort it correctly now.
You create a KPI visualization in Power BI Desktop that uses the month as the trend axis.You discover that the data is not sorted by month. You need to change the sort order of the visualization.What should you do first?
Pin the KPI to a dashboard. Alerts can only be set on tiles pinned from report visuals, and only on gauges, KPIs, and cards.
You create a report in the Power BI service that displays the following visualizations: - A KPI that displays the count of customers - A table that displays the count of customers by country - A line chart that displays the count of customers by year You need to receive an alert when the total number of customers reaches 10,000. What should you do first? Pin the line chart to a dashboard. Pin the KPI to a dashboard. Embed the report into a Microsoft SharePoint page. Pin the report to a dashboard.
Publish the report to the web. In the blog post, use the embed code URL. After you create your Publish to web embed code and share it, the report is updated with any changes you make, and the embed code link is immediately active. Anyone who opens the link can view it. After this initial action, however, updates to reports or visuals can take approximately one hour before becoming visible to your users.
You create a report in the Power BI service. You plan to provide external users with access to the report by publishing the report to a public blog. You need to ensure that the report in the blog post will be updated as the data is refreshed. What should you do in the Power BI service? Publish the app workspace to the entire organization. In the blog post, use the URL of the workspace. Share the report. In the blog post, use the URL of the dashboard. Publish the report to the web. In the blog post, use the embed code URL. In the blog post, use the URL of the report.
Add other users as members Purchase Power BI Premium Free users can't access other app workspaces but only if the workspace is backed up by a premium license.
You create an app workspace named Wingtip Sales. Wingtip Sales is configured as shown in the following exhibit (see first image). Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. The one task that Austin is permitted to perform, but the other members are not permitted to perform, is [answer choice]. add other users as members create a new dashboard pin a report visualization to a dashboard publish a PBIX file To make the content in Wingtip Sales available to users who have the free Power BI license, you must first [answer choice]. add all the users as workspace members change the app workspace from Private to Public purchase Power BI Premium
Modify the members of the app workspace. Users or groups need access to both the SharePoint Online page and the report in the Power BI app to see the report on the SharePoint page.
You embed a Power BI report in a Microsoft SharePoint Online page. A user named User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available." User1 is unable to view the report. You verify that you can access the SharePoint Online page and that the Power BI report displays as expected. You need to ensure that User1 can view the report from SharePoint Online. Publish the app workspace. Share the dashboard in the app workspace. Edit the settings of the Power BI web part. Modify the members of the app workspace.
Configure the app workspace for Premium capacity. In this instance Power BI Premium is nearly twice cheaper than Pro licenses for 1000 users.
You have a Microsoft SharePoint Online site named Sales. Your company has 1,000 sales users. All the sales users can access Sales. You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part. You need to ensure that all the sales users can view the report from the Sales site. What should you do? Configure the Portal Site Connection for the Sales site. Enable anonymous access for the Sales site. Configure the app workspace for Premium capacity. Disable the Embed content in apps setting from the Tenant settings in Power BI.
From the app workspace settings, add a member. All the members of a workspace can automatically see the APP related to this workspace. So, we should add USER1 as a member is this workspace.
You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private. A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account. You need to ensure that User1 sees App1 from the My organization AppSource. What should you do? From the app workspace, click Update app, configure the Access setting, and then click Update app. From the app workspace, share the dashboard. From the app workspace settings, add a member. From the app workspace, click Update app, configure the Content settings, and then click Update app.
an alert
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:A line chart that shows the number of defective products manufactured by day. - A KPI visual that shows the current daily percentage of defective products manufactured. You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create? a Q&A visual a subscription a smart narrative visual an alert
Total Sales = SUM('Sales'[Total Sales Amount])
You have a Power BI data model that contains the following three tables: - Sales - Date - Product The Sales table is related to the Date and Product tables by using many-to-one relationships. The Sales table contains a column named Total Sales Amount. You need to create a measure named Total Sales that can be used in visuals to aggregate Total Sales Amounts by product or by date. What should you use? Total Sales = SUM('Sales'[Total Sales Amount]) Total Sales = ALL('Sales'[Total Sales Amount]) Total Sales = MAX('Sales'[Total Sales Amount]) Total Sales = CALCULATE([Total Sales])
Publish the reports in an app and grant the HR managers access permission. Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers? Publish the reports to a different workspace other than the one hosting the datasets. Publish the reports in an app and grant the HR managers access permission. Add the HR managers as members of the existing workspace that hosts the reports and the datasets. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Change the dashboard theme.
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit (see first image). You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit (see second image). What should you do? Edit the details of each tile. Change the report theme. Change the dashboard theme. Create a custom CSS file.
not affect cross-filter
You have a report page that contains the visuals shown in the following exhibit (see image). Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Answer Area: Selecting a quarter on the line chart will [answer choice] the clustered column chart. cross-filter cross-highlight not affect Selecting a data point on the Tailspin Toys line on the line chart will [answer choice] the map. cross-filter cross-highlight not affect
Replace the slicers with report-level filters. Sync the slicers across the pages. A: Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter. B: You can sync a slicer and use it on any or all pages in a report. 1. On the Power BI Desktop View menu, select Sync slicers. The Sync slicers pane appears between the Filters and Visualizations panes.
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values in a slicer on one page, the selections are not persisted on other pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Replace the slicers with report-level filters. Sync the slicers across the pages. Create a bookmark for each slicer value. Replace the slicers with page-level filters. Replace the slicers with visual-level filters.
Rules
You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort: - For values that are greater than or equal to 100, the font of the data label must be dark red. - For values that are less than 100, the font of the data label must be dark gray. Which type of format should you use? Color scale Rules Field value
Pin the report as a live page.
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year. You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year. What should you do? Pin each visualization to the dashboard, and then add a web content tile. Add a page level filter, and then pin each visualization to the dashboard. Publish the app workspace. Pin the report as a live page.
Total Sales Occupation City
You have a table that contains the following three columns: - City - Total Sales - Occupation You need to create a key influencers visualization as shown in the exhibit. How should you configure the visualization? Answer Area: Analyze: City Occupation Total Sales Explain by: City Occupation Total Sales Expand by: City Occupation Total Sales
From the Office 365 Admin center, click Groups.
You have an app workspace named Retail Store Analysis in the Power BI service. You need to manage the members that have access to the app workspace using the least amount of administrative effort. What should you do? From the Office 365 Admin center, click Users. From the Power BI Admin portal, click Tenant settings. From the Power BI Admin portal, click Usage metrics. From the Office 365 Admin center, click Groups.
Microsoft Information Protection sensitivity labels
You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use? comments tiles Microsoft Information Protection sensitivity labels Active Directory groups
sum of the StoreID values the Sales table and the Customer table
You have the Power BI data model shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Answer Area When a table visual is added to a blank report page and populated by using the StoreID field from the Sales table, a [answer choice] is displayed. distinct count ofthe StoreID values list of all the StoreID values list of the distinct StoreID values sum of the StoreID values Adding a page filter of Sales[StoreID] = 1 will filter the values displayed on the page from [answer choice]. all the tables related to the Sales table only the Sales table only the Store table the Sales table and the Customer table
Add a Top N filter to the visual. Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales. Note: 1. Select the Column you want to display the Top Sales Profit 2. Then change the Filter Type of that Column to Top N 3. Fill in Top / Bottom number field 4. And lastly drag to the By Value filed your Sales Profit Incorrect Answers: B: You would need a filter as well.
You have the dataset shown in the following exhibit (see image). You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do? Add a Top N filter to the visual. Configure the Sales Profit measure to use the RANKX function. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
New Parameter 0.5
You have the report shown in the following exhibit (see image). Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Discount [Discount] was created by using the [answer choice] command. New Column New Measure New Parameter New Table The maximum value for the Discount slicer is [answer choice]. 0.1 0.5 1 50
From the Modeling tab, change the Data Type to Percentage. Go to "Table View" Modeling ribbon tab, change the Data Type to "percentage" and keep 2 decimal.
You have the visualization shown in the following exhibit (see first image). You need to display the values as shown in the following exhibit (see second image). What should you do? Create a calculated column that adds the % symbol to the values. From the Modeling tab, change the Data Type to Percentage. Edit the query of the data source and change the Data Type to Percentage. Create a measure that adds the % symbol to the values.
Report1 and Report3 Report1, Report2 and Report3
You have three Power BI Desktop projects named Report1.pbix, Report2.pbix, and Report3.pbix that have the following characteristics: - Report1.pbix contains a custom visualization. - Report2.pbix implements row level security. - Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery. Which reports support Publish to Web, and which reports can be published to Power BI Report Server? Reports Report1 only Report3 only Report 1 and Report3 Report2 only Report 1 and Report2 Report2 and Report3 Answer Area Reports that support Publish to web: Reports that can be published to Power BI Report Server:
Add a custom streaming data tile to a dashboard. For pubnub data, we can visualize it using data tile on dashboard and configure pubnub as data source.
You need to create a dashboard in the Power BI service to display data from a PubNub source. Add a Microsoft SQL Server Analysis Services (SSAS) data source that uses Connect live and create a report. Pin the report to a dashboard. Create an app workspace and publish the workspace to a dashboard. Add a Microsoft Azure SQL database data source that uses DirectQuery and create a report. Pin the report to a dashboard. Add a custom streaming data tile to a dashboard.
Background color Rules
You need to create a visual as shown in the following exhibit (see first image). The indicator color for Total Sales will be based on % Growth to Last Year.The solution must use the existing calculations only. How should you configure the visual? Answer Area Conditional formatting: Background color Data bars Font color Icons Web URL Format by: Color scale Field value Rules
Background color Rules The existing calculation refers to the measure "% Growth to Last Year" and not about an extra column with the color nameReference:
You need to create a visual as shown in the following exhibit. The indicator color for Total Sales will be based on % Growth to Last Year.The solution must use the existing calculations only.How should you configure the visual? Answer Area Conditional formatting: Background color Data bars Font color Icons Web URL Format by: Color scale Field value Rules
Member A Member can add members or others with lower permissions.
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Viewer Contributor Member Admin
Clear the visual cache. Clear the data engine cache.
You need to use Performance Analyzer in Power BI Desktop to review the performance of report elements. Which two tasks should perform before you start the recording from Performance Analyzer? Clear the visual cache. Clear the data engine cache. Open the Selection pane. Refresh the dataset.
Column quality
You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select? Show whitespace Column profile Column distribution Column quality
pricing tier from the Azure portal must use the app owns data model On image (Power BI Embedded) option is selected.
You open the Power BI Admin portal as shown in the following graphic. All the app workspaces use the customer's capacity. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. You can scale up the customers capacity by changing the [answer choice]. pricing tier from the Azure portal settings of the workspace subscription from the Office 365 admin center Teant settings from the Power BI Admin portal When designing a custom application that embeds reports from the customers capacity the developer [answer choice]. can use both the user owns data model and the app owns data model must use the app owns data model must use the user owns data model
Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown? Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,Sales[Total Sales],0.40) Add a new percentile line that uses Total Sales as the measure and 40% as the percentile. Create a horizontal line that has a fixed value of 24,000. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,Sales[Total Sales],0.40)
Configure the app workspace for Premium capacity. With pro you can only refresh data 8 time a day while with premium its 48 time which is every 30 minutes.
You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What should you do? Assign each user a Power BI Pro license. Store the dataset in Microsoft Azure Storage that uses the Premium storage tier. Create the app workspace by using an account that is assigned a Power BI Pro license. Configure the app workspace for Premium capacity.
Visual 2 Visual 4
You plan to embed multiple visualizations in a public website.Your Power BI infrastructure contains the visualizations configured as shown in the following table. Which two visualizations can you embed into the website? Each correct answer presents a complete solution. Visual 1 Visual 2 Visual 3 Visual 4 Visual 5
From the Visualization Pane, select Get More Visuals.
You plan to visualize your data using a Word Cloud visual from AppSource.You need to add the visual to your report page. What should you do? From the Visualization Pane, select Get More Visuals. From the Visualization Pane, select Import a visual from a file. Add a Python visual to the report page. Add a Paginated report visual to the report page.
Enable R Scripting on the computer that has Power BI Desktop installed. Download and install Microsoft R on the computer that has Power BI Desktop installed.
You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization. Which two actions should you perform? Download and install Microsoft R Server. Download and install RStudio Server on the computer that has Power BI Desktop installed. Install SQL Server R Services on the server that runs SQL Server. Enable R Scripting on the computer that has Power BI Desktop installed. Download and install Microsoft R on the computer that has Power BI Desktop installed.
Too many records were sent to the visual. R visuals in the Power BI service have a few limitations including: - Data size limitations data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.
You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue? The visual was built by using a different version of R. The data comes from a Microsoft SQL Server source. The data is deduplicated. Too many records were sent to the visual.
Go to dev.powerbi.com/apps and register an application.
Your company has a custom line-of-business application named SalesApp. The developers of SalesApp want to push data into the Power BI service to create several visualizations. You need to ensure that the developers can push the data from SalesApp to the Power BI service. What should you do? Go to portal.azure.com and create a web app. Go to dev.powerbi.com/apps and register an application. Go to app.powerbi.com/admin-portal and click Publish to web. Go to app.powerbi.com and create an app workspace.
Create a new group on the state column and set the Group type to List. List is used to create string groups. Bin is used to create numeric groups.
Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do? Create a new aggregation that summarizes by employee. Create a new group on the state column and set the Group type to List. Create a new group on the state column and set the Group type to Bin. Create a new aggregation that summarizes by state.
Create a workspace for development and a workspace for production. From the production workspace, publish an app. Use different work stages (Development, Test, and Production). Deploy from the Development workspace.
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets. What should you recommend? Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace. Create one workspace for development. From the new workspace, publish an app for production. Create a workspace for development and a workspace for production. From the production workspace, publish an app. In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
Power BI(free) Power BI PRO Power BI PRO
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks: - Access a published Power BI app. - Modify reports in an app workspace. - Share dashboards created in My Workspace. You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) license, whenever possible. Which license should you identify for each task? Answer Area Access a published Power BI app: Power BI(free) Power BI PRO Modify reports in an app workspace: Power BI(free) Power BI PRO Share dashboards created in My Workspace: Power BI(free) Power BI PRO
From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. You need to run the following cmdlet: Set-MsolCompanySettings -AllowAdHocSubscriptions $true
Your organization has a Microsoft Office 365 subscription. When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit (see image). You need to ensure that all the users can access the Power BI service. What should you do first? From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user. From the Power BI Admin portal, modify the Tenant settings. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. From the properties of each dashboard, modify the Share dashboard settings.
From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. The Set-MsolCompanySettings cmdlet is used to set company-level configuration settings.
Your organization has a Microsoft Office 365 subscription.When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. You need to ensure that all the users can access the Power BI service. What should you do first? From the properties of each dashboard, modify the Share dashboard settings. From Microsoft Azure PowerShell, run the Set-MsolDomain cmdlet. Instruct each user to install Microsoft Office 2016. From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. From Power BI Admin portal, modify the Tenant settings. From the Microsoft Azure Active Directory admin center, assign a Power BI (free) license to each user. From the Power BI Admin portal, modify the Privacy Settings.
