Pl300 Flashcards
(180 cards)
1
Q
What is the primary purpose of Power BI?
A
To visualize and analyze data for business intelligence.
2
Q
True or False: Power BI can connect to both cloud and on-premises data sources.
A
True
3
Q
Fill in the blank: In Power BI, __________ is a collection of data sources, queries, connections, and models.
A
dataset
4
Q
What are the three main components of Power BI?
A
Power BI Desktop, Power BI Service, and Power BI Mobile.
5
Q
Which of the following is NOT a data preparation step in Power BI? a) Cleaning b) Transforming c) Visualizing
A
c) Visualizing
6
Q
What is the purpose of the Power Query Editor?
A
To transform and clean data before loading it into Power BI.
7
Q
True or False: DAX stands for Data Analysis Expressions.
A
True
8
Q
What is the primary function of DAX in Power BI?
A
To create calculated columns and measures.
9
Q
What type of data does Power BI typically use for visuals?
A
Tabular data.
10
Q
Fill in the blank: __________ is the process of creating relationships between different tables in Power BI.
A
Data modeling
11
Q
Which of the following is a valid DAX function? a) SUMIF b) AVERAGE c) COUNTROWS
A
c) COUNTROWS
12
Q
What is a measure in Power BI?
A
A calculation used in data analysis that is evaluated based on the context of the report.
13
Q
True or False: Power BI allows for real-time data streaming.
A
True
14
Q
What feature in Power BI allows for sharing reports and dashboards with others?
A
Power BI Service.
15
Q
What does the term ‘data modeling’ refer to in Power BI?
A
The process of creating a structure that defines how data is connected and organized.
16
Q
What is the difference between a calculated column and a measure in DAX?
A
A calculated column is computed row by row, while a measure is calculated based on the context of the report.
17
Q
Fill in the blank: In Power BI, __________ allows users to create interactive reports.
A
visualizations
18
Q
Which visual type is best for showing trends over time?
A
Line chart.
19
Q
What is the purpose of slicers in Power BI?
A
To filter data in reports interactively.
20
Q
True or False: You can only publish Power BI reports to the Power BI Service.
A
False
21
Q
What does the term ‘refresh’ mean in Power BI?
A
Updating the dataset with the latest data from the source.
22
Q
Which of the following is NOT a data source supported by Power BI? a) Excel b) SQL Server c) Microsoft Word
A
c) Microsoft Word
23
Q
What is the function of the ‘Edit Queries’ option in Power BI?
A
To modify and transform data before loading it into the model.
24
Q
Fill in the blank: The __________ pane in Power BI Desktop allows you to add visualizations to your report.
A
Visualizations
25
What is a tooltip in Power BI?
A small pop-up that provides additional information when hovering over a visual.
26
What is the purpose of the 'Data View' in Power BI?
To view and manage the underlying data in the model.
27
True or False: Power BI dashboards can only display data from a single report.
False
28
What does 'Publish to Web' do in Power BI?
It creates a public URL to share reports with anyone on the internet.
29
What is the role of the 'Relationships' view in Power BI?
To visualize and manage relationships between tables in the data model.
30
Which DAX function would you use to calculate the total sales amount?
SUM.
31
Fill in the blank: __________ charts are ideal for comparing parts of a whole in Power BI.
Pie
32
What is the significance of the 'Refresh Rate' in Power BI Service?
It determines how often the dataset is updated with new data.
33
True or False: You can use R and Python scripts in Power BI.
True
34
What is a 'drill-through' feature in Power BI?
It allows users to right-click on a data point to view more detailed information.
35
Which visual in Power BI is best for showing the distribution of values?
Histogram.
36
Fill in the blank: __________ allows users to group data based on specific criteria in Power BI.
Binning
37
What is the purpose of the 'Bookmarks' feature in Power BI?
To save specific views of a report for easy access later.
38
True or False: Power BI can perform sentiment analysis on text data.
True
39
What is the 'Q&A' visual in Power BI?
A feature that allows users to ask natural language questions about their data.
40
Which DAX function would you use to count unique values in a column?
DISTINCTCOUNT.
41
Fill in the blank: In Power BI, __________ can be used to create conditional formatting rules.
DAX measures
42
What does the term 'data lineage' refer to in Power BI?
The tracking of data flow from its source to the final report.
43
True or False: You can create custom visuals in Power BI.
True
44
What is the purpose of the 'Field' pane in Power BI?
To manage and select fields to use in reports and visualizations.
45
What type of join is used when merging two tables in Power BI?
Inner join, left join, right join, or full outer join.
46
Fill in the blank: The __________ function in DAX returns the current date.
TODAY
47
What is a 'dataflow' in Power BI?
A collection of queries that can be reused across multiple datasets.
48
True or False: Power BI can only connect to Microsoft data sources.
False
49
What is the purpose of 'Row-Level Security' in Power BI?
To restrict data access for specific users based on roles.
50
Which visual is best for displaying hierarchical data?
Tree map.
51
Fill in the blank: The __________ feature in Power BI allows you to create visuals based on user input.
What If
52
What is the role of the 'Visual Interactions' feature in Power BI?
To control how visuals on a report page interact with each other.
53
True or False: You can export data from Power BI to Excel.
True
54
What does 'Power BI Premium' offer that 'Power BI Pro' does not?
Dedicated cloud resources and larger dataset capacity.
55
Fill in the blank: The __________ function in DAX calculates the average of a column.
AVERAGE
56
What is the significance of using 'Variables' in DAX formulas?
To store intermediate values and improve performance.
57
What is a 'KPI' in Power BI?
Key Performance Indicator, a visual that shows progress toward a measurable goal.
58
True or False: You can schedule data refreshes in Power BI Service.
True
59
What does the 'Data Insights' feature in Power BI do?
Provides automated insights based on the dataset.
60
Fill in the blank: __________ visuals can display multiple measures simultaneously in Power BI.
Combo
61
What is the purpose of the 'Sync Slicers' feature in Power BI?
To ensure that slicers filter multiple report pages simultaneously.
62
What is the difference between 'Import' and 'DirectQuery' modes in Power BI?
'Import' mode loads data into Power BI while 'DirectQuery' mode queries the data source live.
63
True or False: You can create hierarchical slicers in Power BI.
True
64
What is the purpose of the 'Performance Analyzer' in Power BI?
To measure and analyze the performance of reports and visuals.
65
Fill in the blank: __________ is used to define the structure of a dataset in Power BI.
Schema
66
What does the 'Get Data' feature do in Power BI?
Allows users to connect and import data from various sources.
67
True or False: Power BI can automatically detect relationships between tables.
True
68
What is 'Paginated Reports' in Power BI?
Reports that are designed for printing and are formatted to fit on a page.
69
What is the role of 'Data Categories' in Power BI?
To inform Power BI how to treat and visualize the data.
70
Fill in the blank: The __________ function in DAX is used to find the maximum value in a column.
MAX
71
What is the purpose of 'Data Visualizations' in Power BI?
To represent data graphically for better understanding and insights.
72
True or False: The 'Manage Relationships' feature is used to create and modify data relationships in Power BI.
True
73
What is the significance of using 'Calculated Tables' in Power BI?
To create new tables based on existing data for analysis.
74
Fill in the blank: The __________ visual allows you to compare actual values against targets in Power BI.
Bullet chart
75
What is a 'Dashboard' in Power BI?
A single-page view that displays key metrics and visuals from reports.
76
True or False: You can use bookmarks to create guided navigation in Power BI reports.
True
77
What does the 'What If' parameter feature allow you to do in Power BI?
To create scenarios by changing input values dynamically.
78
Fill in the blank: The __________ function in DAX returns the current time.
NOW
79
What is the purpose of the 'Report Server' in Power BI?
To host and manage Power BI reports on-premises.
80
True or False: You can integrate Power BI with Microsoft Teams.
True
81
What does the 'Export to PowerPoint' feature do in Power BI?
Allows users to export reports as PowerPoint presentations.
82
Fill in the blank: The __________ visual is ideal for showing proportions of a whole in Power BI.
Donut chart
83
What is the purpose of 'Data Alerts' in Power BI?
To notify users when data reaches certain thresholds.
84
True or False: Power BI allows for the creation of custom themes.
True
85
What does the 'Drill Down' feature do in Power BI?
Enables users to explore deeper levels of data in a visual.
86
Fill in the blank: The __________ function in DAX is used to calculate the difference between two dates.
DATEDIFF
87
What is the significance of using 'Data Profiling' in Power BI?
To assess the quality and structure of data before analysis.
88
True or False: Power BI can generate natural language summaries of data.
True
89
What does the 'Dataflows' feature in Power BI allow you to do?
To create reusable data transformation processes.
90
Fill in the blank: The __________ visual is used to display a single measure in a prominent way in Power BI.
Card
91
What is the primary purpose of Power BI?
To visualize and analyze data for business intelligence.
92
True or False: Power BI can connect to both cloud and on-premises data sources.
True
93
Fill in the blank: In Power BI, __________ is a collection of data sources, queries, connections, and models.
dataset
94
What are the three main components of Power BI?
Power BI Desktop, Power BI Service, and Power BI Mobile.
95
Which of the following is NOT a data preparation step in Power BI? a) Cleaning b) Transforming c) Visualizing
c) Visualizing
96
What is the purpose of the Power Query Editor?
To transform and clean data before loading it into Power BI.
97
True or False: DAX stands for Data Analysis Expressions.
True
98
What is the primary function of DAX in Power BI?
To create calculated columns and measures.
99
What type of data does Power BI typically use for visuals?
Tabular data.
100
Fill in the blank: __________ is the process of creating relationships between different tables in Power BI.
Data modeling
101
Which of the following is a valid DAX function? a) SUMIF b) AVERAGE c) COUNTROWS
c) COUNTROWS
102
What is a measure in Power BI?
A calculation used in data analysis that is evaluated based on the context of the report.
103
True or False: Power BI allows for real-time data streaming.
True
104
What feature in Power BI allows for sharing reports and dashboards with others?
Power BI Service.
105
What does the term 'data modeling' refer to in Power BI?
The process of creating a structure that defines how data is connected and organized.
106
What is the difference between a calculated column and a measure in DAX?
A calculated column is computed row by row, while a measure is calculated based on the context of the report.
107
Fill in the blank: In Power BI, __________ allows users to create interactive reports.
visualizations
108
Which visual type is best for showing trends over time?
Line chart.
109
What is the purpose of slicers in Power BI?
To filter data in reports interactively.
110
True or False: You can only publish Power BI reports to the Power BI Service.
False
111
What does the term 'refresh' mean in Power BI?
Updating the dataset with the latest data from the source.
112
Which of the following is NOT a data source supported by Power BI? a) Excel b) SQL Server c) Microsoft Word
c) Microsoft Word
113
What is the function of the 'Edit Queries' option in Power BI?
To modify and transform data before loading it into the model.
114
Fill in the blank: The __________ pane in Power BI Desktop allows you to add visualizations to your report.
Visualizations
115
What is a tooltip in Power BI?
A small pop-up that provides additional information when hovering over a visual.
116
What is the purpose of the 'Data View' in Power BI?
To view and manage the underlying data in the model.
117
True or False: Power BI dashboards can only display data from a single report.
False
118
What does 'Publish to Web' do in Power BI?
It creates a public URL to share reports with anyone on the internet.
119
What is the role of the 'Relationships' view in Power BI?
To visualize and manage relationships between tables in the data model.
120
Which DAX function would you use to calculate the total sales amount?
SUM.
121
Fill in the blank: __________ charts are ideal for comparing parts of a whole in Power BI.
Pie
122
What is the significance of the 'Refresh Rate' in Power BI Service?
It determines how often the dataset is updated with new data.
123
True or False: You can use R and Python scripts in Power BI.
True
124
What is a 'drill-through' feature in Power BI?
It allows users to right-click on a data point to view more detailed information.
125
Which visual in Power BI is best for showing the distribution of values?
Histogram.
126
Fill in the blank: __________ allows users to group data based on specific criteria in Power BI.
Binning
127
What is the purpose of the 'Bookmarks' feature in Power BI?
To save specific views of a report for easy access later.
128
True or False: Power BI can perform sentiment analysis on text data.
True
129
What is the 'Q&A' visual in Power BI?
A feature that allows users to ask natural language questions about their data.
130
Which DAX function would you use to count unique values in a column?
DISTINCTCOUNT.
131
Fill in the blank: In Power BI, __________ can be used to create conditional formatting rules.
DAX measures
132
What does the term 'data lineage' refer to in Power BI?
The tracking of data flow from its source to the final report.
133
True or False: You can create custom visuals in Power BI.
True
134
What is the purpose of the 'Field' pane in Power BI?
To manage and select fields to use in reports and visualizations.
135
What type of join is used when merging two tables in Power BI?
Inner join, left join, right join, or full outer join.
136
Fill in the blank: The __________ function in DAX returns the current date.
TODAY
137
What is a 'dataflow' in Power BI?
A collection of queries that can be reused across multiple datasets.
138
True or False: Power BI can only connect to Microsoft data sources.
False
139
What is the purpose of 'Row-Level Security' in Power BI?
To restrict data access for specific users based on roles.
140
Which visual is best for displaying hierarchical data?
Tree map.
141
Fill in the blank: The __________ feature in Power BI allows you to create visuals based on user input.
What If
142
What is the role of the 'Visual Interactions' feature in Power BI?
To control how visuals on a report page interact with each other.
143
True or False: You can export data from Power BI to Excel.
True
144
What does 'Power BI Premium' offer that 'Power BI Pro' does not?
Dedicated cloud resources and larger dataset capacity.
145
Fill in the blank: The __________ function in DAX calculates the average of a column.
AVERAGE
146
What is the significance of using 'Variables' in DAX formulas?
To store intermediate values and improve performance.
147
What is a 'KPI' in Power BI?
Key Performance Indicator, a visual that shows progress toward a measurable goal.
148
True or False: You can schedule data refreshes in Power BI Service.
True
149
What does the 'Data Insights' feature in Power BI do?
Provides automated insights based on the dataset.
150
Fill in the blank: __________ visuals can display multiple measures simultaneously in Power BI.
Combo
151
What is the purpose of the 'Sync Slicers' feature in Power BI?
To ensure that slicers filter multiple report pages simultaneously.
152
What is the difference between 'Import' and 'DirectQuery' modes in Power BI?
'Import' mode loads data into Power BI while 'DirectQuery' mode queries the data source live.
153
True or False: You can create hierarchical slicers in Power BI.
True
154
What is the purpose of the 'Performance Analyzer' in Power BI?
To measure and analyze the performance of reports and visuals.
155
Fill in the blank: __________ is used to define the structure of a dataset in Power BI.
Schema
156
What does the 'Get Data' feature do in Power BI?
Allows users to connect and import data from various sources.
157
True or False: Power BI can automatically detect relationships between tables.
True
158
What is 'Paginated Reports' in Power BI?
Reports that are designed for printing and are formatted to fit on a page.
159
What is the role of 'Data Categories' in Power BI?
To inform Power BI how to treat and visualize the data.
160
Fill in the blank: The __________ function in DAX is used to find the maximum value in a column.
MAX
161
What is the purpose of 'Data Visualizations' in Power BI?
To represent data graphically for better understanding and insights.
162
True or False: The 'Manage Relationships' feature is used to create and modify data relationships in Power BI.
True
163
What is the significance of using 'Calculated Tables' in Power BI?
To create new tables based on existing data for analysis.
164
Fill in the blank: The __________ visual allows you to compare actual values against targets in Power BI.
Bullet chart
165
What is a 'Dashboard' in Power BI?
A single-page view that displays key metrics and visuals from reports.
166
True or False: You can use bookmarks to create guided navigation in Power BI reports.
True
167
What does the 'What If' parameter feature allow you to do in Power BI?
To create scenarios by changing input values dynamically.
168
Fill in the blank: The __________ function in DAX returns the current time.
NOW
169
What is the purpose of the 'Report Server' in Power BI?
To host and manage Power BI reports on-premises.
170
True or False: You can integrate Power BI with Microsoft Teams.
True
171
What does the 'Export to PowerPoint' feature do in Power BI?
Allows users to export reports as PowerPoint presentations.
172
Fill in the blank: The __________ visual is ideal for showing proportions of a whole in Power BI.
Donut chart
173
What is the purpose of 'Data Alerts' in Power BI?
To notify users when data reaches certain thresholds.
174
True or False: Power BI allows for the creation of custom themes.
True
175
What does the 'Drill Down' feature do in Power BI?
Enables users to explore deeper levels of data in a visual.
176
Fill in the blank: The __________ function in DAX is used to calculate the difference between two dates.
DATEDIFF
177
What is the significance of using 'Data Profiling' in Power BI?
To assess the quality and structure of data before analysis.
178
True or False: Power BI can generate natural language summaries of data.
True
179
What does the 'Dataflows' feature in Power BI allow you to do?
To create reusable data transformation processes.
180
Fill in the blank: The __________ visual is used to display a single measure in a prominent way in Power BI.
Card
