QlikView QSBA2024 Qlik Sense Business Analyst Certification Exam - 2024 Online Training

Question #1

Two customers in an organization want to use an app that contains a finance data set. With different analysis objectives, each customer will only use a subset of that data.

Which procedure should the business analyst follow?

A . Apply Section Access to manage the data for each customer
B . Create multiple visualizations using set analysis
C . Duplicate and rename the apps for each customer
D . Unpivot, then re-associate the data tables for each customer

Reveal Solution Hide Solution

Question #2

An app needs to load a few hundred rows of data from a .csv text file. The file is the result of a concatenated data dump by multiple divisions across several countries. These divisions use different internal systems and processes, which causes country names to appear differently. For example, the United States of America appears in several places as ‘USA’, ‘U.S.A.’, or ‘US’.

For the country dimension to work properly in the app, the naming of countries must be standardized in the data model.

Which action should the business analyst complete to address this issue?

A . Create a calculated master dimension expression
B . Load a lookup table to convert values
C . Cleanse the source text file prior to loading
D . Use the Replace option in Data manager

Reveal Solution Hide Solution

Question #3

A business analyst needs to rapidly prototype an application design for a prospective customer. The only dataset provided by the customer contains 30 fields, but has over one billion rows. It will take too long to keep loading in its entirety while the analyst develops the data model.

Which action should the business analyst complete in the Data manager?

A . Split the dataset and create a normalized star schema of associated tables
B . Deselect text columns with unique data values to reduce the memory footprint
C . Use the Filter data option to reduce the number of rows
D . Truncate text fields longer than 256 characters to create preview fields

Reveal Solution Hide Solution

Question #4

A business analyst designs a visualization to analyze a count of products by fixed price ranges. The customer now wants the price ranges to be dynamically modified so they are configurable by the application users. The business analyst modified the dimension axis on the visualization.

Which step should the business analyst complete next?

A . Define a variable and use it in a variable input object on the sheet
B . Create a calculated field in Data manager, using the Class() function
C . Load an independent source file to contain the user-defined boundary values
D . Create the price range dimension using the Buckets feature in Data manager

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

To make the price ranges dynamically adjustable by the application users, a variable input object is the best approach. The business analyst can define a variable that stores the range value, which users can modify directly through a variable input control. This method allows users to change the price ranges interactively, giving them control over the ranges used in the analysis. Key Concepts:

Variable Input Object: This object allows users to interact with and modify the values of predefined variables directly within a Qlik Sense sheet, which can then be used to adjust calculations dynamically, such as defining custom ranges.

Configurable by Users: This approach gives end-users the flexibility to modify the visualization based on their specific needs without requiring backend changes or reloading the app.

Why the Other Options Are Less Suitable:

B. Create a calculated field in Data manager, using the Class() function: The Class() function is useful for creating static price ranges, but it does not allow for user interaction or dynamic updates to the ranges.

C. Load an independent source file to contain the user-defined boundary values: While this could provide configurable ranges, it’s unnecessarily complex and would require more management, and

it’s not as user-friendly as using a variable.

D. Create the price range dimension using the Buckets feature in Data manager: Similar to the Class() function, this would create static groupings, which wouldn’t be dynamically adjustable by the user.

References for Qlik Sense Business Analyst:

Dynamic Controls with Variables: Qlik Sense provides the ability to create variable input objects that allow users to control how visualizations behave dynamically. This feature is highlighted in Qlik Sense’s Business Analyst best practices when making interactive applications.

By using a variable and a variable input object, the business analyst enables user interactivity and customization, making A the correct choice.

Question #5

A business analyst needs to create two side-by-side charts for a sales department with the following data:

• Number of orders

• Name of the customer

• Percentage of margin

• Total sales

The charts use a common dimension, but each chart has different measures. The analyst needs to create a color association between the two charts on the dimension values.

Which action should the business analyst take?

A . Use nested IF statements to set the colors by expression for each dimension value
B . Define the color values in the master measures and use the color library
C . Select ‘By Dimension’ and ‘Persistent colors’ in the Colors property panel
D . Use the Fieldlndex function to set the colors by expression for each dimension value

Reveal Solution Hide Solution

Question #6

A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data.

The requirements include:

• Users need to drill down to various details within the available data set.

• Several final measures will be repeatedly used. These final measures require combining several fields in a single table.

• User experience and load time is a high priority.

Which action should the business analyst take to meet these requirements?

A . Aggregate the data to the source period
B . Develop a master item using the required source fields
C . Combine the various source fields in a calculated item in the Data manager
D . Combine the source fields and create additional fields in Excel

Reveal Solution Hide Solution

Question #7

A project management team uses an app to monitor different projects.

• Projects may have co-dependent tasks and processes

• Some projects include subtasks

The business analyst needs to use a diagram similar to a workflow with the processes and the sub tasks represented as boxes with lines to relate them to each other. The color of the boxes could also be determined by the status of each project or task.

Which visualization should be used?

A . Sankey chart
B . Grid chart
C . Org chart
D . Network chart

Reveal Solution Hide Solution

Question #8

The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category.

The sales manager wants to have the potential percentage Sales for each Stage (Initial to Won) of the sales process.

Which visualizations will meet these requirements?

A . Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales
B . Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales
C . Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales
D . Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

Reveal Solution Hide Solution

Question #9

A business analyst is creating an app for the sales team.

The app must meet several requirements:

• Compare 10 top-performing sales representatives and the amount of sales for each

• Investigate margin percentage and total sales by each product category

• View distribution of sales amount

Which visualizations should be used for this app?

A . A bar chart, scatter plot, and histogram
B . A treemap, container, and distribution plot
C . A bar chart, line chart, and scatter plot
D . A treemap, box plot, and histogram

Reveal Solution Hide Solution

Question #10

The VP of Finance is requesting a presentable solution that allows them to share finance information in monthly meetings with C-suite executives. Given the monthly meeting agendas, the solution must be customizable.

Which Qlik Sense feature should be implemented to meet this requirement?

A . Storytelling
B . Insight Advisor Chat
C . Action Buttons
D . Bookmarks

Reveal Solution Hide Solution

QlikView QSBA2024 Qlik Sense Business Analyst Certification Exam – 2024 Online Training