Qlik Sense Business Analyst Exam : Questions & Answers
A business analyst develops apps for users to independently visualize their data to gain insights.
The users have desktop computers, tablets, and mobile devices. When creating the apps, the business
analyst does not need to know the specific device on which it will be consumed.
- ANSWER: Responsive Design
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:NPrinting
A business analyst needs to crate a new application for an organization. The new application should
enable sales data analysis at the year, month, week, and day level based on the date of individual
transactions. The application should also enable users to analyze transactions by regions and products.
The organization has operations worldwide. Each region represents a group of different countries. The
sales department defines these ad-hoc groups. An existing QVD file that contains all the data needed has
been identified as a potential source.
What are the minimum fields that the analyst should expect to find in the QVD file? -
ANSWER:TransactionDate, Country, SalesAmount, and Product ID
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. -
ANSWER:Treemap
, A retail store owner needs to analyze sales and profitability for the products sold. The store owner
carries approximately 500 products in different categories. The store owner needs to view sales revenue,
quantity, and profit margin by product category. The store owner also needs to the ability to drill down
to individual products and identify outliers.
Which visualization should a business analyst use to show this information for the current period? -
ANSWER:Scatter Plot
A marketing company must analyze the age of customers who view movies at a theater at least once a
month, and where those customers are located. The business analyst must consider several
requirements:
-Age of customers
- Addresses of customers
- Frequency of theater visits
Which objects should a business analyst use to visualize these requirements? - ANSWER:Histogram and
Map
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
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 locations
A business analyst must combine the following bar charts on one sheet in a story:
- bar chart that updates with live data
- bar chart that shows static data from a previous period
How should the business analyst meet this requirement? - ANSWER:Embed a sheet with the bar chart
for live data, then add a snapshot of the bar chart for the static data
A business analyst needs to present a one-slide story and be able to make selections in a visualization.
A business analyst develops apps for users to independently visualize their data to gain insights.
The users have desktop computers, tablets, and mobile devices. When creating the apps, the business
analyst does not need to know the specific device on which it will be consumed.
- ANSWER: Responsive Design
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:NPrinting
A business analyst needs to crate a new application for an organization. The new application should
enable sales data analysis at the year, month, week, and day level based on the date of individual
transactions. The application should also enable users to analyze transactions by regions and products.
The organization has operations worldwide. Each region represents a group of different countries. The
sales department defines these ad-hoc groups. An existing QVD file that contains all the data needed has
been identified as a potential source.
What are the minimum fields that the analyst should expect to find in the QVD file? -
ANSWER:TransactionDate, Country, SalesAmount, and Product ID
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. -
ANSWER:Treemap
, A retail store owner needs to analyze sales and profitability for the products sold. The store owner
carries approximately 500 products in different categories. The store owner needs to view sales revenue,
quantity, and profit margin by product category. The store owner also needs to the ability to drill down
to individual products and identify outliers.
Which visualization should a business analyst use to show this information for the current period? -
ANSWER:Scatter Plot
A marketing company must analyze the age of customers who view movies at a theater at least once a
month, and where those customers are located. The business analyst must consider several
requirements:
-Age of customers
- Addresses of customers
- Frequency of theater visits
Which objects should a business analyst use to visualize these requirements? - ANSWER:Histogram and
Map
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
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 locations
A business analyst must combine the following bar charts on one sheet in a story:
- bar chart that updates with live data
- bar chart that shows static data from a previous period
How should the business analyst meet this requirement? - ANSWER:Embed a sheet with the bar chart
for live data, then add a snapshot of the bar chart for the static data
A business analyst needs to present a one-slide story and be able to make selections in a visualization.
