1In the context of Dashboard Design Framework, what is the 'Z-pattern' regarding reading flow?
A.The eye scans from the bottom-left to top-right
B.The eye scans from the top-left to top-right, then diagonally down, then across the bottom
C.The eye focuses only on the center of the screen
D.The eye reads data tables vertically first
Correct Answer: The eye scans from the top-left to top-right, then diagonally down, then across the bottom
Explanation:
The Z-pattern describes the natural route the human eye travels when viewing a screen, suggesting that key high-level insights should be placed at the top.
Incorrect! Try again.
2What is the primary purpose of sketching a dashboard layout before building it in Power BI?
A.To write DAX code manually
B.To import custom visuals from the marketplace
C.To generate the data model automatically
D.To prototype the user journey and arrangement of visuals without software distractions
Correct Answer: To prototype the user journey and arrangement of visuals without software distractions
Explanation:
Sketching allows designers to plan the narrative and layout rapidly without getting bogged down by technical implementation details.
Incorrect! Try again.
3Which Power BI object is best suited for displaying a single key performance indicator (KPI), such as 'Total Revenue'?
A.Scatter Plot
B.Table
C.Pie Chart
D.Card Visual
Correct Answer: Card Visual
Explanation:
The Card visual is designed to display a single data point or aggregate value prominently.
Incorrect! Try again.
4When designing a report page, where is the 'Selection Pane' most useful?
A.Managing the layering order (z-order) and visibility of objects
B.Writing complex measures
C.Formatting axis titles
D.Importing data from SQL
Correct Answer: Managing the layering order (z-order) and visibility of objects
Explanation:
The Selection Pane allows you to control which visuals are on top of others and toggle their visibility.
Incorrect! Try again.
5Which visual type is most effective for comparing values across different categories using vertical bars?
A.Line Chart
B.Clustered Column Chart
C.Pie Chart
D.Donut Chart
Correct Answer: Clustered Column Chart
Explanation:
Column charts are standard for comparing categorical data vertically.
Incorrect! Try again.
6What is a primary use case for a Line Chart in Power BI?
A.Visualizing trends over time
B.Showing proportions of a whole
C.Displaying a single number
D.Comparing geographical density
Correct Answer: Visualizing trends over time
Explanation:
Line charts connect data points to show continuous change, making them ideal for time-series analysis.
Incorrect! Try again.
7Which feature would you use to add a static image, such as a company logo, to a report?
A.Get Data > Image
B.Insert > Image
C.Visualizations Pane > Image Chart
D.Modeling > New Parameter
Correct Answer: Insert > Image
Explanation:
The Insert tab in the ribbon provides the option to add static elements like images, shapes, and text boxes.
Incorrect! Try again.
8In a Scatter Chart, what does the 'Play Axis' feature allow you to do?
A.Filter the data by the top 10 items
B.Drill down into the matrix
C.Change the colors of the dots
D.Animate the data changes over time
Correct Answer: Animate the data changes over time
Explanation:
The Play Axis allows users to see how the relationship between variables changes over a time dimension.
Incorrect! Try again.
9Which visual is best suited for analyzing the stages of a sales process or pipeline?
A.Tree Map
B.Area Chart
C.Funnel Chart
D.Gauge Chart
Correct Answer: Funnel Chart
Explanation:
Funnel charts display a process with sequential stages, where the width represents the value at each stage.
Incorrect! Try again.
10To display a running total or explain the change in a value from a starting point to an ending point, which chart is ideal?
A.Waterfall Chart
B.Scatter Chart
C.Pie Chart
D.Ribbon Chart
Correct Answer: Waterfall Chart
Explanation:
Waterfall charts show how an initial value is affected by a series of positive and negative values.
Incorrect! Try again.
11Where can you add a Trend Line to a Line Chart?
A.The Analytics pane (magnifying glass icon)
B.The Format pane
C.The Filters pane
D.The Fields pane
Correct Answer: The Analytics pane (magnifying glass icon)
Explanation:
The Analytics pane contains statistical overlays like trend lines, average lines, and forecast lines.
Incorrect! Try again.
12What is a prerequisite for using the 'Forecast' feature in the Analytics pane?
A.The data must be categorical
B.The visual must be a Pie Chart
C.The x-axis must contain a continuous date/time field
D.The data must contain negative values
Correct Answer: The x-axis must contain a continuous date/time field
Explanation:
Forecasting algorithms require a time-series element (continuous date axis) to predict future values.
Incorrect! Try again.
13What is the main difference between a Table visual and a Matrix visual?
A.Matrices support row and column grouping (hierarchies) similar to PivotTables
B.Tables are only for text
C.Matrices cannot display totals
D.Tables can show pictures
Correct Answer: Matrices support row and column grouping (hierarchies) similar to PivotTables
Explanation:
A Matrix visual allows for multi-dimensional analysis with row and column headers, whereas a Table is a two-dimensional grid.
Incorrect! Try again.
14In a Map visual, what does the size of the bubble usually represent?
A.The population density
B.The latitude
C.A quantitative measure (e.g., Sales Amount)
D.The geographic region area
Correct Answer: A quantitative measure (e.g., Sales Amount)
Explanation:
In a Bubble Map, the size of the circle indicates the magnitude of the measure being analyzed.
Incorrect! Try again.
15Which map visual is used to shade geographic regions (like states or countries) based on a data value?
A.Filled Map (Choropleth)
B.Dot Map
C.Scatter Chart
D.Shape Map
Correct Answer: Filled Map (Choropleth)
Explanation:
Filled Maps color the entire area of a geographic region based on data intensity.
Incorrect! Try again.
16What is the primary function of a Slicer in a report?
A.To sort the data alphabetically
B.To permanently delete data
C.To change the background color
D.To allow users to filter the data displayed on the report page interactively
Correct Answer: To allow users to filter the data displayed on the report page interactively
Explanation:
Slicers are on-canvas visual filters that let users narrow down the portion of the dataset being shown.
Incorrect! Try again.
17Which option allows a single slicer to filter visuals across multiple pages of a report?
A.Bookmarks
B.Selection Pane
C.Sync Slicers
D.Drillthrough
Correct Answer: Sync Slicers
Explanation:
The Sync Slicers pane allows a designer to synchronize slicer selections across different report pages.
Incorrect! Try again.
18Which filter type would you use to show only the 5 products with the highest sales?
A.Top N Filtering
B.Advanced Filtering
C.Basic Filtering
D.Drill-down
Correct Answer: Top N Filtering
Explanation:
Top N filtering allows you to filter for the top or bottom number of items based on a specific measure.
Incorrect! Try again.
19Conditional Formatting can be applied to which aspects of a Table or Matrix?
A.Only the font style
B.Only the column width
C.The query dependencies
D.Background color, font color, data bars, and icons
Correct Answer: Background color, font color, data bars, and icons
Explanation:
Power BI allows extensive conditional formatting on cell backgrounds, fonts, and the addition of visual indicators like bars and icons.
Incorrect! Try again.
20What does 'Diverging' colors mean in the context of Conditional Formatting?
A.Using only black and white
B.Using random colors
C.Making the text invisible
D.Using a three-color scale (e.g., Red, Yellow, Green) to represent low, middle, and high values
Correct Answer: Using a three-color scale (e.g., Red, Yellow, Green) to represent low, middle, and high values
Explanation:
Diverging color scales allow you to define a center point, distinguishing effectively between negative/low and positive/high values.
Incorrect! Try again.
21Which visual is best for showing part-to-whole relationships where the total is 100%?
A.Scatter Plot
B.KPI Visual
C.Line Chart
D.Donut Chart
Correct Answer: Donut Chart
Explanation:
Donut (and Pie) charts are specifically designed to show how a whole is divided into parts.
Incorrect! Try again.
22How can you prevent a specific visual from being affected by a Slicer selection?
A.Group the visuals
B.Edit Interactions
C.Hide the visual
D.Lock the visual
Correct Answer: Edit Interactions
Explanation:
The 'Edit Interactions' feature allows you to define how visuals influence each other, including disabling filtering for specific visuals.
Incorrect! Try again.
23What is a 'Tree Map' used for?
A.Showing routes on a map
B.Forecasting future trends
C.Displaying a single text value
D.Displaying hierarchical data using nested rectangles
Correct Answer: Displaying hierarchical data using nested rectangles
Explanation:
Tree Maps display data as a set of nested rectangles, where the size and color represent data values.
Incorrect! Try again.
24If you want to add a reference line to a chart indicating a target goal of 50%, which feature should you use?
A.Trend Line
B.Forecast
C.Constant Line
D.Slicer
Correct Answer: Constant Line
Explanation:
A Constant Line in the Analytics pane allows you to draw a straight line at a specific value (e.g., a target or benchmark).
Incorrect! Try again.
25Which of the following is NOT a standard option for a Date Slicer?
A.Text Search
B.Relative Date (e.g., Last 30 Days)
C.Between
D.Before
Correct Answer: Text Search
Explanation:
While text slicers have search, date slicers specifically offer Between, Before, After, List, Dropdown, and Relative options.
Incorrect! Try again.
26What happens when you enable 'Stepped layout' in a Matrix visual?
A.The colors change to a gradient
B.All data is shown in one column
C.The matrix becomes a chart
D.Sub-categories are indented below their parent category in a single column
Correct Answer: Sub-categories are indented below their parent category in a single column
Explanation:
Stepped layout places child rows underneath parent rows in the same column, saving horizontal space.
Incorrect! Try again.
27To visualize the correlation between two numerical variables (e.g., Sales vs. Discount), which chart is best?
A.Pie Chart
B.Card
C.Scatter Plot
D.Gauge
Correct Answer: Scatter Plot
Explanation:
Scatter plots plot two numerical values against each other on X and Y axes to reveal correlations.
Incorrect! Try again.
28What is the purpose of the 'Filters Pane' in the Report View?
A.To publish the report
B.To manage filters applied to the visual, page, or entire report
C.To write SQL queries
D.To hold all the visual elements
Correct Answer: To manage filters applied to the visual, page, or entire report
Explanation:
The Filters Pane provides a centralized location to view and modify the scope of data filtering at three different levels.
Incorrect! Try again.
29What acts as a container for visuals in Power BI?
A.The Model View
B.The Canvas
C.The Ribbon
D.The Query Editor
Correct Answer: The Canvas
Explanation:
The report canvas is the blank area where visuals are placed and arranged.
Incorrect! Try again.
30Which feature allows you to categorize geographic data (e.g., telling Power BI that a column contains 'City' names) to improve map accuracy?
A.Sort By Column
B.Group Data
C.Data Category
D.Edit Interactions
Correct Answer: Data Category
Explanation:
Setting the Data Category (e.g., Address, City, Country) helps Bing Maps correctly identify locations.
Incorrect! Try again.
31Which visual is effectively a speedometer used to show progress toward a goal?
A.Card
B.Gauge Chart
C.Slicer
D.KPI Visual
Correct Answer: Gauge Chart
Explanation:
Gauge charts use a circular arc to display a single value within the context of a goal or target.
Incorrect! Try again.
32When designing a dashboard, what is 'White Space' (Negative Space)?
A.Empty space between visuals to reduce clutter and improve readability
B.A formatting error
C.The area where data is missing
D.The background color of the slicer
Correct Answer: Empty space between visuals to reduce clutter and improve readability
Explanation:
White space is a crucial design element that prevents the report from looking crowded and helps the user focus.
Incorrect! Try again.
33In a Combined (Combo) chart, what two chart types are typically mixed?
A.Pie and Donut
B.Map and Table
C.Scatter and Bubble
D.Line and Column
Correct Answer: Line and Column
Explanation:
Combo charts (Line and Stacked/Clustered Column) allow you to view two different measures with different scales on the same visual.
Incorrect! Try again.
34What is the benefit of using 'Data Bars' in a Table visual?
A.It turns the table into a map
B.It deletes the text
C.It sorts the table alphabetically
D.It adds a bar chart inside the cell to visualize the magnitude of the value
Correct Answer: It adds a bar chart inside the cell to visualize the magnitude of the value
Explanation:
Data bars provide a quick visual comparison of values directly within the table grid without needing a separate chart.
Incorrect! Try again.
35Which filtering scope applies to every page in the Power BI file?
A.Report level filters
B.Visual level filters
C.Page level filters
D.Drillthrough filters
Correct Answer: Report level filters
Explanation:
Report level filters (Filters on all pages) restrict data across the entire .pbix file.
Incorrect! Try again.
36How do you align multiple visuals perfectly on a page?
A.Use the 'Align' options in the Format tab
B.Change the page size
C.Drag them roughly into place
D.Write a measure
Correct Answer: Use the 'Align' options in the Format tab
Explanation:
The Format tab offers Align (Left, Center, Top, Distribute) tools to organize visuals precisely.
Incorrect! Try again.
37What is a 'Ribbon Chart' useful for?
A.Filtering data
B.Displaying a single percentage
C.Showing rank changes between categories over time
D.Showing exact values in a grid
Correct Answer: Showing rank changes between categories over time
Explanation:
Ribbon charts connect categories across time periods, highlighting which category has the highest rank (value) at any given time.
Incorrect! Try again.
38If you want to filter a visual based on whether a text field contains specific words, which filter type do you use?
A.Top N
B.Slicer
C.Basic Filtering
D.Advanced Filtering
Correct Answer: Advanced Filtering
Explanation:
Advanced filtering provides logical operators like 'Contains', 'Starts with', and 'Is not blank'.
Incorrect! Try again.
39In the context of visuals, what is a 'Tooltip'?
A.A tool to edit the data model
B.A box that appears with details when you hover over a data point
C.The axis label
D.The title of the chart
Correct Answer: A box that appears with details when you hover over a data point
Explanation:
Tooltips provide additional context or granular data when a user hovers their mouse over a specific part of a visual.
Incorrect! Try again.
40Which analytics line indicates the arithmetic mean of the data displayed?
A.Average Line
B.Constant Line
C.Min Line
D.Max Line
Correct Answer: Average Line
Explanation:
The Average Line calculates the mean of the data points currently visible in the chart.
Incorrect! Try again.
41What is the 'KPI' (Key Performance Indicator) visual specifically designed to show?
A.A map of locations
B.A large table of data
C.Value, Goal, and Trend status
D.A scatter plot correlation
Correct Answer: Value, Goal, and Trend status
Explanation:
The KPI visual shows a current value, a target goal, and a trend indicator (often colored red/green) to show performance history.
Incorrect! Try again.
42You can use 'Icons' in conditional formatting to:
A.Change the font to Wingdings
B.Insert a video
C.Play a sound
D.Display symbols (arrows, flags) indicating if data is above or below a threshold
Correct Answer: Display symbols (arrows, flags) indicating if data is above or below a threshold
Explanation:
Icon sets allow for quick visual cues (like up/down arrows) to indicate status directly in tables or matrices.
Incorrect! Try again.
43Which visual is commonly used to break down a measure by contributions of different factors (e.g., Variance Analysis)?
A.Pie Chart
B.Line Chart
C.Card
D.Decomposition Tree
Correct Answer: Decomposition Tree
Explanation:
The Decomposition Tree allows users to visualize data across multiple dimensions, aggregating data and drilling down into it in any order.
Incorrect! Try again.
44What allows you to change the orientation of a Slicer from a vertical list to horizontal buttons?
A.Changing the data type
B.The Filters Pane
C.Format Pane > Slicer settings > Orientation
D.It is not possible
Correct Answer: Format Pane > Slicer settings > Orientation
Explanation:
Changing a slicer's orientation to Horizontal creates a button-like interface often used for headers or touch-friendly reports.
Incorrect! Try again.
45What is the 'Visual Header'?
A.The set of icons (filters, focus mode, drill) that appear above a visual when hovered
B.The page footer
C.The main title text inside the chart
D.The data source name
Correct Answer: The set of icons (filters, focus mode, drill) that appear above a visual when hovered
Explanation:
The Visual Header contains utility icons for the end-user, such as drill down, focus mode, and viewing underlying data.
Incorrect! Try again.
46Why might you use a 'Background Image' on a report page with high transparency?
A.To increase file size
B.To hide the data
C.To act as a slicer
D.To provide subtle branding or texturing without distracting from visuals
Correct Answer: To provide subtle branding or texturing without distracting from visuals
Explanation:
Using high transparency allows the background to add aesthetic value (branding/structure) without making the data hard to read.
Incorrect! Try again.
47Which chart type requires a 'Location' field or 'Latitude/Longitude' fields?
A.Map Visual
B.Scatter Plot
C.Tree Map
D.Heat Map Matrix
Correct Answer: Map Visual
Explanation:
Map visuals rely on geospatial data points to plot information correctly on the earth's surface.
Incorrect! Try again.
48What is the function of the 'Format Painter' tool in Power BI Desktop?
A.It refreshes the data
B.It copies formatting settings from one visual to another
C.It creates a new visual
D.It paints the background red
Correct Answer: It copies formatting settings from one visual to another
Explanation:
Similar to Excel or Word, Format Painter copies style attributes (colors, fonts, borders) to maintain consistency.
Incorrect! Try again.
49When configuring a Line Chart, what does the 'Legend' field do?
A.It changes the background color
B.It filters the data
C.It creates a separate line for each category in the legend field
D.It adds a title
Correct Answer: It creates a separate line for each category in the legend field
Explanation:
Adding a field to the Legend bucket splits the single line into multiple lines, one for each unique value in that field.
Incorrect! Try again.
50Can you format the background color of a visual based on a measure value (e.g., Sales)?
A.Yes, using the 'fx' (function) button in formatting options
B.No, backgrounds must be static colors
C.Only in Excel, not Power BI
D.Only if the visual is a Card
Correct Answer: Yes, using the 'fx' (function) button in formatting options
Explanation:
The 'fx' button allows dynamic styling where the color changes programmatically based on data values (conditional formatting).