WorksheetsLet's Be POWER
Total questions: 15
Worksheet time: 8mins
Which of the following data sources is not supported by Power BI Desktop?
(Select one or more correct answers)
R Script
SQL Server Database
Web
None (all of them are supported)
If you want to create a Dashboard, which of the following applications should you use?
Power BI Desktop
Power BI Service
Power Query
Microsoft Azure
"__________ is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel."
M Formula Language
Visual Basic
Data Analysis Expressions (DAX)
Structured query language
What is the primary benefit of using visualizations such as line charts, bar charts, and column charts in Power BI?
They require fewer resources than more complex visualizations.
Users are used to them
They are simple
You can visualize trends, identify outliers, and have a better understanding of the data.
What is the name of the following view?
Report View
Connection View
Model View
Data View
What type of relationship exists between these tables?
One to One
One to Many
Many to Many
* to *
If the company wants a visualization that is useful in displaying a series of positive and negative changes, from one value to another. Which visualization you would recommend?
Bar Chart
Waterfall Chart
Line Chart
Scatter Chart
If you want to show trends in data over time, what visualization should you use?
Ribbon chart
Bar chart
Scatter plot
Line Graph
Which of the following are not examples or cardinality?
One to Many
North to South
Dimension Table
Many to Many
What does this image represent?
A chart of the sales of a company
A pie chart
A pyramid
The participation of a company in a specific segment or market.
What is the primary purpose of Power BI?
Spreadsheet calculations
Data visualization and analytics
Word processing
Graphic design
In Power BI, what are relationships used for?
Formatting visuals
Connecting tables based on common fields
Sorting data
Creating calculated columns
Which is not a type of Filter in Power BI?
Filters on Slicer
Filters on this page
Filters on all pages
Filters on this visual
Which of the following is a way to share a report in Power BI?
Publishing to the Power BI service
Exporting to a PDF file
Sharing a link to the report
All of these options
What are the three modalities of Power BI designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively?
Desktop, service, and Mobile apps.
Tiles, visualizations, and dashboards.
Reports, dashboards, and tiles.
