QUESTION: 17

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 this error?

Change the OrderDate number formatting to 'Date' in the properties panel
Create a new calculated field for OrderDate with: Date (Floor (OrderDateTime))
Change the OrderDate field type to "Date" with the format 'YYYY-MM-DD' in the data manager
Create a new calculated field for OrderDate with: Date (LTrim (OrderDateTime, 10))

Answer(s): C

Reveal Solution Next Question

QUESTION: 18

A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations.
Which steps should the business analyst take to add the visualizations to a sheet?

Click Generate insights to find visualizations, then click Add to sheet
Use the selection tool to find visualizations, then click Add to sheet
Use smart search to find visualizations, then click Add to sheet
Drag and drop fields on the workspace, then click Add to sheet

Answer(s): A

Reveal Solution Next Question

QUESTION: 19

Refer to the exhibit.
A business analyst is testing an existing app that returns unexpected results. Using the selection tool, the business analyst observes the following behavior
- Select a CompanyName and the associated OrderlD records are white
- Select a Year and all OrderlD records are gray
- Select an OrderlD and the Quarter values are all gray, but the CompanyNames are white
- Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray What is causing these results?

OrderlD should be the key field in the MasterCalendar
The logical model is NOT a star schema
The OrderDate fields are different data types
MasterCalendar should be associated to the OrderDetails table

Answer(s): C

Reveal Solution Next Question

QUESTION: 20

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?

Edit the sheet, select Chart Properties panel Custom sorting, then select Germany
Edit the sheet, select Chart Properties panel Custom sorting, then click Descending Frequency
In the data manager edit the table, select Country! then select Order from the data profiling card
In the data manager, edit the table, select Country, then select Order from the column header

Answer(s): D

Reveal Solution Next Question

Free QSBA2018 Exam Braindumps (page: 5)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20