NEW
Font size
WorksheetsPowerBI
Total questions: 15
Worksheet time: 8mins
A dataset that includes _ can be used to create a map visualization.
A. house numbers, street names
B. geospatial data
C. city names, country names
D. longitude, latitude
A, B, C, D
A, C, D
B, C, D
D
How do you create a chart visual in Power BI Desktop Report view?
A. Click New Visual on the Home tab.
B. Select a chart visual in the Visualizations pane.
C. Click New Visual on the Data Tools tab.
D. Select a field that contains values.
A, B, or D
B or D
B orC
A or B
What daily sales number does this DAX measure formula calculate?
CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))
running total sales in each month that starts over each month
total sales for the entire month
running total in entire year for the entire month
rolling average over 12 months of sales
You are creating a report in Power BI Desktop and want to restrict the data to records where Country="Canada". To accomplish this, what do you need to create?
a directive
a custom column
an indexed column
a parameter
. What is the primary benefit of using visualizations such as line charts, bar charts, and column charts?
They are easier to create than other visualizations.
They require fewer resources than more complex visualizations.
They are also used in Excel, so they feel familiar to users.
In Power BI service, deleted pages are available after deletion until
midnight of the day on which they are deleted
you empty the Recycle Bin
the report has been saved
You need to add a required color to a bar chart. How can you add an exact color value to an existing bar chart?
Click the color in the visual (e.g., the bars) and right-click to select the color.
You cannot select custom colors in a bar chart or related visual.
Select the value closest to this color from the color formatting options
The Excel function IF is nearly the same as which DAX function?
SWITCH
IFS
IFX
Power BI’s Publish to Web option allows you to embed visualizations within_. (Select all that apply.)
A. blog posts B. email messages C. web sites D. text messages
A, B, C
A, C, D
A, B, C, D
What can you do within the Power BI Desktop ## Query Settings pane?
A. Rename a query step.
B. Delete a query step.
C. Delete from one query step to the end.
D. Reorder the steps.
A, D
A, B, C, D
A, C, D
B, C, D
You just deleted a dashboard in the Power BI service and want to get it back. What should you do?
Press Ctrl+Z.
Select Undo from the toolbar.
You cannot undo the deletion of a dashboard.
You have a sales data source and want to relate the tables. The table that contains sales transactions is a_table that contains product information is a _ table .
dimension; fact
lookup; data
data; lookup
When you are creating a formula in the Power Query Editor, what does IntelliSense provide a list of? (Select all that apply.)
A. columns B. tables C. functions D. data sources
A, B
B, C
A, B, C,D
A, B, C
One of your data columns includes the city, state, and postal code line of a mailing address. You need to separate the fields so you can access the geospatial elements for a map visualization. What transformation should you apply?
Replace values
Split column
Modify data type
Which data type can be uploaded directly to powerbi.com?
Excel files
comma-separated value (CSV) files
Power BI Desktop files
all of these answers
