NEW
Font size
WorksheetsData Visualization in Power BI
Total questions: 20
Worksheet time: 10mins
What is Power BI?
A spreadsheet software
A business intelligence tool
A project management software
A video editing tool
none
Which company develops Power BI?
Microsoft
Adobe
Apple
What is the file extension of Power BI Desktop files?
.pptx
.ppcx
.pbix
.xlsx
A critical aspect of data aggregation is that it allows you to focus on
A.The important and most meaningful data
B.Disabling interactive analysis over big data
C.Larger cache size and decreased query performance
D.All of the above
This chart is used when a timeline is associated with data
Bar Chart
Box Plot
Line Chart
Tree Map
The complete design and functionality of a dashboard can be controlled by
KPI Cards
Breakers
Slicers
Groupers
What are the three core views in Power BI desktop?
Report, Data, Queries
Report, Queries, Relationships (Model)
Report, Data, Relationships (Model)
Queries, Data, Relationships (Model)
These charts are also called speedometer charts:
Gantt Charts
Gauge Charts
Sankey Charts
Line Charts
23 You need to store details about business entities Which of the following table should you use ?
A.Fact table
B.Dimension table
C.Date table
D.table
________ is used to compare the values based on the share of the area occupied
Bar chart
Pie chart
Slicer
Card
The intersection of the two axes, where Y Axis has numbers plotted, should always be zero
True
False
10 Which storage mode leaves the data at the data source?
A.Import
B.DirectQuery
C.Dual
D.None of the Above
The dashboards are created in _________ window of Power BI
Report view
Data view
Model view
None of these
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
5 The common flow of activity in Power BI is described by?
A.Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards
B.Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.
C.Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
D.Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.
________ option in the visualization pane allows you create charts and visuals with simple command and questions
Q & A
Card
Ask me
None of these
31 Which are calculated based on filters that are used by the report user?
A.Measures
B.Calculated columns
C.Calculated rows
D.Calculated tables
Which of the following selections are not best practices for naming conventions in Power BI?
Change all the values
Replace values that have integers with human readable results
Rename columns to have spaces in them
Abbreviate column names.
Which type of data visualization should you use to represent frequencies for a categorical variable?
Bar graph
Histogram
Scatterplot
Pie chart
What is cardinality?
Cardinality is the measure of unique values in a table
Cardinality is the granularity of the data
Cardinality is how long it takes for the data to load
Cardinality is a type of visual element
