QSBA2018

Refer to the exhibits.

A business analyst must create a bar chart to show the total value of orders processed per day. The dataset loaded by the data architect only contains the OrderNo, OrderDateTime, and OrderAmount. The business analyst creates a calculated field, OrderDate, using the expression, Date (OrderDateTime). The bar chart does NOT present the information correctly.

How should the business analyst fix the error?
A . Change the OrderDate number formatting to ‘Date’ in the properties panel
B . Create a new calculated field for OrderDate with: Date (Floor (OrderDateTime))
C . Change the OrderDate field type to Date’ in the format ‘YYYY-MM-DD’ in the data manager.
D . Create a new calculated field for OrderDate with: Date (LTrim (OrderDateTime,10))

View Answer

Answer: C

Explanation:

Reference: https://1c-predpriyatie-qlik.ivan-shamaev.ru/wp-content/uploads/2018/01/ Manage_data_Qlik_Sense.pdf

Report: sheet for the row-level details

View Answer

Answer: C

A business analyst is creating a dashboard to analyze supply chains.

The app must contain several elements:

– A bar chart that shows a number of products and product groups handled by shipper

– A map that shows the number of shipments sent from factory locations

– A bar chart that shows average delivery costs by shipper

Which dimensions should the business analyst use for this app?
A . Product, Shipper, FactoryLocation
B . Shipper, FactoryLocation
C . Shipper, Product
D . Product, ProductGroup, Shipper

View Answer

Answer: D

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.

Leadership needs the following capabilities:

– Ability to view the total donation amount

– Ability to identify departments that raise $10,000 or more

Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)
A . Pie chart
B . Box plot
C . Bar chart
D . KPI
E . Treemap

View Answer

Answer: CD

A business analyst must display current year sales versus previous year sales by region, sub-region, and city.

The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.

Which calculated expressions should the business analyst create to meet these requirements?
A .

B .


C .

D .

View Answer

Answer: B

Change the format from ‘Geo data’ to ‘General’

View Answer

Answer: D

A business analyst must display current year sales versus previous year sales by region, sub-region, and city.

The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.

Which calculated expressions should the business analyst create to meet these requirements?
A .

B .


C .

D .

View Answer

Answer: B

A bus company wants to analyze customer travel patterns to add additional services or create new routes.

The business analyst needs to consider the following data:

– 190 routes across the city

– Start and end location of each route

– Volume of customers travelling per hour

– Customer complaints when buses are full

Which visualization should a business analyst use to meet this requirement?
A . Area layer map
B . Treemap
C . Line layer map
D . Scatter plot

View Answer

Answer: A

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.

Leadership needs the following capabilities:

– Ability to view the total donation amount

– Ability to identify departments that raise $10,000 or more

Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)
A . Pie chart
B . Box plot
C . Bar chart
D . KPI
E . Treemap

View Answer

Answer: CD

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays.

Leadership needs the following capabilities:

– Ability to view the total donation amount

– Ability to identify departments that raise $10,000 or more

Which two visualizations should the business analyst use without set analysis to meet these requirements? (Choose two.)
A . Pie chart
B . Box plot
C . Bar chart
D . KPI
E . Treemap

View Answer

Answer: CD