Qlik QSBA sample question

[juneismymonth5]

Hi everyone, 

I am preparing for QSBA certification and got stuck in the following question:

A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.

The team wants to use insight Advisor to query events and opportunities to:

* Review specific areas and periods

* Use marketing terms not currently present in the app when classifying opportunities

* Define calendar periods and add calculations for specific data fields

Some examples are as follows:

Business term                                       Comments

Fiscal year                                         The year starting from April this year to the next year

Iberia region                                     All cities in Spain and Portugal

Death Opp                                         Opportunities within any of these Statuses: Not success, Missed or Not responded

People                                                 Perform a calculation that counts the distinct number of AttendatID

Which process should the business analyst follow?

A) Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results
B) Define me business logic and vocabulary to define values using the fields, data set Create groups and set properties in fields Use Calendar groups to define custom periods
C) Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms
D) Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

From my point of view, I think that B) can be a good choice, could you please help with a second opinion? 🙂

Thx,

[Mike_Dickson · Accepted solution]

Hello @juneismymonth5 

The question is asking for the process that a business analyst should follow in order to achieve the goals mentioned by the marketing team. These goals include reviewing specific areas and periods, using marketing terms for classification, defining calendar periods, and adding calculations.

Let's review the options:

A) Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries. Use the Selection tool to remove any tags not needed for the search results.

• This option talks about adding tags and using the Selection tool, but it doesn't address the other requirements such as defining calendar periods, adding calculations, and using marketing terms.

B) Define the business logic and vocabulary to define values using the fields, dataset. Create groups and set properties in fields. Use Calendar groups to define custom periods.

• This option seems comprehensive as it mentions defining business logic and vocabulary (which could include marketing terms), creating groups, setting properties in fields, and using Calendar groups for custom periods. This addresses most of the requirements mentioned in the question.

C) Create master dimensions and measures, including calendar measures to define fiscal periods. Use tags to improve the Insight Advisor search features and include vocabulary terms.

• This option talks about creating master dimensions and measures, which is important for custom calculations, but it does not explicitly mention setting up business logic and vocabulary. However, it does discuss using tags for improving search and including vocabulary terms.

D) Update the data set using data manager or data load editor to include these terms as flags or values in the data set. Also define the variable to determine which calculation should be used for each field.

• This option talks about updating the dataset and defining variables for calculations, but it does not explicitly mention defining calendar periods and doesn't seem as comprehensive in addressing the requirements.

Based on the analysis above, option B seems to be the most comprehensive in addressing the requirements outlined in the question. It mentions defining business logic and vocabulary, creating groups, setting properties, and defining custom periods, which aligns with the goals of the marketing team. Therefore, I would agree with your assessment that option B is the best choice among the provided options.

[juneismymonth5]

Hi @Mike_Dickson ,

Many thanks for such a complete response.  I really appreciate your help!!

Kind regards,

@juneismymonth5 

[sumanta12]

https://www.udemy.com/course/qliksense-certification-model-question-answer/?referralCode=B4F9618A647...