Qlik Sense Business Analyst (QSBA) exam
Study Questions | With Answers
A company has customers in 16 countries. The majority of the customers are in
Germany A business analyst creates a fitter pane for Country and wants "Germany"
listed first. The rest of the countries should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement? - ANSWER In
the data manager edit the table, select Country! then select Order from the data
profiling card
Which two features/functions are enabled by the Qlik Associative Engine? - ANSWER
Smart search and data profiling
A manufacturer has several requirements for its new sales dashboard:
- Deliver analytics to mobile devices- Share data with retail partners via a custom
portal-Prevent sensitive data from being shared with competitors- Provide governed
reusable assets
Which capabilities should a business analyst use to meet these requirements? -
ANSWER Mashups
Master items
Responsive design
Configurable security rules
A retailer with 300 locations worldwide needs to analyze revenue to prepare for its next
board meeting. The retailer needs to view the distribution of its total revenue by
continent and country.
A business analyst has created a bar chart that provides a drill-down option from
continents to countries. However, the board wants to visualize all data in one chart
without drill down or scrolling.
,Which visualization should the analyst use? - ANSWER Treemap
A business analyst must arrange the sheets within an app to logically guide user
interactions. Which order should the business analyst use to meet this requirement? -
ANSWER High-level dashboard, interactive analysis, reports
A business analyst must create a set of managed reports that:
- Can be distributed via email- Has a central resource so users can view historical
reports- Will have a format so that the users can add content- Will refresh and
distribute reports on a schedule- Enables users to manage their own report
subscriptions Which Qlik capability should the business analyst use to meet these
requirements? - ANSWER Qlik NPrinting
Visualization design is about encoding data, that is, mapping data onto graphical
elements. What is the most efficient of these encodings? - ANSWER Length
To analyze current office space utilization, a business analyst must create an office floor
plan to show employee density and movements. What are the requirements to create
the office floor plan? - ANSWER A KML file with the floor plan shapes, the office
movements, and employee location
A business analyst creates a bar chart and notices the weekdays are NOT in a US
default format. The analyst does NOT have permissions to enter the data load editor
and edit the data. The analyst only has a few minutes before the meeting to show
the insights to a manager. The business analyst wants to quickly customize the chart
to show the weekdays in US format.
Which action should the business analyst take to fix the chart? - ANSWER Change the
dimension to a calculated dimension using the REPLACE() function.
Which of the following statements is correct? - ANSWER The grouping, by which you
want to show results in a chart is known as the dimension.
, A business analyst is using a box plot to show distribution. The data scientist provides
the formulas to configure a custom box plot. Which action(s) should the business
analyst take to meet these requirements? - ANSWER Under Box plot elements, disable
Use presets and enter the given formulas in the expressions field
A business analyst needs to add a reference line to a bar chart. Which action should the
business analyst take to meet this requirement? - ANSWER Create a reference line
using Max(Aggr(Sum(Sales),CompanyName))
A sales department has a pie chart that displays the total amount of sales by city. Users
have requested several changes to the pie chart:
- Display the labels in 'Red'- Increase the font size of the title- Change the color of the
values to 'Blue'
Which technique should a business analyst use to meet these requirements? -
ANSWER Create a custom theme
A business analyst needs to make a complex pie chart easier to understand. The pie
chart shows the total number of customers by customer type. There are 12 customer
types. Some customers do NOT have a type assigned. The business analyst needs
to:
- Show all customers including those without a customer type- See the total number of
customers in each customer type
Which two visualizations could the business analyst use to meet these requirements?
- ANSWER Bar Chart
Treemap
A business analyst wants to develop a Qlick Sense app with some key performance
indicators on the dashboard. The analyst decides to use two KPI objects to represent
key metrics for the organization.
Study Questions | With Answers
A company has customers in 16 countries. The majority of the customers are in
Germany A business analyst creates a fitter pane for Country and wants "Germany"
listed first. The rest of the countries should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement? - ANSWER In
the data manager edit the table, select Country! then select Order from the data
profiling card
Which two features/functions are enabled by the Qlik Associative Engine? - ANSWER
Smart search and data profiling
A manufacturer has several requirements for its new sales dashboard:
- Deliver analytics to mobile devices- Share data with retail partners via a custom
portal-Prevent sensitive data from being shared with competitors- Provide governed
reusable assets
Which capabilities should a business analyst use to meet these requirements? -
ANSWER Mashups
Master items
Responsive design
Configurable security rules
A retailer with 300 locations worldwide needs to analyze revenue to prepare for its next
board meeting. The retailer needs to view the distribution of its total revenue by
continent and country.
A business analyst has created a bar chart that provides a drill-down option from
continents to countries. However, the board wants to visualize all data in one chart
without drill down or scrolling.
,Which visualization should the analyst use? - ANSWER Treemap
A business analyst must arrange the sheets within an app to logically guide user
interactions. Which order should the business analyst use to meet this requirement? -
ANSWER High-level dashboard, interactive analysis, reports
A business analyst must create a set of managed reports that:
- Can be distributed via email- Has a central resource so users can view historical
reports- Will have a format so that the users can add content- Will refresh and
distribute reports on a schedule- Enables users to manage their own report
subscriptions Which Qlik capability should the business analyst use to meet these
requirements? - ANSWER Qlik NPrinting
Visualization design is about encoding data, that is, mapping data onto graphical
elements. What is the most efficient of these encodings? - ANSWER Length
To analyze current office space utilization, a business analyst must create an office floor
plan to show employee density and movements. What are the requirements to create
the office floor plan? - ANSWER A KML file with the floor plan shapes, the office
movements, and employee location
A business analyst creates a bar chart and notices the weekdays are NOT in a US
default format. The analyst does NOT have permissions to enter the data load editor
and edit the data. The analyst only has a few minutes before the meeting to show
the insights to a manager. The business analyst wants to quickly customize the chart
to show the weekdays in US format.
Which action should the business analyst take to fix the chart? - ANSWER Change the
dimension to a calculated dimension using the REPLACE() function.
Which of the following statements is correct? - ANSWER The grouping, by which you
want to show results in a chart is known as the dimension.
, A business analyst is using a box plot to show distribution. The data scientist provides
the formulas to configure a custom box plot. Which action(s) should the business
analyst take to meet these requirements? - ANSWER Under Box plot elements, disable
Use presets and enter the given formulas in the expressions field
A business analyst needs to add a reference line to a bar chart. Which action should the
business analyst take to meet this requirement? - ANSWER Create a reference line
using Max(Aggr(Sum(Sales),CompanyName))
A sales department has a pie chart that displays the total amount of sales by city. Users
have requested several changes to the pie chart:
- Display the labels in 'Red'- Increase the font size of the title- Change the color of the
values to 'Blue'
Which technique should a business analyst use to meet these requirements? -
ANSWER Create a custom theme
A business analyst needs to make a complex pie chart easier to understand. The pie
chart shows the total number of customers by customer type. There are 12 customer
types. Some customers do NOT have a type assigned. The business analyst needs
to:
- Show all customers including those without a customer type- See the total number of
customers in each customer type
Which two visualizations could the business analyst use to meet these requirements?
- ANSWER Bar Chart
Treemap
A business analyst wants to develop a Qlick Sense app with some key performance
indicators on the dashboard. The analyst decides to use two KPI objects to represent
key metrics for the organization.
