WorksheetsPower BI - Game 1
Total questions: 20
Worksheet time: 25mins
Which of the following data sources is not supported by Power BI Desktop?
CSV
SQL Server Database
Web
Access
None (all of them are supported)
"__________ 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 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 you want to show trends in data over time, what visualization should you use?
Ribbon chart
Bar chart
Scatter plot
Line Graph
In Power BI, the BI stands for
Business Intelligence
Business Intellectual
Board Intelligence
Board Intellectual
________ is used to show a percentage of a total.
Bar chart
Pie chart
Slicer
Card
The dashboards are created in _________ window of Power BI
Report view
Data view
Model view
None of these
All the dashboard graphics creating options in report view available in which pane?
Filter pane
Visualization pane
Data pane
None of these
Which of the following options allows you to connect the database to Power BI?
Input data
Fetch data
Get data
Browse data
Which of the following is the right way to create new columns in Power Query editor?
Create Column from Examples
Create Column based on Condition
Create Column based on Index Number
All answers are correct
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.
What is one method for creating a visual?
Drag a field from the Fields list onto the Report view canvas.
Drag a field from the Fields list onto the Visualizations pane.
Drag a field from the Fields list onto the Model view canvas.
A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be
Many to One
One to Many
Many to Many
One to One
green chart
vertical chart
line chart
column chart
What is the Power Bi file Format?
.pbi
.pbix
xls
You have two queries that contain different data with the same structure and you are required to combine them into one query. Which of the following operations should you perform?
A. Merge
B. Append
C. Combine column
D.Combine Row
Identify the chart in Power BI
Gauge Chart
Funnel Chart
Stacked Column Chart
Stacked Bar Chart
What is the main use of Power Query editor?
To create graph and charts
To share report to other users
To clean and transform data
None of the above
Power BI Query Editor does not have undo button
TRUE
FALSE
