Test Flashcards

You intend to build a report with Power BI Desktop, which is optimized for Power BI Report Server. Power BI Report Server will be used to publish the report. You must ensure that users can consume all of the report's visualizations. Which of the following two types of visualizations should you leave out of the report?

Answer: R visuals

When optimizing a Power BI report for Power BI Report Server, it's crucial to avoid visualizations that require external components or are not fully supported without additional configuration. R visuals (A) require an R engine and specific R packages to be installed and configured on the Report Server, which is often not feasible or straightforward. 'Breadcrumbs' (C) is not a standard Power BI visualization; if it refers to a custom visual, many custom visuals from AppSource may not be fully compatible with or easily deployable to Power BI Report Server, potentially hindering consumption.

You have ten dashboards in your workplace. Sales Data is a dashboard that shows data from two sources. You realize that users can't find what they're looking for. Natural language queries are used to populate the dashboard with data. You must ensure that consumers may utilize natural language searches to find data. What are your options?

Answer: Modify the Q&A and Cortana settings in the datasets' properties

Natural language queries (Q&A) in Power BI rely heavily on the underlying dataset for accurate responses. To ensure users can effectively find data using Q&A, you must modify the Q&A and Cortana settings within the properties of the relevant datasets. These settings allow you to define synonyms, suggest questions, and configure field properties, all of which enhance the Q&A engine's ability to understand and respond to user queries.

You have a Power BI dashboard that shows several sales representations for your company. On the dashboard, you enable Q&A. When using Q&A, you should present users with sample questions to ask. From the Power BI Settings, which settings should you change?

Answer: Datasets

The Q&A feature in Power BI is powered by the underlying datasets that feed the dashboard. To present users with sample questions and improve the overall Q&A experience, you need to configure these settings at the dataset level. Within the dataset's properties in the Power BI service, you can define suggested questions, add synonyms, and manage other Q&A-related options to guide users in their natural language queries.

You have a Microsoft Excel spreadsheet with a Sales table in it. The Sales table must be added as a tile to a Power BI dashboard. What is the best way to set up the tile?

Answer: Pin the table from the Power BI tab in Excel

The most efficient way to add a table from an Excel spreadsheet as a tile to a Power BI dashboard is by using the Power BI tab (or add-in) directly within Excel. This feature allows users to select a range, chart, or table in their Excel workbook and 'Pin' it to an existing Power BI dashboard. This creates a live tile that updates as the Excel data changes, without requiring a full import of the workbook into the Power BI service.

You've created a Power Pivot model with a KPI. As illustrated in the exhibit, you must develop a visualization based on the Power Pivot model. (Select Exhibit from the drop-down menu.) Which visualization technique should you employ?

Answer: KPI

To develop customized visualizations for Power BI, developers utilize the Power BI Custom Visuals SDK. This SDK relies on Node.js and its package manager (npm) for setting up the development environment, managing dependencies, and building the visual. Therefore, installing Node.js is a fundamental prerequisite and typically the very first step in the custom visual development process.

The visualization in the following display is available to you. The values must be displayed as shown in the following exhibit. What are your options?

Answer: Create a metric that includes the percent sign in the values

When displaying values as percentages, especially if the raw data is not already in a decimal format (e.g., 0.5 for 50%), creating a measure (metric) provides the most control. A measure can perform necessary calculations (like dividing by 100 if the raw data is '50' for 50%) and then apply specific formatting to ensure the percent sign is correctly included in the displayed value. While changing the data type to Percentage (Option D) works for decimal values, a metric offers greater flexibility for various data inputs and precise display requirements.

To display data from a PubNub source, you must create a dashboard in the Power BI service. What are your options?

Answer: A custom streaming data tile can be added to a dashboard

To display real-time data from a streaming source like PubNub directly on a Power BI dashboard, the appropriate method is to add a custom streaming data tile. Power BI supports streaming datasets that can connect to various real-time data feeds. These tiles are specifically designed to visualize constantly updating data streams directly on a dashboard, providing immediate insights without needing a full report.

You create a table named Sales from the Home tab in Power BI Desktop by clicking Enter Data. When you add Region and Sales to a visualization, the following data appears. Why are there just four rows of data in the visualization instead of six?

Answer: the Default Summarization on Region

If you have 6 rows of data but a visualization shows only 4 rows for 'Region' and 'Sales', it implies that there are duplicate region entries in your original 6 rows, and the visualization is grouping by distinct regions. While Power BI visuals inherently group categorical data, the 'Default Summarization on Region' being set to 'Count (Distinct)' (or similar aggregation for text fields) would explicitly cause the visual to display only the unique region values, thus reducing the number of displayed rows from the total raw data count.

For Power BI, you'll need to make a customized visualization. What do you think should be the first thing you install?

Answer: Node.js

Developing custom visualizations for Power BI requires a specific development environment. The Power BI Custom Visuals SDK, which is essential for creating these visualizations, relies on Node.js and its package manager, npm. Therefore, installing Node.js is the foundational step and the first thing you need to set up before you can begin developing custom visuals.