Qlik Sense Business Analyst – Questions & Accurate
Answers
Which Qlik capability should the business analyst use to meet these
requirements? Right Ans - 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? Right Ans - 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. Right Ans - 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? Right Ans - 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?
Right Ans - 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?
Right Ans - 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? Right Ans - 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? Right Ans -
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.
How should the business analyst meet this requirement? Right Ans - Create
a story and add a sheet from the sheet library that contains the visualization
What chart do we use to see if there is a correlation between advertising
spend and sales for products? Right Ans - Relationship Chart
Answers
Which Qlik capability should the business analyst use to meet these
requirements? Right Ans - 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? Right Ans - 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. Right Ans - 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? Right Ans - 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?
Right Ans - 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?
Right Ans - 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? Right Ans - 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? Right Ans -
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.
How should the business analyst meet this requirement? Right Ans - Create
a story and add a sheet from the sheet library that contains the visualization
What chart do we use to see if there is a correlation between advertising
spend and sales for products? Right Ans - Relationship Chart
