Qlik Sense Business Analyst (QSBA)
Qualification Exam | Questions With
Answers
Pareto Chart - ANSWER A combo chart wit h a bar graph can show relative
importanceof dimensions contributing to total. Cumulative Contribution (a bar graph
whose bars are drawn in decreasing order of frequency or relative frequency)
Trend or Process control chart (Analysis type) - ANSWER Words or phrases
recognized: trend, historical, over time
represented in a Line chart
Comparison, Correlation or Cluster (Analysis Type) - ANSWER Words or phrases
recognized: correlate, vs, 'x' vs 'y' per 'category' represented in Scatterplot, KPI,
Boxplot or Combochart
Breakdown or Year-to-date (Analysis type) - ANSWER Words or phrases recognized:
by, per, broken down by, distributed by, between, compare between
represented in barchart, table or treechart
Map distribution (Analysis type) - ANSWER Words or phrases recognized: show a map
of 'x' by 'category'
represented in map chart
Rank or Contribution (Analysis type) - ANSWER Words or phrases recognized:
top/bottom, highest/lowest, best/worst, most/least, biggest/smallest
, represented as a bar chart, pivot table or combochart (as pareto chart)
Fact, Values, Overview (Analysis type) - ANSWER Words or phrases recognized:
list, count of, total, average
represented in a KPI, table or distribution plot
Aggregation guided : Count - ANSWER Words or phrases recognized: count of,
count, number of, how many, how many of, enumerate
Aggregation guided: Sum - ANSWER Words or phrases recognized:sum of, total
of, sum, total
Aggregation guided: Average - ANSWER Words or phrases recognized: avg
of, average of, avg, average
Aggregation guided: Minimum - ANSWER Words or phrases recognized: min of,
maximum of, minimal of, min, minimum, minimal
Aggregation guided: Maximum - ANSWER Words or phrases recognized: max
of, maximum of, max, maximum, maximal
Natural Language Query: Categorical (dimensional) Filters - ANSWER Include= on, in,
for, with, have
Exclude=excluding, not in, not for, are not, have no, without, not from, outside
Natural Language Query: Measure Filters - ANSWER Greater than=is greater than,
greater than, is larger than, larger than, is higher than, >
Less than=is less than, less tahn, is lower than, less than, lower than, <
Equal=is, is equal to, equals to, =
Between=between, is between
No=have no, do not have
Qualification Exam | Questions With
Answers
Pareto Chart - ANSWER A combo chart wit h a bar graph can show relative
importanceof dimensions contributing to total. Cumulative Contribution (a bar graph
whose bars are drawn in decreasing order of frequency or relative frequency)
Trend or Process control chart (Analysis type) - ANSWER Words or phrases
recognized: trend, historical, over time
represented in a Line chart
Comparison, Correlation or Cluster (Analysis Type) - ANSWER Words or phrases
recognized: correlate, vs, 'x' vs 'y' per 'category' represented in Scatterplot, KPI,
Boxplot or Combochart
Breakdown or Year-to-date (Analysis type) - ANSWER Words or phrases recognized:
by, per, broken down by, distributed by, between, compare between
represented in barchart, table or treechart
Map distribution (Analysis type) - ANSWER Words or phrases recognized: show a map
of 'x' by 'category'
represented in map chart
Rank or Contribution (Analysis type) - ANSWER Words or phrases recognized:
top/bottom, highest/lowest, best/worst, most/least, biggest/smallest
, represented as a bar chart, pivot table or combochart (as pareto chart)
Fact, Values, Overview (Analysis type) - ANSWER Words or phrases recognized:
list, count of, total, average
represented in a KPI, table or distribution plot
Aggregation guided : Count - ANSWER Words or phrases recognized: count of,
count, number of, how many, how many of, enumerate
Aggregation guided: Sum - ANSWER Words or phrases recognized:sum of, total
of, sum, total
Aggregation guided: Average - ANSWER Words or phrases recognized: avg
of, average of, avg, average
Aggregation guided: Minimum - ANSWER Words or phrases recognized: min of,
maximum of, minimal of, min, minimum, minimal
Aggregation guided: Maximum - ANSWER Words or phrases recognized: max
of, maximum of, max, maximum, maximal
Natural Language Query: Categorical (dimensional) Filters - ANSWER Include= on, in,
for, with, have
Exclude=excluding, not in, not for, are not, have no, without, not from, outside
Natural Language Query: Measure Filters - ANSWER Greater than=is greater than,
greater than, is larger than, larger than, is higher than, >
Less than=is less than, less tahn, is lower than, less than, lower than, <
Equal=is, is equal to, equals to, =
Between=between, is between
No=have no, do not have